Database Programmer - PostgreSQL Programmer

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

Job summary

A logistics solutions provider in Brampton is seeking an experienced Database Programmer to design and maintain robust database solutions. The ideal candidate must have expertise in PostgreSQL, advanced SQL skills, and experience in scripting and automation. This role offers a competitive salary and opportunities for career growth and a comprehensive healthcare benefits package.

Benefits

Competitive Salary

Healthcare Benefit Package

Career Growth

Qualifications

• 3+ years of hands-on experience with PostgreSQL database administration and development.
• Advanced SQL programming skills including complex queries, stored procedures, and functions.
• Strong analytical and problem-solving abilities.

Responsibilities

• Design and develop complex database schemas and stored procedures in PostgreSQL.
• Monitor database performance using PostgreSQL built-in tools.
• Implement comprehensive backup strategies using pg_dump and pg_basebackup.

Skills

PostgreSQL database management

SQL programming

Scripting (Bash, Python, Perl)

Database performance tuning

Backup and recovery operations

Education

Bachelor's degree in Computer Science

Tools

pgAdmin

Grafana

Docker

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 an experienced Database Programmer with specialized expertise in PostgreSQL database management, scripting, and optimization. The ideal candidate will be responsible for designing, implementing, and maintaining robust database solutions while ensuring optimal performance, security, and reliability of our data infrastructure.

Responsibilities:

Database Development & Programming

• Design and develop complex database schemas, stored procedures, functions, and triggers in PostgreSQL
• Write efficient SQL queries and optimize existing database code for improved performance
• Develop and maintain database applications using PostgreSQL-specific features and extensions
• Implement data validation rules, constraints, and business logic at the database level

Scripting & Automation

• Create and maintain shell scripts, Python scripts, or other automation tools for database operations
• Develop automated deployment scripts for database schema changes and updates
• Build monitoring scripts to track database performance metrics and health indicators
• Automate routine maintenance tasks including statistics updates and space management

Performance Monitoring & Optimization

• Monitor database performance using PostgreSQL built-in tools (pg_stat_*, pg_locks, etc.)
• Analyze query execution plans and identify performance bottlenecks
• Implement performance tuning strategies including query optimization and configuration adjustments
• Set up and maintain database monitoring solutions (e.g., pgAdmin, Grafana, or custom dashboards)
• Generate regular performance reports and capacity planning recommendations

Index Management & Optimization

• Design and implement appropriate indexing strategies for optimal query performance
• Analyze index usage patterns and identify redundant or unused indexes
• Reorganize and rebuild indexes to maintain optimal performance
• Monitor index fragmentation and implement maintenance schedules
• Create specialized indexes (partial, functional, GIN, GiST) based on application requirements

Backup & Recovery Operations

• Design and implement comprehensive backup strategies using pg_dump, pg_basebackup, and WAL archiving
• Schedule and monitor automated backup processes
• Test backup integrity and develop disaster recovery procedures
• Implement point-in-time recovery (PITR) solutions
• Maintain backup retention policies and archive management
• Document and test database recovery procedures

Database Administration

• Install, configure, and maintain PostgreSQL database servers
• Manage database security including user roles, permissions, and access controls
• Perform database upgrades and patch management
• Monitor database logs for errors, security issues, and performance problems
• Implement and maintain database replication and high availability solutions
  

Required Qualifications

• Technical Skills
• 3+ years of hands-on experience with PostgreSQL database administration and development
• Advanced SQL programming skills including complex queries, stored procedures, and functions
• Scripting expertise in one or more languages (Bash, Python, Perl, or PowerShell)
• Database monitoring tools experience (pgAdmin, pg_stat_monitor, or similar)
• Index management experience including analysis, creation, and optimization
• Backup and recovery expertise with PostgreSQL native tools and third-party solutions
• Core Competencies
• Strong understanding of PostgreSQL architecture, internals, and configuration
• Experience with database performance tuning and query optimization
• Knowledge of PostgreSQL extensions (PostGIS, pg_partman, etc.) is a plus
• Familiarity with cloud PostgreSQL services (AWS RDS, Google Cloud SQL, Azure Database)
• Understanding of database security best practices and compliance requirements
• Experience with version control systems (Git) for database schema management
• Soft Skills
• Strong analytical and problem-solving abilities
• Excellent communication skills for technical documentation and team collaboration
• Ability to work independently and manage multiple priorities
• Detail-oriented with strong attention to data accuracy and system reliability
• Proactive approach to identifying and resolving potential issues
• Preferred Qualifications
• Bachelor's degree in Computer Science, Information Technology, or related field
• PostgreSQL certification or equivalent professional credentials
• Experience with database migration projects and ETL processes
• Knowledge of containerization technologies (Docker, Kubernetes) for database deployment
• Familiarity with CI/CD pipelines for database deployments
• Experience with data warehousing and analytics platforms
• Understanding of database clustering and load balancing solutions

• Competitive Salary
• Healthcare Benefit Package
• Career Growth