IHS Markit Principal Database Engineer (SQL Server) in London, United Kingdom

Department overview

The Data Platform Engineering team are responsible for designing, validating, automating and enhancing the data platforms used within IHS Markit. These platforms deliver data, our primary commodity, to world leading institutions in the finance, telecommunications, energy, defence, transportation, and automotive industries. Our customer base represents 85% of the Fortune Global 500.

Position summary

This core engineering position is a rare opportunity to take a lead role in driving the evolution of the SQL Server platform for an S&P 500 company. In collaboration with developers, DBAs, system administrators and IT engineers, the successful candidate will help IHS Markit effectively ingest, store, process, and deliver its most valuable commodity, data.

IHS Markit offer a challenging and rewarding environment for confident SQL Server engineers:

  • High revenue systems with demanding performance and availability requirements

  • Large and rapidly growing databases measured in tens of terabytes

  • Developers ever keen to leverage new features

  • Desire to improve service while maintaining, or reducing, costs

  • Structured, semi-structured, and unstructured data

  • Private and public cloud adoption

  • Opportunity to engineer other relational, and NoSQL databases including Oracle Database and MongoDB Enterprise

IHS Markit invests significantly in current technology and this role will involve designing for and working with modern converged IT infrastructure and up-to-date versions of both database and operating system technologies.

Primarily a SQL Server based role, the successful candidate will have the opportunity to contribute to the delivery of all supported data platforms. IHS Markit is also investigating Open Source DBMSs such as MySQL, and Big Data technologies including HDFS, Hadoop, HBase, Spark, Ignite, Elasticsearch, Kafka, and more to handle new data sets and drive value through analytics.

Engineers are expected to stay abreast of general industry trends, and how they can bring value to IHS Markit’s customers.

Duties & accountabilities

  • Delivering services more quickly and to a higher quality using approaches such as

  • Infrastructure as code

  • Continuous Integration

  • Automation

  • Orchestration

  • Core technology roadmap delivery & maintenance

  • Design & documentation of core technology standards & policies

  • Design of shared and dedicated database platforms

  • Delivery of core technology build instructions & training

  • Integrating databases and data platforms with supporting technologies – monitoring, management, security, compliance

  • Delivery of standard operating procedures for core technologies – backup, recovery, patch, upgrade, clone, HA, DR, capacity management

  • Generating new, and sharing old, ideas

  • Sharing knowledge and experience to audiences with different levels of technical understanding

  • Requirements gathering – we build what the business needs

  • Proposing, or reviewing, new feature/technology adoption

  • Testing new versions of databases and data platforms (functional & performance)

  • Testing existing database and data platform technologies on new software versions (E.g. Windows Server, firmware) and hardware platforms (E.g. server, storage)

  • Complex incident and problem resolution (tier 3 support), including application and infrastructure performance problem investigations

  • Influencing adoption of new technologies through budget submission and justification

  • Improving software licence utilisation & management

Business competenciesEducation and experience

More emphasis will be placed on a candidate’s ability to evidence their soft and technical skills than on their academic background.

The ideal candidate will have worked as a senior SQL Server DBA or SQL Server engineer for 10+ years, in environments that have constantly challenged them, enabling them to develop very strong interpersonal and technical capabilities.

Achievement of Microsoft Certified Master (MCM), Microsoft Certified Solutions Expert (MCSE), or evidence that the candidate has achieved an equivalent level of technical capability, is expected.

Active membership of the SQL Server user community (SQL Saturday, SQL Bits, PASS) is a bonus.

The successful candidate will be able to demonstrate a deep understanding, and hands-on experience, with all aspects of the following processes and technologies:

  • SQL Server installation, start-up, backup, recovery, patch, upgrade, migration, & disaster recovery

  • SQL Server resource management, including underlying infrastructure (server, storage, network)

  • SQL Server capacity forecasting (organic growth, new initiatives, application changes, infrastructure changes)

  • SQL Server replication, including Transactional Replication for deployments exceeding 30TBs and 20K+ Articles

  • SQL Server Failover Clustering, Always On Availability Groups, Failover Cluster Instances, including configuration on ESXi and multi-site

  • Database Mirroring, including across domains

  • Windows Server 2008 – 2016

  • SQL Server licensing (2008 onwards), including an understanding of how this is influenced by Software Agreements & Software Assurance

  • Applying an understanding of the SQL Server Query Optimizer and database design best practices (partitioning, indexing, etc) to help developers write efficient and well performing applications

  • Leveraging SQL Server performance features (e.g. Dynamic Management Views) to reduce response times or increase throughput for key business processes, both proactively and reactively

  • Developing efficient SQL, Transact-SQL, and Powershell to automate administration tasks

  • Securing Windows/SQL Server including through the use of Active Directory, Group Managed Service Accounts, Kerberos, security delegation, penetration testing, and implementation of, and adherence to, security best practices

  • SQL Server Reporting Services (SSRS) – Scale-out farm design & management, report design

  • SQL Server Analysis Services (SSAS) – design, implementation, and usage

  • SQL Server Integration Services (SSIS)

  • Job execution via SQL Server Agent

  • SSRS & SSAS report design

  • Storage integration – IO management, multipath, storage protocols

  • SQL Server deployment on both physical and virtual machines

In addition, hands-on experience of the following will be beneficial:

  • Amazon Web Services

  • Microsoft Azure

  • VMWare vRealize/VMWare vRealize Orchestrator

  • Development & monitoring tools – Redgate, Idera, SQL Sentry, Solarwinds

  • System Center Configuration Manager (SCCM) – Package creation, management

  • System Center – Orchestrator – Runbook creation, management

  • AWS RDS for SQL Server

  • Microsoft Power BI

  • .NET development – for automation of administration tasks, and to assist developers interacting with SQL server

  • Data protection technologies – Idera, Quest (Dell), NetBackup, Commvault, Actifio, NetApp AltaVault, Rubriks, or similar

  • Storage/database cloning technologies – Pure FlashArray snapshots , Actifio, Delphix, HPE 3Par Virtual Copy/Physical Copy

  • ServiceNow

  • Microsoft Visual Basic for Applications (VBA)

  • Developing annual budgets, and influencing financial spend

  • Linux operating system – administration and/or interaction with and shell scripting

  • Python scripting

Commercial awareness

Candidates must be able to estimate the costs related to delivering technology services, including software licencing, hardware purchasing and maintenance, human effort costs and the cost of delay. This understanding will be vital in designing services that meet the needs of the business, while remaining cost effective.

Management requirements

No management experience is required, but ‘thought leadership’ qualities will help a candidate achieve success in this role.

Personal competencies

Personal impact

Experience is important, but there will be at least an equal focus on attitude and aptitude.

The successful candidate will be passionate about what they do and be confident of the value they can bring to IHS Markit.

An overwhelming desire to improve oneself through research, learning, listening, and experimentation.

Strong motivation to share ideas, experience, and skills with others.

Willingness to put the needs of the company and colleagues above their own.

Appetite to take ownership of tasks, incidents, and problems, and the capability to complete/resolve them quickly and effectively.

Sufficient self-confidence to question the status quo, and the diplomacy and influencing skills required to convince others to change.

An ability to apply logic to solve problems.

The candidate must be a self-starter, with the motivation and personal organisation to deliver their own work, and encourage delivery from those they depend upon, to project timelines.

Communication

We share what we do with peers, managers, and business partners though documentation, training, and knowledge transfer. The successful candidate will therefore be able to write clear, concise documentation that can be followed by people of all experience levels and explain often complex topics to anyone from a junior developer to a CTO.

IHS Markit is a global organisation, employing people in a variety of industries and from a range of cultures. Clear and effective communication is vital to ensuring the successful adoption of the solutions you propose.

Teamwork

Data Platform Engineering are a team, and not simply a group of talented individuals. We share ideas, skills, and experiences, and shape what we do together. Candidates will need to show that they can thrive in this environment.

Company overview

IHS Markit harnesses deep sources of information, analytics and expertise to forge solutions for the industries and markets that drive global economies. Our company partners with clients in business, finance and government to provide the unrivalled insights and perspectives that lead to well-informed, confident decisions. We call this The New Intelligence.

IHS Markit serves more than 50,000 key customers in more than 140 countries, including 85 percent of the Fortune Global 500. We help decision makers apply higher-level thinking to daily tasks and strategic issues across a host of industries and disciplines including energy, finance, automotive, engineering, technology, maritime and trade, aerospace and defence, chemical, and economics and country risk.

Headquartered in London, IHS Markit (S&P 500: INFO) is committed to sustainable, profitable growth.

It is the policy of IHS Markit to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, IHS Markit will provide reasonable accommodations for qualified individuals with disabilities. We maintain a drug-free workplace. For candidates in the US, we are a participant in E-Verify (see link below).

EEO is the LawEEO is the Law SupplementRight to WorkPay Transparency PolicyE-Verify

Current ColleaguesIf you are currently a colleague with IHS Markit please apply internally via Workday.About IHS Markit

IHS Markit harnesses deep sources of information, analytics and expertise to forge solutions for the industries and markets that drive global economies. Our company partners with clients in business, finance and government to provide the unrivaled insights and perspectives that lead to well-informed, confident decisions. We call this The New Intelligence. IHS Markit serves more than 50,000 key customers in more than 140 countries, including 80 percent of the Fortune Global 500. We help decision makers apply higher-level thinking to daily tasks and strategic issues across a host of industries and disciplines including energy, finance, automotive, engineering, technology, maritime and trade, aerospace and defense, chemical, and economics and country risk.

Headquartered in London, IHS Markit (Nasdaq: INFO) is committed to sustainable, profitable growth.