PostgreSQL Database Administrator

Charger Logistics Inc; Brampton; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player seeks a skilled PostgreSQL Database Administrator to join their dynamic team. In this role, you will manage and maintain PostgreSQL databases, ensuring high performance, availability, and security. You will collaborate closely with the IT Development team to support product development and scalability. This is an exciting opportunity to work in a fast-paced environment where your expertise will directly contribute to the success of logistics solutions across North America. If you are passionate about database management and eager to grow your career, this position is perfect for you.

Benefits

Competitive Salary

Healthcare Benefit Package

Career Growth

Qualifications

• 3+ years of experience as a PostgreSQL DBA in a production environment.
• Strong understanding of database architecture and high-availability setups.

Responsibilities

• Install, configure, and maintain PostgreSQL database systems.
• Monitor performance and implement changes for scalability and reliability.
• Automate routine DBA tasks and ensure data integrity across systems.

Skills

PostgreSQL Administration

SQL Query Optimization

Database Backup and Recovery

Performance Tuning

Cloud Deployments

Linux Operating Systems

Education

Bachelor’s degree in Computer Science

Tools

pgBackRest

Prometheus

Grafana

Docker

Kubernetes

Job description

Charger logistics Inc. is a world- class asset-based carrier with locations across North America. With over 20 years of experience providing the best logistics solutions, Charger logistics has transformed into a world-class transport provider and continue to grow.

We are seeking a skilled and proactive PostgreSQL Database Administrator (DBA) to manage and maintain our PostgreSQL databases. The ideal candidate will be responsible for ensuring high performance, availability, and security of our database systems, and will work closely with IT Development team to support product development and scalability.

Responsibilities:

• Install, configure, and maintain PostgreSQL database systems in production and development environments.
• Monitor database performance and implement changes to improve performance, scalability, and reliability.
• Create and manage database objects such as schemas, tables, indexes, views, triggers, and stored procedures.
• Perform regular database backups and recovery testing; ensure disaster recovery procedures are in place.
• Implement and enforce security best practices to safeguard sensitive data.
• Conduct performance tuning, optimization, and query analysis.
• Automate routine DBA tasks using tools and scripts.
• Collaborate with software engineers to design database schemas and support deployment pipelines.
• Ensure data integrity and consistency across distributed systems.
• Stay up to date with PostgreSQL updates and apply patches as required.

Must-Have Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Proven experience as a PostgreSQL DBA in a production environment (3+ years preferred).
• Strong understanding of database architecture, replication, and high-availability setups.
• Proficiency in writing complex SQL queries and optimizing performance.
• Experience with backup/recovery tools (e.g., pgBackRest, Barman).
• Knowledge of database monitoring tools (e.g., pg_stat_statements, Prometheus + Grafana).
• Familiarity with cloud-based deployments (AWS RDS/Aurora, GCP Cloud SQL, etc.).
• Working knowledge of Linux-based operating systems and shell scripting.

Nice-to-Have Skills:

• PostgreSQL certification (e.g., EDB Certified PostgreSQL DBA) is a plus.
• Experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB).
• Exposure to containerized environments (Docker, Kubernetes).
• Familiarity with CI/CD tools and DevOps practices.
• Experience with other RDBMS or NoSQL databases.

• Competitive Salary
• Healthcare Benefit Package
• Career Growth