Database Architect Expert - Albany, United States - PSI International

Description

HBITS Database Architect

Expert


Agency Name:
Information Technology Services (ITS)

Is this a Project/Program specific Position?

Yes

If YES, list the Project/

Program Name:
Enterprise Data Warehouse and various Health Cluster projects within the agency.

provide a short description of the Position:

Data warehouse database and ETL(Extract, Transform, Load) process redesign and implementation.

Provide a list of the day to day tasks to be performed by the

Selected Candidate:

Design and implement an Enterprise Data Warehouse solution using the Kimball methodology of data warehouse Star schema and dimensional data modeling.

Implement and maintain Fine Grain Access Control Audit (FGACA) and Oracle Virtual Private Database(VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).

Guide the ETL team in shaping the ETL architecture and must be able to resolve difficult design and build issues.

Expert level experience with the Informatica toolset is required to develop and maintain current and future data marts.

Extract and Analyze data from numerous heterogenous patient and staffing data systems, used for the design, implementation and maintenance of complex reporting data marts.

Liaison between technical staff, non-technical staff and business clients to gather business requirements needed to build and implement complex data warehouse database structures.

Identify, troubleshoot, and resolve difficult data warehouse technical issues, including Production break/fix problems.

Number of Form 2 Candidate Responses allowed per Contractor, per Position?

1


Target Start Date:
Engagement Length in Months: 30. 0

Is this a Full or Part-Time Position?

(Full-Time is 40 Hours Per Week)

Full Time

If Part-Time, enter approximate number of hours per Week:

What are the daily work hours?

(Note if negotiable or list preferred start and end time):

Between 8:00 AM

9:00 AM and 4:30 PM- 5:30 PM with 1D2 hour for lunch

Where is the physical work office located?

800 North Pearl Street, Menands, NY, 12204

Is telecommuting allowed for this position?

(As designated by the Authorized User)

Yes

If YES, note if negotiable or list the percentage allowed/number of days allowed per week

50%

What is the format of the Candidate interview?

Webcasting

If Webcasting, is Candidate required to be on camera?

Yes

What type of software is typically used by the Agency?

Oracle; Informatica; SQL Server; IDERA

What type of hardware is typically used by the Agency? Client UNIX

Position Mandatory Qualification


Position Job Title:
Database Architect

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

OGS HBITS Determination


Position Skill Level:
Expert

84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Position Requested Qualifications

1.

84 months of experience designing and implementing Enterprise Data warehouse architecture solutions using the Kimball methodology of dimensional modeling.

2.

84 months of experience designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment.

3.

84 months of experience in collaborating with ETL (Extract, Transform, Load) developers as a team lead in designing Informatica ETL process and data warehouse database architecture.

4.

84 months of experience working with non-technical and business clients to gather, analyze, and

5.

84 months of experience analyzing, interpreting, and outputting patient mental health data from numerous heterogenous systems including pharmacy, Medicaid, incident, patient movement, and human resource systems.

6.

84 months of experience in relational data management disciplines and design and development experience using Oracle technologies.

7.

Bachelor's Degree

6


Additional Information Requests:
Are there additional security requirements for the Authorized User?

Yes

If YES, include the additional security requirements:

Mandatory ITS Security Agreements and Fingerprint-based Background Check.

Will additional training potentially be required during the Engagement? Yes

#J-18808-Ljbffr