S&P Global

Lead, Database Engineering

S&P Global

full-time

Posted on:

Location Type: Office

Location: Gurugram • India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AnsibleAWSCloudEC2MySQLOraclePostgresPythonSQLTerraform

About the role

  • The Database Administrator will manage and optimize SQL Server , Oracle, PostgreSQL, MySQL databases hosted in AWS environments such as Amazon RDS, Amazon EC2, and Amazon Aurora.
  • The role requires expertise in database performance tuning, security, automation and cloud-based best practices.
  • The DBA will collaborate closely with architects, developers, system administrators, and DevOps teams to ensure efficient database integration with business applications.
  • Administer and maintain SQL Server , Oracle, PostgreSQL & MySQL databases hosted on Amazon RDS and Amazon EC2.
  • Provide 24*7 support for our production databases.
  • Perform database installations, patching, and upgrades on AWS infrastructure.
  • Configure and manage multi-AZ deployments, Read Replicas, and Data Guard (for Oracle) to ensure high availability.
  • Tune SQL Queries and stored procedures for optimal performance.
  • Implement database partitioning, compression, and indexing strategies for performance optimization.
  • Maintain Performance Baselines and document tuning efforts and outcomes.
  • Identify bottlenecks in queries, indexes, execution plans and overall database design.
  • Proactively identify and resolve slow-running queries and blocking issues.
  • Manage SQL Server Always On configurations for improved failover and availability.
  • Work closely with developers to design and maintain optimized database schemas for SQL Server / Oracle /My SQL / Postgres.
  • Support application teams in writing efficient queries, stored procedures, and functions.
  • Troubleshoot performance bottlenecks, locking issues, and query deadlocks.
  • Assist developers in leveraging SQL Server Profiler, Oracle AWR, and AWS Performance Insights for tuning queries.
  • Utilize AWS tools like CloudWatch, Performance Insights, and CloudTrail for proactive database monitoring.
  • Conduct execution plan analysis and implement query optimizations to improve response times.
  • Tune Oracle’s Optimizer Statistics, SQL Profiles, and SQL Server’s Query Store for enhanced performance.
  • Implement security best practices using AWS services like AWS KMS, IAM Roles, and Security Groups for database access control.
  • Manage encryption for data at rest and in transit using Transparent Data Encryption (TDE) for SQL Server and Oracle.
  • Ensure compliance with organizational and industry security standards.
  • Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots.
  • Develop and test disaster recovery plans.
  • Configure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch and AWS SNS.
  • Collaborate with developers, cloud architects, and DevOps teams to integrate database changes into CI/CD pipelines.
  • Document database architectures, configurations, backup strategies, and recovery plans.

Requirements

  • Strong expertise in SQL Server 2016/2019/2022 , Oracle 12c/19 c, Postgres 12/13/14/15/16 & MySQL.
  • Hands-on experience with Amazon RDS, EC2-hosted databases, and AWS migration tools like AWS DMS.
  • Proficiency in writing complex SQL queries, stored procedures, PL/SQL / PGSQL and performance tuning techniques.
  • Familiarity with cloud automation tools such as AWS CloudFormation, Terraform, Ansible , Python.
  • Strong understanding of database security, auditing, and encryption best practices.
  • Experience in PowerShell, T-SQL, PL/SQL, PGSQL.
  • 11+ years of experience as DBA managing SQL Server, Oracle, Postgres & MySQL.
  • Experience with AWS database migration strategies and cloud performance tuning best practices.
Benefits
  • Health & Wellness: Health care coverage designed for the mind and body.
  • Flexible Downtime: Generous time off helps keep you energized for your time on.
  • Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
  • Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
  • Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families.
  • Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL ServerOraclePostgreSQLMySQLperformance tuningdatabase securityautomationcomplex SQL queriesstored proceduresencryption
Soft Skills
collaborationtroubleshootingproblem-solvingdocumentation