Galent
Role: Senior PostgreSQL System Administrator
Location: Markham, Canada
Mode: Hybrid, need to visit office mandatorily for 3 days
Job Summary:
We are seeking an experienced and highly skilled Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will be responsible for database performance, optimization, scalability, and security across mission-critical systems. You will also mentor junior DBAs and support architectural decisions to ensure high availability and business continuity.
Key Responsibilities:
- Lead the installation, configuration, and administration of PostgreSQL database servers across production and non-production environments.
- Design and implement high availability (HA), disaster recovery (DR), and replication solutions.
- Monitor and analyze database performance, identify bottlenecks, and fine-tune SQL queries and database configurations.
- Perform database upgrades, patching, and migrations with minimal downtime.
- Implement robust backup and recovery strategies using tools like pgBackRest, Barman, etc.
- Ensure database security through access controls, auditing, and encryption.
- Automate routine database tasks using shell scripting or Ansible.
- Collaborate with development, infrastructure, and DevOps teams to design scalable database architectures.
- Document procedures, standards, and best practices for database management.
- Provide mentorship to junior DBAs and act as an SME for PostgreSQL in cross-functional teams.
- Support on-call rotation and handle critical incidents as needed.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, Engineering, or a related field.
- 5-7 years of PostgreSQL DBA with MongoDb experience in production environments.
- Deep understanding of PostgreSQL internals, architecture, and advanced features.
- Versions: PostgreSQL V14
- Proven experience with streaming/logical replication and clustering.
- Expertise in performance tuning, query optimization, and index strategy.
- Strong experience with backup and recovery tools and strategies.
- Advanced knowledge of Linux/Unix systems and scripting (Bash, Python preferred).
- Familiarity with monitoring tools like Prometheus, Grafana, or Zabbix.
- Experience managing PostgreSQL on cloud platforms (AWS RDS, GCP Cloud SQL, Azure).
Preferred/Good to Have:
- Experience with containerization and orchestration tools (Docker, Kubernetes).
- Knowledge of other database technologies (MySQL, Oracle, or NoSQL solutions).
- Exposure to CI/CD pipelines and DevOps practices.
- Experience with Infrastructure as Code (IaC) using Ansible, Terraform, etc.
Soft Skills:
- Excellent problem-solving, analytical, and troubleshooting skills.
- Strong communication and documentation abilities.
- Leadership and mentoring capabilities.
- Proactive mindset with a focus on process improvements and automation.
