Alpha Consulting Corp. ยท 3 days ago
Senior PostgreSQL Database Administrator (DBA)
Alpha Consulting Corp. is seeking a talented and experienced PostgreSQL Database Administrator to manage and optimize their database systems. This role involves overseeing day-to-day database operations, implementing backup and restore strategies, and ensuring high availability of database solutions.
ConsultingPharmaceuticalStaffing Agency
Responsibilities
Understanding of PostgreSQL Architecture : Strong grasp of PostgreSQL architecture and internal components
Backup and Restore Strategies : Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR)
Version Upgrades (7%): Proven experience in performing minor and major PostgreSQL version upgrades
Database Replication and High-Availability Extensive experience with database replication and high-availability solutions
Database Operations Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU load, locks, blocking, long-running queries, etc.)
Configuration and Performance Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views
Maintenance Activities: Experience with routine database maintenance activities (vacuum, analyze, reindex, patching)
Cloud-Based Deployments : Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (GCP)
HADR Tools : Strong experience with HADR tools such as Repmgr, Pgpool, and pgBackRest
Containerization and Orchestration : Solid hands-on experience with containerization and orchestration technologies, including Kubernetes
Scripting Skills (7%): Strong scripting skills in Shell and/or Python for automation and monitoring
High-Performance Databases Proven experience administering multi-terabyte, high-performance production databases
Learning and Adaptability: Ability to independently learn, adapt, and implement new technologies
Communication and Collaboration : Excellent communication skills with the ability to collaborate effectively across business and technical teams
Database Infrastructure Design Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes
Qualification
Required
Strong grasp of PostgreSQL architecture and internal components
Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR)
Proven experience in performing minor and major PostgreSQL version upgrades
Extensive experience with database replication and high-availability solutions
Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU load, locks, blocking, long-running queries, etc.)
Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views
Experience with routine database maintenance activities (vacuum, analyze, reindex, patching)
Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (GCP)
Strong experience with HADR tools such as Repmgr, Pgpool, and pgBackRest
Solid hands-on experience with containerization and orchestration technologies, including Kubernetes
Strong scripting skills in Shell and/or Python for automation and monitoring
Proven experience administering multi-terabyte, high-performance production databases
Ability to independently learn, adapt, and implement new technologies
Excellent communication skills with the ability to collaborate effectively across business and technical teams
Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes
Preferred
Exposure to Kubernetes platforms such as GKE or EKS
Company
Alpha Consulting Corp.
Alpha Consulting Corp. has been exceeding expectations in the IT, pharmaceutical, and clinical staffing business since 1994.
H1B Sponsorship
Alpha Consulting Corp. 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 (2)
2024 (4)
2023 (3)
2021 (4)
2020 (6)
Funding
Current Stage
Growth StageCompany data provided by crunchbase