PostgreSQL Database Administrator (DBA)
Jobs via Dice, Cary, NC, United States
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Executive Software Guild, is seeking the following. Apply via Dice today!
Job Description
Install, configure, and maintain PostgreSQL database servers.
Monitor database performance and perform tuning for optimal efficiency.
Implement and manage backup and recovery strategies (pg_dump, pg_basebackup, PITR).
Configure and manage replication (streaming replication, logical replication).
Ensure high availability using clustering and failover solutions.
Manage database security, roles, and access controls.
Perform database patching, upgrades, and migrations.
Troubleshoot and resolve database issues in a timely manner.
Monitor system health, storage, and capacity planning.
Collaborate with development teams to optimize queries and database design.
Maintain documentation and follow best practices.
Required Skills & Qualifications
Bachelor's degree in Computer Science, IT, or related field.
10+ years of experience as a PostgreSQL DBA.
Strong knowledge of PostgreSQL architecture and internals.
Experience with performance tuning and query optimization.
Hands‑on experience with backup/recovery and replication.
Proficiency in SQL and database administration.
Experience working in Linux/Unix environments.
#J-18808-Ljbffr
Job Description
Install, configure, and maintain PostgreSQL database servers.
Monitor database performance and perform tuning for optimal efficiency.
Implement and manage backup and recovery strategies (pg_dump, pg_basebackup, PITR).
Configure and manage replication (streaming replication, logical replication).
Ensure high availability using clustering and failover solutions.
Manage database security, roles, and access controls.
Perform database patching, upgrades, and migrations.
Troubleshoot and resolve database issues in a timely manner.
Monitor system health, storage, and capacity planning.
Collaborate with development teams to optimize queries and database design.
Maintain documentation and follow best practices.
Required Skills & Qualifications
Bachelor's degree in Computer Science, IT, or related field.
10+ years of experience as a PostgreSQL DBA.
Strong knowledge of PostgreSQL architecture and internals.
Experience with performance tuning and query optimization.
Hands‑on experience with backup/recovery and replication.
Proficiency in SQL and database administration.
Experience working in Linux/Unix environments.
#J-18808-Ljbffr