Remote PostgreSQL DBA - AWS RDS/Aurora & Terraform

Gravity IT Resources; Knoxville (TN); Remote; USD 110,000 - 160,000; Part time

Job summary

Gravity IT Resources is seeking a remote Database Administrator to support and optimize a cloud-based PostgreSQL environment on AWS. The role focuses on administering RDS/Aurora PostgreSQL, implementing Terraform IaC, and ensuring performance, security, and reliability across migrations and modernization projects.

The candidate will monitor health, tune SQL, establish standards, automate tasks, and collaborate with data, engineering, and infrastructure teams to drive cloud modernization

Qualifications

• Experience administering PostgreSQL databases on AWS (RDS/Aurora).
• Experience with performance monitoring, SQL optimization, and production support.
• Terraform configurations for cloud infrastructure automation.
• Knowledge of database security, backup, HA, and DR.
• Experience migrating databases to PostgreSQL from SQL Server or IBM Db2.
• Proficiency in SQL development, database administration, and automation.
• Experience implementing database standards and change management.
• Strong analytical and communication skills.
• Ability to work independently across technical teams.

Responsibilities

• Administer and optimize Amazon RDS for PostgreSQL and Aurora PostgreSQL environments for performance, availability, security, and reliability.
• Develop, implement, and maintain IaC using Terraform for database provisioning and management.
• Monitor database health, troubleshoot production issues, and identify performance improvements.
• Develop and tune SQL queries and configurations for efficiency and performance.
• Establish database standards, procedures, security controls, and change management practices.
• Automate routine database administration, monitoring, and maintenance tasks.
• Plan migrations between AWS platforms and from on-premises systems to AWS PostgreSQL.
• Support high availability, backups, disaster recovery, and business continuity initiatives.
• Collaborate with engineering, infrastructure, and data teams on integrations and modernization.
• Serve as SMEs on PostgreSQL and AWS database technologies, providing guidance.

Skills

PostgreSQL on AWS

Terraform IaC

SQL optimization

Database security & HA

Troubleshooting

Independent work

Communication

Tools

Amazon RDS

Amazon Aurora PostgreSQL

Terraform

SQL Server

IBM DB2 for i

Job description

Gravity IT Resources is seeking a remote Database Administrator to support and optimize a cloud-based PostgreSQL environment on AWS. The role focuses on administering RDS/Aurora PostgreSQL, implementing Terraform IaC, and ensuring performance, security, and reliability across migrations and modernization projects.

The candidate will monitor health, tune SQL, establish standards, automate tasks, and collaborate with data, engineering, and infrastructure teams to drive cloud modernization