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

• 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/No
  
  SQL database such as Elasticsearch, Mongo
  
  DB, Oracle, Postgre
  
  SQL 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

Mid‑Senior level

Contract

Information Technology

IT Services and IT Consulting