Senior Lead Database Engineer - DevOps

JOB TITLE:  Senior Lead Database Engineer - Devops

DEPARTMENT: Infrastructure Platform Engineering

REPORTING TO: Senior Manager – Database Solutions

The Senior Lead Database Engineer is a technical authority on Database based projects and will provide production and development support for all LSEG BSL database applications.  This includes design, deployment, migration, automation and operational support of critically important Oracle and SQL Server databases hosted on the Microsoft Azure platform. 

You will work closely with DB Design, Application and Cloud teams to build robust, scalable and secure databases environments in Azure using industry standard methodologies and ensuring these systems are maintained to these standards.

The role involves designing and implementing the database strategies for backup and recovery, performance analysis, clustering, data management, user and developer assistance, and be a point of escalation.

Also responsible for database connectivity using ODBC, JDBC or vendor specific architectures.

Key responsibilities of the role:

• Leads projects’ priorities and outcomes.
• Evaluates new database features, emerging database technologies, and database reference architecture on premise and in public / private cloud.
• Contributes to defining company standards for infrastructure including servers, storage, networking, converged / hyper-converged infrastructure, and VMware technologies.
• Leads database technology strategies for migration, consolidation, replication, partitioning, backup & recovery, and prevention of data corruption.
• Leads development and maintenance of database designs, builds, patching and security capabilities using company tools and standards to improve the availability, scalability, latency, and efficiency of LSEG’s services.
• Assists Cybersecurity in maintaining an appropriate database security policy and evaluate applications to ‘police’ alignment to policy.
• Liaises with external vendors, application teams and business lines to determine database requirements / proposals for delivering maximum benefit to the business.
• Provides guidance in Business Continuity, High Availability, and Disaster Recovery strategies.
• Monitors and handles database resources to ensure optimum performance.
• Writes and reviews highly optimised and accurate code for LSEG database infrastructure and suggests improvements to existing code.
• Defines and maintains strategies for database management to include both manual procedures/spot checks and automated alerts.
• Provides mentorship and trains other team members on design techniques and coding standards, nurtures innovation and teamwork, and assists with complex critical issues.
• Assists Unix and Windows administrators to support applications requiring database expertise.

Design, Develop, Deploy and Migrate responsibilities:

• Define standards for Database deployments
• Define data migration approaches
• 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 (SQL Server) in Azure.
• Define and validate database migration plans 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.

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 SQL Server DB workloads on Azure.

Automation DBA responsibilities

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

Extensive experience in Programming, Automation and DevOps.  Familiar with Database Programming Languages: Oracle SQL and PL/SQL, SQL Server TSQL Scripting

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 anyone’s 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' and employees' 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 it’s used for, and how it’s 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.