Associate Director, Database Engineering at S&P Global

, , India -

Full Time

Start Date

Immediate

Expiry Date

07 Mar, 26

Salary

0.0

Posted On

07 Dec, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Engineering, SQL Server, Oracle, PostgreSQL, MySQL, AWS, Performance Tuning, Query Optimization, Data Migration, Database Security, Automation, Cloud Best Practices, Backup Strategies, Disaster Recovery, Collaboration, Documentation

Industry

Financial Services

Description

About the Role: Grade Level (for internal use): 12 The Role: Associate Director, Database Engineering. The Team: We are looking for a highly self-motivated hands-on Database Engineer who would focus on our database infrastructures estate and tune database queries within our enterprise solutions division. He 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, and cloud-based best practices. 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, Performance Tuning, Query Rewrite & Data migration skills while having the chance to become exposed to fresh and divergent technologies (e.g. Ms SQL/ PostgreSQL/Oracle/My SQL/ Snowflake) Responsibilities: 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. Database Management & Maintenance 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. Application Support 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. Performance Tuning & Optimization 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 Oracles' Optimizer Statistics, SQL Profiles, and SQL Server’s Query Store for enhanced performance. Data Integrity & Security 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. Backup & Recovery Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots. Develop and test disaster recovery plans. Monitoring & Alerting Configure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch and AWS SNS. Collaboration & Documentation 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. What We’re Looking For: Strong expertise in SQL Server 2016/2019/2022, Oracle 12c/19c, 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 16+ years of experience as DBA managing SQL Server, Oracle, Postgres & MySQL. Experience with AWS database migration strategies and cloud performance tuning best practices. 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 at S&P Global. Our benefits include: 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. For more information on benefits by country visit: https://spgbenefits.com/benefit-summaries Global Hiring and Opportunity at S&P Global: At S&P Global, we are committed to fostering a connected and engaged workplace where all individuals have access to opportunities based on their skills, experience, and contributions. Our hiring practices emphasize fairness, transparency, and merit, ensuring that we attract and retain top talent. By valuing different perspectives and promoting a culture of respect and collaboration, we drive innovation and power global markets. Recruitment Fraud Alert: If you receive an email from a spglobalind.com domain or any other regionally based domains, it is a scam and should be reported to reportfraud@spglobal.com. S&P Global never requires any candidate to pay money for job applications, interviews, offer letters, “pre-employment training” or for equipment/delivery of equipment. Stay informed and protect yourself from recruitment fraud by reviewing our guidelines, fraudulent domains, and how to report suspicious activity here. ----------------------------------------------------------- Equal Opportunity Employer S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment. If you need an accommodation during the application process due to a disability, please send an email to: EEO.Compliance@spglobal.com and your request will be forwarded to the appropriate person. US Candidates Only: The EEO is the Law Poster http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf describes discrimination protections under federal law. Pay Transparency Nondiscrimination Provision - https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf ----------------------------------------------------------- 20 - Professional (EEO-2 Job Categories-United States of America), IFTECH202.2 - Middle Professional Tier II (EEO Job Group) S&P Global delivers Essential Intelligence® that shapes decision making. We provide the world’s leading organizations with the right data, connected technologies and expertise they need to move ahead. As part of our team, you’ll help solve complex challenges that equip businesses, governments and individuals with the knowledge to adapt to a changing economic landscape.

Responsibilities

The Associate Director, Database Engineering will manage and optimize various databases hosted in AWS environments, ensuring high availability and performance. Responsibilities include database maintenance, performance tuning, application support, and collaboration with development teams.