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
Skills and Experience | Essential:
MCDBA (Microsoft Certified DBA) or OCP (Oracle Certified Professional DBA) on Oracle 10g or above.
Bachelor's Degree in a relevant subject, or equivalent.
ITIL V3 Foundation Certification or higher
Good working knowledge of Linux operating systems
Previous experience and knowledge of cloud technologies i.e., AWS or Azure
Proven experience of backup/recovery solutions and experience of High Availability Clusters and Standby Databases
Experience of SSRS and SSIS (SQL Server Reporting Services and Initiation Services)
In depth industry experience with Microsoft SQL Server 2008 and upwards and Oracle version 10 and upwards including development and monitoring tools
Experience working in a critical 24x7 database environment
Patching and upgrading of both SQL Server & Oracle.
Skills and Experience | Desirable:
Experience with any of the following additional database/NoSQL technologies
