Senior DBA

Hays Specialist Recruitment Limited ,
Hatfield, Hertfordshire
Job Type: Full-time

Overview

An excellent opportunity to work as a Senior DBA for a lead IT service provider Job Summary Location: Hatfield An exciting opportunity has arisen for an experienced Senior DBA within the GIS Databases function. The successful candidate will join a diverse, infrastructure team that manage multiple database environments. Roles & Responsibilities The role is to join as a member of the GIS Databases team which supports all our internal database environments across the group on Oracle and SQL Server. The role's main priority will be to manage our production environments proactively and there will be some element of working on projects. Proactively manage, maintain and monitor Oracle and SQLServer systems Diagnose the database system health regularly and troubleshoot any issues. Capacity monitoring and forecast the growth of critical databases. Able to respond to different stakeholder's support requests Persistently seek innovative ways to improve DBA Team's efficiency and quality. Provide technical expertise to the development teams by assisting developers with implementations and ongoing maintenance of the Database environments. Applicant must be fully responsible for managing all Oracle and SQL Server related Backups and Recovery scenarios and perform backup validation and restore tests. Support all production, development & test environments Be available to work outside normal office hours, weekend and public holidays. Applicants will be expected to be on call after few months and respond according to agreed SLA's The ideal candidate will be fast to learn our topology, have excellent communication skills both face to face and on the telephone, you will have the ability to assess and prioritise tasks without close supervision, with excellent problem solving skills. Effective and accurate documentation, with real-time updates to the various ticketing systems and projects tools is essential. The role includes providing rota based Out-Of-Hours Support for Major Incidents in a 3rd line capacity, which may include attending site in Hatfield, if the need/incident arises. Key Requirements Oracle 12c running on Windows Platforms SQL Server 2012, 2014, 2016, 2017, SSAS, SSRS and SSIS configuration Extensive knowledge of the Oracle and SQL Server toolsets Good SQL & PL/SQL and T-SQL knowledge Performance Tuning expertise on both Oracle and SQL Server databases Good knowledge and working experience of RMAN Thorough understanding of High Availability and DR including working experience of Oracle Data guard and SQL Server availability group Experience of working within a controlled ITIL environment with good understanding of control processes & procedures. Excellent problem solving and troubleshooting skills Motivated team player with excellent organisational skills, triage and task prioritisation. Desirable: Oracle Certification in 12c Microsoft Certifications ITIL Foundation or at minimum awareness Server Hardware predominantly HP Hays Talent Solutions is a trading division of Hays Specialist Recruitment Limited and acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk