- 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:
- 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.
- 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.
- 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.
- 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 setting
- Patching and upgrading of both SQL Server & Oracle.
Skills and Experience | Desirable :
- Experience with any of the following additional database/NoSQL technologies
- MySQL,
- PostgreSQL
- Aurora
- RDS
- CouchDB
- DynamoDB