Application Support Engineer

Role Overview

Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems. We are looking for an experienced PostgreSQL Database Administrator/Engineer with 4+ years of hands-on experience in PostgreSQL database administration, performance tuning, cloud deployments, backup & recovery, and high availability solutions.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases in production and non-production environments.
• Manage PostgreSQL databases on cloud platforms like AWS RDS/Aurora, Azure Database for PostgreSQL, or Google Cloud SQL.
• Monitor database health, performance, availability, and security.
• Perform query optimization, indexing, vacuum tuning, and performance troubleshooting.
• Implement backup, recovery, replication, and disaster recovery strategies.
• Configure and manage High Availability (HA) and failover solutions.
• Handle database migrations from on-premise to cloud environments.
• Automate database administration tasks using Shell scripting, Python, or Ansible/Terraform.
• Work closely with DevOps, application, and infrastructure teams.
• Ensure database security, access control, and compliance standards.
• Troubleshoot production incidents and provide root cause analysis.

Requirements

• Minimum 3 years of experience in PostgreSQL Administration.
• Expertise in PostgreSQL architecture, replication, partitioning, and performance tuning.
• Experience with cloud database services: Amazon Web Services RDS/Aurora, Microsoft Azure, or Google Cloud Platform.
• Knowledge of HA technologies like Patroni, PgBouncer, Pgpool-II, or streaming replication.
• Experience with backup/recovery tools such as pgBackRest, Barman, or WAL-G.
• Strong SQL and PL/pgSQL skills.
• Scripting knowledge in Bash, Python, or Shell scripting.
• 15 years full time education.

Skills

• PostgreSQL
• AWS
• Python
• SQL
• Shell scripting