PROJECT/S FOR IMPLEMENTATION

The SQL DBA/Developer will be responsible for the database design and development of ETL that will support the data needed for the dashboards of Mount Grace Hospitals, Inc. (MGHI). The role requires solid experience in data warehousing design and data integration and processing using MS SQL platform.

SCOPE OF WORK

• He/she will be assigned for MGHI Dashboard project only, with the following deliverables:

• Design data warehouse adhering to best practices that will support the data dashboard requirements.
• Develop sustainable and flexible ETL solution using MS SQL SSIS tool.
• Provide data sources for Tableau dashboard.
• QA and unit testing of ETL and data processing.
• Document work through code comments, specifications documents, and other relevant knowledge transfer documents.
• Conduct knowledge transfer sessions for transition to support.

DURATION

3 months

EDUCATIONAL BACKGROUND

þ Computer Science/ Information Technology

þ Engineering (ME, IE, ECE, EE, COE)

 Others: (Specify)      

JOB REQUIREMENTS (Experience, Skills, Certification, Licensure etc.)

Bachelor’s degree in computer science or a related field.

Extensive data warehouse engineering experience.

Strong SQL experience across Microsoft SQL BI Tool (SQL DB and SSIS)

At least 4years solid experience using MS SQL (preferably MSSQL 2012/2017 or later version)

In depth knowledge T-SQL, data management and data processing.

Strong analytical and problem-solving skill with attention to details and structured approach to testing.

SQL-DBA Developer