ZipRecruiter

Log In

1

Postgresql Dba Jobs in Alberta (NOW HIRING)

H2 Safety

Enterprise GIS Administrator

Calgary, AB · On-site

Spatial database ownership Own the PostgreSQL/PostGIS (h2Spatial) environment and its Esri ... Administer licensing and named-user management and manage ArcGIS Pro client-side deployment. * Own ...

H2Safety

Enterprise GIS Administrator

Calgary, AB

Spatial database ownership - Own the PostgreSQL/PostGIS (h2Spatial) environment and its Esri ... Administer licensing and named-user management and manage ArcGIS Pro client-side deployment. * Own ...

H2 Safety

Enterprise GIS Administrator

Calgary, AB · On-site

Spatial database ownership -- Own the PostgreSQL/PostGIS (h2Spatial) environment and its Esri ... Administer licensing and named-user management and manage ArcGIS Pro client-side deployment. * Own ...

All JobsPostgresql Dba JobsPostgresql Dba Jobs in Alberta

Postgresql Dba information

See Alberta salary details

$14.5K

$125.1K

$201.5K

How much do postgresql dba jobs pay per year?

As of Jul 28, 2026, the average yearly pay for postgresql dba in Alberta is $125,130.00, according to ZipRecruiter salary data. Most workers in this role earn between $104,000.00 and $140,000.00 per year, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive as a PostgreSQL DBA, and why are they important?

To thrive as a PostgreSQL DBA, you need a solid understanding of database architecture, SQL, performance tuning, backup and recovery, and typically a degree in computer science or a related field. Proficiency with PostgreSQL tools (such as pgAdmin, psql), scripting languages, and familiarity with monitoring and automation systems are important, and certifications like PostgreSQL Certified Professional can be beneficial. Strong problem-solving abilities, attention to detail, and effective communication skills help DBAs excel in managing complex data environments and collaborating with development teams. These skills ensure the reliability, security, and efficiency of critical data systems, which are essential for organizational success.

What does a PostgreSQL DBA do?

A PostgreSQL DBA (Database Administrator) is responsible for installing, configuring, maintaining, and securing PostgreSQL databases. They manage database performance, perform backups and recovery, ensure data integrity, and troubleshoot any issues related to the database. Additionally, PostgreSQL DBAs often work on database design, user management, and tuning queries to optimize system performance. Their expertise is crucial for businesses that rely on PostgreSQL for their data storage and management needs.

What is the difference between Postgresql Dba vs MySQL Database Administrator?

AspectPostgresql DbaMySQL Database Administrator
CertificationsPostgreSQL certifications, DBA certificationsMySQL certifications, DBA certifications
Work EnvironmentLinux/Unix servers, cloud platforms, enterprise environmentsLinux/Unix servers, cloud platforms, web hosting environments
Industry UsageFinancial, healthcare, government sectorsWeb development, e-commerce, startups
Common TasksDatabase tuning, backup, replication, securityDatabase tuning, backup, replication, security

Both Postgresql Dba and MySQL Database Administrator roles involve managing and maintaining databases, ensuring performance, security, and availability. While they share many core responsibilities, the main differences lie in the database systems they specialize in and the typical industry environments they serve. Postgresql Dba roles often focus on enterprise and complex data environments, whereas MySQL DBAs are more common in web-based and startup settings.

What are some common challenges faced by PostgreSQL DBAs when managing large-scale databases?

PostgreSQL DBAs often encounter challenges such as optimizing query performance, managing data growth, and ensuring high availability in large-scale environments. Handling replication, performing timely backups and restores, and tuning configurations for both hardware and workload can require advanced troubleshooting and proactive monitoring. Collaborating closely with developers and system administrators is essential to address issues like slow queries or schema changes, making communication skills just as important as technical expertise.

What Does a PostgreSQL DBA Do?

As a PostgreSQL database administrator or PostgreSQL DBA, you build, maintain, configure, and repair PostgreSQL open-source databases. Other duties include deploying applications to help clients and employers use the database for their specific needs. You also update and secure the database’s network and server, respond to security alerts, and perform data back-up and recovery tasks. Your responsibilities often include working with a developer to program software and training employees to use database features. You are also expected to test and debug upgrades or changes to the database before deploying them.

More about Postgresql Dba jobs
What are popular job titles related to Postgresql Dba jobs in Alberta? For Postgresql Dba jobs in Alberta, the most frequently searched job titles are:
What job categories do people searching Postgresql Dba jobs in Alberta look for? The top searched job categories for Postgresql Dba jobs in Alberta are:
Postgresql Dba jobs near you
Infographic showing various Postgresql Dba job openings in Alberta as of July 2026, with employment types broken down into 77% Full Time, 21% Part Time, and 2% Contract. Highlights an 94% Physical, 3% Hybrid, and 3% Remote job distribution, with an average salary of $125,130 per year, or $60.2 per hour.

Enterprise GIS Administrator

H2 Safety

Calgary, AB • On-site

Other

Medical, Retirement, PTO

Posted 6 days ago

Job description

Salary:

Grow Your Career with Us!

Celebrating our 22nd anniversary this year, H2Safety Services Inc. is Canadas largest provider of emergency response management services and solutions. Our team of industry-leading experts delivers comprehensive, tailored emergency management services, emergency response training, and technology services to companies throughout Canada, North America, and around the world. By continuously investing in our people and world-class technology, we ensure the highest level of protection and compliance for our clients, stakeholders, and the environment.


In June 2025, H2Safety became a part of SGS, the worlds leading testing, inspection, and certification company - and a world leader in sustainability. As part of SGS, H2Safety is working towards globally advancing operational safety, digital transformation, and ESG performance across industries, including oil and gas, mining, transportation, utilities, renewables, and government. Our success and approach are deeply rooted in building authentic relationships and addressing community concerns transparently, allowing us to also excel in Indigenous and government relations.


The Role:

We are seeking an Enterprise GIS Administrator to oversee and support H2Safety's enterprise GIS platform. This hands-on role is responsible for administering ArcGIS Enterprise, managing PostgreSQL/PostGIS spatial databases and Esri geodatabases, publishing map services, and ensuring a reliable, secure, and high-performing GIS environment. Reporting to the GIS Manager, you will help support the GIS infrastructure behind our emergency management and response solutions.


Key Accountabilities


  • Platform reliability and availability Keep the core GIS platform ArcGIS Enterprise, the PostGIS spatial database, and map-service publishing stable, secure, and performant for client-facing, life-safety systems.
  • Platform administration and upgrades Own the installation, configuration, upgrade, and licensing of the full ArcGIS Enterprise stack.
  • Spatial database ownership Own the PostgreSQL/PostGIS (h2Spatial) environment and its Esri geodatabases, including schema governance, performance, migrations, and data consolidation.
  • Publishing and service governance Own map-service publishing standards and content lifecycle across the platform.
  • Documentation and knowledge continuity Maintain authoritative documentation of the platform's configuration, architecture, and operating procedures.
  • Growth into automation Build capability in Python and FME to add depth and continuity over time.


Key Duties

ArcGIS Enterprise Administration

  • Install, configure, upgrade, and patch ArcGIS Enterprise (Server, Portal for ArcGIS, Data Store, Web Adapter) and manage federation across components.
  • Manage certificates across all components, including renewals on server, portal, and the web application firewall.
  • Administer licensing and named-user management and manage ArcGIS Pro client-side deployment.
  • Own upgrade strategy, planning, and execution, along with Web GIS topology design and governance.
  • Configure ArcGIS Monitor and own its alerting and operational runbooks.
  • Engage Esri Canada for support escalations and professional services.


Spatial Database Administration

  • Administer PostgreSQL/PostGIS on Azure Flexible Server: schema design, multi-schema permissions, versioning, indexing, performance tuning, and backup validation.
  • Administer Esri enterprise geodatabases (SDE) on PostgreSQL, including connection management, compression, and reconcile/post.
  • Own the h2Spatial database, including schema governance and ongoing consolidation of data from legacy sources.
  • Plan and execute data migrations, and troubleshoot queries under production load.
  • Assess and remediate data quality in inherited environments.
  • Coordinate with the software development team on database design decisions that affect product features.


Map Service Publishing & Governance

  • Publish and configure map services to ArcGIS Enterprise, and troubleshoot publishing and performance issues.
  • Define and maintain publishing standards for naming, metadata, sharing, and performance.
  • Manage content lifecycle to prevent service sprawl and maintain discoverability.
  • Make service-architecture decisions affecting client-facing products, in coordination with software development.

Education, Experience & Credentials
Required:

  • Degree in GIS, geomatics, computer science, or a related field, or equivalent professional experience.
  • 5+ years administering ArcGIS Enterprise (Server, Portal for ArcGIS, Data Store, Web Adapter), including installation, configuration, upgrades, federation, certificates, and licensing.
  • Strong PostgreSQL/PostGIS administration, including spatial data modeling, performance tuning, indexing, and backup validation.
  • Experience with Esri enterprise geodatabases (SDE) on PostgreSQL.
  • Experience publishing and troubleshooting map services in ArcGIS Enterprise.
  • Working knowledge of Microsoft Azure enough to operate GIS workloads and collaborate effectively with the infrastructure team.
  • Demonstrated ability to document technical systems and transfer knowledge to others.


Reliability, Security & Continuity

  • Own the disaster-recovery posture for the GIS tier, including backup validation and restore testing.
  • Support SOC 2 control alignment for the GIS platform.
  • Monitor platform health and respond to incidents affecting client-facing systems.
  • Collaborate with the Cloud & Infrastructure Lead on the Azure environment, networking, and security supporting the GIS platform.


Automation & Development (Growth Area)

  • Support the existing Python and FME automation that feeds the GIS platform and publishing.
  • With mentorship from the senior GIS developer, build hands-on capability in Python and FME workbench development.
  • Provide additional depth and backup to the GIS development team as capability grows.


Documentation & Enablement

  • Maintain authoritative documentation of platform configuration, architecture, and operating procedures, including the rationale behind key decisions.
  • Mentor and enable GIS analysts and adjacent technical staff.


Preferred:

  • Python for automation and integration, or a strong aptitude and willingness to learn it.
  • FME (FME Form/Desktop and FME Flow/Server).
  • ArcGIS Monitor and Azure Virtual Desktop (AVD).
  • Familiarity with security practices for hosted platforms web application firewalls, private endpoints, least-privilege access, and SOC 2.
  • Experience migrating or modernizing legacy or undocumented GIS environments.
  • Esri certifications.


Your Total Rewards:

Generous paid time off
Comprehensive health care plan
Company matching RRSP program
Annual performance bonus
Employee referral incentive
Flexible start/finish times


Apply Now:
If this role sounds exciting and you're ready to make an impact, we invite you to apply and join our dynamic team at H2Safety. As a valued member of our company, you'll have the opportunity to work alongside industry-leading experts, contribute to cutting-edge projects, and play a crucial role in enhancing the safety and efficiency of emergency response management.


Explore job opportunities at an organization leading the way in safeguarding people and the planet. We look forward to hearing from you!