Lead Database Engineer

spgi; Union City (IN); On-site; USD 120,000 - 180,000; Full time

Job summary

S&P Global Market Intelligence in the United States seeks a seasoned Database Architect to design, implement, and maintain scalable database solutions across SQL Server, Oracle, and PostgreSQL, while driving data strategy and collaborating with developers, admins and stakeholders.

The role emphasizes automation with AWS CloudFormation, Terraform and Ansible, security, performance, backup and disaster recovery, and may require night shifts for on-call support.

Qualifications

• Expertise in database design, data modeling, and schema development.
• Strong experience with SQL Server, Oracle, and cloud database solutions like Amazon RDS or Azure SQL Database.
• Proficiency in database performance tuning, query optimization, and indexing strategies.
• Experience with data replication, partitioning, and sharding techniques.
• Proficiency in automation tools such as AWS CloudFormation, Terraform, or Ansible.
• Excellent problem solving and communication skills.
• 12+ years of experience in database design, architecture, and administration.
• Proven experience delivering scalable database solutions.

Responsibilities

• Design scalable, high-performance database solutions across multiple platforms.
• Define database schema structures, indexing, and partitioning for optimal performance.
• Develop data models to support application requirements and ensure data integrity.
• Establish standards for database design, security, and performance tuning.
• Collaborate with development teams to implement database solutions aligned with applications.
• Develop and maintain stored procedures, functions, triggers, and views for business logic.
• Ensure seamless integration between database systems and data pipelines.
• Analyze performance metrics and optimize through indexing, caching, and partitioning.
• Implement encryption, access controls, auditing, and regulatory compliance.
• Develop backup, recovery, and failover strategies for business continuity.
• Design high availability solutions (Always On, Data Guard, AWS Multi-AZ).
• Maintain thorough documentation of database designs, configurations, and benchmarks.
• Work with stakeholders to translate business requirements into technical solutions.

Skills

Database design

Data modeling

Schema development

SQL Server

Oracle

PostgreSQL

Cloud databases

Performance tuning

Indexing strategies

Automation

Communication

Leadership

On-call readiness

Tools

AWS CloudFormation

Terraform

Ansible

Job description

About the Role:

Grade Level (for internal use): 11 The Role: Database Architect.

The Team: We are looking for a highly self-motivated hands-on Database Architect who would focus on our database infrastructures estate and automations and DevOps engineering within our enterprise solutions division.

The Impact: This is an excellent opportunity to join Enterprise Solutions as we transform and harmonize our infrastructure into a unified place while also developing your skills and furthering your career as we plan to power the markets of the future.

What's in it for you: This is the place to hold your existing Database & Infrastructure skills while having the chance to become exposed to fresh and divergent technologies (e.g. AWS/ Snowflake/ Terraforms/)

Responsibilities: The Database Architect is responsible for designing, implementing, and maintaining database solutions that support business applications and data integration requirements. This role involves defining database structures, ensuring optimal performance, and driving database strategy to align with organizational objectives. The Database Architect collaborates with developers, system administrators, and business stakeholders to deliver scalable and secure database solutions. Willingness to work night shifts as required for the role.

Database Design & Architecture

• Design scalable, high-performance database solutions using SQL Server, Oracle, or PostgreSQL.


• Define database schema structures, indexing strategies, and partitioning techniques for optimal performance.


• Develop data models to support application requirements and ensure data integrity.


• Establish standards for database design, security, and performance tuning.

Database Development & Integration

• Work closely with development teams to implement database solutions that align with application requirements.


• Develop and maintain stored procedures, functions, triggers, and views for business logic.


• Ensure seamless integration between database systems and data pipelines.

Performance Tuning & Optimization

• Analyze database performance metrics and implement indexing, caching, and partitioning strategies.


• Leverage tools like SQL Server Profiler, Oracle AWR, and AWS Performance Insights to monitor and improve performance.

Data Security & Compliance

• Implement encryption, access controls, and auditing measures to secure data assets.


• Ensure compliance with industry standards such as GDPR, HIPAA, or ISO standards.


• Collaborate with security teams to manage database vulnerabilities and risks.

Backup & Disaster Recovery

• Develop comprehensive backup, recovery, and failover strategies for business continuity.


• Design high availability solutions using SQL Server Always On, Oracle Data Guard, or AWS Multi-AZ configurations.

Collaboration & Documentation

• Work closely with stakeholders to gather business requirements and translate them into technical solutions.


• Maintain detailed documentation for database designs, configurations, and performance benchmarks.

What We’re Looking For:

• Expertise in database design, data modeling, and schema development.


• Strong experience with SQL Server, Oracle, and cloud database solutions like Amazon RDS or Azure SQL Database.


• Proficiency in database performance tuning, query optimization, and indexing strategies.


• Experience with data replication, partitioning, and sharding techniques.


• Proficiency in automation tools such as AWS CloudFormation, Terraform, or Ansible.


• Excellent problem solving and communication skills.


• 12+ years of experience in database design, architecture, and administration.


• Proven… >

Preferred Certifications:

• AWS Certified Database - Specialty


• Microsoft Certified: Azure Solutions Architect Expert


• Oracle Certified Master (OCM)


• Certified Data Management Professional (CDMP)

About S&P Global Market Intelligence

At S&P Global Market Intelligence, a division of S&P Global we understand the importance of accurate, deep and insightful information. Our team of experts delivers unrivaled insights and leading data and technology solutions, partnering with customers to expand their perspective, operate with confidence, and make decisions with conviction.

For more information, visit www.spglobal.com/marketintelligence .

What’s In It For You?

Our Mission: Advancing Essential Intelligence.

Our People: We're more than 35,000 strong worldwide-so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all.From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing the way people see things and empowering them to make an impact on the world we live in. We're committed to a mo