Remote Senior Postgres DBA — Performance & Aurora Expert

Zuven technologies Inc; Pittsburgh (Allegheny County); Remote; USD 110,000 - 160,000; Full time

Job summary

Zuven Technologies Inc. is seeking an exceptional Postgres DBA to join our product and engineering team. This hands-on expert will manage PostgreSQL environments, optimize queries, and tune performance to enable real-time decision making for government markets.

Requirements include 5–7 years of PostgreSQL experience and strong AWS Aurora knowledge. Initially remote, with on-site work planned in Pittsburgh, PA, and collaboration with users and SMEs to build scalable data architectures.

Qualifications

• 5–7 years of PostgreSQL experience.
• Advanced knowledge of Postgres configuration, management and optimization.
• Experience with AWS Amazon Aurora.
• Bachelor's degree in Computer Science, Mathematics or related technical field.

Responsibilities

• Maintains AWS Amazon Aurora Postgres database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements.
• Perform configuration, upgrade, monitoring and other database administration tasks.
• Apply various techniques to produce solutions to large-scale optimization problems, including data pre-processing, indexing, blocking, field and record comparison and classification
• Build best practices to manage all Postgres environments in a consistent manner
• Work directly with users as well as SMEs to establish, create and populate optimal data architectures and structures, as well as articulate techniques and results using non-technical language
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Maintains quality service by establishing and enforcing organization standards.

Skills

PostgreSQL

Query optimization

AWS Aurora

Stored procedures

Education

Bachelor's degree in Computer Science, Mathematics or related technical field

Tools

AWS

PostgreSQL tuning tools

Job description

Zuven Technologies Inc. is seeking an exceptional Postgres DBA to join our product and engineering team. This hands-on expert will manage PostgreSQL environments, optimize queries, and tune performance to enable real-time decision making for government markets.

Requirements include 5–7 years of PostgreSQL experience and strong AWS Aurora knowledge. Initially remote, with on-site work planned in Pittsburgh, PA, and collaboration with users and SMEs to build scalable data architectures.