S&P Global Automotive Insights is seeking an experienced Senior Database Administrator (DBA) to manage, optimize, and support PostgreSQL databases in both production and non-production environments. This role requires deep expertise in PostgreSQL, cloud infrastructure (AWS), and automation, with a strong focus on performance, reliability, and scalability.
Requirements
- 8+ years of hands-on experience with PostgreSQL and/or Oracle administration.
- Strong SQL proficiency and deep knowledge of performance tuning, replication, and HA configurations.
- Experience with database backup strategies, PITR, and disaster recovery planning.
- Experience migrating Oracle databases to AWS PostgreSQL (preferred).
- 4+ years of experience with AWS (EC2, RDS, S3, VPC, CloudWatch, IAM).
- Proven track record managing PostgreSQL on AWS RDS and EC2.
- Strong experience with Terraform for infrastructure automation (required).
Responsibilities
- Administer PostgreSQL databases in both production and non-production environments.
- Perform database tuning, query optimization, and indexing to maintain high performance.
- Monitor, troubleshoot, and resolve database performance, availability, and scalability issues.
- Configure and manage automated backups, replication, and disaster recovery procedures.
- Implement high-availability and failover strategies using AWS RDS and PostgreSQL clusters.
- Support database migrations, particularly Oracle to Amazon PostgreSQL.
- Deploy and manage cloud resources using AWS services including EC2, RDS, S3, VPC, IAM, and CloudWatch.
Other
- Provide 24/7 on-call support for critical database-related incidents and ensure timely resolution.
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- AWS Certified Solutions Architect (Preferred)
- AWS Certified DevOps Engineer (Preferred)
- This role is limited for candidates with indefinite right to work within the USA.
