Infrastructure Engineering Specialist

Why this job matters

The Oracle Database Infrastructure Engineering Specialist is responsible for the design, implementation, and maintenance of Oracle databases including RAC,  Dataguard, Goldengate  and services. They will work closely with the broader engineering team to ensure the reliability, scalability, and security of the company's Oracle Database environment

What you’ll be doing

• Provide consultancy and guidance for the 3L DBA teams responsible for OR production database services.
• Provide Technical Guidance to Senior Managers and Delivery Units on ‘Best Practice’ with regard to the delivery of Oracle database products and services.
• Provide support and technical consultancy for database components which include but are not limited to : patching, upgrades, new database build activity, delivery of backup strategy/solutions, standard / emergency changes, production incident resolution, performance tuning and supporting system migrations. 
• Able to support, coach and motivate a technical teams in the delivery of secure and robust Oracle database products and services.
• When required contribute to 3rd Line support of all Oracle Databases and associated components that form the team’s defined supported estate.
• Responsible for Design and Delivery of systems ensuring the availability and reliability of Openreach database systems with the highest possible level of business criticality where issues can affect the business ability to trade, cash flow and ultimately could be share price affecting.
• Under Service Obsession Initiative, contribute to EOSL by managing the removal of legacy databases and systems. In addition improve system reliability and NFMI maturity ratings. 
• Able to provide assessment of Incident and Change records that impact database with a skill set capable of contributing to RCA and give directions and make recommendations, and, where database related take ownership to improve service, proactively exploring and offering to the wider stakeholder community, including component/ASG teams, improvements including and beyond database related. 
• Have the drive and focus to work in a Service Obsessed environment, putting the Customer first to improve the overall Customer experience.
• Ensure database integrity standards are maintained and database access is secured.
• Responsible for continuous improvement, striving to improve process and automation of all aspects of 3L DBA work. 
• Undertake Technical Lead manager tasks delegated by senior/line management, including covering for Line manager/s as and when necessary / requested.

Skills Required

• 10 or more years of Oracle 3L DBA experience supporting production databases. Knowledge and experience of 23ai,19c and12c. 
• Must have significant and demonstrable experience of supporting large scale mission critical systems including Oracle RAC, Oracle Dataguard and Goldengate.
• Must have proven track record of investigating and resolving service affecting issues, providing RCAs and making contributions to PIR calls.
• Must have proven track record of carrying out database and application specific, performance reviews and making recommendations to improve throughput and service.  
• Extensive knowledge and experience 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 DBA, ASG and project teams, through to senior stakeholders adjusting style to suit the audience.
• Must have demonstrable experience of leading and taking control of issues, incidents with mixed audiences, and particularly with senior stakeholders. To be assertive where necessary, and be prepared to speak out, diplomatically, where concerns need to be aired and addressed.
• 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 considerable experience and understanding of following Oracle Technology stack :  
RAC                            ASM
CRS                            Grid Control / OEM
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)
Virtulization (VMware, VBox)     Postgres Database