purpose and adhere to BT Standards
Help to define, develop and implement pre-emptive maintenance, monitoring and housekeeping routines across all defined supported systems to demonstrate a reduction in reactive incidents
Provide weekly reports / feedback when requested
Help service improvement initiatives saving space, cost, improving major system performance and reliability, EOSL targets and NFMI scores.
Ensure all DAAS / EC MI build requests are managed and delivered within the defined CT and are RFT.
Implement DR and resiliency solutions
Ensure all new systems accepted into support have RFT, CT and Automation principles embedded in their design, rejecting anything that is deemed as adding avoidable or manual support overheads
Ensure all team Rotas are properly resourced and executed
Work in a flexible manner to meet the support needs of the team and the expectations of our customer base .
Skill, Experience and Qualifications :
5 or more years of Oracle 3L DBA experience (10g / 11g) supporting production databases. Must have knowledge and experience of 12c.
Must have significant and demonstrable experience of supporting large scale mission critical systems.
Must have ability to investigate and resolve service affecting issues, providing RCA’s and making contributions to PIR calls.
Must have ability to carry out database and application specific, performance reviews and make recommendations to improve throughput and service.
Knowledge of planning, installing, upgrading, and patching Oracle Database software
Experience of developing and testing backup, recovery and housekeeping strategies for mission critical systems.
Excellent communication skills, able to engage at a very detailed technical level with ASG and project teams, through to senior stakeholders adjusting style to suit the audience.
Must be prepared to support out of hours when appropriate, this could be for planned build work or to support major service affecting incidents.
Must have experience, well used skills and full understanding of :
Scripting Skills RMAN
DB Recovery Database Performance Tuning
Dataguard Commvault / Netbackup
Desirable to have experience and understanding of :
GoldenGate PL / SQL
Exadata Oracle Security (TDE and Database Vault)