Database Administrator

Datavail Infotech; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading database solutions provider in Canada is seeking a Senior Database Administrator. You will ensure the reliability of production databases and design high-availability systems while leveraging cloud services like AWS or Azure. The ideal candidate will have over 8 years of experience with PostgreSQL and possess strong analytical skills. Join a team that emphasizes continuous learning and growth in a supportive environment.

Benefits

Learning from experienced DBAs

Certifications covered by the company

Qualifications

• 8+ years of professional experience in database support and operations.
• Experience in cloud services like AWS or Azure.
• Proficient in SQL and PostgreSQL database management.

Responsibilities

• Ensure uptime and reliability of production databases.
• Design and implement high availability systems.
• Improve internal documentation and training resources.

Skills

PostgreSQL expertise

Cloud experience (AWS or Azure)

Analytical skills

SQL query development

Linux knowledge

Infrastructure-as-Code (IaC)

Job description

At least 8 years of professional experience, with:

• 4 or more years supporting databases, particularly Postgres, in a developer or operations role
• 4 or more years of hands‑on experience working in a major cloud offering, with AWS or Azure preferred
• Comfort and experience using a ticketing system such as ServiceNow or Jira to track and plan work, and communicate progress Previous customer facing experience in a Solutions Architect or other consulting role strongly considered
• Must possess strong analytical, verbal, and written communication skills; with the ability to explain technical concepts to a wide audience
• Experience with PostgreSQL databases whether on‑premise or in the cloud, self‑hosted, AWS RDS or Aurora Postgres, Azure Flexible Server, or other managed offering
• Proven expertise troubleshooting, diagnosing, and resolving technical issues - Understanding of data architecture, relational database concepts, logical and physical database design
• Ability to quickly size‑up a technical situation and formulate a plan to manage Production facing resources
• Skill reading and writing SQL queries, profiling and analyzing query plans, and supporting database users and developers
• Good working knowledge of Linux Operating Systems, shell scripting, and package management in one or more of the major distribution families
• Familiarity with Infrastructure‑as‑Code (IaC) tooling such as Ansible, Terraform/OpenTofu, or Chef
• Datavail's team of database administrators is seeking a highly skilled, self‑motivated, and passionate engineer to join our Global PostgreSQL Practice
• Postgres continues to grow in prominence and popularity, and our customers throughout many sectors and regions across the world use it as the bedrock of their Production systems
• As a Senior Database Administrator, you will advise customers on Cloud best practices, support the operation and maintenance of data systems, improve scalability and observability, and bring a modern, platform‑oriented approach to your work
• You will grow your technical skills and get a first‑hand view on trends as they are emerging in the wider industry
• You and the larger team of database professionals and developers will work on unique customer problems, monitor and interpret key metrics, and conduct regular reviews with your customers on the health of your systems
• Most importantly, you will work extensively with Postgres, the world's most advanced open‑source database

As the senior engineer you will be responsible for:

• Ensuring the uptime and reliability of Production databases
• Designing and implementing high availability systems with streaming and logical replication
• Managing the automation of backups and recovery
• Assisting with Disaster Recovery planning and implementation
• Learning about the broader Postgres ecosystem, including extensions, add‑on products, and open-source projects that contribute to the functioning and management of the core database
• Reacting to metrics and alerts around performance and capacity; and improving these alerts over time to provide better value and actionability
• Operating in Cloud environments, and recommending the appropriate cloud‑native tools for unique situations
• Supporting application developers and working with customer engineering teams to provide meaningful, measurable results

Improving internal documentation, runbooks, and other resources to train the wider team on best practices and new techniques

Why should you work at Datavail?

• To learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience
• To broaden your experience working with customers in many domains and environments
• To improve your familiarity with the many projects and variations surrounding Postgres; including AWS RDS, Aurora, Azure Flexible Server, TimescaleDB, Percona, Patroni, and many more
• Your Certifications would be on us
• To grow and expand your technical skills in a modern environment

If you think you are someone who brings these skills and you want a chance to build your career working with Postgres, please apply!