What are the responsibilities and job description for the PostgreSQL Database Administrator (Only open for Full Time) position at Key Infotek LLC?
Job Details
PostgreSQL Database Administrator
Job Description
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.
