Job Role: MySQL Database Administrator (DBA)
Location: Princeton, NJ (Hybrid)
Duration: Long Term (Contract)
Overview
We are seeking a highly skilled and seasoned MySQL 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. If you thrive in a challenging environment and have a deep understanding of database administration, we’d love to hear from you!
Responsibilities
- Database Management:
- 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.
- Security and Compliance:
- Implement access controls, encryption, and authentication mechanisms.
- Ensure compliance with industry standards (e.g., GDPR, HIPAA) and best practices.
- Performance Tuning:
- Analyze query performance, identify bottlenecks, and optimize SQL queries.
- Fine-tune database parameters for optimal resource utilization.
- High Availability and Disaster Recovery:
- Set up and manage replication, clustering, and failover mechanisms.
- Develop and test backup and recovery strategies.
- Collaboration and Documentation:
- Work closely with development teams to understand application requirements.
- Document database schemas, configurations, and procedures.
- Automation and Scripting:
- Automate routine tasks using scripts (e.g., Bash, Python).
- Implement monitoring and alerting solutions.
- Capacity Planning:
- Forecast database growth and plan for scalability.
- Optimize storage and memory usage.
- 24/7 On-Call Support:
- Participate in on-call rotation for database emergencies.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- Technical Skills:
- 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).
- Experience:
- Minimum 10 years of hands-on experience as a MySQL DBA.
- Track record of managing large-scale production databases.
- Certifications (optional but desirable):
- MySQL Database Administrator (Oracle Certified Professional, MySQL 5.6 or later).
- AWS Certified Database – Specialty.
- Soft Skills:
- Strong problem-solving abilities.
- Excellent communication and collaboration skills.
- Detail-oriented and proactive.
- Ability to work independently and as part of a team.
