Job Description :
Responsibilities
Provision AWS Aurora MySQL instances instances, both in clustered and non-clustered configurations
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
Estimate MySQL database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Develop Stored Procedures and Database Triggers in support of application development.
Participate in application development projects and be responsible for the database architecture and design.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Participate in a 24×7 support rotation.
Support complex web-based applications.
Demonstrated ability with infrastructure/DB automation tools such as GitHub, Terraform, Ansible, or similar software.
Qualifications
5+ years of experience writing database code in MySQL databases
Experience with a code library tool such as GitHub
Experience with databases in a Linux environment
Experience with MySQL in AWS
Working knowledge of data security, and user authentication and authorization.
5-7 years of relevant work experience.
Must have strong analytical, verbal and written communication skills.
Must have experience in Mysql database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
Must have strong knowledge of Linux.
Strong understanding of command line and server administration.
Knowledge of shell scripting (e.g., Bash, Perl
Knowledge of MySQL features, such as its event scheduler
Ability to plan resource requirements from high level specifications
Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases