DBA – AWS PostgreSQL

Gravity IT Resources; Knoxville (TN); A distancia; USD 110.000 - 160.000; A tiempo parcial

Descripción de la vacante

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

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

PostgreSQL on AWS

Terraform IaC

SQL optimization

Database security & HA

Troubleshooting

Independent work

Communication

Herramientas

Amazon RDS

Amazon Aurora PostgreSQL

Terraform

SQL Server

IBM DB2 for i

Descripción del empleo

Job Title: Database Administrator

Location Requirements: Remote

Job Type: Contract

Role Overview:
You will support and optimize a cloud-based database environment. Join the Data Team to manage, enhance, and ensure the performance, security, and reliability of Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL databases. You will handle administration, automation, troubleshooting, and modernization projects, including complex database migrations and infrastructure automation using Terraform.

Responsibilities:

• Administer, maintain, and optimize Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL environments to ensure performance, availability, security, and reliability
• Develop, implement, and maintain Infrastructure as Code (IaC) using Terraform for database provisioning and management
• Monitor database health, troubleshoot complex production issues, and identify performance improvement opportunities
• Develop, optimize, and tune SQL queries, configurations, and related solutions for efficiency and performance
• Establish and maintain database standards, operational procedures, security controls, and change management practices
• Automate routine database administration, monitoring, maintenance, and operational tasks
• Plan and execute database migrations between AWS platforms and from on-premises systems like Microsoft SQL Server and IBM DB2 for i (iSeries) to AWS PostgreSQL
• Support high-availability, backup, recovery, and disaster recovery initiatives for business continuity
• Collaborate with engineering, infrastructure, and data teams on database integrations, application requirements, and cloud modernization efforts
• Serve as a subject matter expert on PostgreSQL and AWS database technologies, providing technical guidance and mentoring

Required Qualifications:

• Strong hands-on experience administering PostgreSQL databases within AWS, especially Amazon RDS and Amazon Aurora
• Proven experience with database performance monitoring, SQL query optimization, indexing, troubleshooting, and production support
• Experience developing and maintaining Terraform configurations for cloud infrastructure automation
• Strong understanding of database security, access management, backup/recovery, high availability, and disaster recovery
• Experience supporting database migrations, including from Microsoft SQL Server or other relational platforms to PostgreSQL
• Proficiency in SQL development, database administration, and operational automation
• Experience implementing database standards, managing database changes, and resolving complex technical issues
• Strong analytical, troubleshooting, and communication skills
• Ability to work independently and across technical teams

Equal Employment Opportunity Statement
Gravity IT Resources is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected characteristic. All employment decisions are based on qualifications, merit, and business needs.