Postgres DBA

TechDigital Group; Minnesota; On-site; USD 90,000 - 130,000; Full time

Job summary

Join a forward-thinking company as a Senior Infrastructure DBA, where you will leverage your extensive experience in PostgreSQL to maintain and optimize large-scale database systems. This role focuses on ensuring database performance, security, and disaster recovery without the need for coding. You will be responsible for creating and managing database objects, monitoring performance, and developing automation technologies to streamline processes. If you're passionate about database management and thrive in an enterprise environment, this is the perfect opportunity to make a significant impact.

Qualifications

• 5+ years of experience supporting PostgreSQL in large-scale environments.
• Strong knowledge of PostgreSQL management tools on Red Hat Linux.

Responsibilities

• Create and manage database objects like triggers and indexes.
• Monitor database performance and ensure optimal operation.
• Maintain backups and execute disaster recovery procedures.

Skills

PostgreSQL

Database Management

Performance Tuning

Disaster Recovery

Linux (Red Hat)

MSSQL

MySQL

Automation Technologies

Tools

pg_ctl

psql

Job description

Job Description

We are seeking a Senior Infrastructure DBA with over 5 years of experience supporting PostgreSQL in an enterprise environment. This role is focused on maintaining and optimizing database systems, not on development or coding.

Responsibilities

1. Create and manage database objects such as triggers and indexes.
2. Monitor database performance and ensure optimal operation.
3. Identify and resolve potential issues proactively.
4. Maintain backups and execute disaster recovery procedures.
5. Monitor and enforce database security to prevent unauthorized access.
6. Schedule and perform regular server maintenance.
7. Maintain and update database schema and manage database availability.
8. Perform performance tuning and provide best practice guidance to development teams.
9. Resolve production data issues and manage tablespace and role management.
10. Develop automation technologies to streamline data loading processes.
11. Develop and maintain relational databases, ensuring data integrity.
12. Manage user access and permissions effectively.
13. Utilize utilities like pg_ctl and psql for database maintenance.

Requirements

• Minimum 5 years of experience supporting PostgreSQL in large-scale environments (10+TB databases).
• Strong knowledge of PostgreSQL management tools and operating on Red Hat Linux for optimal performance.
• Experience with other database technologies such as MSSQL and MySQL is a significant plus.
• This position is for an infrastructure DBA, not a developer. The focus is on system maintenance, optimization, backups, and disaster recovery, without writing code.