Senior Lead Database Engineer - DevOps

Location: Bengaluru

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 Dev Ops 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 Dev Ops tools and practices. Ability to develop automation to provision and manage SQL Server DB workloads on Azure.

Automation DBA Responsibilities

SRE / Dev Ops (Python, Terraform, Ansible, Powershell Scripting / Bash / Korn Shell Scripting, Git Hub/Gitlab, Bitbucket, Jenkins, Rundeck, Hashicorp Vault, docker, Kubernetes, helm charts etc.).
RDBMS (Oracle, SQL Server, Postgre

SQL etc).
Azure, AWS (RDS and…