MySql DBA

Responsibilities

• Should have around 10+ years of experience in DBA Activities
• Provision MySQL instances: standalone, replication, cluster, HA configurations
• Should have good exposure in cloud technologies – OCI, MySQL Heatwave, AWS RDS etc
• Ensure performance, security, and availability of databases
• Should be able to handle backup and recovery procedures
• Perform general technical trouble shooting and give consultation to development/operations team
• Maintain integrity of Databases across multiple instances as per agreed policies
• Production & Preproduction deployment and troubleshooting support
• Prepare documentations and specifications
• Handle critical database procedures such as upgrade, recovery, migration, performance tuning etc.
• Profile server resource usage, optimize and tweak as necessary
• Should be able to write shell/python scripts
• Monitor DB infrastructure and able to do the performance tuning (server level, query etc) wherever required
• Should have general understanding and working experience on NDB Cluster, Innodb Cluster etc
• Collaborate with other team members and stakeholders

Required Skills

• Strong proficiency in MySQL, Elasticsearch database management
• Decent experience with recent versions of MySQL (5.5, 5.6, 5.7, 8.0, 9) on prem and cloud
• Good hands on experience of OCI, MySQL Heatwave, AWS etc
• Understanding of MySQL's underlying storage engines
• Experience with Innodb Cluster, HA, Replication configuration in MySQL
• Experience with DB monitoring tools MySQL Enterprise, Datadog, Prometheus etc
• Knowledge of de‑facto standards and best practices in MySQL
• Should be good in Unix or Python shell scripting
• Knowledge of MySQL features
• Familiarity with another SQL/NoSQL database such as Elasticsearch, MongoDB, Oracle, PostgreSQL etc
• Familiarity with configuration management tools like chef, ansible etc
• Knowledge of limitations in MySQL and their workarounds in contrast to another popular relational database
• Proficient understanding of code versioning tools Git, Perforce etc

Seniority Level

Mid‑Senior level

Employment Type

Contract

Job Function

Information Technology

Industries

IT Services and IT Consulting