Database Engineer

solaireresort; Parañaque; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

solaireresort is seeking a Database Engineer to manage and optimize large-scale database systems with Microsoft SQL, MySQL, Oracle, and PostgreSQL across on‑premises and cloud environments. You will lead capacity planning, performance tuning, and incident resolution for critical systems in a 24/7 setting.

The role requires 5+ years of experience with high-availability deployments, migrations to newer versions, backups, DR planning, and strong SQL optimization skills.

Qualifications

• At least five years of career experience handling hundreds of servers and databases in a 24/7 environment.
• Successful migrations of databases to newer versions and implementation of high-availability solutions.
• Experience with cloud databases (GCP, AWS, Azure) and DR/BCP configurations.
• Strong performance optimization, indexing, and disk space optimization for DB systems.

Responsibilities

• Setups, maintenance, and monitoring of high availability of database servers.
• Collaborate with production support to set up testing environments, review test plans and investigate issues.
• Provide capacity planning of database server hardware resources.
• Ensure all server issues are addressed within a service level agreement (SLA).
• Suggests and implements process and systems improvement.
• Work closely with the network team on company security policy.
• Create and monitor backup strategy and patch management on database servers.
• Daily monitor system logs and perform root cause analysis of errors.

Skills

SQL Always-On

MySQL InnoDB

Oracle RAC

PostgreSQL PostgreHA

DB2

MongoDB

Cloud DB

BCP/DR

Performance monitoring

Index tuning

Database migration

Virtualization

Tools

MSSQL

MySQL

Oracle

PostgreSQL

MongoDB

Job description

POSITION SUMMARY

The Database Engineer is responsible for providing day-to-day management, capacity planning, performance optimization, incident resolution, and overall support for database systems, including systems running on the platform. This position is an escalation point for critical core gaming systems and related outages. Provides assistance and monitoring across all IT projects using or interfacing with MSSQL, MySQL, Oracle, PostgreSQL, DB2 and MongoDB and ensures that the outcomes of work are delivering the most effective and robust way to run business applications.

DUTIES AND RESPONSIBILITIES

• Setups, maintenance, and monitoring of high availability of database servers
• Closely work with the production support team in setting up testing environments, review test plans and test cases, and investigate technical issues raised
• Provide capacity planning of database server hardware resources
• Ensure all server issues are addressed within a service level agreement (SLA)
• Suggests and implements process and systems improvement
• Work closely with the network team on company security policy
• Creates and monitors backup strategy
• Provides patch management on database servers
• Daily monitors system logs and provides root cause analysis of errors

Requirements

QUALIFICATIONS AND REQUIREMENTS

At least five (5) years of career experience handling hundreds of servers and databases in a 24/7 environment. Successful implementation of infrastructure roll-out, upgrades, administration, and decommissioning with relation to databases. Demonstrated migrations of databases to newer versions. Successfully implemented different high-availability solutions, business continuity, and disaster recovery. Strong and proven competencies on Microsoft SQL (Always-On), MySQL (InnoDB Cluster, Master-Slave replication), Oracle (RAC, Dataguard) and PostgreSQL (PostgreHA). Strong experience in performance monitoring, database optimization, and index tuning Experience in other databases such as DB2 and MongoDB is a plus. Experience and exposure in different Cloud Database technologies (GCP, AWS and Azure). Experience in BCP/DR configuration and monitoring including backup and recovery scenarios Adequate exposure in Data Warehousing, Stored Procedure optimization, SQL Server optimization, and disk space optimization for performance (RAID and SAN) Experience with Virtualization Technologies is preferred.