Database Administrator - PostgreSQL
Harrisburg, PA
Contracted to Full Time
Experienced
This position requires participation in a 24x7x365 on-call rotation
Location: Harrisburg, PA
Position Type: Hybrid
Hybrid Schedule: 1 day in office per week minimum.
Must be flexible to be on site 5 days if management team requires
Contract Length: 6 months, Contract to hire
This position requires participation in a 24x7x365 on-call rotation
Position Overview:
Duties:
Location: Harrisburg, PA
Position Type: Hybrid
Hybrid Schedule: 1 day in office per week minimum.
Must be flexible to be on site 5 days if management team requires
Contract Length: 6 months, Contract to hire
This position requires participation in a 24x7x365 on-call rotation
Position Overview:
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.
Duties:
- 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).
Apply for this position
Required*