Database Analyst DBA

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

Location: Manila , Philippines ; Clark, Philippines

Type - Contract

Duration - 12+ Month

Email Resume - ••••@hipaas.com

Job Description

Seeking a Database Analyst to lead structured data migrations between enterprise applications and optimize PostgreSQL workloads. Role focuses on data quality, performance tuning, reporting, and cross-team collaboration.

• 5+ years in a Database Analyst, DBA, or Data Engineer role.
• Advanced PostgreSQL expertise (query planning, indexing strategies, locking behavior, 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.
• Preferred

Job Qualifications

• Experience with scripting (Python or Bash) for automation.
• Exposure to cloud-hosted PostgreSQL (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).
• Familiarity with performance monitoring tools (pg_stat_statements, pgBadger,