MySQL Database Administrator

NAVA Software solutions is looking for a MYSQL Database Administrator

Details:

MySQL Database Administrator

Santa Clara CA - Hybrid

Duration: 6-12 months

The position will be part of a fast-paced crew that develops and maintains complex IAAS/PAAS, build environments on platforms including MySQL, Elasticsearch and MongoDB.

We are looking for a candidate with background of around 10+ years in MySQL Database Administration to manage our build and test platforms. Responsibilities will include provisioning, maintaining existing DB infrastructure, Enhancements and working on issues together application development and operations team

Job Description:

• 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

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
• Proficient in optimizing SQL statements
• Knowledge of MySQL features
• Familiarity with another SQL/NoSQL database such as Elasticsearch, MongoDB, and Oracle.