IHS Markit SQL Server Database Administrator in Dallas, Texas
General Job Duties:
Works with leads on project teams to deploy and maintain database technologies and database-dependent product releases.
Performs database administration tasks, including: installation, configuration, maintenance, tuning, and backup/recovery in a production envrionment.
Monitors and analyzes database performance and usage data to implement proactive/corrective measures.
Owns troubleshooting investigations of IHS Markit’s key internal and customer facing databases, and may facilitate cross-discipline resolution of problems.
Maintains expertise in supported database versions. Implements best-practice standards, relevant features, and recommended upgrades.
Reports to management regularly on database project status and areas of concern.
Participates in a global 24x7 on-call rotation.
Performs other duties as assigned.
Specific Job Duties:
Performs as a member of the Global Database Administration team.
Responds to complex operational issues across multiple installations of the SqlServer (2005/2008/2012/2014/2016) database and Windows infrastructure.
Analyzes SQLserver database performance data and usage trends to institute corrective actions. Maintains CMS (Central Management Server) and other SQLserver monitoring tools.
Administers SQLserver high-availability features (clustering, mirroring, and replication, availability groups) and supplemental tools (SSRS, SSIS, SSAS).
Insures corporate database backup/recovery strategy using Commvault-for-SqlServer, is implemented and tested.
Bachelors in Computer Science, related field or equivalent experience.
MCDBA (Microsoft Certified Database Administrator) certification preferred.
5+ years experience administrating 500 GB+, multi-user Microsoft SQLserver databases (2005, 2008, 2012, 2014, 2016)
3+ years experience in 24x7 production database operations.
Deployment experience in Microsoft high-availability technologies, including clustering, mirroring, and replication.
Administator-level capability with Microsoft Windows operating systems (Windows Server 2003/2008/2012).
Advanced TSQL scripting and query optimization skill.
Administrator experience with SqlServer tools, including CMS, SSRS, SSAS, and SSIS.
Versed in storage (NAS, SAN) and virtualization (VMware) technolgies.
Experience with other enterprise-class databases (Oracle, MySQL, Sybase) and operating systems (Linux, Solaris) desirable.
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 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.