Lead Database Engineer - DevOps

Description :

Responsibilities :

- 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.

Requirements :

- 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.

- 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.

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.

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.