The candidate's primary role will be administering and supporting very large MySQL databases including proactive monitoring of databases for ensuring performance.
Support MS SQL DBA related activities on a need-bases.
Performing application tuning and performance monitoring Plan growth and changes. (Capacity planning).
Deployment of High availability solution with Load Balancing and Failover mechanism.
Monitor, optimize and allocate physical data storage for database systems and work with development teams.
Size various database technologies to business needs/requirements.
6+ years of experience designing, developing, tuning, optimizing, deploying and updating MySQL instances in a high volume transactional environment with critical up time requirements.
Candidate should have experience with database sharding In-depth database knowledge with significant expertise in database administration and MySQL application system administration in Unix/Linux environment.
Implementation and support experience in High Availability features in MySQL for e.g. Replication(RBR/SBR), Clustering (MySQL/Galera) etc. is Must.
Must have managed very large size (TBs) of databases in distributed environment.
Must have configured and managed replication/standby instances of MySQL in UNIX / Linux Environments.
Must have configured and managed online backup technologies in MySQL and ensure disaster recovery and data retention protocols (backup, monitoring, security, installation).
Excellent troubleshooting and performance tuning skills, ability to write shell scripting is required. Ideal candidate will have good exposure to Linux.
Strong process and methodology to work through SDLC for database deployment.
Experience in setup, configuration and manage replication and DR methodologies of MSSQL Server like Transaction, peer-to-peer, log shipping, mirroring and Always-on.
Experience in writing procedures, function and SQL query tuning (ANSI SQL and T-SQL).
Exposure in managing large scale NoSQL databases will be added advantage.