Senior AWS PostgreSQL DBA — Automate, Migrate & Optimize

Premier Staffing Partners, Inc.; Knoxville (TN); On-site; USD 120,000 - 170,000; Full time

Job summary

Premier Staffing Partners, Inc. is seeking an experienced Senior Database Administrator – AWS PostgreSQL to support a large-scale AWS PostgreSQL environment within the Data Team.

You will own administration, performance tuning, security, backups, disaster recovery, and migration strategies for Amazon RDS for PostgreSQL and Aurora PostgreSQL. This role stresses automation and IaC using Terraform, and collaboration with engineering, infrastructure, and application teams to implement best practices

Qualifications

• Experience with AWS, PostgreSQL, and SQL Server in enterprise environments.
• Strong Terraform and IaC implementation capabilities.
• Proven ability to optimize large-scale AWS PostgreSQL deployments.

Responsibilities

• Administer and support Amazon RDS for PostgreSQL and Aurora PostgreSQL.
• Monitor, troubleshoot, and optimize database performance, availability, and reliability.
• Develop, analyze, and tune complex SQL queries and database solutions.
• Build and maintain database Infrastructure as Code using Terraform.
• Automate database administration, monitoring, deployment, and operational processes.
• Establish and maintain database standards, procedures, and best practices.
• Perform database change management and support production releases.
• Troubleshoot complex database performance issues and DR initiatives.
• Plan and execute database migrations between AWS platforms.
• Support migrations from Microsoft SQL Server and IBM DB2 for i / iSeries to AWS PostgreSQL.
• Partner with engineering, infrastructure, application, and data teams on architecture.

Skills

AWS database technologies

Amazon RDS for PostgreSQL

Microsoft SQL Server

SQL performance tuning

Terraform

Database migrations

Security and backup/recovery

High availability/DR

Tools

Terraform

Amazon RDS for PostgreSQL

Amazon Aurora PostgreSQL

AWS Database Services

Job description

Premier Staffing Partners, Inc. is seeking an experienced Senior Database Administrator – AWS PostgreSQL to support a large-scale AWS PostgreSQL environment within the Data Team.

You will own administration, performance tuning, security, backups, disaster recovery, and migration strategies for Amazon RDS for PostgreSQL and Aurora PostgreSQL. This role stresses automation and IaC using Terraform, and collaboration with engineering, infrastructure, and application teams to implement best practices