Senior Database Architect: Cloud, Performance & Security

spgi; Union City (IN); On-site; USD 120,000 - 180,000; Full time

Job summary

S&P Global Market Intelligence in the United States seeks a seasoned Database Architect to design, implement, and maintain scalable database solutions across SQL Server, Oracle, and PostgreSQL, while driving data strategy and collaborating with developers, admins and stakeholders.

The role emphasizes automation with AWS CloudFormation, Terraform and Ansible, security, performance, backup and disaster recovery, and may require night shifts for on-call support.

Qualifications

• 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 delivering scalable database solutions.

Responsibilities

• Design scalable, high-performance database solutions across multiple platforms.
• Define database schema structures, indexing, and partitioning for optimal performance.
• Develop data models to support application requirements and ensure data integrity.
• Establish standards for database design, security, and performance tuning.
• Collaborate with development teams to implement database solutions aligned with applications.
• Develop and maintain stored procedures, functions, triggers, and views for business logic.
• Ensure seamless integration between database systems and data pipelines.
• Analyze performance metrics and optimize through indexing, caching, and partitioning.
• Implement encryption, access controls, auditing, and regulatory compliance.
• Develop backup, recovery, and failover strategies for business continuity.
• Design high availability solutions (Always On, Data Guard, AWS Multi-AZ).
• Maintain thorough documentation of database designs, configurations, and benchmarks.
• Work with stakeholders to translate business requirements into technical solutions.

Skills

Database design

Data modeling

Schema development

SQL Server

Oracle

PostgreSQL

Cloud databases

Performance tuning

Indexing strategies

Automation

Communication

Leadership

On-call readiness

Tools

AWS CloudFormation

Terraform

Ansible

Job description

S&P Global Market Intelligence in the United States seeks a seasoned Database Architect to design, implement, and maintain scalable database solutions across SQL Server, Oracle, and PostgreSQL, while driving data strategy and collaborating with developers, admins and stakeholders.

The role emphasizes automation with AWS CloudFormation, Terraform and Ansible, security, performance, backup and disaster recovery, and may require night shifts for on-call support.