Data Base Analyst

6 hours ago

Clark Freeport Zone, Philippines HiPaaS Inc Full time ₱660,000 - ₱780,000 per year

Overview

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.

Key Responsibilities

- Plan, script, and execute end-to-end data migrations (assessment, mapping, transformation, validation, reconciliation).

- Diagnose and resolve SQL and data integrity issues across multiple environments.

- Monitor PostgreSQL performance (indexes, vacuum/analyze cadence, execution plans) and implement tuning.

- Refactor and optimize complex SQL (CTEs, window functions, partitioning strategies).

- Build and maintain reporting queries and views aligned to business requirements.

- Implement data quality checks, profiling, and audit trails.

- Collaborate with product, engineering, and analytics teams to formalize data requirements.

- Identify schema and query optimization opportunities to reduce latency and resource usage.

- Contribute to documentation (data dictionaries, migration runbooks, performance playbooks).

Qualifications

- 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

- 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, Prometheus/Grafana).

- Basic knowledge of BI/reporting tools.

Core Competencies

- Attention to detail

- Systematic problem solving

- Performance mindset

- Cross-functional collaboration

- Continuous learning

Job Type: Fixed term

Contract length: 6 months

Pay: Php55, Php65,000.00 per month

  • Data & Trade Operations Analyst

    6 hours ago

    Clark Freeport Zone, Pampanga, Philippines MWC Group AG Full time ₱400,000 - ₱600,000 per year

    About the OpportunityWe're looking for two skilled and adaptable Data & Trade Operations Analysts to join our growing operations team in Clark, working directly with our Swiss headquarters and UK/EU-based subsidiaries. With a current team of 20+ professionals, this is a rare opportunity to join a dynamic international environment that values precision,...

  • BPO QA Analyst

    7 hours ago

    Clark Freeport Zone, Philippines ERC Global Full time ₱15,000 - ₱30,000 per year

    Job SummaryThe QA Analyst is responsible for assessing the agent's performance and proficiency when handling inquiries from customers. These interactions can through various channels (Voice, Chat, E-mail and /or social media), conduct sessions with associates and provide feedback addressing performance, product knowledge and Inbound and outbound call...

  • PH - Senior Financial Analyst

    5 hours ago

    Clark Freeport Zone, Philippines Aprio Full time ₱1,200,000 - ₱2,400,000 per year

    Work with a nationally ranked CPA and advisory firm that is passionate for what's next. Aprio has 30 U.S. office locations, one in the Philippines and more than 2,100 team members that speak 60+ languages across the globe. By bringing together proven expertise, deep understanding, and strategic foresight for fast-growing industries, Aprio ensures clients are...

  • Non-Destructive (NDR) Reports and Data Analyst

    1 week ago

    Clark Freeport Zone, Pampanga, Philippines Boomering inc Full time ₱45,000 - ₱55,000 per year

    Position Title: Non-Destructive (NDR) Reports and Data AnalystWork Set-up: Work From HomeSalary: Php 45,000.00 – Php 55,000.00Schedule: Monday - Friday, 2:00 PM – 11:00 PM PH Time | UK HolidaysOur client is a leader in structural repairs, boasting over 30 years of experience. Their dedicated team is committed to providing exceptional service to...

  • SOC Analyst

    2 weeks ago

    Clark Freeport Zone, Philippines ABACODE Full time ₱250,000 - ₱750,000 per year

    Clark, Pampanga, PhilippinesFull TimePhilippines - SecurityMid LevelAbout UsThrive is an innovative technology solutions provider focused on Cyber Security, Hybrid Cloud, Global Network Management, Disaster Recovery and traditional Managed Services. Our corporate culture, engineering talent, customer-centric approach, and focus upon NextGen services help us...

  • Analyst, Incident and Problem Management-1

    7 hours ago

    Clark Freeport Zone, Philippines Travel + Leisure Co. Full time ₱30,000 - ₱60,000 per year

    We Put the World on VacationTravel + Leisure Co. is the world's leading vacation ownership and travel membership company, with a dynamic and growing portfolio of resort, travel club, and lifestyle travel brands. Our dedicated associates help the company achieve its mission to put the world on vacation. Innovation and growth keep our work interesting and fun....

  • Event Management Analyst

    2 weeks ago

    Clark Freeport Zone, Philippines ABACODE Full time ₱250,000 - ₱500,000 per year

    Clark, Pampanga, PhilippinesFull TimePhilippines - Information TechnologyEntry LevelMUST WORK BELOW SHIFT -Wed - Fri and every other Sat, 7am-8pm, EST About UsThrive is a rapidly growing technology solutions provider focusing upon Cloud, Cyber Security, Networking, Disaster Recovery and Managed Services. Our corporate culture, engineering talent,...

  • Junior Onsite IT Support

    6 hours ago

    Clark Freeport Zone, Philippines Phil-Data Business Systems Inc. Full time ₱250,000 - ₱350,000 per year

    Junior Onsite IT Support is responsible in repairing, maintaining, and upgrading all hardware and equipment to ensure optimal workstation performance. The person will also troubleshoot problem in a timely and accurate fashion, and provide end-user assistance where required.Provide investigation, diagnosis, resolution and recovery for hardware/software...

  • IT Support

    5 hours ago

    Clark Freeport Zone, Philippines Phil-Data Business Systems Inc. Full time ₱200,000 - ₱300,000 per year

    IT Support is responsible in repairing, maintaining, and upgrading all hardware and equipment to ensure optimal workstation performance. The person will also troubleshoot problem in a timely and accurate fashion, and provide end-user assistance where required.Provide investigation, diagnosis, resolution and recovery for hardware/software problems. When...

  • Senior Financial Analyst

    5 hours ago

    Clark Freeport Zone, Pampanga, Philippines BMG Outsourcing Inc. Full time ₱900,000 - ₱1,200,000 per year

    Position: Admin Assistant (Up to ₱80K)Schedule: Monday to Friday, 7 AM – 4 PM (PH Time)Work setup: HybridStart and build your career with BMG Outsourcing – one of the well-respected Australian-owned Outsourcing Company with office in Clark and Sydney, providing high quality services to clients and promising career to its employees.We are seeking a...