Description:
MySQL (Aurora MySQL) DBA Job Description
We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security 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
• Configuration of Aurora instances including replication setup, parameter settings and identification of appropriate instance types/sizes.
• 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
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• 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.
Skills and Qualifications
• Strong proficiency in MySQL database management, especially with Amazon Aurora.
• Decent experience with recent versions of MySQL
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. will be added advantage.
1.The more the Jobs you apply, the higher your chances of getting a job.
2. Keep your profile updated Update
Recruiters prefer candidates with complete profile information.
3. Keep visiting the Teamlease.com daily
Daily visit will ensure you won’t miss out on any Job opportunity.
4. Watch videos to improve Watch videos
Be a better candidate than others by watching these Job-related videos.