Senior PostgreSQL DBA & Data Migration Specialist

Hipaas Infotech; Angeles; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

Hipaas Infotech is seeking a Database Analyst to lead data migrations between enterprise applications and optimize PostgreSQL workloads. The role emphasizes data quality, performance tuning, reporting, and cross‑team collaboration.

Requirements include 5+ years in related roles, advanced PostgreSQL expertise, strong SQL skills, and experience with ETL tooling and version control for migrations.

Qualifications

• 5+ years in a Database Analyst, DBA, or Data Engineer role.
• Advanced PostgreSQL expertise (query planning, indexing, locking, transactions, extensions).
• Strong SQL (window functions, CTEs, set-based operations, performance tuning).
• Experience with data migration tooling (custom ETL scripts, psql, pg_dump/pg_restore, logical replication).
• Proven troubleshooting using EXPLAIN / EXPLAIN ANALYZE and pg_stat_* views.
• Strong analytical and communication skills; able to translate requirements into efficient queries.
• Experience with version control and change management for schema and migration scripts.
• Knowledge of data protection and privacy best practices.

Responsibilities

• Lead structured data migrations between enterprise applications.
• Optimize PostgreSQL workloads and ensure data quality.
• Focus on reporting and performance tuning; collaborate with cross‑team partners.
• Translate requirements into efficient queries and provide actionable insights.

Skills

Strong SQL

Analytical thinking

Communication skills

Data privacy knowledge

Scripting (Python or Bash)

Tools

psql

pg_dump/pg_restore

logical replication

version control

Job description

Hipaas Infotech is seeking a Database Analyst to lead data migrations between enterprise applications and optimize PostgreSQL workloads. The role emphasizes data quality, performance tuning, reporting, and cross‑team collaboration.

Requirements include 5+ years in related roles, advanced PostgreSQL expertise, strong SQL skills, and experience with ETL tooling and version control for migrations.