MySQL DBA at DialogTech
Sorry, this job was removed at 5:01 a.m. (CST) on Friday, December 25, 2020
DialogTech provides the leading AI-driven conversation intelligence platform for marketers at businesses that value inbound phone calls. When consumers call, DialogTech turns those conversations into actionable insights businesses use to improve marketing ROI, increase sales conversions, and deliver more personalized customer experiences, both online and over the phone. Recognized as the leader and pioneer in call analytics since 2007, DialogTech is the trusted conversation intelligence platform for many of the world's most successful brands and agencies.
As a MySQL DBA, you will play a key role within our team. You will be responsible for the configuration, deployment, performance, availability, recovery, and security of our database architecture. Additionally, you will be responsible for the movement of data across multiple environments. You must have experience with data security, data standards, familiarity with storage solutions, database virtualization and replication as well as other sophisticated technical tools and solutions!
Your essential duties and responsibilities will include:
- Performing standard database administration tasks (backups, restores, replication issues, SQL tuning, troubleshooting, etc.)
- Managing database release lifecycles in development/qa/production environments
- Working with our technology team members to help ensure that our production applications (the databases) are running efficiently
- Assisting with production releases and scheduled maintenance
- Crafting sophisticated SQL queries that can be used monthly to extract key data and detailing the data extraction queries and the interpretation of all data fields
- Developing roadmaps and strategies for data usage across DialogTech
- Documentation of configurations and provide project updates
- Participates in production database on-call 24/7 support rotation
What you will need for success:
- Bachelor’s degree in Computer Science, Information Technology or similar experience
- 5+ years of experience as a Database Administrator, the majority in enterprise scale environments
- Extensive experience with MySQL (5.6+)
- Proficiency with Linux (RHEL or CentOS preferred)
- Ability to solve and resolving database issues (integrity, performance, replication, connectivity, and security)
- Experience with Performance Tuning and Query Optimization
- Strong scripting and automation skills
- Experience with database backup and recovery methods and tools
- Knowledge of High Availability and Disaster Recovery methods
- Familiar with optimizing MySQL configurations for various applications using standard methodologies
- Ability to make database schema changes in production with no negative impact
- Extensive data modeling experience with MySQL databases.
- Experience architecting large scale databases using MySQL in development and production environments
- Excellent SQL skills and demonstrable ability to write sophisticated SQL for purposes of analyzing data and/or evaluating how information needs might be translated into back end database structures
- Ability to work with a team or solo on various projects.
- Can learn optimal using self-teaching material.
- Superb communication, organization and documentation abilities
- Ability to thrive in a self-disciplined environment and balance multiple projects and tasks.
- Demonstrated ability and passion for staying abreast of current and emerging technologies and industry trends
- Ability to work in a fast-paced environment
Nice to have skills:
- Experience with and in depth knowledge of InnoDB and AWS
- Experience with using ProxySQL
- Familiarity with NoSQL storage systems like DynamoDB, ElasticSearch, Redis, MongoDB, Cassandra, Lucene etc
- Experience working in an agile software development environment and/or continuous delivery
Join us at one of the 101 Best and Brightest Places to Work in Chicago and nationally, 11 times running, Chicago Tribune's Top 100 Workplaces company and a 2017 Crain's Fast 50 company!
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
Read Full Job Description
