PostgreSQL Database Administrator

Dataquest; Harrisburg (Dauphin County); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical insurance

Vision insurance

401(k)

Disability insurance

Job summary

A leading IT firm is seeking a PostgreSQL DevOps DBA to lead database design and management. The ideal candidate will have extensive experience in PostgreSQL, performance monitoring, and automation of database tasks. This full-time position requires a mid-senior level professional capable of mentoring others. The role offers comprehensive benefits including medical, vision insurance, and a 401(k).

Qualifications

• 5+ years of experience in PostgreSQL database administration.
• Familiarity with containerization tools.
• Ability to mentor and support junior members.

Responsibilities

• Design and manage database architecture and infrastructure.
• Ensure database high availability and performance monitoring.
• Automate backups and maintenance tasks.

Skills

Database design and architecture

PostgreSQL database familiarity

Automation of backups

Advance shell scripting

Performance monitoring

Tools

Terraform

Kubernetes

AWS RDS

Unix shell scripting

Ansible

Job description

A PostgreSQL DevOps DBA plays a critical role in modern IT organizations that rely on PostgreSQL as their primary database management system.

This position leads the design, implementation, maintenance and support of database environments. This role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements for the most complex projects, working independently. This position requires the necessary skills to coordinate and support other database administrators as senior database administrators are expected to mentor, coach, and train less senior team members.

RESPONSIBILITIES

• Database design and architecture
• Manage PostgreSQL database design and architecture, infrastructure management, high availability (HA) assurance, security, performance monitoring and alerting and the performance of routine maintenance tasks including performance tuning, backup, and recovery.
• Understanding of the application's data storage requirements and the business logic involved.
• Design and create database schemas and tables, configuring indices and other database objects to optimize query performance.
• Full understanding of architecture and performance to recommend deployment options for Aurora (AWS PostgreSQL) and/or open PostgreSQL on both AWS and on-premises.
• Ability to deploy and maintain database using containerization tools such as Terraform and Kubernetes.
• Ensure the database is designed for scalability and maintainability, considering future growth and data retention needs. Knowledge of database configuration requirements for both AWS and on-premises installations.
• Upgrading/Patching
• Setup and Configuration
• Backup and restore for both daily use and/or disaster recovery (both annual testing and disaster preparedness)
• Data export, load processing, and transformations (ETL)
• PostgreSQL extensions familiarity
• High Availability, Load Balancing, and Replication
• Monitoring, reporting, and alert configurations
• Advance shell scripting skills
• Extensive familiarity with PostgreSQL database and schema objects
• Extensive familiarity with AWS RDS/S3/EC2/Aurora PostgreSQL.
• Understand access controls, encryption, and other security measures to protect the data.
• Authentication Configuration - LDAP configuration and implementation, local account maintenance
• Ability to identify and resolve performance issues by monitoring database performance metrics and analyzing query performance.
• Optimizing queries and indexes, tuning memory settings, and identifying and addressing performance bottlenecks.
• Automation of backups, monitoring, and patching using tools like: Unix shell scripting, Windows PowerShell, Python, and Ansible.

Preferred Skillset:

• SQL Server Database Administration Experience
• MongoDB Database Administration Experience
• Familiarity with RHEL and Windows Server OS’s
• Familiarity with Jira
• Familiarity with ITIL Service Management Change Processes
• Familiarity with Grafana
• Familiarity with monitoring tools like Nagios, Zabbix, Prometheus, and Grafana to detect and report potential issues.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

Banking

Benefits

Medical insurance

Vision insurance

401(k)

Disability insurance