Job Title: PostgreSQL Database Administrator (DBA)
Location: Toronto, ON (Hybrid)
Duration: 06 Months (High Possibility of Extension)
Job Summary:
We are seeking an experienced PostgreSQL Database Administrator (DBA) to design, manage, and optimize PostgreSQL database platforms. The role involves database administration, data modeling, performance tuning, backup and recovery, schema design, and database lifecycle management. The ideal candidate will have strong PostgreSQL expertise, experience with specification-driven development practices, and the ability to support secure, scalable, and highly available database environments.
Key Responsibilities:
- Design conceptual, logical, and physical data models based on business requirements.
- Develop and maintain PostgreSQL schemas, tables, indexes, views, functions, and database objects.
- Perform PostgreSQL administration including installation, configuration, patching, upgrades, and maintenance.
- Manage database backup, recovery, disaster recovery, and point-in-time recovery strategies.
- Monitor and optimize database performance through query tuning, indexing, and capacity planning.
- Create and manage database migration plans with rollback and validation procedures.
- Translate business and technical requirements into version-controlled database specifications.
- Develop and review SQL, PL/pgSQL, DDL, DML, and migration scripts.
- Participate in incident management, troubleshooting, root-cause analysis, and production support.
- Implement database security controls including authentication, authorization, encryption, auditing, and access management.
- Maintain database documentation, standards, and compliance requirements.
- Support CI/CD integration, database testing, schema validation, and deployment processes.
Required Skills:
- 5+ years of hands-on PostgreSQL Administration experience.
- Strong expertise in PostgreSQL performance tuning and optimization.
- Experience with data modeling and database design.
- Strong proficiency in SQL and PL/pgSQL.
- Experience with backup, recovery, replication, and disaster recovery.
- Knowledge of database migration and version control practices.
- Experience with incident response, troubleshooting, and root-cause analysis.
- Familiarity with Specification-Driven Development methodologies.
Preferred Skills:
- Experience with AWS RDS PostgreSQL or Azure Database for PostgreSQL.
- Knowledge of high-availability and replication solutions.
- Experience with database migration/versioning tools (Flyway, Liquibase, etc.).
- Exposure to Docker, Kubernetes, and Infrastructure as Code (IaC).
- Experience with AI-assisted development tools.
- PostgreSQL or cloud database certifications are a plus.
Education:
- Bachelor's degree in Computer Science, Information Technology, Engineering, or equivalent practical experience.