Database Administrator

Unilab, Inc.; Mandaluyong; On-site; PHP 420,000 - 700,000; Full time

Job summary

Unilab, Inc. in Mandaluyong is seeking a backend data engineer to design and develop robust data structures and reporting solutions, ensuring readability, reliability, and performance.

The role emphasizes building scalable data pipelines using MS SQL Server and SSIS, with a focus on query optimization and data warehousing principles. The successful candidate will implement automation to streamline daily operations, troubleshoot data issues, and translate business requirements into technical

Qualifications

• Graduate in Computer Science or related field.
• Extensive experience developing data pipelines using MS SQL Server and SSIS.
• Strong experience in creating, reading, and troubleshooting complex SQL queries and stored procedures.
• Good understanding of data warehousing principles and best practices to design robust backend data structures for reporting and analytics.

Responsibilities

• Designs and develops efficient backend data structures and reporting solutions with readability, reliability, and performance as key standards.
• Recommends and implements database and development standards guided by best practices.
• Administers databases and reports applications including backups, performance tuning, and security patches.
• Ensures validity and accuracy of data during replacement or transfer processes.
• Performs monthly data tasks, monitors daily jobs, and informs data team of technical issues.
• Troubleshoots reporting and data issues and proposes long-term solutions.
• Implements automation to support daily data operations.
• Translates business requirements into technical designs and vice-versa.
• Produces technical, functional, and operational documentation and root-cause analyses.

Skills

SQL

Data pipeline development

Troubleshooting

Education

Bachelor's degree in Computer Science or related field

Tools

MS SQL Server

SSIS

Job description

Job Description

Role Overview

• Designs and develops efficient backend data structure and reports solutions, ensuring that the solution meets data team standards for readability, reliability, and performance.
• Recommends and implements database and development standards guided by the technology's best practices.
• Administers databases and reports applications including, but not limited to, backup and recovery, performance tuning, query optimization, troubleshooting, security and installation of patches and upgrades.
• Ensures validity and accuracy of a data set or all data contained in a database each time data is replacated or transferred.
• Ensures timely update of data and reports by performing monthly data tasks, monitoring daily jobs and sending advisory to data team and concerned department for any technical issue.
• Troubleshoots both reporting solutions and data issues and provides inputs/recommendations for long term solutions to technical problems.
• Implements automation that will help data team in their daily operations.
• Gathers business requirements and translates it into technical design and vise-versa.
• Creates and updates technical, functional and operational documentations. Provides incident and root cause analysis reports for critical issues
• Provides ad-hoc data requests from business and other departments.

Qualifications

• Graduate of Computer Science or related field
• Extensive experience developing data pipelines using MS SQL Server and SSIS
• Strong experience in creating, reading, and troubleshooting complex SQL queries and stored procedures
• Good understanding of data warehousing principles and best practices, with the ability to design a robust backend data structure to support reporting and analytics