Lead Database Engineer

S&P Global; Dadri; On-site; INR 2,500,000 - 8,000,000; Full time

Job summary

S&P Global is seeking a hands-on Database Architect to design, implement, and maintain scalable database solutions across SQL Server, Oracle and PostgreSQL. You will drive data modeling, security, and performance tuning while collaborating with developers and business stakeholders.

The role emphasizes cloud integrations (AWS, Terraform, Ansible) and robust backup/DR strategies, with night-shift flexibility as needed to support operations. A senior, hands-on mindset is essential.

Qualifications

• Expertise in database design, data modeling and schema development.
• Strong experience with SQL Server, Oracle and cloud database solutions.
• Proficiency in performance tuning, indexing and data security.

Responsibilities

• Design scalable, high-performance database solutions using SQL Server, Oracle, or PostgreSQL.
• Develop and maintain data models, stored procedures, functions, triggers and views.
• Ensure security, compliance and performance through tuning and monitoring.
• Collaborate with developers and stakeholders to align databases with applications.
• Plan backup, disaster recovery and high-availability strategies.

Tools

SQL Server

Oracle

PostgreSQL

AWS CloudFormation

Terraform

Ansible

Job description

About the Role:

Grade Level (for internal use):

11

The Role:

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 experience in cloud database solutions and large-scale data management projects.

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 more equitable future and to helping our customers find new, sustainable ways of doing business. Join us and help create the critical insights that truly make a difference.

Our Values:

Integrity, Discovery, Partnership

Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead. We start with a foundation of integrity in all we do, bring a spirit of discovery to our work, and collaborate in close partnership with each other and our customers to achieve shared goals.

Benefits:

We take care of you, so you can take care of business. We care about our people. That’s why we provide everything you—and your career—need to thrive