Database Support Engineer
Shift Pattern:
Standard 40 Hour Week (United Kingdom) Scheduled Weekly Hours:
40 Corporate Grade:
F - Officer Reporting Line:
(UK Division) LME Information Technology Location:
UK-London Worker Type:
Permanent About the London Metal Exchange: The London Metal Exchange (LME) is the world centre for industrial metals trading. In 2022, 134.2 million lots were traded, equating to $15.2 trillion and 3.1 billion tonnes notional, with a market open interest high of 1.8 million lots. The metals community uses the LME, an HKEX Group company, as a venue to transfer or take on price risk, as a physical market of last resort and as the provider of transparent global reference prices. Overall Purpose of Role: Assist the team in managing the development and performance of SQL databases, being responsible for the day-to-day support of Database Services, focusing on: Supporting Business-As-Usual activity for the database team Incident and change management process Monitoring and alerting Responsibilities: Ensuring all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) Testing backups to ensure we can meet the business’ Recovery Time Objectives (RTO) Troubleshooting SQL Server service outages as they occur Configuring SQL Server monitoring utilities to minimize false alarms Monitoring and reporting on all database checks Performing database and software life-cycle activities to ensure highest level of system performance and availability Working with the senior DBA to assist in database deployment Documenting the company’s database environment Performance, compatibility testing and dependency management between components Automation and scripting of delivery processes or frameworks such as a build or application delivery Collaborating with other software engineers and managers, technical leads, and developers to ensure successful delivery of software projects Contributing to the delivery of efficient solutions to meet business continuity and disaster recovery requirements Academic and Professional Qualifications Required: Degree educated, in a technical discipline Any professional qualifications (MS SQL, ITIL or similar) would be useful Required Knowledge and Level of Experience: SQL and relational databases Windows/Linux and Database Security concepts Clustering, disaster recovery and high availability Automation using Ansible or similar tools Proficiency in at least one programming language (Python, Java, SQL, Powershell, etc.) Exposure to cloud technologies would be useful The LME is committed to creating a diverse environment and is proud to be an equal opportunity employer. In recruiting for our teams, we welcome the unique contributions that you can bring in terms of education, ethnicity, race, sex, gender identity, expression and reassignment, nation of origin, age, languages spoken, colour, religion, disability, sexual orientation and beliefs. In doing so, we want every LME employee to feel our commitment to showing respect for all and encouraging open collaboration and communication. About Us
Hong Kong Exchanges and Clearing Limited (HKEX) is a publicly-traded company (HKEX Stock Code:388) and one of the world’s leading global exchange groups, offering a range of equity, derivative, commodity, fixed income and other financial markets, products and services, including the London Metals Exchange. As a superconnector and gateway between East and West, HKEX facilitates the two-way flow of capital, ideas and dialogue between China and the rest of world, through its pioneering Connect schemes, increasingly diversified product ecosystem and its deep, liquid and international markets. HKEX is a purpose-led organisation which, across its business and through the work of HKEX Foundation, seeks to connect, promote and progress its markets and the communities it supports for the prosperity of all.
#J-18808-Ljbffr
Shift Pattern:
Standard 40 Hour Week (United Kingdom) Scheduled Weekly Hours:
40 Corporate Grade:
F - Officer Reporting Line:
(UK Division) LME Information Technology Location:
UK-London Worker Type:
Permanent About the London Metal Exchange: The London Metal Exchange (LME) is the world centre for industrial metals trading. In 2022, 134.2 million lots were traded, equating to $15.2 trillion and 3.1 billion tonnes notional, with a market open interest high of 1.8 million lots. The metals community uses the LME, an HKEX Group company, as a venue to transfer or take on price risk, as a physical market of last resort and as the provider of transparent global reference prices. Overall Purpose of Role: Assist the team in managing the development and performance of SQL databases, being responsible for the day-to-day support of Database Services, focusing on: Supporting Business-As-Usual activity for the database team Incident and change management process Monitoring and alerting Responsibilities: Ensuring all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) Testing backups to ensure we can meet the business’ Recovery Time Objectives (RTO) Troubleshooting SQL Server service outages as they occur Configuring SQL Server monitoring utilities to minimize false alarms Monitoring and reporting on all database checks Performing database and software life-cycle activities to ensure highest level of system performance and availability Working with the senior DBA to assist in database deployment Documenting the company’s database environment Performance, compatibility testing and dependency management between components Automation and scripting of delivery processes or frameworks such as a build or application delivery Collaborating with other software engineers and managers, technical leads, and developers to ensure successful delivery of software projects Contributing to the delivery of efficient solutions to meet business continuity and disaster recovery requirements Academic and Professional Qualifications Required: Degree educated, in a technical discipline Any professional qualifications (MS SQL, ITIL or similar) would be useful Required Knowledge and Level of Experience: SQL and relational databases Windows/Linux and Database Security concepts Clustering, disaster recovery and high availability Automation using Ansible or similar tools Proficiency in at least one programming language (Python, Java, SQL, Powershell, etc.) Exposure to cloud technologies would be useful The LME is committed to creating a diverse environment and is proud to be an equal opportunity employer. In recruiting for our teams, we welcome the unique contributions that you can bring in terms of education, ethnicity, race, sex, gender identity, expression and reassignment, nation of origin, age, languages spoken, colour, religion, disability, sexual orientation and beliefs. In doing so, we want every LME employee to feel our commitment to showing respect for all and encouraging open collaboration and communication. About Us
Hong Kong Exchanges and Clearing Limited (HKEX) is a publicly-traded company (HKEX Stock Code:388) and one of the world’s leading global exchange groups, offering a range of equity, derivative, commodity, fixed income and other financial markets, products and services, including the London Metals Exchange. As a superconnector and gateway between East and West, HKEX facilitates the two-way flow of capital, ideas and dialogue between China and the rest of world, through its pioneering Connect schemes, increasingly diversified product ecosystem and its deep, liquid and international markets. HKEX is a purpose-led organisation which, across its business and through the work of HKEX Foundation, seeks to connect, promote and progress its markets and the communities it supports for the prosperity of all.
#J-18808-Ljbffr
