mySQL DBA

Role: MySQL Admin

Location: Palo Alto, CA

Duration: 6+ Months

Level 3 MySQL Admin:

• 6-10 years of expertise in MySQL Administration on different UNIX environments (RHEL/Ubuntu/SUSE) with good Shell Scripting knowledge.
• Proficient in Storage Engine Architecture (Innodb, MyISAM, NDB, Memory, Archive etc.) concurrency, transactions, indexing, locking, caching.
• Strong Expertise in Installation/configuration and Migration of MySQL 5.6/5.X Enterprise/Community Version and above Databases.
• In-depth knowledge of Database Architecture, Data Structures and internals.
• Strong Knowledge on implementation of SOP framework, processes and policies.
• Strong Knowledge on scripting to automate DB tasks, maintain configuration for Databases and implementation of Proactive monitoring.
• Strong Knowledge in Installation, configuration and monitoring MySQL Databases, MySQL Clusters.
• Real-time knowledge on Database performance assessment and capacity planning.
• In-depth knowledge on High-Availability Environments like MySQL Replication topologies (Master-Master, Master-Slave etc.), DRBD Setups.
• Strong knowledge on implementing traditional backup/recovery process and percona backup/recovery processes.
• Expertise in writing and debugging SQL Queries and performance optimization.
• Hands-on experience MySQL version upgrade/patches, User Administration, Security Implementation and Audit processes.
• Sound Knowledge on any of UI’s like MySQL Workbench, SQLyog, Control Centre, MySQL Administrator.
• Contribute to architectural directions and new features evaluation/implementation.
• Provide off-hours maintenance and project support.
• Ability to Guide development teams on appropriate use of database features and structures.
• Ability to identify inefficient queries and develop alternatives.
• Knowledge on SAN storage arrays, VMware and Linux-DRBD.
• Knowledge on other RDMS Environments like PostgreSQL/SQL Server/Oracle is added advantage.
• Excellent at Communication, Problem-solving and Interpersonal Skills