[Remote] Aurora PostgreSQL Database Administrator
Note: The job is a remote job and is open to candidates in USA. Smart IT Frame connects top talent with leading organizations across the USA, specializing in IT, healthcare, and professional roles. The company is seeking an experienced Aurora PostgreSQL Database Administrator to manage secure, reliable, and high-performing database environments, focusing on migrations, performance tuning, replication, high availability, and production support.
Responsibilities
- Plan and execute end-to-end database migrations to Amazon Aurora PostgreSQL
- Assess schemas, dependencies, data volumes, compatibility, risks, and migration strategies
- Configure and tune AWS DMS full-load and CDC migration pipelines
- Perform schema/code conversion, data validation, reconciliation, cutover, and rollback planning
- Troubleshoot and optimize SQL, indexes, execution plans, statistics, memory, connections, and I/O
- Monitor and maintain VACUUM, autovacuum, WAL, bloat, locks, and database growth
- Configure Aurora Replicas, reader endpoints, failover, replication, and recovery
- Implement and troubleshoot PostgreSQL logical replication
- Support cross-Region resilience, Aurora Global Database, backups, PITR, and DR testing
- Manage Aurora clusters, instances, parameter groups, extensions, upgrades, security, and capacity
- Automate health checks, maintenance, deployments, and recovery using scripting and AWS tools
- Provide production incident response, RCA, change management, documentation, and on-call support
Skills
- • 3–5+ years of database administration/database engineering experience
- • Strong hands-on experience with Amazon Aurora PostgreSQL in production
- • At least one successful migration from Oracle, Sybase, SQL Server, MySQL/MariaDB, Db2, or similar to Aurora PostgreSQL
- • Hands-on AWS DMS Full Load & CDC experience
- • Advanced PostgreSQL knowledge: MVCC, locking, query planning, indexing, statistics, VACUUM/autovacuum, WAL, and query diagnostics
- • Experience with Aurora Replicas, logical replication, replication slots, WAL retention, failover, and recovery
- • Strong AWS knowledge: RDS/Aurora, CloudWatch, IAM, KMS, Secrets Manager, VPC, security groups, snapshots, logs & events
- • Scripting with Python, Bash/Shell, and SQL
- • Working knowledge of Linux/Unix, TCP/IP, DNS, ports, TLS, firewalls, and cloud networking
- • Strong troubleshooting, communication, documentation, and production support skills
- • AWS SCT / DMS Schema Conversion experience
- • Aurora Global Database / cross-Region DR
- • RDS Proxy, pglogical, partitioning, or Aurora Query Plan Management
- • Terraform / CloudFormation, Git, CI/CD
- • ServiceNow / Jira and ITIL-style incident/change management
- • HIPAA, SOX, or PCI DSS experience
- • AWS, PostgreSQL, or DBA certifications
Benefits
- Remote work arrangement
- Contract employment
Company Overview
Company H1B Sponsorship