PostgreSQL Database Administrator - (AWS RDS Aurora, Redshift) - Hybrid in Charlotte - W2 Contract

Optomi LLC
Charlotte, NC, United States
23 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours

Tech stack

Databases Disaster Recovery PostgreSQL Performance Tuning Query Optimization Esri GIS (Software) System Availability Database Performance Indexer Amazon Relational Database Service Infrastructure Automation Frameworks Database Backup

Job description

PostgreSQL Database Administrator - (AWS RDS Aurora, Redshift) - Hybrid in Charlotte - W2 Contract

Requirements

  • 10+ years of professional database administration, engineering, or related experience. \n

  • Extensive hands-on experience administering and supporting PostgreSQL databases in enterprise production environments. \n

  • Strong experience supporting large PostgreSQL environments with hundreds of databases and/or large database clusters. \n

  • Hands-on experience with PostgreSQL running within Amazon RDS. \n

  • Advanced PostgreSQL performance tuning and troubleshooting experience. \n

  • Strong knowledge of indexing, query optimization, execution plans, locking, connections, vacuuming, and database resource utilization. \n

  • Experience designing and automating database maintenance processes. \n

  • Strong knowledge of database backup, recovery, high availability, and disaster recovery strategies. \n

  • Experience with scripting and automation tools used to manage database environments at scale. \n

  • Ability to independently troubleshoot complex database performance and availability issues. \n

  • Experience with monitoring, alerting, capacity planning, and database health management. \n

  • ESRI geodatabase experience is a plus, but not required. \n

Benefits & conditions

The ideal candidate will bring deep PostgreSQL expertise and experience managing large-scale, production database environments within AWS. This individual will help own and support an extensive PostgreSQL footprint consisting of hundreds of databases hosted within Amazon RDS. The role will focus heavily on database performance, reliability, automation, backup and recovery, and ongoing maintenance.

\n

\n

What the Right Professional Will Enjoy!

\n \n

  • The opportunity to help own and optimize a large-scale PostgreSQL environment consisting of hundreds of production databases. \n

  • The opportunity to work extensively with PostgreSQL hosted within AWS RDS and solve complex performance, scalability, and reliability challenges. \n

  • The opportunity to improve the environment through automation of database maintenance, backups, monitoring, and other operational processes. \n

  • The opportunity to serve as a senior technical resource with significant ownership and influence over database best practices and long-term improvements. \n

\n

\n

About the company

Optomi, in partnership with one of the nation’s largest energy and utility organizations, is seeking a Senior PostgreSQL Database Administrator to fulfill a contract position with a client based in Charlotte, NC.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…