Associate Director, Database Engineering at S&P Global

Gurugram, Haryana, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level

Full TimeJob Type

UnknownVisa

Financial Services, TechnologyIndustries

Requirements

Highly self-motivated and hands-on Database Engineer experience
Expertise in managing and optimizing SQL Server, Oracle, PostgreSQL, and MySQL databases
Experience with AWS environments including Amazon RDS, Amazon EC2, and Amazon Aurora
Expertise in database performance tuning, query optimization, security, automation, and cloud-based best practices
Skills in SQL query tuning, stored procedures, execution plan analysis, indexing, partitioning, and compression
Knowledge of high availability configurations like multi-AZ deployments, Read Replicas, Data Guard, and SQL Server Always On
Familiarity with AWS tools such as CloudWatch, Performance Insights, CloudTrail, AWS KMS, IAM Roles, Security Groups, AWS Backup, and AWS SNS
Experience with database installations, patching, upgrades, backup/recovery, and disaster recovery planning
Proficiency in tools like SQL Server Profiler, Oracle AWR, Query Store, and Optimizer Statistics
Ability to provide 24/7 support for production databases

Responsibilities

Administer and maintain SQL Server, Oracle, PostgreSQL, and MySQL databases hosted on Amazon RDS and Amazon EC2
Provide 24/7 support for production databases
Perform database installations, patching, and upgrades on AWS infrastructure
Configure and manage multi-AZ deployments, Read Replicas, and Data Guard for high availability
Tune SQL queries and stored procedures for optimal performance
Implement database partitioning, compression, and indexing strategies
Maintain performance baselines, document tuning efforts, and identify bottlenecks in queries, indexes, execution plans, and database design
Proactively identify and resolve slow-running queries and blocking issues
Manage SQL Server Always On configurations for failover and availability
Collaborate with developers to design and maintain optimized database schemas
Support application teams in writing efficient queries, stored procedures, and functions
Troubleshoot performance bottlenecks, locking issues, and query deadlocks
Assist developers with tools like SQL Server Profiler, Oracle AWR, and AWS Performance Insights
Utilize AWS tools (CloudWatch, Performance Insights, CloudTrail) for proactive database monitoring
Conduct execution plan analysis and implement query optimizations
Tune Oracle Optimizer Statistics, SQL Profiles, and SQL Server Query Store
Implement security best practices using AWS KMS, IAM Roles, Security Groups, and encryption (TDE)
Ensure compliance with security standards
Design and implement automated backup strategies using AWS Backup and RDS snapshots
Develop and test disaster recovery plans
Configure proactive alerts for performance, storage, and availability using CloudWatch and AWS SNS
Collaborate with developers, architects, and DevOps teams for CI/CD integration
Document database changes and processes

Skills

SQL Server

Oracle

PostgreSQL

MySQL

AWS

Amazon RDS

Amazon EC2

Amazon Aurora

Database Performance Tuning

Query Tuning

Database Security

High Availability

Data Guard

Database Patching

Read Replicas

Snowflake

S&P Global

Provides financial information and analytics services

About S&P Global

S&P Global provides financial information and analytics to a wide range of clients, including investors, corporations, and governments. The company offers services such as credit ratings, market intelligence, and indices, which help clients understand and navigate the global financial market. S&P Global's products work by utilizing advanced data analytics and research to deliver insights that assist clients in making informed decisions and managing risks. Unlike many competitors, S&P Global has a diverse range of divisions, including S&P Global Ratings and S&P Dow Jones Indices, which allows it to cater to various financial needs. The company's goal is to support clients in driving growth while also committing to corporate responsibility and positive societal impact.

New York City, New YorkHeadquarters

1917Year Founded

IPOCompany Stage

Data & Analytics, Financial ServicesIndustries

10,001+Employees

Benefits

Health Insurance

Unlimited Paid Time Off

Professional Development Budget

401(k) Company Match

Family Planning Benefits

Employee Discounts

Risks

Integration challenges with new acquisitions like ProntoNLP may cause operational issues.

Increased competition from AI-driven platforms like Brooklyn Investment Group.

Dependence on volatile credit ratings market could impact revenue stability.

Differentiation

S&P Global integrates advanced AI tools for superior financial analytics capabilities.

The company offers comprehensive ESG solutions, meeting growing sustainability demands.

S&P Global's diverse divisions provide a wide range of financial services globally.

Upsides

Acquisition of ProntoNLP boosts data analytics and sentiment scoring capabilities.

Rising demand for ESG data enhances S&P Global's market position.

Expansion into India strengthens S&P Global's research and insights offerings.

Land your dream remote job 3x faster with AI

Try Jobo Free