What are the responsibilities and job description for the MySQL Database Administrator position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Nava Software Solutions, is seeking the following. Apply via Dice today!
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:
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
- 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.