Job Description
ech Lead – Database Engineer (SQL Server Automation)Role ProfileJOB TITLE:Tech Lead – Database Engineer (SQL Server Automation)DEPARTMENT: Foundation ServicesREPORTING TO: Senior Manager – Database SolutionsThe Tech Lead – Database Engineer (SQL Server Automation) 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 Database Engineer 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.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.Review database application code, collaborate on code improvements and maintain the source code using standard company tooling.Assist Unix and Windows 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.Key behaviours and skills required to be successful in the role:Have experience in supporting business critical applications and servers in a multi data center/ multisite environment. In particular the jobholder will demonstrate expertise in the following areas:SQL Server Automation DBA.SRE / DevOps (Python, Terraform, Ansible,, Powershell Scripting / Bash / Korn Shell Scripting, GitHub/Gitlab, Bitbucket, Jenkins, Rundeck, Hashicorp Vault, docker, Kubernetes, helm charts etc.).RDBMS (SQL Server, Oracle, PostgreSQL etc).Azure, AWS (RDS) Cloud Database Skills.Extensive experience in SQL Server 2008 - 2022 Database Administration, Clustering, SQL Server Always On, SQL Server Replication, SQL Server Mirroring, SSRS, SSIS, TSQL Scripting, Database Infrastructure Installs, Database Upgrades / Patching, Windows Server 2008 - 2022, Programming, Automation and DevOps.OTHER REQUIREMENTSExperience with Oracle (11g – 23ai), 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 REQUIREMENTSExperience with Delphix.Experience in Citrix, Web Development, Control-M, Service Now.Skills in other Database technologies such as MySQL, MongoDB.Familiar with Distributed Transactions and Data Warehousing.Required Behavioural SkillsStrong 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.
