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 (pgstat*, 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
