Lead Engineer Database Engineer - DevOps

Description :

The Lead Engineer Database Engineer - Devops will design and detail the strategies for backup and recovery, performance analysis, clustering, data management, user and developer assistance, and will also be a point of escalation. The engineer will also be responsible for database connectivity using ODBC, JDBC or vendor-specific architectures. This role will be responsible for the design, deployment, migration and operational support of critically important Oracle / SQL databases hosted on the Microsoft Azure platform. Work closely with DB Design, Application and cloud teams to build robust, scalable, and secure database environments in Azure and migrate DB workloads from :

• 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 in supporting 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 with policy.
• Develop automation for database deployment and maintenance using DevOps tools and Infrastructure-as-Code (IaC) practices.
• Play a key role in the solution design and implementation of database infrastructure (Oracle) in Azure.
• Implement database migrations from on-premise to Azure.
• Develop and maintain CI / CD pipelines specific to the database.
• Ensure alignment with the defined Database standards evaluation.
• Apply security standard methodologies and compliance controls for database 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 :
• Experience supporting business-critical applications and servers in a multi-data centre / multisite environment.
• Familiarity with IaC and DevOps tools and practices.
• Ability to develop automation to provision and manage Oracle DB workloads on DBA :
• 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 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 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 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)