Senior Engineer, Database Engineering at S&P Global

Gurugram, Haryana, India

S&P Global  Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Financial Services, TechnologyIndustries

Requirements

  • Deep understanding of MS SQL, Oracle, Postgres SQL, and MySQL
  • Oracle Certified Associate (OCP)
  • Microsoft Certified: Database Administrator
  • MySQL Certified: Database Administrators
  • PostgreSQL Certified: Database Administrators
  • AWS Certified Solutions Architect
  • 10+ years of experience as DBA

Responsibilities

  • Maintain and optimize SQL Server 2016/2019/2022, Oracle 12c/19c, Postgres 14/15/16, and MySQL databases hosted in AWS environments such as Amazon RDS, Amazon EC2, and Amazon Aurora
  • Ensure expertise in database performance tuning, security, cloud-based best practices, and continuous availability
  • Collaborate closely with developers, system administrators, and DevOps teams to ensure efficient database integration with business applications
  • Own the stability, performance, and availability of all production database environments
  • Lead incident resolution, root cause analysis, and prevention strategies
  • Define and enforce database operational standards, guardrails, and best practices
  • Administer and maintain SQL Server, Oracle, PostgreSQL, MySQL databases hosted on Amazon RDS and Amazon EC2
  • Perform database installations, patching, and upgrades on AWS infrastructure
  • Configure and manage multi-AZ deployments, Read Replicas, AOAG, and Data Guard to ensure high availability
  • Manage SQL Server Always On configurations for improved failover and availability
  • Implement database partitioning, compression, and indexing strategies for performance optimization
  • Conduct deep performance analysis at the system, query, and indexing levels
  • Recommend and implement architectural improvements for scalability
  • Guide application teams in schema and query optimization
  • Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots for SQL Server
  • Use Oracle RMAN for Oracle database backups and recovery
  • Develop and test disaster recovery plans using AWS DMS and Cloud Endure
  • Monitor and 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
  • Drive automation of operational DBA tasks using PowerShell, Python, AWS CLI, or similar tools
  • Evaluate and implement new database technologies, monitoring solutions, and optimization tools

Skills

SQL Server
Oracle
PostgreSQL
MySQL
AWS
Amazon RDS
Amazon EC2
Amazon Aurora
Database Performance Tuning
Database Security
DevOps
Python
Terraform
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