PostgreSQL DBA / Data Engineer

DataArtha Solutions; Ernakulam; Híbrido; INR 1.800.000 - 2.800.000; Jornada completa

Descripción de la vacante

DataArtha Solutions in Kochi (hybrid) seeks an experienced PostgreSQL/Data Platform Engineer to own database schema design, migrations, backup and failover testing. The role emphasizes production PostgreSQL, data engineering and performance tuning in a hybrid setup.

You will review models, optimize indexes, monitor capacity, and ensure safe migrations with zero/low-downtime changes while supporting incident response and data correction.

Formación

• Advanced PostgreSQL administration and SQL optimisation.
• Migration safety, rollback/forward-fix and release sequencing.
• Backup, PITR and disaster-recovery testing.
• Data security, masking and operational troubleshooting.

Responsabilidades

• Review logical/physical models, constraints, keys and tenant-aware indexing.
• Govern Flyway migration safety and release sequencing.
• Monitor queries, locks, connections, storage and capacity.
• Tune SQL, indexes and database configuration from measured evidence.
• Own backup, PITR, restore and Multi-AZ failover testing.

Conocimientos

PostgreSQL administration

SQL optimisation

Amazon RDS operations

Migration safety & rollback

Monitoring & capacity planning

Backups & PITR testing

Data security & masking

Herramientas

Flyway

Amazon RDS

Descripción del empleo

Protect the integrity, performance and recoverability of the Pulse system of record. Guide schema design, migration safety, indexing, monitoring, backup and data lifecycle practices for PostgreSQL on Amazon RDS.

Data Platform India - Kochi preferred / hybrid 6-10 years with production PostgreSQL and data engineering Full-time

Reports To Solution Architect / Engineering Manager

Experience 6-10 years with production PostgreSQL and data engineering

Employment Full-time

Direct Reports None initially

What you'll do and what you'll bring

Key Responsibilities

• Review logical/physical models, constraints, keys and tenant-aware indexing
• Govern Flyway migration safety, rollback/forward-fix and release sequencing
• Monitor queries, locks, connections, storage, vacuum and capacity
• Tune SQL, indexes and database configuration from measured evidence
• Own backup, PITR, restore and Multi-AZ failover testing
• Define retention, archival, masking and non-production data controls
• Support incidents, data correction and root-cause analysis
• Prepare reporting/read-scaling evolution without premature complexity

Essential Qualifications & Skills

• Advanced PostgreSQL administration and SQL optimisation
• Amazon RDS operations, monitoring and recovery
• Indexing, execution plans, locks and transaction isolation
• Schema migration and zero/low-downtime data change
• Backup, restore, PITR and disaster-recovery testing
• Data security, masking and operational troubleshooting

First Six Months

Expected outcomes

• Approve core schema and migration standards
• Baseline database metrics and slow-query process
• Complete restore and failover exercises
• Verify capacity for launch and Year-1 growth
• Document data correction and incident procedures

Accountability

Success measures

• Query latency and database saturation
• Migration success
• Recovery-point/recovery-time compliance
• Data-integrity incidents

Good to Have

Preferred qualifications and behavioural fit

Preferred Qualifications

• Spring/JPA query behaviour Data warehouse/ETL fundamentals High-volume order or inventory databases

Behavioural Competencies

• Precision Risk awareness Evidence-based tuning Calm incident ownership

Working Context

What to expect if you join

The role works in a cross-functional, documentation-first and architecture-led product environment. Candidates must be comfortable with hands-on ownership, transparent decisions, code/design review, automated quality controls and production accountability. The six-month MVP excludes unnecessary microservices, Kubernetes, speculative AI and other scope not approved through product governance.

Final compensation, work arrangement and joining date will be confirmed during the recruitment process. DataArtha Solutions is committed to fair, respectful and merit-based selection.