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!
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 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
Ability to understand business objectives and focus and prioritize multiple projects accordingly.
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.
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