What are the responsibilities and job description for the PostgreSQL Database Administrator position at Ventures Unlimited?
Job Details
Install, configure, and maintain PostgreSQL database instances (on-premises and cloud).
Monitor database performance, troubleshoot slow queries, and optimize indexes and queries.
Implement backup, restore, and disaster recovery strategies using tools.
Set up and manage replication (Streaming Replication, Logical Replication, BDR).
Manage database security, user roles, and permissions, ensuring compliance with standards.
Perform database migrations, upgrades, and patching while ensuring minimal downtime.
Automate database administration tasks with scripts (Bash, Python, SQL).
Monitor system resources, storage, and performance metrics to ensure availability and scalability.
Collaborate with development teams to improve database architecture and optimize queries.
Document database configurations, processes, and troubleshooting procedures.
Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $100,000 - $140,000
