MySQL DBA

Summary of the position
The MySQL Database Administrator (DBA) will be based in our PMC India Office in Vadodara, task managed and supervised by the Database Service Manager. You will be responsible for carrying out maintenance & support of multiple enterprises, mission-critical Database Server. Resolution of incidents & problems, root cause analysis (RCA) leading to recommending and performing change activities concerning the databases and interfaced applications. You will be expected to perform, as required, various ad hoc database project activities.

The role extends to defining and operating scheduled housekeeping activities, defining, recommending, and implementing monitoring and alerting processes. Supporting solution architects and developers on test, UAT and production environments.

This DBA will participate in a 24/7 OOH schedule including bank holidays – as the team grows this will then move to an on the desk 24/7 & BHs as a standard shift pattern.

Your passion for delivering a high degree of customer service, technical expertise, diligence and timeliness is vital. As a DBA, you will need to be articulate, advocating accurate and comprehensive solutions to system problems & requirements. You will work as part of a small team of off-shore DBAs to implement effective 24/7 support, monitoring & alerting services utilising our PMC India Office in Vadodara.

Key Accountabilities

• Provide reactive support, adhering to fast response and resolution deadlines, in the event of an unplanned interruption to the customer’s provided services. Support services are defined as any application which has a dependency on a database.

• Lead the resolution of incidents raised as part of the PMC resolver group adhering to PMC’s contractual obligations regarding SLA performance.

• Provide daily database administration activities including, but not limited to:

• Housekeeping including the creation, implementation, and ongoing maintenance of maintenance plans for the efficient running of a database, and any associated application with a dependency on the database.

• Monitoring and alerting of MySQL Database Instance. The review, creation, implementation and maintenance of monitoring parameters enabling proactive database monitoring and, importantly, issue prevention.

• Operating system and application configuration recommendations for optimising the supported databases to maximise effective and efficient operation.

• Database replication, best practices, and support of existing operational systems.

• Database backup and DR processes – to create, maintain and monitor.

• Perform Change Management activities to include but not limited to:

• Change assessments for all database-related changes.

• To support the customer in change testing.

• Deploying and rolling back all database changes for projects and BAU fixes on the production databases.

• Provide project-based activities at agreed schedule times to include but not limited to:

• Develop, modify any database objects as required by the project.

• Upgrade databases to newer versions.

• Reviewing database scripts written by developers.

• Advice on peripheral OS configurations or capacity parameters as appropriate.

• Design database schemas in coordination with the customer’s data architecture principles and cooperation with the customer’s data architect, including any implementation or upgrade of database platforms.

Skills and Experience | Essential

• Good experience as MySQL DBA on Installation, configuration and upgrading of MySQL Server

• Ensure integrity, Availability, and performance of MySQL database systems by providing technical support and maintenance

• Knowledge on MySQL DB architecture

• Implement and maintain database security (create and maintain users and roles, assign privileges)

• Perform troubleshooting and maintenance of multiple databases.

• Monitor databases regularly to check for any errors such as existing locks and failed updates

• Good experience on managing regular backups, recovery and PITR of databases

• Oversee the File system alerts and utilization of data and log files.

• Responsible for regular maintenance on databases

• Proficiency in MySQL database performance tuning and optimization (Query optimization, Indexing etc.)

• Experience on Data movement utilities like Export/load/Dump

• Identify and recommend database best practices to support business needs

• Shell scripting knowledge for automation tasks and monitoring alerts

• Able to support 24/7 rotation

Skills and Experience | Desirable

• MySQL Certification (e.g. Oracle certified MySQL Database Administrator)

• Experience and working knowledge of other RDBMS systems, especially AWS Aurora.

• Exposure to SQL Azure

• Exposure to Linux Operating Systems