Job Description

Summary of the position


The Microsoft SQL Server 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 SQL 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 Microsoft SQL and Oracle databases. 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.


• Provide recommendations to customer IT teams for configuration and installation settings for database server setup to include operating system or application configuration settings where relevant.


• Confirm the databases are in a fit state to be backed up and recovered, supporting as required during database recovery to ensure that applications are in a working condition.


• Restore databases to any environments as requested by the customer.


• Provide support to DR tests and in the event of an invocation of DR to provide technical assistance in bringing the database servers and services back online.


• Provide support outside of core hours for scheduled activities, e.g. maintenance activities, Change implementation, database restoration, DR tests etc.


-Work on rotational OOH schedule - Covering 24/7 & BHs - As the team grows this will then move to a on the desk 24/7 & BHs as a standard rota.


• Provide technical leadership and recommendation into the future direction of database technology.


• Comply with PMC's and the customer's security policies, instructions and directives.


• Perform other duties as requested by PMC.


Skills and Experience | Essential



• MCDBA (Microsoft Certified DBA)


• Bachelor's Degree in a relevant subject, or equivalent.


• Experienced with all editions of MS SQL Server from 2000 through to 2019.


• SQL Server Database 2019 installation & management.


• Configuration of SQL Server in a HA environment including Windows Server Failover Clusters (WSFC), Log shipping and Always-On High Availability (Availability Groups).


• SSIS, SSRS, ETL in SQL Server experience.


• SQL Server Security and DR solutions.


• SQL Server backup, recovery, and performance tuning


• Knowledge of latest features of SQL Server and their benefits.


• Performance troubleshooting business critical databases.


• Experience of working in an ITIL environment, ideally possesses an ITIL Foundation qualification.


• Experience working in a critical 24x7 database environment.


• Solid performance tuning skills and ability to diagnose problems quickly and efficiently.