SQL Server Database Engineer

SQL Server Database Engineer

The SQL Server Database Engineer will provide production and development support for LSEG database applications. This includes designing, developing and implementing database systems with advanced automation tools in accordance with industry best practices.

The SQL Server Database Engineer will design and document strategies for backup and recovery, performance analysis, database clustering, and data management.

The SQL Server Database Engineer will also be responsible for database connectivity using ODBC, JDBC or vendor specific architectures, provide user and developer assistance, and also be a point of escalation for first line support.

Key responsibilities of the role:

Develop and maintain database build standards including security to industry standards, patching and high availability Monitor and manage database resources to ensure optimum performance Document and manage 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 and advise accordingly. Manage and maintain the source code control system for the database objects. Assist Windows administrators as necessary to support applications that use the databases. Participate in the support shift cover 8am to 6pm and be available for on-call service. Shift cover will mean that you perform tasks that may be outside of the normal responsibilities. Develop 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. Evaluate and implement applications to 'police' adherence 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 have experience in the following areas:

SQL Server DBA.

Extensive experience in SQL Server 2008 - 2019 Database Administration (Enterprise and Standard editions) Clustering SQL Server Always On SQL Server Replication SQL Server Mirroring SSRS, SSIS Windows Server 2008 - 2019 Database Infrastructure Installs, Upgrades and Patching

OTHER REQUIREMENTS

Experience with Sybase ASE (15 - 16) would be very favourably considered. Experience of working in the finance/banking sector would be an advantage. High Availability and Disaster Recovery using Storage Based Replication Excellent verbal and written communication skills with the ability to communicate effectively at both business and technical level. Excellent problem solving skills, able to think clearly under pressure and across technology boundaries. The ability to plan and manage work and present a clear list of tasks and time frames to management. Understanding of ITIL Service Framework Familiarity with monitoring products. Powershell Scripting TSQL Cloud Technologies (Azure & AWS) DevOps and CI / CD Tools:

Bitbucket, GitLab, Jenkins, Ansible, Terraform, Hashicorp Vault, AWS Workspace

OPTIONAL REQUIREMENTS

Experience with Delphix Python Perl scripting Control-M Data Warehousing Distributed Transactions Other database technologies such as PostgreSQL, MySQL, SAP Hana ServiceNow Experience in Citrix, Web Development would also be an advantage.

Required Behavioural Skills

• Strong persuading and influencing skills.
• Excellent verbal and written skills with the ability to communicate effectively at both business and technical levels.
• Excellent problem solving skills
• Able to work independently with the minimum of supervision.
• The ability to liaise with different levels of staff within the organisation.
• Good team player.
• Must be motivated to progress in the role.
• Self starter with the ability to plan and manage work according to deadlines
• Pragmatic approach.
• Willingness to share experience / knowledge.

We are looking for intellectually curious people, passionate about the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you are creative and a problem solver, this is the place to be as will be supporting you to fast-forward your career.

We maximize each employee's potential through personal development and through a wide range of learning tools both formal and informal. We believe that remunerating our people with competitive salaries and a range of attractive benefits such as:

25 days' holiday per year
1 additional day off for your Birthday
Annual wellness allowance
Share Purchase Plan
Medical Health Insurance
Medical Subscription (preventive medical services)
Dental Coverage
Life insurance
Pillar 3 Private Pension
Meal Vouchers
Flexible Benefits
Bookster
Volunteering Events
Team Buildings

At LSEG, we believe that creating a diverse and inclusive organisation is fundamental to the way we deliver on our promise of creating essential partnerships and open opportunities. Our open culture is central to how we deliver our purpose - driving financial stability, empowering economies and enabling customers to create sustainable growth - in everything we do.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 70 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 any 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.