Sr Database Administrator

Job Description

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 knowledgeand 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 SQLsolutions, 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 andProduction 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 recoveryof current systems. Business competencies Education and experience A minimum of 3 years working as a Microsoft SQL Database Engineer. In depth experience with Microsoft SQL 2005 and later Strong proficiency with Microsoft TSQL, and ideally its variants inother 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 designingand 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 technologiessuch as iSCSI and Fibre Channel Familiar with storage technologies, particularly NetApp and PureStorage to a level needed to raise storage provisioning requests Experience with Microsoft clustering and/or other clustering technologies. Experienced troubleshootingand problem management Experience with performance and availability monitoring systems. A working knowledge of ITIL A working knowledge of Amazon Aws. Commercial awareness Ability to understand business objectives and focus and prioritize multiple projectsaccordingly. 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 theEnglish language. Teamwork Must be able to work effectively with other groups, such as Network, Database, Virtualisation, Storage and Development teams, in resolving issues. Inclusion and diversity are critical to the success of IHS Markit, and we activelyencourage applications from people of all backgrounds. We are committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, status as a protected veteran,or any other protected category. For more information on the many ways in which we enthusiastically support inclusion and diversity efforts for both candidates and employees, please access our Inclusion & Diversity Statement here . We are proud to providereasonable accommodations to applicants with disabilities. If you are interested in applying for employment with IHS Markit and need special assistance or an accommodation to use our website or to apply for a position, please contact or call +. Determinationon requests for reasonable accommodation are considered on a case-by-case basis. This contact information (email and phone) is intended for application assistance and accommodation requests only. We are unable to accept resumes or provide information aboutapplication status through the phone number or email address above. Resumes are only accepted through the online application process, and only qualified candidates will receive consideration and follow-up. IHS Markit maintains a substance-free workplace; employeesmay be asked to submit to a drug test (where permitted by law). In addition, as a federal contractor in the United States, the company participates in the E-Verify Program to confirm eligibility to work. For information please click on the following links:IHS Markit Business Code of Conduct Right to Work EEO is the Law EEO is the Law Supplement Pay Transparency Current Colleagues If you are currently employed by IHS Markit, please apply internally via the Workday internal careers site.