MYSQL DBA with Aurora skill

Description

Provision Aurora instances.• Maintain configuration of Aurora instances including replication setup, parameter settings and identification of appropriate instance types/sizes.• Ensure performance, security, and availability of Aurora databases.• Strong knowledge on database migration• Handle common database procedures, such as upgrade, backup, recovery, and migration.• Monitor production Aurora database(s) in AWS RDS, identifying emerging data-related issues, including system-level and SQL-level performance and database storage utilization, performing tuning and initiating proactive mitigating measures as appropriate; provides data- related incident response; and coordinates with others as necessary.• Respond quickly and effectively to production issues, troubleshooting solutions, and taking responsibility for seeing those solutions through resolution. Identify root cause and corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.• Review/deploy data-manipulation (DML) and data-definition (DDL) changes as needed.• Perform table maintenance as needed for business requirements.• Perform data cleanup in staging and production environments upon request.• Perform access management for authorized users.• Review and execute new queries as needed to support business requirements. • Strong proficiency in supporting, administrating, troubleshooting, and tuning of MySQL databases with a demonstrated thorough knowledge of MySQL 5.6• Strong knowledge of the innoDB storage engine and its affect/limits• Solid skills in performance tuning• Index creation and management• Partitioning creation and management• In-depth knowledge and experience with various database objects creation and maintenance• Experience in replication configuration and resolving replica database performance anomalies• Thorough knowledge of the various MySQL instance parameters governing overall database performance• Working knowledge of MySQL internals (incl. locking, transaction consistency, and recovery paths)• Experience building and administering production databases• Familiarity with Amazon Web Services and/or Cloud Computing• Excellent communication skills

Qualifications

Technical Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 AWS PL3 Desired 2 MySQL DB Administration PL3 Required

* Proficiency Legends

Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.