Job Summary :
We are seeking a highly skilled and experienced MySQL Database Administrator to join our dynamic technology team. As a key member, you will be responsible for the health, performance, and reliability of our critical MySQL database infrastructure, primarily hosted on AWS RDS. You will play a vital role in ensuring the continuous operation of our 24 / 7 production environment, implementing best practices, optimizing performance, and contributing to the scalability and security of our data assets. This role also requires experience with NoSQL databases, providing an opportunity to contribute to a diverse data Install, configure, administer, and maintain MySQL databases in a high-availability, 24 / 7 production environment, primarily on AWS RDS.
- Experience with managing MySQL on other cloud platforms (Azure or GCP) is also valuable.
- Leverage AWS RDS services, including provisioning, scaling, backups, recovery, monitoring, and security best practices.
- Analyze database performance, identify bottlenecks, and implement effective performance tuning strategies, including optimizing parameter group settings and SQL queries.
- Write, review, and optimize complex SQL queries for performance and efficiency.
- Administer and maintain MongoDB / DocDB or other NoSQL databases, ensuring their stability, performance, and data integrity.
- Implement and utilize monitoring tools such as New Relic, Performance Insights, and DataDog to proactively identify and resolve database issues. Configure alerts and dashboards for critical database metrics.
- Develop, implement, and test robust backup and recovery strategies to ensure data integrity and business continuity.
- Implement and enforce database security policies and procedures, including user access management, encryption, and vulnerability management.
- Develop and maintain scripts (e.g., Shell, Python) to automate routine database administration tasks, improving efficiency and reducing manual errors.
- Work closely with development, operations, and other teams to troubleshoot issues, provide database expertise, and support application deployments.
- Create and maintain comprehensive documentation for database configurations, processes, and procedures.
- Stay up-to-date with the latest database technologies and best practices, and proactively recommend improvements to our database :
- 3 - 5 + years of hands-on experience as a MySQL Database Administrator in a 24 / 7 production environment.
- Strong proficiency in managing and troubleshooting MySQL databases, particularly on AWS RDS.
- Demonstrated experience managing MySQL databases in a cloud environment (AWS RDS is essential; Azure or GCP experience is a plus).
- Proven experience with configuring and optimizing MySQL parameter group settings for performance.
- Excellent SQL query writing and optimization skills.
- Must have practical experience with at least one NoSQL database such as MongoDB or AWS DocumentDB.
- Hands-on experience with database monitoring tools such as New Relic, Performance Insights, and DataDog.
- Proficiency in scripting languages (e.g., Shell, Python) for automation of database tasks.
- Strong analytical and problem-solving skills with the ability to diagnose and resolve complex
database issues efficiently.
Excellent written and verbal communication skills with the ability to effectively communicatetechnical information to both technical and non-technical 1 audiences.
Ability to work effectively in a collaborative team environment.Preferred Qualifications :
AWS certification(s) related to database administration (e.g., AWS Certified Database - Specialty).Experience with database migration tools and processes.Experience with other database technologies.Knowledge of infrastructure-as-code tools (e.g., Terraform, CloudFormation).Familiarity with CI / CD pipelines and database integration.ref : hirist.tech)