Sr PostgreSQL Database Administrator

Location: Harrisburg, PA
Description: Our client is currently seeking a Sr PostgreSQL Database Administrator
Harrisburg, PA ****must live in PA****

W2 Only

Contract-to-Hire Opportunity

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.

Required Skillset:

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, replication, 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 PGSQL databases using containerization tools such as Terraform, Ansible, Rancher, 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.

PostgreSQL Database Administration Experience

Installation management

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

Advanced 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, Ansible, and Stone Branch.

Collaboration

Excellent communication skills - both written and oral

Self-Starter initiative with Team-Player mentality

Experience leading a project

Problem-Solver

Basic Project Management skills - ability to create, read, append to, and follow plans

Nice to Have Skillset:

SQL Server Database Administration Experience (technical skills: see above list)

MongoDB Database Administration Experience (technical skills: see above list)

LUWDB2 Database Administration Experience (technical skills: see above list)

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.

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact:

This job and many more are available through The Judge Group. Please apply with us today!