Oracle Database Engineer

The role works in a DevOps context, so will work across all of the following areas:

• Delivery of new solutions, upgrades and improvements;
• Routine operational management of the platform to ensure the security and health of the platform;
• Service request management;
• Break-fix as required to ensure that the system is healthy and that we meet our SLAs

The environment is demanding with high expectations for fast turnaround against requests and fault resolution, so we constantly strive to automate the environment to minimise the need for manual intervention. The successful candidate will be able to blend the requirement to define, follow and optimise our service across the domains of people, technology and process.

Principle Responsibilities

• Design, develop and implement complex database systems for new projects and deliveries, in partnership with the Database Architect.
• Delivering against our catalogue of database services
• Monitoring, optimizing, troubleshooting and performance tuning
• Planning requirements and storage needs to allow for database growth and shrinkage
• Delivering our Database service to defined SLAs
• Developing and maintaining backup and disaster recovery plans
• Upgrading, patching, and general database maintenance
• Knowledge sharing and mentoring

Core engineering – mid and top level accountabilities

• Designs, implements, and documents database implementations, and leads in the construction and maintenance of moderately complex or complex  database systems
• Overcomes obstacles to deliver quality implementations and service on  time and  to SLA
• Collaborates and negotiates with all project team members (developers, testers etc)  to maximise the efficiency of the delivery team through an integrated and appropriate DBA services
• Assist the capacity planning and hardware design for database server(s)
• Designs and documents, or validates, the data access mechanisms to guarantee that transactions are processed reliably and data is efficiently stored and retrieved  

Expert Technologist accountabilities

• Recognized as the expert and point of contact for at least one database technology
• Defines and leads on the implementation and selection of database technology through extensive knowledge across platforms and the various advantages and disadvantages of each
• Expert in Physical, virtual or Cloud implementations of databases  

Skills and Experience

Install, configure & support of Oracle Database 10g – 11g – 12c

Install, configure & support of IBM DB2 9 – 10 – 11

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Database upgrade planning and execution

Database patching

Experience with backups, restores and recovery models

DB Security design, implementation and monitoring

Application security

Capacity Planning

SQL and PL/SQL troubleshooting, coding and optimization

Understanding of how the underpinning infrastructure (OS, virtual infrastructure, physical infrastructure) impacts Database design and operations – collaboration with teams that manage those areas

Desirable

Vendor certification

Cloud based administration

Install, configure & support of MS SQL Server 2012, 2014, 2016, 2019

Familiar with VMware (Infrastructure 5.5 / 6 / 6.5), AWS / Azure and Clustering services

Familiar with Microsoft Windows Server 2008, 2012, 2016, Windows 7, 8.1 &10,

Familiar with Linux RHE or CentOS 6 and 7

Very strong attention to detail.