PostgreSQL DBA-Remote with 25% travel, most likely VA, but could be GA, TX, NJ but Preferred VA
Posted 3 days ago by Cyber Sphere LLC
Negotiable
Undetermined
Remote
Remote
Summary: The PostgreSQL DBA role involves managing, maintaining, and optimizing PostgreSQL database systems, particularly in EnterpriseDB environments. The candidate will be responsible for various tasks including installation, configuration, performance tuning, and ensuring high availability of databases. The position requires hands-on experience in mission-critical production environments and a strong focus on database reliability and security. The role is remote with 25% travel expected, primarily to Virginia but potentially to other states as well.
Key Responsibilities:
- Install, configure, upgrade, and administer PostgreSQL and EnterpriseDB database environments.
- Manage and support EnterpriseDB Postgres Distributed (PGD) clusters for high availability and replication.
- Perform database deployments, migrations, patching, and version upgrades.
- Monitor database health, availability, and performance using monitoring and administration tools.
- Troubleshoot database issues, replication failures, and performance bottlenecks.
- Implement and maintain backup and recovery strategies using PostgreSQL/EDB tools.
- Configure and manage replication, clustering, failover, and disaster recovery solutions.
- Perform database performance tuning including query optimization, indexing, vacuuming, and resource utilization improvements.
- Support production, development, QA, and staging database environments.
- Ensure database security, access control, and compliance standards are maintained.
- Collaborate with application developers, infrastructure teams, and DevOps teams for database-related activities.
- Create and maintain technical documentation, SOPs, and operational procedures.
- Participate in on-call support and incident management activities when required.
Key Skills:
- Strong hands-on experience with PostgreSQL database administration.
- Experience working with EnterpriseDB (EDB) products and tools.
- Hands-on experience with EnterpriseDB Postgres Distributed (PGD) clusters.
- Knowledge of PostgreSQL architecture, replication, clustering, and high availability concepts.
- Experience in database installation, configuration, backup/recovery, and patch management.
- Strong experience in database performance tuning and query optimization.
- Experience with Linux/Unix operating systems.
- Good understanding of database security and access management.
- Experience with monitoring and troubleshooting database environments.
- Familiarity with shell scripting or automation tools is preferred.
- Strong analytical, troubleshooting, and communication skills.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Title - PostgreSQL DBA
Location- Remote with 25% travel, most likely VA, but could be GA, TX, NJ but Preferred VA
Duration Contract
Job Summary
We are seeking a skilled PostgreSQL DBA with strong experience in EnterpriseDB (EDB) environments to manage, maintain, and optimize PostgreSQL database systems. The ideal candidate will be responsible for installation, configuration, administration, monitoring, performance tuning, deployments, and high availability management of PostgreSQL databases, including EnterpriseDB Postgres Distributed (PGD) clusters.
The candidate should have hands-on experience supporting mission-critical production environments and ensuring database reliability, scalability, security, and performance.
Key Responsibilities
- Install, configure, upgrade, and administer PostgreSQL and EnterpriseDB database environments.
- Manage and support EnterpriseDB Postgres Distributed (PGD) clusters for high availability and replication.
- Perform database deployments, migrations, patching, and version upgrades.
- Monitor database health, availability, and performance using monitoring and administration tools.
- Troubleshoot database issues, replication failures, and performance bottlenecks.
- Implement and maintain backup and recovery strategies using PostgreSQL/EDB tools.
- Configure and manage replication, clustering, failover, and disaster recovery solutions.
- Perform database performance tuning including query optimization, indexing, vacuuming, and resource utilization improvements.
- Support production, development, QA, and staging database environments.
- Ensure database security, access control, and compliance standards are maintained.
- Collaborate with application developers, infrastructure teams, and DevOps teams for database-related activities.
- Create and maintain technical documentation, SOPs, and operational procedures.
- Participate in on-call support and incident management activities when required.
Required Skills
- Strong hands-on experience with PostgreSQL database administration.
- Experience working with EnterpriseDB (EDB) products and tools.
- Hands-on experience with EnterpriseDB Postgres Distributed (PGD) clusters.
- Knowledge of PostgreSQL architecture, replication, clustering, and high availability concepts.
- Experience in database installation, configuration, backup/recovery, and patch management.
- Strong experience in database performance tuning and query optimization.
- Experience with Linux/Unix operating systems.
- Good understanding of database security and access management.
- Experience with monitoring and troubleshooting database environments.
- Familiarity with shell scripting or automation tools is preferred.
- Strong analytical, troubleshooting, and communication skills.
Preferred Qualifications
- 4+ years of DBA experience with PostgreSQL, preferably in EnterpriseDB environments.
- Experience supporting large-scale or mission-critical production systems.
- Knowledge of cloud platforms such as AWS, Azure, or Google Cloud Platform is a plus.
- Experience with DevOps tools and CI/CD deployments is an added advantage.
- EnterpriseDB certifications are preferred.
Regards,
Sai Srikar
Email: