Lead Database Engineer-Devops

Key responsibilities of the role:

• Develop and maintain database build standards including security to industry standards, patching and high availability.
• Monitor and handle database resources to ensure optimum performance.
• Document and run database server procedures such as backup and restore, upgrades and disaster recovery procedures.
• Undertake maintenance and upgrades, generally out of normal business hours including weekends.
• Provide database design support to development projects.
• Performance tuning and diagnostics, query plan analysis and the use of AWR / ASH / ADDM.
• Review database application code, collaborate on code improvements and maintain the source code using standard company tooling.
• Assist Unix administrators to support applications requiring database expertise.
• Participate in shift cover and be available for on-call service. Shift cover will mean that you perform tasks that may be outside of the normal responsibilities.
• Define and maintain a strategy for database management to include both manual procedures/spot checks and automated alerts.
• Assist IT Security in maintaining an appropriate database security policy and evaluate applications to police’ alignment to policy.

Design, Develop, Deploy and Migrate responsibilities:

• Develop automation for database deployment and maintenance using DevOps tools and Infrastructure-as-Code (IaC) practices.
• Play a key role in solution design and implementation of database infrastructure (Oracle) in Azure.
• Implement database migrations from on-premises to Azure.
• Develop and maintain CI/CD pipelines specific to database.
• Ensure alignment with defined Database standards.
• Apply security standard methodologies and compliance controls for database access.

Operations responsibilities:

• DB Platform Maintenance - Maintain the Database platform including Infrastructure, Code and Integrations to provide a robust database service to the application teams.
• Database Administration - Investigate and resolve production issues, incidents, and service disruptions in a timely manner.

Key behaviours and skills required to be successful in the role:

• Experience supporting business critical applications and servers in a multi data center/ multisite environment.
• Familiarity with IaC and DevOps tools and practices. Ability to develop automation to provision and manage Oracle DB workloads on Azure.

Automation DBA responsibilities:

• SRE / DevOps (Python, Terraform, Ansible, Bash / Korn Shell Scripting, Powershell Scripting, Github/Gitlab, Bitbucket, Jenkins, Rundeck, Hashicorp Vault, docker, Kubernetes, helm charts etc.).
• RDBMS (Oracle, SQL Server, PostgreSQL etc).
• Azure, AWS (RDS) Cloud Database Skills.

Extensive experience in ORACLE 11g, 12c, 19c Database Administration, RAC, Grid Infrastructure, ASM / ACFS, Data Guard, Exadata, PL/SQL, RMAN, Oracle Enterprise Manager, Database Infrastructure Installs, Database Upgrades / Patching, APEX (Application Express), Solaris X86 and Sparc, Red Hat Enterprise Linux.

Other Requirements:

• Experience with Oracle (11g – 23ai), SQL Server (2008 - 2022) or Sybase ASE (15 - 16) would be very favourably considered.
• High Availability and Disaster Recovery with different replication technologies.
• Experience of working in the finance/banking sector would be an advantage.
• Advanced problem solving skills, able to think clearly under pressure and across technology boundaries.
• Able to prioritise work and present a clear list of tasks and time frames to management.
• Understanding of ITIL Service Framework.
• Familiarity with monitoring products.

Optional Requirements:

• Experience with Delphix.
• Experience in Citrix, Web Development, Control-M, Service Now.
• Skills in Perl scripting and other Database technologies such as MySQL, MongoDB.
• Familiar with Distributed Transactions and Data Warehousing.
• Knowledge/Experience in using database migration tools

Required Behavioural Skills:

• Strong persuading and influencing skills.
• Proficient communicator (verbal and written) at business and technical levels.
• Excellent problem solving skills.
• Able to work independently with minimal direction.
• Collaborate closely with various levels of staff within the organisation.
• Great teammate.
• Must be motivated to progress in the role.
• Self starter with the ability to plan and handle work efficiently.
• Pragmatic approach.
• Willingness to share experience / knowledge.