Aurora PostgreSQL Database Administrator

Aurora PostgreSQL Database Administrator

Job ID: 60890-1



Client: Cognizant



Vendor: Spectraforce



Contract: Contract



Location: Remote Anywhere in the USA



Work Arrangement: 100% Remote



Interview Process: Virtual



Openings: 2



Submission Timeline: EOD



Work Authorization: Any Visa



Relocation: Yes



LinkedIn Profile: Required



References: Not Required Job Overview

We are seeking an experienced Aurora PostgreSQL Database Administrator to support database migration, performance tuning, replication, high availability, and production database operations within AWS environments . The ideal candidate will have strong hands-on experience with Amazon Aurora PostgreSQL, AWS RDS, database migration technologies, PostgreSQL performance optimization, replication, and AWS cloud services .

The candidate will be responsible for supporting database migrations from various platforms to Aurora PostgreSQL, ensuring database performance, availability, reliability, and operational stability in production environments.

Key Responsibilities

• Administer and support Amazon Aurora PostgreSQL and AWS RDS database environments.

• Design, execute, and support database migrations from platforms such as Oracle, SQL Server, Sybase, MySQL/MariaDB, Db2 , or similar database technologies to Aurora PostgreSQL.

• Utilize AWS Database Migration Service (DMS) for full-load and Change Data Capture (CDC) migrations.

• Perform AWS Schema Conversion Tool (SCT)/DMS Schema Conversion activities and resolve schema compatibility issues during migration.

• Conduct migration validation, data reconciliation, cutover planning, production cutovers, and rollback activities.

• Perform advanced PostgreSQL performance tuning and query optimization .

• Analyze database performance using tools and utilities such as EXPLAIN ANALYZE, pg_stat_activity, and pg_stat_statements .

• Optimize indexes, queries, and database configurations to improve performance and scalability.

• Troubleshoot and resolve issues related to MVCC, locking, VACUUM/autovacuum, WAL, and database resource utilization .

• Configure and manage Aurora Replicas, logical replication, replication slots, WAL retention, failover, and high-availability solutions .

• Monitor database health, performance, availability, and capacity across production environments.

• Utilize AWS CloudWatch and Database Insights for database monitoring and performance analysis.

• Work with AWS services including IAM, KMS, Secrets Manager, VPC, backups, snapshots, and point-in-time recovery .

• Develop and maintain automation scripts using Python, Bash/Shell, SQL, and AWS CLI/SDK .

• Support production database incidents, troubleshooting, maintenance activities, and emergency issues.

• Participate in after-hours production migrations, cutovers, and critical database support activities as required.

• Collaborate with application, infrastructure, cloud, development, and engineering teams to ensure successful database deployments and migrations.

• Develop and maintain database documentation, operational procedures, migration plans, and troubleshooting guides.

• Ensure database environments meet organizational standards for security, availability, performance, and recoverability.

Required Qualifications

• 5+ years of experience in Database Administration, Database Engineering, or a closely related field.

• Strong hands-on experience with Amazon Aurora PostgreSQL and AWS RDS .

• Strong experience supporting PostgreSQL databases in AWS cloud environments .

• Hands-on experience migrating databases from one or more of the following platforms:

  • Oracle

  • SQL Server

  • Sybase

  • MySQL/MariaDB

  • Db2

  • Other relational database platforms

• Strong experience with AWS DMS , including:

  • Full Load

  • Change Data Capture (CDC)

  • Migration validation

  • Cutover

  • Rollback

• Experience with AWS SCT/DMS Schema Conversion .

• Advanced knowledge of PostgreSQL performance tuning , including:

  • EXPLAIN ANALYZE

  • pg_stat_activity

  • pg_stat_statements

  • Indexing

  • MVCC

  • Locking

  • VACUUM/autovacuum

  • WAL

  • Query optimization

• Strong understanding of Aurora Replicas, logical replication, replication slots, WAL retention, failover, and high availability .

• Experience with production database environments, migrations, incident management, and after-hours cutovers.

• Strong scripting/programming experience with:

  • Python

  • Bash/Shell

  • SQL

  • AWS CLI/SDK

• Strong troubleshooting, analytical, and problem-solving skills.

• Ability to work effectively with cross-functional technical teams in a remote environment.

AWS & Cloud Technologies

Experience with the following AWS technologies is required or highly desirable:

• Amazon Aurora PostgreSQL

• AWS RDS

• AWS DMS

• AWS SCT

• Amazon CloudWatch

• Database Insights

• IAM

• KMS

• Secrets Manager

• VPC

• AWS Backup

• RDS Snapshots

• Point-in-Time Recovery

• AWS CLI/SDK

Preferred Qualifications

• Experience with Aurora Global Database .

• Experience with Terraform and/or CloudFormation .

• Knowledge of CI/CD pipelines and database deployment automation .

• Experience with RDS Proxy .

• Experience with pglogical .

• Experience working with ServiceNow and/or Jira .

• Experience supporting databases in regulated or compliance-driven environments .

• Experience participating in complex enterprise database migration and modernization initiatives.

Education

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related technical field.

Core Must-Have Skills

1. Amazon Aurora PostgreSQL / AWS RDS

2. 5+ years of Database Administration/Engineering experience

3. AWS DMS Full Load & CDC

4. AWS SCT / DMS Schema Conversion

5. Database migration experience with Oracle, SQL Server, Sybase, MySQL/MariaDB, or Db2

6. Advanced PostgreSQL performance tuning

7. Aurora Replicas, logical replication, replication slots, WAL retention, failover & HA

8. Python, Bash/Shell, SQL, AWS CLI/SDK

9. Production database support and migration/cutover experience

10. Strong AWS cloud database administration experience