Job Description :
Role: MySQL Database Administrator
Duration: 6+ months
Location: Sunnyvale, CA, 94086
Interview:- Phone and then Face to Face
Senior level experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required.
Responsibilities
Provision MySQL instances, both in clustered and non-clustered configurations
Prepare documentations and specifications
Handle database procedures, such as upgrade, backup, recovery, migration, etc.
Handle complex database procedures, planning, scaling and optimization to meet the needs of the business
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders
Deploy, maintain, and monitor MySQL server instances in physical and virtual environments
Develop and maintain replication, backup, and disaster recovery strategies
Ensure security, privacy and data integrity in all MySQL environments
Optimize and tune MySQL server performance
Skills and Qualifications
Expert proficiency in MySQL and Oracle database management
Expert experience with recent versions of MySQL and in writing and optimizing SQL statements
Strong understanding of MySQL’s underlying storage engines
6+ years’ experience configuring and troubleshooting MySQL replication
Ability to plan resource requirements from high level specifications
Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
Strong understanding of limitations in MySQL and their workarounds in contrast to other popular relational databases
Experience with database backup, restoration and DR planning and execution