MySQL Database Administrator

Unclassified - Princeton, NJ

Full-time - Senior

Princeton, NJ

About the position

We are seeking a highly skilled and seasoned MySQL Database Administrator (DBA) to join our team. As a key member of our database management group, you will be responsible for ensuring the performance, availability, and security of our MySQL databases. This role requires a deep understanding of database administration and the ability to thrive in a challenging environment.

Responsibilities

• Design, implement, and maintain MySQL databases, ensuring optimal performance and reliability.
• Monitor database health, troubleshoot issues, and optimize query execution.
• Perform regular backups, data migrations, and upgrades.
• Implement access controls, encryption, and authentication mechanisms.
• Ensure compliance with industry standards (e.g., GDPR, HIPAA) and best practices.
• Analyze query performance, identify bottlenecks, and optimize SQL queries.
• Fine-tune database parameters for optimal resource utilization.
• Set up and manage replication, clustering, and failover mechanisms.
• Develop and test backup and recovery strategies.
• Work closely with development teams to understand application requirements.
• Document database schemas, configurations, and procedures.
• Automate routine tasks using scripts (e.g., Bash, Python).
• Implement monitoring and alerting solutions.
• Forecast database growth and plan for scalability.
• Optimize storage and memory usage.
• Participate in on-call rotation for database emergencies.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Extensive experience with MySQL database administration (version 5.6 and above).
• Proficiency in SQL, stored procedures, and performance tuning.
• Familiarity with database security (user management, encryption, auditing).
• Knowledge of backup and recovery strategies.
• Exposure to high availability solutions (replication, clustering).
• Scripting skills (Bash, Python, or similar).
• Minimum 10 years of hands-on experience as a MySQL DBA.
• Track record of managing large-scale production databases.

Nice-to-haves

• MySQL Database Administrator (Oracle Certified Professional, MySQL 5.6 or later) certification.
• AWS Certified Database - Specialty certification.