What are the responsibilities and job description for the Senior MySQL Database Administrator position at sustainabletalent?
Sustainable Talent is partnering with Nvidia a global leader who's been transforming computer graphics, PC gaming, and accelerated computing for over 25 years. We are looking for a Senior MySQL Database Administrator to support our client's Software Infrastructure and Operations team. This is a W-2 full-time, contract role based in Santa Clara, CA. We offer competitive pay $80 - 110/hr based on factors like experience, education, location, etc. and provide full benefits, PTO, and amazing company culture!
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 client's build and test platforms. Responsibilities will include provisioning, maintaining existing DB infrastructure, Enhancements and working on issues together application development and operations team.
Role Responsibilities
- Provision MySQL instances: standalone, replication, cluster, HA configurations.
- Ensure performance, security, and availability of databases.
- 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 Experience
- 10 years of experience in DBA Activities.
-Strong exposure in cloud technologies – OCI, MySQL Heatwave, AWS RDS etc.
- 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, 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.
- Good communication skills.
- Proficient understanding of code versioning tools Git, Perforce etc.
Sustainable Talent is a M/F , disabled, and veteran equal employment opportunity and affirmative action employer.
Salary : $80 - $110