MySQL DBA C2C requirements Bentonville, AR (Hybrid)

Role: MySQL DBA

Location: Bentonville, AR (Hybrid)

Duration: 12 Months

Rate: $50/hr On C2C

Skills: Python/Shell Scripting,MY Sql Experience

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.