Capstone IT Staffing · 1 day ago
PostgreSQL DBA
Capstone IT Staffing is seeking an experienced PostgreSQL Database Administrator to support application development teams in a heavily on-prem, command-line–driven environment. This role focuses on hands-on operations, ticket-based support, and managing PostgreSQL databases, including performing major version upgrades from PostgreSQL 9 to PostgreSQL 16.
Responsibilities
Provide day-to-day PostgreSQL DBA support for internal application development teams
Manage and resolve incoming tickets related to PostgreSQL environments
Perform major PostgreSQL upgrades (PostgreSQL 9 → 16), including planning, execution, and validation
Administer PostgreSQL databases in on-prem environments using the command line
Handle all core DBA responsibilities:
Backups and restores
Performance tuning and query optimization
Vacuuming and routine maintenance
Patching and upgrades
Migrations and data movement
Write, review, and troubleshoot SQL, DDL, and DML
Communicate clearly with stakeholders and close the loop on tickets and requests
Work independently once requirements and instructions are provided
Qualification
Required
Strong experience administering PostgreSQL in on-prem environments
Candidates with only cloud-managed Postgres experience (RDS, Cloud SQL, etc.) will not be a fit
Deep understanding of PostgreSQL internals and operational best practices
Hands-on experience with: Backups and restores, Performance tuning, Vacuuming and maintenance, Upgrades and migrations
Strong ability to write and interpret SQL, including DDL and DML
Comfortable working in a Linux command-line environment
Professional, reliable, and responsive
Follows instructions
Works independently
Communicates clearly and closes tickets effectively
Preferred
Experience with YAML and/or Puppet
Shell or Bash scripting experience
Prior experience upgrading PostgreSQL from older major versions to current releases
Exposure to cloud platforms such as AWS or GCP (not required)
Company
Capstone IT Staffing
Capstone IT unlocks your business potential with the transformative power of technology and human resources.
H1B Sponsorship
Capstone IT Staffing has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (6)
2022 (2)
2021 (5)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase