Haystack
← Back to Jobs
Technology
AS

PostgreSQL DBA

Amtex Systems Inc.Norfolk, VA🇺🇸United StatesPosted 15 Sept 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
Norfolk, VA, United States
Posted
19 hours ago
MariaDBMySQLOracleSQLSQL ServerShellAWSPCI DSSTCP/IPAgileBashCloudFormationDNSGitHIPAAJiraPostgreSQLPythonRESTTerraform

Job Description

Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 25 years.

Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.


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.

Similar jobs

Browse related jobs

Apply now