Database Administrator

Title: Database AdministratorLocation: Toronto, ON / Vancouver, BC / HybridContract: 6+ MonthsRequired Skill: PostgreSQL ~ ORACLE SQL ~ Microsoft SQL Server 2019Job Description-Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.Key Responsibilities:Database Administration:· Install, configure, and maintain PostgreSQL databases in production and non-production environments.· Perform database refresh activities between environments as required.· Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date.Architecture & Performance:· Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.· Handle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices.High Availability & Clustering:· Implement and manage repmgr cluster technology for high availability and failover.· Troubleshoot and resolve cluster node failure issues promptly to minimize downtime.Migration & Cloud Integration:· Design and execute migration strategies from on-prem to cloud environments.· Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.Backup & Recovery:· Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.· Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.Replication:· Configure and manage logical replication for data synchronization across environments.Required Skills & Qualifications:· Proven experience as a Postgres Database Administrator in enterprise environments.· Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.· Hands-on experience with repmgr clustering, failover handling, and node recovery.· Expertise in performance tuning, query optimization, and troubleshooting.· Experience with migration strategies from on-premises to cloud platforms.· Familiarity with Google Cloud or Azure database services.· Proficiency in backup, recovery, and disaster recovery planning.· Working knowledge of logical replication and streaming replication.· Excellent problem-solving and communication skills.Preferred Qualifications:· Experience with automation tools (Ansible, Terraform) for database deployments.· Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.· Scripting skills in Shell, Python, or similar for automation.