PostgreSQL DBA

PostgreSQL DBA

Onsite/Hybrid preferred - Norfolk, VA

Long Term

Looking for Independent Candidates Only!

Summary:

The Aurora PostgreSQL Database Administrator is responsible for secure, reliable, and high-performing database services and migrations from other database engines to Amazon Aurora PostgreSQL-Compatible Edition.

This role combines end-to-end migration delivery, advanced query and workload tuning, and replication and high-availability engineering. The DBA partners with application, DevOps, cloud, infrastructure, security, and service-management teams and supports production.

Required

Three to five years of database administration or database engineering experience in a medium-to-large production environment.

Strong hands-on administration of Amazon Aurora PostgreSQL-Compatible Edition, including cluster configuration, parameter groups, monitoring, backup and recovery, upgrades, security, and production support.

Successful delivery of at least one end-to-end migration from a different database engine, such as Oracle, Sybase, SQL Server, MySQL/MariaDB, Db2, or a comparable platform, to Aurora PostgreSQL.

Practical experience with AWS DMS full load and change data capture, schema and code conversion, migration troubleshooting, data validation, cutover, and rollback planning.

Advanced PostgreSQL performance knowledge, including MVCC, locking, query planning, indexing, statistics, VACUUM and autovacuum, WAL, memory and connection management, and query-level diagnostics.

Hands-on replication experience with Aurora Replicas and PostgreSQL logical replication, including lag monitoring, replication slots, WAL retention, failover, and recovery considerations.

AWS experience with RDS/Aurora, CloudWatch Database Insights, IAM, KMS, Secrets Manager, VPC and security groups, snapshots, events, logs, and related networking.

Scripting experience with Python, Bash or shell, and SQL, along with working knowledge of Linux/Unix and AWS CLI/SDK.

Working knowledge of TCP/IP, DNS, ports, TLS, firewalls, and cloud network connectivity.

Strong troubleshooting, documentation, communication, teamwork, and customer-service skills.

Experience following production change, incident-management, security, and operational-control processes.

Bachelor's degree in computer science, information systems, engineering, or a related discipline, or equivalent practical experience.

Preferred

Deep source-platform knowledge in Sybase, SQL Server, MySQL/MariaDB, Db2, or another enterprise database engine used in heterogeneous migrations.

Experience using DMS Schema Conversion or AWS SCT for complex database-code conversion, assessment reports, transformation rules, and remediation planning.

Experience with Aurora Global Database, cross-Region disaster recovery, RDS Proxy, pglogical, advanced partitioning, or Aurora query plan management.

Experience with infrastructure as code, Git, CI/CD, AWS CloudFormation, Terraform, and automated database deployment or validation pipelines.

Familiarity with ServiceNow, Jira, Agile delivery, and structured incident, problem, and change management.

Knowledge of regulated-environment controls such as HIPAA, SOX, or PCI DSS.

Relevant AWS, PostgreSQL, or database-administration certification.

Work Expectations

Support after-hours migrations, cutovers, maintenance, upgrades, recovery tests, and production incidents.

Manage multiple priorities while maintaining disciplined change controls, clear documentation, and timely stakeholder communication.

Regards,

Puneet.