Lead Database Engineer

Job Description

JOB TITLE - Lead Database Engineer - Devops

DEPARTMENT: Infrastructure Platform Engineering

REPORTING TO: Senior Manager Database Solutions

The Lead Database Engineer - Devops will provide production and development support for all LSEG BSL database applications. This includes designing, defining and implementing database systems with automation tools in accordance with industry standard methodologies and ensuring these systems are maintained to these standards.

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

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

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyones race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants&apos and employees&apos religious practices and beliefs, as well as mental health or physical disability needs.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what its used for, and how its obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.

---