AWS RDS/PostgreSQL Database Administrator

Overview

Remote
$100,000 - $110,000
Contract - W2
Contract - 12 Month(s)

Skills

AWS RDS
PostgreSQL
Database Administration
Performance Management
data migration
CloudFormation
Terraform
VPC
IAM
AWS CloudWatch
SNS

Job Details

Must have 9+ years of AWS RDS DB and Postgres DBA experience. If you have any qualified

Job Details

Database Administrator

Key Responsibilities Design, Implementation & Configuration: Architect and configure AWS RDS instances tailored for PostgreSQL workloads. Oversee migrations from on-premises or alternative cloud databases to AWS RDS/PostgreSQL.

Performance Management: Monitor performance metrics, diagnose bottlenecks, and optimize query execution plans. Implement indexing, partitioning, and caching strategies for high availability and throughput.

Security & Compliance: Apply best practices for database security, encryption, backups, and disaster recovery in AWS. Ensure regulatory compliance and data privacy standards (e.g., GDPR, HIPAA). Maintenance & Troubleshooting: Perform upgrades, patching, and maintenance of database environments. Respond to incidents, troubleshoot failures, and provide root cause analyses. Automation & Monitoring: Develop and maintain automated scripts for provisioning, backup, and monitoring. Integrate AWS CloudWatch, SNS, and other tools for real-time alerting and analytics.

Collaboration & Documentation: Work closely with DevOps, application developers, and project managers to support database needs. Document operational procedures, topologies, configurations, and lessons learned.

Required Skills & Qualifications

Technical Expertise: Deep experience with AWS RDS management, performance tuning, and scalability. Advanced knowledge of PostgreSQL architecture, administration, and optimization. Hands-on with backup, restore, high-availability setups (read replicas, Multi-AZ), and failover strategies in AWS. Proficient in SQL and procedural languages (PL/pgSQL); familiar with data migration tools (DMS, pg_dump, etc.).

Cloud & DevOps Knowledge: Experience with infrastructure-as-code tools (CloudFormation, Terraform) for database provisioning. Understanding of VPC, IAM roles, encryption options, and integration with other AWS services. Soft Skills: Strong analytical, troubleshooting, and communication abilities. Commitment to continual learning and adapting in cloud-first environments

Administration of RDS and Postgres DBs

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.