Application Support Engineer

Project Role : Application Support Engineer

Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.

Must have skills : PostgreSQL Administration

Good to have skills : NA

Minimum 2 Year(s) Of Experience Is Required

Educational Qualification : 15 years full time education

Summary:

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. The ideal candidate should have strong expertise in cloud platforms such as AWS, Azure, or GCP and experience managing production-grade PostgreSQL environments.

Roles & Responsibilities:

Install, configure, upgrade, and maintain PostgreSQL databases in production and non-production environments.

Manage PostgreSQL databases on cloud platforms like AWS RDS/Aurora PostgreSQL, 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.

Professional & Technical Skills:

Strong experience with PostgreSQL administration (4+ years).

Expertise in PostgreSQL architecture, replication, partitioning, and performance tuning.

Experience with cloud database services:

Amazon Web Services RDS/Aurora PostgreSQL

Microsoft Azure PostgreSQL

Google Cloud Platform Cloud SQL

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

Additional Information:

• The candidate should have minimum 2 years of experience in PostgreSQL Administration.
• This position is based at our Gurugram office.
• A 15 years full time education is required.