S&P Global

Senior Lead Database Engineer - SQL Server

Database Administrator in New York, NY , Princeton, NJ , Virginia, USA

Posted 2019-11-08
Description

The individual selected for the role will be part of a world class Data Platform Services SQLOps team supporting our flagship S&P Global Data Platform 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. This individual 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.


The Impact:

Our products rely heavily 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 tickers. This critical back-end driven data, allows our users to value their portfolios, monitor market moving events, understand their risk and maintain their back-office systems.


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. AWS RDS, SQL Server, Oracle, Postgres, NoSQL, Cassandra, Apache NiFi, Attunity, SOLR, Vertica, and petabytes of storage hosted both on-premises and cloud platforms).
As a critical member of the team, this individual will have the opportunity to collaborate with a global team of database administrators and engineers to achieve product and team objectives.

Responsibilities:

As a Lead Database Administrator, you will Support, Administer, Manage, and Tune 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 MI and Legacy CIQ Platforms.

Manage key database releases for QA, Pre-Production, Production and DR as part of the overall SDLC.
Maintain database including patch applications and enhancements/upgrades of environments.
Install upgrades and patches to existing databases servers
Automate routine maintenance tasks using scripting technologies
Solve non-routine problems and determine the best solution through cost/benefit analysis.
Apply methods and procedures on new or special assignments.
Work with other teams with in operations and peer groups like Development and QA as a lead and/or member.
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 and suggest implementation ideas.
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
Work on different NOSQL technologies and provide solutions
What We are looking for

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

Basic Qualifications

Bachelor's degree in Computer Science, Information Systems or Engineering
Experience on MS SQL Server and Persistent NoSQL Data Stores primarily in the AWS Cloud Space and also knowledge of On-Premise infrastructure.
7+ years of hands-on database administration, support and performance tuning experience
Preferred Qualifications

Experience in PostgreSQL Database Administration
Experience in building and managing AWS RDS
Experience in Bash/PowerShell scripting
Experience with data technologies like SOLR, HP Vertica, ELK Stack, Hadoop, Cassandra, Apache NiFi.
Good experience with database support, administration, performance tuning, and database monitoring.
Basic knowledge on PowerShell or any other scripting or program language is a must.
Knowledge on Database Mirroring, SQL Always-On and Windows Clustering is a plus
Excellent communication skills, with strong verbal and writing proficiency.
Ability to troubleshoot problems involving Client Libraries (like ADO.NET), Operating Systems, Network and Storage is a plus.
Experience in an Agile or Dev Ops environment is a plus.
Grade 12 (Internal Only)

To all recruitment agencies: S&P Global does not accept unsolicited agency resumes. Please do not forward such resumes to any S&P Global employee, office location or website. S&P Global will not be responsible for any fees related to such resumes.

S&P Global is an equal opportunity employer committed to making all employment decisions without regard to race/ethnicity, gender, pregnancy, gender identity or expression, color, creed, religion, national origin, age, disability, marital status (including domestic partnerships and civil unions), sexual orientation, military veteran status, unemployment status, or any other basis prohibited by federal, state or local law. Only electronic job submissions will be considered for employment.

If you need an accommodation during the application process due to a disability, please send an email to: EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person.

The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdfdescribes discrimination protections under federal law.

Ready to be seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Company summary

At S&P Global, we don’t give you intelligence—we give you essential intelligence. The essential intelligence you need to make decisions with conviction. Together, the divisions of S&P Global -- including S&P Global Ratings, S&P Global Market Intelligence, S&P Dow Jones Indices, and S&P Global Platts -- are the foremost providers of essential intelligence for the capital and commodities markets.

Whether it's analyzing data, innovating technology, or developing market insights, we're always looking for intellectually curious, progressive and passionate thinkers to join our team. With over 20,000 employees working across 95 offices around the globe, the diverse and vibrant community at S&P Global is unlike one you’ll find anywhere else.

Perks

401K matching; 4 weeks PTO; paternal leave; Tuition refund program; scholarship program for your children; commuter benefits; various discounts on products and services; gym membership discount.

Tech Stack

AWS, DevOps, Azure, Kubernetes, Ansible, Git, Jenkins, Python, Linux, C/C++, Java, C#, ASP.NET, Scala, RESTful APIs

Be seen in a new Database Administrator job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and be seen.