Job Description

CLOUD DB( SQL + Aurora) - 1 Year Contract with Company NP - Who can join within 20 days Strong Communication · Work under general direction. Use discretion in responding to moderate issues, review your own work at frequent milestones and determine when issues should be escalated to a higher level. · Interact and exert influence over colleagues, stakeholders and external partners. · Perform moderate work and non-routine in a variety of environments. · Apply methodical approach to the resolution of moderately complex issues. · Demonstrate an analytical and systematic approach to issue resolution. · Plan, schedule and monitor your work competently within deadlines and according to standards/quality expected. · Be a team player and contribute fully to the workings of the team. · Demonstrate communication skills and identify and negotiate appropriate personal development opportunity. Skills and Experience: · Minimum of 6 years of experience working with MySQL, MariaDB, percona databases and/or other databases. · Minimum 2+ years of experience with AWS RDS (Aurora, DynamoDB and Redshift, etc.) · Should support/Administer i.e. manage, maintain and monitor Aurora databases in AWS and on-prem MySQL databases. · Perform 24x7 advanced tier troubleshooting, including off-hour maintenance and optimization activities, problem resolution, and on-call. · Possess a working knowledge of database internals including locks, waits, transaction consistency, data integrity, recovery paths, etc. · Knowledge of containerization such as Docker or Kubernetes and EKS services would be a huge plus. · Must have performed MySQL/aurora (cloud) database upgrades and patching with minimum downtime (rolling upgrades/patches). · Should have experience in migrating on-prem MySql databases to RDS using different methods like DMS, Replication, etc. · Should have worked directly with developers and engineers to review database models and design, indexes and queries. · Perform database backups and recovery. · Must-know techniques of backing up tables, databases, utilities for backup and restoring them to a point-in-time or restore a master. · Design and build Disaster Recovery strategies · Should possess strong architecture knowledge and concept of infrastructure, storage, networking, and databases. · Should have a reasonable understa