Microsoft SQL Database Engineer
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.
IHS Markit’s Information Technology group is a globally consistent operational model with consolidated toolsets and compliant processes in support of all Markit products.
IT consists of over 600 IT professionals supporting over 13,000 users and circa 10,000 Windows servers. IT is organised on a Global, Regional and Local basis with the appropriate capabilities in each area to meet the business needs and drive the most efficient organisation.
A MS SQL Database Engineer, who is comfortable working within a matrixed environment and is focussed on providing operational excellence within the MS SQL platform.
Duties & accountabilities
Design and build highly available Microsoft SQL solutions, making use of log shipping, mirroring and Always On technologies
Ensure performance, security, and availability of databases
Prepare documentation and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, and optimize and tweak as necessary
Collaborate with other team members and stakeholders
Work closely with the SQL Operations team, and act in a mentoring capacity to junior DBAs
Collaborate with the global Engineering and Production Support teams to create a forward looking service improvement plans and roadmaps.
Maintain a broad knowledge of operating systems and hardware and making recommendations on improving administration, availability, scalability, and disaster recovery of current systems.
Business competencies, education and experience
A minimum of 3 years working as a Senior Microsoft SQL Database Engineer with at least 10 years MS SQL DBA experience.
In depth experience with Microsoft SQL 2005 and later
Strong proficiency with Microsoft TSQL, and ideally its variants in other popular RDBMS
Skilled at optimizing large complicated SQL statements
Knowledge of best practices when dealing with relational databases
Working knowledge of Microsoft SQL Server merge and transactional replication
A good working knowledge of designing and implementing HA solutions, including use of Always On FCI and Availability Groups
Capable of troubleshooting common database issues
Familiar with tools that can aid with profiling server resource usage and optimizing it
An appreciation of storage technologies such as iSCSI and Fibre Channel
An appreciation and understanding of VMWare ESXi technologies with respect to implementing Microsoft SQL Server
Familiar with storage technologies, particularly HPE 3PAR and PureStorage to a level needed to raise storage provisioning requests
Experience with Microsoft clustering and/or other clustering technologies.
Experienced troubleshooting and problem management
Willingness to take ownership of production issues is a must, as is the ability to provide support to other members of the team.
Excellent communication skills, both written and verbal, in the English language.
Must be able to work effectively with other groups, such as Network, Database, Virtualisation, Storage and Development teams, in resolving issues.
We are proud to be an EEO/AA employer M/F/Disability/Veterans. Please refer to the EEO is the Law Poster & Supplement, Right to Work and Pay Transparency Policy. IHS is a participant in E-Verify (see links below). We maintain a drug-free workplace and perform pre-employment drug testing.