About the Role

We are looking for an experienced Senior Database Engineer (PostgreSQL) to design, implement, optimize, and maintain high-performance PostgreSQL databases for enterprise-scale applications. The ideal candidate should have solid expertise in database architecture, performance tuning, replication, backup strategies, high availability, security, and cloud-hosted PostgreSQL environments.

The role requires close collaboration with software architects, backend developers, DevOps engineers, and infrastructure teams to ensure reliable, scalable, and secure database systems.

Key Responsibilities

· Design, develop, and maintain PostgreSQL databases for enterprise applications.

· Optimize database performance through indexing, query optimization, execution plan analysis, and schema tuning.

· Design scalable database schemas following best practices.

· Monitor database health, performance, and availability.

· Configure and manage PostgreSQL replication (Streaming Replication, Logical Replication).

· Implement High Availability (HA) and Disaster Recovery (DR) solutions.

· Plan and execute database backup and recovery strategies.

· Perform database migrations and upgrades with minimal downtime.

· Troubleshoot production database issues and perform root cause analysis.

· Implement database security, encryption, user roles, and access controls.

· Automate database administration tasks using scripts and monitoring tools.

· Collaborate with development teams to improve SQL performance.

· Review database designs during software architecture discussions.

· Create and maintain database documentation and operational runbooks.

· Support production deployments and database releases.

· Participate in on-call production support when required.

Required SkillsPostgreSQL





· PostgreSQL Administration (v13 preferred)

· Query Optimization

· Index Optimization

· Execution Plan Analysis (EXPLAIN / EXPLAIN ANALYZE)

· Table Partitioning

· Materialized Views

· Functions & Stored Procedures (PL/pgSQL)

· Triggers

· CTEs & Window Functions

· JSON / JSONB

· Full Text Search

· Foreign Data Wrapper (FDW)

Database Administration

· Database Backup & Restore

· Point-in-Time Recovery (PITR)

· WAL Management

· Replication

· Failover

· High Availability

· Disaster Recovery

· Connection Pooling (PgBouncer)

· Vacuum & Autovacuum Tuning

Performance Tuning

· Slow Query Analysis

· Lock Monitoring

· Deadlock Analysis

· Index Maintenance

· Statistics Management

· Memory Configuration

· Connection Optimization

· Capacity Planning

Cloud & Infrastructure

· PostgreSQL on Linux

· AWS RDS PostgreSQL

Monitoring Tools

· pgAdmin

· aws cloudwatch

Desired Skills

· Experience with PostgreSQL clusters handling millions of records.

Qualifications

· Bachelor’s degree in Computer Science, Information Technology, or related field.

Preferred Experience

· 6–10 years in database administration.

· Minimum 4 years of hands-on PostgreSQL experience.

· Experience supporting production databases with high availability.

· Experience managing databases larger than 1 TB is preferred.

· Experience working in Agile/Scrum environments.

Soft Skills

· Strong analytical and troubleshooting skills.

· Excellent communication and documentation abilities.

· Ability to mentor junior database engineers.

· Strong ownership and accountability.

· Ability to work under pressure during production incidents.

Pay: From ₹50,000.00 per month

Benefits

- Cell phone reimbursement
- Paid sick time
- Provident Fund

Work Location: In person

📌 Senior Database Engineer (PostgreSQL) (Kozhikode)
🏢 Alhind Tours and Travels
📍 Kozhikode