Lead Database Engineer

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. (ref:hirist.tech)