Senior Database Administrator- PostgreSQL AWS

Senior Database Administrator – AWS PostgreSQL

Remote | Eastern Time Hours | 12-Month + W2 Contract

Check all associated application documentation thoroughly before clicking on the apply button at the bottom of this description.

NO SPONSORSHIP, NO CORP-TO-CORP

*Candidates who reside in Knoxville, TN, or close surrounding areas are highly preferred

We are seeking an experienced Senior Database Administrator – AWS PostgreSQL to support and optimize a large-scale AWS PostgreSQL environment as part of an enterprise Data Team. This role will focus heavily on the administration, automation, performance, security, reliability, and migration of Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL databases. The ideal candidate will bring deep PostgreSQL expertise along with strong AWS and SQL Server experience. This is a strong opportunity for a senior-level DBA who enjoys owning complex PostgreSQL environments, solving challenging production issues, and helping modernize enterprise database platforms in AWS.

Key Responsibilities

• Administer and support Amazon RDS for PostgreSQL and Amazon 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 and application performance issues
• Support high-availability, backup, recovery, and disaster recovery initiatives
• Plan and execute database migrations between AWS database platforms
• Support migrations from Microsoft SQL Server and IBM DB2 for i / iSeries environments to AWS PostgreSQL
• Partner with engineering, infrastructure, application, and data teams on database architecture and solutions
• Serve as a PostgreSQL and AWS database SME while mentoring team members and promoting best practices

Required Experience

• Strong hands-on experience administering PostgreSQL in enterprise production environments
• Strong experience with AWS database technologies , particularly:
• Amazon RDS for PostgreSQL
• Amazon Aurora PostgreSQL
• Experience administering and/or migrating Microsoft SQL Server
• Strong SQL development, xhyhwjd troubleshooting, and performance-tuning experience
• Experience with Terraform and Infrastructure as Code
• Experience with database migrations, upgrades, change management, and production support
• Strong understanding of database security, backup/recovery, high availability, and disaster recovery
• Ability to troubleshoot complex database performance and reliability issues

Preferred Experience

• Experience migrating SQL Server databases to PostgreSQL
• Experience with IBM DB2 for i / iSeries
• Experience with AWS database migration tools and cloud modernization initiatives
• Experience developing database automation and operational tooling
• Previous experience serving as a seniLong-termPostgreSQLor DBA, technical lead, or database SME