PostgreSQL System Admin

1 week ago

Markham, Ontario, Canada Viva Tech Solutions Full time

Key Responsibilities:

  • Lead the installation, configuration, and administration of PostgreSQL database servers across production and non-production environments.
  • Design and implement high availability (HA), disaster recovery (DR), and replication solutions.
  • Monitor and analyze database performance, identify bottlenecks, and fine-tune SQL queries and database configurations.
  • Perform database upgrades, patching, and migrations with minimal downtime.
  • Implement robust backup and recovery strategies using tools like pgBackRest, Barman, etc.
  • Ensure database security through access controls, auditing, and encryption.
  • Automate routine database tasks using shell scripting or Ansible.
  • Collaborate with development, infrastructure, and DevOps teams to design scalable database architectures.
  • Document procedures, standards, and best practices for database management.
  • Provide mentorship to junior DBAs and act as an SME for PostgreSQL in cross-functional teams.
  • Support on-call rotation and handle critical incidents as needed.

Required Skills & Qualifications:

  • Bachelor's degree in Computer Science, Engineering, or a related field.
  • 5–7 years of PostgreSQL DBA with MongoDb experience in production environments.
  • Deep understanding of PostgreSQL internals, architecture, and advanced features.
  • Versions: PostgreSQL V14
  • Proven experience with streaming/logical replication and clustering.
  • Expertise in performance tuning, query optimization, and index strategy.
  • Strong experience with backup and recovery tools and strategies.
  • Advanced knowledge of Linux/Unix systems and scripting (Bash, Python preferred).
  • Familiarity with monitoring tools like Prometheus, Grafana, or Zabbix.
  • Experience managing PostgreSQL on cloud platforms (AWS RDS, GCP Cloud SQL, Azure).

Preferred/Good to Have:

  • Experience with containerization and orchestration tools (Docker, Kubernetes).
  • Knowledge of other database technologies (MySQL, Oracle, or NoSQL solutions).
  • Exposure to CI/CD pipelines and DevOps practices.
  • Experience with Infrastructure as Code (IaC) using Ansible, Terraform, etc.

  • Senior PostgreSQL System Administrator

    1 week ago

    Markham, Ontario, Canada Recutify Inc. Full time

    Position: Senior PostgreSQL System AdministratorLocation : Markam, CanadaMode of Work : Hybrid (3 days a week)Job Summary:We are seeking an experienced and highly skilled Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will be responsible for database...

  • Senior PostgreSQL System Administrator

    1 week ago

    Markham, Ontario, Canada Yochana Full time

    Position Name – Senior PostgreSQL System AdministratorType of hiring – FulltimeLocation – Markham, ON (Hybrid 3 Days Onsite)Job Description:We are seeking an experienced and highly skilledSenior PostgreSQL System Administratorwith5 to 7 Years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will be responsible...

  • Senior PostgreSQL System Administrator

    1 week ago

    Markham, Ontario, Canada Galent Full time

    Position:Senior PostgreSQL System AdministratorLocation:Markam, ON, CanadaMode of Work : Hybrid (3 days a week)Job Summary:We are seeking an experienced and highly skilledSenior PostgreSQL System Administratorwith 5 to 7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will be responsible for database...

  • Senior PostgreSQL System Administrator

    5 days ago

    Markham, Ontario, Canada Aarorn Technologies Inc Full time

    Job Title: Senior PostgreSQL System AdministratorLocation: Markham, ON (3x onsite a week)Employment Type: ContractPay Rate: CAD$40 - $48/HR INCJob DescriptionWe are seeking an experienced and highly skilled Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience in managing large-scale PostgreSQL environments.The ideal candidate will...

  • Senior PostgreSQL System Administrator

    1 week ago

    Markham, Ontario, Canada Quantum World Technologies Inc. Full time

    Required Skills & Qualifications:Bachelor's degree in Computer Science, Engineering, or a related field.5–7 years of PostgreSQL DBA with MongoDb experience in production environments.Deep understanding of PostgreSQL internals, architecture, and advanced features.Versions: PostgreSQL V14Proven experience with streaming/logical replication and...

  • Senior System Administrator

    1 week ago

    Markham, Ontario, Canada Galent Full time

    Role : PostgreSQL System AdministratorLocation : Markham ON Canada - Day 1 OnsiteJob Summary:We are seeking an experienced and highly skilledSenior PostgreSQL System Administratorwith 5 to 7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will be responsible for database performance, optimization,...

  • Bookkeeper & Admin Assistant

    7 days ago

    Markham, Ontario, Canada NOIC Academy Full time

    Position SummaryThe Bookkeeper and Admin Assistant p is responsible for managing the school's day-to-day financial activities and supporting general office operations. This role performs key accounting functions—including monthly financial reporting, maintaining general ledgers, and processing payments—while ensuring accurate, timely, and organized...

  • ETL Developer

    1 day ago

    Markham, Ontario, Canada Aviva Canada Full time

    Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.We are seeking a dedicated ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic...

  • Full Stack Engineer

    1 week ago

    Markham, Ontario, Canada Enercare Inc. Full time

    Company DescriptionEnercare Inc. is one of Canada's largest providers of home and commercial services, specializing in heating, cooling, plumbing, electrical, water heating, and water purification. With a strong commitment to sustainability and innovation, Enercare delivers energy-efficient solutions that help build a greener future.Operating across multiple...

  • Administrative Assistant

    1 week ago

    Markham, Ontario, Canada Tdot Immigration Services Inc. Full time

    OverviewWe are seeking candidates with prior administrative experience and practical exposure to an immigration firm environment. Due to the nature of the role, applicants without immigration industry experience may not be a suitable fit.We are seeking a detail-oriented and highly organized Administrative Assistant to join our team. The Admin Assistant role...