Database Administrator

Reviews service-related reports: (e.g: backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within SLAs. 

Respond to database related alerts and escalations and work with database engineering to come up with strategic solutions to recurring problems. 

Works with database engineering to develop ongoing assessments of database performance and identify problem areas. 

Works with database engineering to develop and enforce a security scheme for the database environment. 

Responsible for deploying database objects like tables, indexes, packages and views across multiple environments. 

Should be proficient in Understanding and Analyzing Database Logs. 

Should be able to work on OnCall (24*7 support) rotation. 

Should be comfortable to work as L1, L2, L3 as and when required.

MINIMUM REQUIREMENTS: 

BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field. 

Preferred 5-10 years as Database Administrator with MySQL related systems and strong understanding of database structures, theories, principles, and practices. 

Knowledge on MySQL Database Architecture and Storage Engines. 

Should be proficient in SQL Query Tuning and Slow Query Optimizations. 

Ability to write, optimize and troubleshoot Stored Procedures, Triggers, Views, Indexed Views, etc. 

Knowledge of Indexes and Index Management Ability to use Performance Monitor to gather Metrics to define baselines ‘

Understanding of, and experience with, server-client computing and relational database environments. 

Experience with AWS - DBA experience on AWS hosted databases such RDS and/or Aurora for MySQL. 

Experience with AWS services like Cloudwatch and other supported services to optimize RDS/Aurora databases. 

MySQL open source tool kit and Percona tool kit experience. 

Experience deploying, configuring, and managing Innodb Cluster - Group Replication. 

Database migration experience (Cloud migration projects). 

Experience with data management and data processing flowcharting techniques. 

Knowledge of reporting and query tools and practices. 

Able to prioritize and execute tasks in a high-pressure environment. 

Experience working in a team-oriented, collaborative environment. 

Ability to work towards proactive solutions. 

Willingness to learn in new technologies. 

Strong root cause analysis. 

Technical documentation skills. 

Good understanding of the organization’s goals and objectives. 

Good interpersonal, written, and oral communication skills. 

*Technical interviews may include demonstration of technical skills.

PREFERRED REQUIREMENTS: 

Experience with Datadog, Splunk, Elastic including APM is a huge plus. 

Experience with other monitoring tools: Idera, MonYog, Red-Gate, Elastic, etc. 

Certification is a plus; MCTS, MCITP, MVP, Oracle (MySQL), Percona, AWS, GCP, Azure Data.

Experience with Microsoft SQL Server experience (2016 - 2019)

○ Experience with High Availability (Always On/Log Shipping) 

○ Experience using SQL Profiler 

○ Examining Execution Plans 

○ SSRS Administration and Configuration 

○ SSIS

   Experience working with VLDB > 1TB Familiarity with NoSQL