Senior Database Administrator - PostgreSQL

LingaTech • Harrisburg, PA

1d • Hybrid

About The Position

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.

Requirements

• Senior-level experience in all areas of database administration
• Experience performing full PostgreSQL installations within containerized environments.
• Proven ability to manage and execute large-scale data migrations from mainframe platforms to AWS and on-prem environments
• Experience managing PostgreSQL database design and architecture, infrastructure, high availability (HA), security, performance monitoring/alerting
• Ability to mentor, coach, and train less senior team members.
• Experience in data migration and fixing problems with data replication
• Skilled at implementing monitoring and alerts

Responsibilities

• Manage PostgreSQL database design and architecture, infrastructure, high availability (HA), security, performance monitoring/alerting, and routine maintenance (tuning, backup, replication, recovery).
• Understand application data storage requirements and associated business logic.
• Design and create database schemas, tables, indexes, and other objects to optimize query performance.
• Evaluate and recommend deployment options for Aurora (AWS PostgreSQL) and/or open-source PostgreSQL on AWS and on-premises.
• Deploy and maintain PostgreSQL databases using containerization/automation tools (e.g., Terraform, Ansible, Rancher, Kubernetes).
• Ensure scalability and maintainability aligned with future growth and data retention needs; define/configure for both AWS and on-prem environments.
• Collaborate closely with stakeholders; communicate effectively (written and oral).
• Lead projects and contribute as a self-starter/team player; solve problems proactively.
• Apply basic project management skills (create/read/update/follow plans).

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed
• Number of Employees: 11-50 employees