Senior System Administrator

Job Summary

We are seeking an experienced and highly skilled Senior Postgre

SQL System Administrator with 5 to 7 years of hands‑on experience managing large‑scale Postgre

SQL environments. The ideal candidate will be responsible for database performance, optimization, scalability, and security across mission‑critical systems, mentor junior DBAs, and support architectural decisions to ensure high availability and business continuity.

• Lead the installation, configuration, and administration of Postgre
  
  SQL 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 Dev Ops 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 Postgre
  
  SQL in cross‑functional teams.
• Support on‑call rotation and handle critical incidents as needed.

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 5–7 years of Postgre
  
  SQL DBA experience in production environments.
• Deep understanding of Postgre
  
  SQL internals, architecture, and advanced features.
• Experience with Postgre
  
  SQL 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 Postgre
  
  SQL on cloud platforms (AWS RDS, GCP Cloud SQL, Azure).

• Experience with containerization and orchestration tools (Docker, Kubernetes).
• Knowledge of other database technologies (MySQL, Oracle, or No
  
  SQL solutions).
• Exposure to CI/CD pipelines and Dev Ops practices.
• Experience with Infrastructure as Code (IaC) using Ansible, Terraform, etc.

• 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.