database engineer i

Grade Level (for internal use): 08

Job Profile: Database Engineer II (A), Database Engineering
Job Family: Database Engineering
Compensation Grade: 08A

Business Title: DATABASE ENGINEER I

Primary Technology: Microsoft SQL Server
Secondary Technology (optional): Oracle, MySQL, SOLR, Elastic Search, Attunity, NIFI

Responsibilities:

• As a Database Administrator (Database Engineer II) you will Support, Administer, Manage the multi-terabyte Database Systems that will enable S&P Global Market Intelligence to ingest, manage, process and serve-up Market Data Products (Research Content, Pricing, Ratings & Financial Aggregates) as well as our highly transactional and dynamic web based CIQ Pro, CIQ Classic and Risk Solutions Platform.
• Manage key database releases for QA, Pre-Production, Production and DR as part of the overall SDLC.
• Contribute to best of breed product support tools and processes including run books, monitoring, and knowledge bases to aid in the product support process and Exercising judgment within defined procedures and policies to determine appropriate action.
• Install upgrades and patches to existing databases servers
• Automate routine maintenance tasks using scripting technologies
• Solves a range of routine problems and analyzes possible solutions using standard procedures.
• Solves problems with minimal oversight or interaction and with general instruction on new work assignments.
• Work with IT Server Management and other groups and make sure that all events, incidents and problems are resolved as per the SLA.
• Improve efficiency and quality of delivery by automating routine tasks.
• Contribute to best of breed product support tools including run books, monitoring, and knowledge bases to aid in the product support process.
• Suggest improvements to current processes and tools we use.
• Willing work on 24/7 shifts
• Perform database backups/ refreshes in non-prod environments.
• Participate 24x7 on call tier 3 support on a weekly rotating schedule
• Contribute to process and troubleshooting documentation.
• Should be able to support virtualized environment

The Impact:

• This is an extremely visible role as the database is the backbone of our flagship products. These products rely on data to allow our customers to find the companies, securities and markets they are interested in, to explore the relationships between entities, and to search using public identifiers (CUSIPs, ISINs, SEDOLs, Tickers, etc). This critical backend driven data allow our users to value their portfolios, monitor market moving events, understand their risk and maintain their back office systems.
• Contribute to the achievement of Database Administration objectives
• Work on issues where analysis of situation or data requires review of relevant factors.

What's in it for you:

• This is the place to hone your existing database and leadership skills while having the chance to become exposed to fresh and divergent technologies (e.g. SQL Server Analysis Services, Oracle, SQL Server Replication, Attunity, NIFI, SQL Server Clustering, SQL Server-AlwaysOn, NoSQL, SOLR, Elastic Search, active-active Databases, and petabyte storage levels).
• As a critical member of the team, you will have the opportunity collaborate with a global team of database administrators and engineers who have recently graduated as well as other team members who are experts in their domain.

The Team:

• You will be part of a world class Database Reliability Engineering (DBRE)/DSE team supporting various product offerings of S&P Global Market Intelligence powered by various middle tier, database and OS technologies and used by tens of thousands of users globally. The team is responsible for ensuring Greater Reliability, High Performance, High Availability and Scalability.
• You will work with a global team of intelligent and ambitious professionals recruited from top industries. The team is responsible for the database support, administration, scalability, performance tuning, release and architecture of large-scale data processing, aggregation and retrieval systems.

What We are looking for:

• We are looking for the kind of person who is not only a roll up the sleeves hard core database technologist, but also a passionate database team member who can lead by example and motivate their peers to excel.

Basic Qualifications:

• Bachelor's degree in Computer Science, Information Systems or Engineering
• 1+ years of hands-on database administration
• ITIL V3 Foundation Certified is a plus.
• AZURE/AWS/GCP Certified is a plus.

Preferred Qualifications:

• Fair MS SQL Server hands on experience (Experience with additional Database platforms like NoSQL, SOLR, Elastic Search, Oracle and PostgreSQL is a huge Plus).
• Fair experience with database support, administration and database monitoring.
• Knowledge on Transactional Replication, Log Shipping, Mirroring, AlwaysOn and Windows Clustering is a plus.
• Knowledge on PowerShell or any other scripting or program language is a plus.
• Basic knowledge and experience with a NoSQL, SOLR, Elastic Search technology and - or Oracle is a plus
• Good communication skills, with verbal and writing proficiencies.

About S&P Global Market Intelligence:

At S&P Global Market Intelligence, we know that not all information is important—some of it is vital. Accurate, deep and insightful. We integrate financial and industry data, research and news into tools that help track performance, generate alpha, identify investment ideas, understand competitive and industry dynamics, perform valuation and assess credit risk. Investment professionals, government agencies, corporations and universities globally can gain the intelligence essential to making business and financial decisions with conviction.

S&P Global Market Intelligence is a division of S&P Global (NYSE: SPGI), which provides essential intelligence for individuals, companies and governments to make decisions with confidence. For more information, visitwww.spglobal.com/marketintelligence