PostgreSQL Database Administrator - United States - ProRec Resource Solutions

    ProRec Resource Solutions
    ProRec Resource Solutions United States

    1 week ago

    Description
    The manager would like this to be an onsite interview for first interview...

    Title/Role:
    PostgreSQL Database Administrator

    Contract Duration: 6 months, right to hire

    Work Location:
    Harrisburg, PA

    Work Arrangement:
    Hybrid (1 day onsite per week, remaining days remote)
    Work Schedule: 8:00 a.m. to 5:00 p.m. (flexible)

    On-Call:
    Participation in a 24x7x365 on-call rotation is required

    Interview Type:
    On-site for local candidates; virtual may be arranged for out-of-town candidates

    Residency Requirements:
    Must be a PA resident at time of hire

    Visas Accepted:
    USC, GC

    Role Summary

    Our client is seeking a PostgreSQL Database Administrator to provide hands-on technical leadership and operational support for enterprise PostgreSQL environments across on-prem and AWS.

    This role emphasizes PostgreSQL administration, AWS migration and modernization, and reliability practices (availability, security, performance, and scalability).

    Important Clarification:
    this is not a Kubernetes administrator role. You will not be responsible for managing Kubernetes infrastructure. The need is for someone familiar with supporting PostgreSQL in a containerized environment and working effectively alongside platform teams.
    Top Requirements


    • Strong PostgreSQL administration experience (support, troubleshooting, performance tuning)
    • WS database migration experience (Aurora PostgreSQL and/or RDS PostgreSQL)
    • Experience working with or alongside Percona tooling and EnterpriseDB (EDB)
    • Familiarity supporting PostgreSQL in a containerized environment (not direct Kubernetes administration)
    • bility to support a hybrid schedule in Harrisburg, PA (1 day onsite per week)
    • Willingness to participate in a 24x7x365 on-call rotation
    Key Responsibilities


    • dminister and support PostgreSQL environments, including performance tuning, monitoring, troubleshooting, and routine maintenance
    • Lead PostgreSQL database design and architecture, including schema design, indexing strategies, and database object optimization
    • Plan and execute database migrations to AWS, including deployment recommendations for Aurora PostgreSQL and/or RDS PostgreSQL and post-migration stabilization
    • Manage high availability, load balancing, replication, and recovery strategies, including disaster recovery preparedness and annual testing
    • Install, configure, upgrade, and patch PostgreSQL and related tooling; manage installation standards and configuration baselines
    • Implement and maintain monitoring, reporting, and alerting to maximize availability, reliability, and performance
    • Perform backup and restore operations for both daily use and disaster recovery; automate and validate backup integrity
    • Identify and resolve performance issues by analyzing metrics and query behavior; optimize queries and indexes, tune memory settings, and remediate bottlenecks
    • Support data export, load processing, and transformations (ETL) as needed; maintain familiarity with PostgreSQL extensions
    • Implement and enforce database security controls including access controls, encryption, and authentication configuration (LDAP and local accounts)
    • Collaborate with infrastructure teams to provision database servers, storage, and platform resources across on-prem and AWS
    • utomate operational processes such as backups, monitoring, and patching using tools such as Unix shell scripting, PowerShell, Python, Ansible, and Stone Branch
    • Support PostgreSQL services running in containerized environments by troubleshooting database-level issues and collaborating with platform teams for platform-level concerns (not responsible for Kubernetes infrastructure support)
    • Provide mentorship, coaching, and training to other DBAs and contribute to standards, documentation, and operational best practices
    Required Qualifications


    • Strong PostgreSQL administration experience, including troubleshooting and performance tuning
    • Experience with AWS database migrations and supporting PostgreSQL in AWS environments (RDS and/or Aurora PostgreSQL)
    • Experience with high availability, replication, backup/restore, and disaster recovery processes
    • Hands-on experience with monitoring and alerting and the ability to diagnose and resolve production issues
    • dvanced shell scripting skills and experience automating operational tasks
    • Experience working with or alongside containerized environments and related tooling (for example, Kubernetes based platforms), Percona tooling, and EnterpriseDB (EDB)
    • Strong communication skills, both written and oral, with the ability to explain technical concepts clearly
    • bility to plan and execute work independently while collaborating effectively across teams
    Preferred Qualifications


    • Experience with Microsoft SQL Server administration
    • Experience with MongoDB administration, including Replica Sets, Sharding, and data movement tools (mongodump, mongorestore, mongoexport, mongoimport)
    • Familiarity with RHEL and Windows Server
    • Familiarity with Jira
    • Familiarity with ITIL change management processes
    • Familiarity with Grafana and monitoring tools such as Nagios, Zabbix, and Prometheus
    • Experience with infrastructure-as-code and automation tooling such as Terraform, Ansible, and related CI/CD practices
    Work Arrangement and Operational Requirements


    • Hybrid schedule in Harrisburg, PA: 1 day onsite per week
  • Work in company

    Database Administrator

    Only for registered members

    We are seeking a dynamic and detail-oriented Database Administrator to join our growing team in this role you will be responsible for managing maintaining and optimizing our organization's databases to ensure seamless data flow and high performance · ...

    United States

    2 weeks ago

  • Work in company Remote job

    Database Administrator

    Only for registered members

    A fast-paced, proactive Database Administrator who excels in their area of expertise to join AEC. · ...

    United States

    2 weeks ago

  • Work in company

    Database Administrator

    Only for registered members

    +This position is responsible for the quality maintenance and performance of data stores across Smile Digital Health along with its clients and partners. · +Perform Database capacity planning, installation, configuration, database design, migration, performance monitoring, securi ...

    United States

    1 month ago

  • Work in company Remote job

    Database Administrator

    Only for registered members

    We are looking for experienced Database Administrators to collaborate with a leading AI organization on a high-priority training and evaluation project. · Design and optimize complex SQL queries using EXPLAIN plans and indexing strategies · Implement schema changes with CREATE/AL ...

    United States

    1 month ago

  • Work in company

    Database Administrator

    Only for registered members

    Aerostar Environmental and Construction (AEC) is seeking a fast-paced Database Administrator to manage their environmental EQuIS database. · ...

    United States

    5 days ago

  • Work in company

    Database Administrator

    Only for registered members

    Mind Computing seeks a Database Administrator to support the Department of Veterans Affairs remotely. · ...

    United States

    1 week ago

  • Work in company

    Database Administrator

    Only for registered members

    This position is responsible for the quality maintenance and performance of data stores across Smile Digital Health along with its clients and partners as a Database Administrator. You will be tasked with enhancing data management practices and providing recommendations and best ...

    United States

    1 week ago

  • Work in company Remote job

    Database Administrator

    Only for registered members

    We're seeking an experienced Database Administrator (DBA) - SQL Server to join our team. · ...

    United States

    1 week ago

  • Work in company

    Database Administrator

    Only for registered members

    Are you looking for a high energy, strategic, and fast-paced position as a Database Administrator? Join Relias, the company changing lives throughout the world by helping healthcare organizations improve their clinical and financial outcomes. · ...

    United States of America

    5 days ago

  • Work in company

    Database Administrator

    Only for registered members

    The Database Administrator (DBA) is a hands-on role focused on maintaining, optimizing, and securing our SQL Server environments.PANTHERx Rare Pharmacy is seeking a skilled Database Administrator to join its team. · We are looking for an individual who can bring deep technical ex ...

    United States

    1 month ago

  • Work in company Remote job

    Sr Database Administrator

    Only for registered members

    The Senior Database Administrator (Sr. DBA) is responsible for the design, implementation, support and maintenance of database systems critical to healthcare operations including patient care, · clinical applications, · and administrative functions for The Guthrie Clinic (TGC). · ...

    United States Full time

    1 week ago

  • Work in company Remote job

    Senior Database Administrator

    Only for registered members

    Peraton is seeking a highly capable and proactive Senior Database Administrator to support our Health and Human Services - Office of Inspector General (HHS-OIG) contract. · This role is critical part of contract mission delivery ensuring stability integrity performance enterprise ...

    United States

    1 month ago

  • Work in company

    Database Administrator 3-IT

    Only for registered members

    Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. · ...

    United States

    1 week ago

  • Work in company

    Database Administrator 2-IT

    Only for registered members

    We are building a platform that manages the end-to-end lifecycle, from provisioning to upgrade to termination. · The Healthcare platform is an exciting team working at the intersection of infrastructure and applications, leveraging OCI to transform some of the largest healthcare ...

    United States

    1 week ago

  • Work in company

    Database Administrator Sr

    Only for registered members

    Description INTEGRIS Health Two Corporate Plaza Bldg. Oklahoma's largest not-for-profit health system has a great opportunity for a Database Administrator Sr in Oklahoma City OK In this position you'll be a part of our Digital Workspace Services team providing exceptional work su ...

    United States

    1 week ago

  • Work in company Remote job

    Remote - Database Administrator

    Only for registered members

    Mosaic Life Care is a health care system in northwest Missouri providing high-value quality healthcare to its patients. · Supports IT system engineering initiatives including design build configure maintain and optimize critical infrastructure including Microsoft SQL Oracle DB Po ...

    United States

    2 weeks ago

  • Work in company

    Manager, Database Administration

    Only for registered members

    The Database Administration (DBA) Manager will lead the architecture security and performance of enterprise-wide database environments within our SaaS-based ecosystem. · ...

    United States

    3 weeks ago

  • Work in company

    Database Administrator 4-IT

    Only for registered members

    Job summary · As a SRE/Database Administrator, you will be responsible for builing, managing and securing Oracle databases & Exadata Infrastructure (Prod & Non-Prod on Prem and VMs in OCI). You will triage database alerts and issues, identify root causes and implement corrective ...

    United States

    1 week ago

  • Work in company

    Senior Database Administrator

    Only for registered members

    CDM Smith is seeking a Senior Database Administrator to join our Digital Engineering Solutions team This individual will be part of the Development group within the Digital Engineering Solutions team helping design and implementation of cloud-based solutions facilitating CI/CD pi ...

    United States

    6 days ago

  • Work in company

    Database Administrator 2-IT

    Only for registered members

    Work with a world class team to provide enterprise-wide Oracle Database Administration support for production systems in Oracle Cloud Infrastructure (OCI) using Autonomous Database (ADB). Provide DBA services to application development teams including database design coding and d ...

    United States

    1 week ago

  • Work in company

    Sr Manager, Database Administration

    Only for registered members

    HHAeXchange es la plataforma tecnológica líder para atención en el hogar y comunidad basada. La empresa fue fundada en · 2008, HHAeXchange nació como una idea para crear una solución integral e completa para atención domiciliaria que ayudara a las personas que están · añezcan o ...

    United States

    2 weeks ago

Jobs
>
Postgresql database administrator