- Denver, CO, USA
- Permanent, Full time
- S&P Global
- 16 Feb 19
The Role: Microsoft SQL Server Administrator
The Location: Denver, CO
The Team: Information Services is a diverse, globally-distributed team of data engineering and management specialists committed to delivery.
The Impact: This is a hybrid role in-that it supports both "grow-the-business" [Project] as well as "run-the-business" [Lights-On] initiatives. S&P Global Platts is the leading independent provider of information and benchmark prices for the commodities and energy markets. Customers in over 150 countries look to our expertise in news, pricing and analytics to deliver greater transparency and efficiency to markets. Traders, analysts, risk managers, purchasing agents and other professionals at more than 10,000 public and private sector organizations in over 150 countries benefit from S&P Global Platts' services.
What's in it for you: When you work at Platts, the world's leading energy information provider, you get the best of a small company and a Fortune 500 corporation. With more than 900 employees in more than 15 offices spanning five continents, Platts has a highly diverse workforce, a global perspective, and a "business casual" culture. As a subsidiary of S&P Global, Platts offers employees a competitive compensation program, a comprehensive benefits package, and a broad spectrum of professional development opportunities. As an employee of Platts and S&P Global, you are part of an organization with a long-standing legacy of journalistic independence and integrity, and a steadfast commitment to providing the markets with the highest quality, most timely and reliable information.
Responsibilities: Build, maintain, tune and monitor Microsoft SQL Server and Service(s) underlying internal as well as customer-facing solutions. The individual will contribute as part of the Information Services team and work closely with IT architects, tech leads, application developers, business analysts and quality assurance specialists. We're looking for a database administrator that works hard and smart, is driven to deliver on commitments & contributes effectively in collaborative endeavors.
What We're Looking For:
8+ years of experience in the following areas:
- Manage, installation and configuration of MS SQL Server [v2008 - v2017]
- Query, database and system tuning for performance
- RunOps 24x7 on-call support
- Backup/Restore methods, Replication, XML and Full-Text Search
- SSAS, SSRS, SSIS or Master Data Services [MDS]
Experience with reverse-engineering and relational modeling [normalization / de-normalization]
Experience with Power BI, Tableau or similar reporting tool
Excellent verbal and written communication skills [English]
Strong organizational and problem-solving skills
Experience with source code management practices and systems
Experience with Agile as well as Waterfall development methodologies
Experience with Windows Server Failover Clustering [WSFC] a plus