Job Description (Posting).
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 (1.) To provide support for on call escalations and doing root cause analysis of given issue (2.) To independently resolve tickets within agreed SLA of ticket volume and time (3.) To adhere to quality standards, regulatory requirements and company policies (4.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts (5.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases