Lead Database Engineer

S&P Global Market Intelligence; Dadri, Hyderabad, Bengaluru; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

S&P Global Market Intelligence is seeking a seasoned Database Architect to lead our database infrastructures estate, drive automation, and implement DevOps practices within Enterprise Solutions. This role focuses on scalable, secure data platforms and cross-team collaboration.

You will design and optimize schemas for SQL Server, Oracle, and PostgreSQL, champion performance tuning, data security, and highly available architectures using cloud and on-prem technologies.

Qualifications

• 12+ years of experience in database design, architecture, and administration.
• 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 performance tuning, query optimization, and indexing strategies.
• Experience with data replication, partitioning, and sharding.
• Experience with automation tools such as AWS CloudFormation, Terraform, or Ansible.
• Strong problem-solving and communication skills.

Responsibilities

• Design scalable database solutions using SQL Server, Oracle, or PostgreSQL.
• Define schemas, indexing, and partitioning for performance.
• Develop data models to support app requirements and data integrity.
• Establish standards for design, security, and tuning.
• Collaborate with dev teams to implement database solutions.
• Develop and maintain stored procedures, functions, triggers, and views.
• Ensure integration between databases and data pipelines.
• Analyze performance metrics and apply indexing, caching, partitioning.
• Implement encryption, access controls, and auditing for security.
• Design HA solutions with SQL Server Always On, Oracle Data Guard, AWS Multi-AZ.
• Document designs, configurations, and benchmarks.

Skills

Database design

Data modeling

Cloud databases

SQL Server

Oracle

PostgreSQL

Automation tools

Tools

AWS CloudFormation

Terraform

Ansible

Job description

Job Summary

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.

Whats 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

• 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)