PostgreSQL DBA

PostgreSQL DBA PostgreSQL Administration, Performance Tuning & High Availability Toronto, ON Work Model: Hybrid (4 days a week in office) Required Skills PostgreSQL Database Administration PostgreSQL Architecture Performance Tuning & Query Optimization High Availability & Clustering Backup & Recovery Role Description Database Administration Install, configure, and maintain PostgreSQL databases in production and non-production environments. Perform database refresh activities between environments. Execute database patching and upgrade activities. Architecture & Performance Manage PostgreSQL architecture, including memory management, indexing, and query optimization. Analyze query execution plans and perform performance tuning. High Availability & Clustering Implement and manage repmgr clustering for high availability and failover. Troubleshoot and resolve cluster node failures. Migration & Cloud Integration Design and execute database migration strategies from on-premises ...