IHS Markit Microsoft SQL Database Engineer in London, United Kingdom

We continue to value and promote our only sustainable advantage and asset – our colleagues.

This position is eligible for the IHS Markit Colleague Referral Program – please refer a friend by clicking the “Email Job to Friend” button or asking them to apply at www.ihs.com/careers at http://bit.ly/1KVdtA7

Click here at https://bit.ly/referral_jobfooter to visit the Colleague Referral Program page on Jive and learn about your eligibility for a Cash Reward!

Department overview:

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.

Position summary

A MS SQL Database Engineer, who is comfortable working within a matrixed environment and is focused on providing operational excellence within the MS SQL platform, this experienced database administrator will possess broad technical knowledge and bring an established work history with Microsoft SQL Server to a high-availability, production environment. This person will own the availability and performance of top revenue-producing databases and coordinates troubleshooting efforts across the infrastructure. Incumbent is a strong team player, who is comfortable leading database projects and collaborating with global database team members in many areas of SQL Server database administration.

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

  • Experience with performance and availability monitoring systems.

  • A working knowledge of ITIL

Commercial awareness

Ability to understand business objectives and focus and prioritize multiple projects accordingly.

Personal competencies

  • Personal impact: Willingness to take ownership of production issues is a must, as is the ability to provide support to other members of the team.

  • Communication: Excellent communication skills, both written and verbal, in the English language.

  • Teamwork: Must be able to work effectively with other groups, such as Network, Database, Virtualisation, Storage and Development teams, in resolving issues.

Salary: Competitive

Date Opened: 08 Sep 2017

Date Closing: 08 Oct 2017

Eligible colleagues must meet the requirements of the job as indicated in the posted job description.

Colleagues must have at least six months of continuous service in their current position with IHS to apply for a posted job, unless approval is granted by the colleagues’ supervisor and Human Resources. This period allows colleagues to become competent in their current role and demonstrate satisfactory performance.

Colleagues must be in good standing in their current role. Colleagues who have received Disciplinary Action or who have been on a Performance Improvement Plan within the past 6 months may not participate in the Job Posting Program, unless approval is granted by the colleague’s supervisor and Human Resources.

Provided that the colleague meets the eligibility requirements mentioned above, as well as the minimum requirements for the position of interest, the colleague should notify his /her supervisor of the intent to apply for an internal position, prior to posting. Any concerns with supervisory notification should be brought to the attention of Human Resources.

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 Markit is a participant in E-Verify (see links below) . We maintain a drug-free workplace and perform pre-employment drug testing.

EEO is the Law at http://www1.eeoc.gov/employers/upload/eeocselfprint_poster.pdf

EEO is the Law Supplement at http://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCPEEOSupplementFinalJRFQA508c.pdf

Right to Work at http://www.uscis.gov/sites/default/files/USCIS/Verification/E-Verify/E-VerifyNativeDocuments/OSCRighttoWorkPoster.pdf

Pay Transparency Policy at https://www.dol.gov/ofccp/pdf/pay-transp_formattedESQA508c.pdf

E-Verify at https://e-verify.uscis.gov/emp/media/resourcesContents/EverifyPosterEnglish.pdf