Job Description :
DirectClient: Texas Department of Health and Human Services Commission(HHSC)
Solicitation
Title: Oracle Database Administrator
Location: Austin, Texas 78751
Duration: Until August 31, 2018 with possible extension
Last date for submission: September 22, 2017(2.00 PM-CST)
Job Description:
The Enterprise Data Governance (EDG) Database Administrator position will be a part of the System Information and Asset Management (SIAM) team which is part of the Health and Human Services Commission''s (HHSC) Information Technology team. The SIAM team works closely with the Center for Analytics and Decision Support (CADS) team to support the Health and Human Services data analytics strategy.
The EDG Database Administrator:
Is responsible for performance and/or oversight of system administration of Master Data Management (MDM) production, test and development servers which utilize an Informatica application tool stack.
Has an excellent understanding of MDM principles and tools.
Works collaboratively with CADS staff and HHSC Information Technology team members to implement new program requirements for master data, identity resolution, and reference data.
The applicant will be able to demonstrate extensive experience in:
Enterprise level database server setup and ability to create/configure/maintain databases in Oracle 12c
Enterprise level application upgrades, production rollouts, code reviews, and working with developers in debugging of Informatica stack application related issues
Implementation of Oracle high availability technologies (e.g. RAC, DataGuard, Golden Gate)
Patching & upgrading of Oracle homes and databases
Configuring database backup and recovery (using RMAN, etc
Planning/developing/testing and implementing database backup procedures
Designing and implementing database maintenance plans and disaster recovery plans
Performance tuning of databases and database queries
Usage of Oracle Identity and Access Management for managing and maintaining enterprise users and their roles/privileges
Logical and physical data modeling of MDM databases (using ER Studio)
Data acquisition, movement, and transformation (using Oracle and Informatica tools)
Understanding of HIPAA compliance policies and HHS security requirements
Working with Oracle and/or Informatica support to resolve any critical issues or bugs encountered during database and application upgrades
Database Administrator, HHS Enterprise Data Governance
II. WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
8 Experience working as an Oracle Database Administrator
8 Experience configuring database backup and recovery
8 Experience planning, developing, testing and implementing database backup procedures
5 Experience using Oracle identity and access management
Preferences:
Years Skills/Experience
4 Experience and understanding of Enterprise Information Management best practices
2 Experience working as an Oracle 12c DBA
4 Experience in MDM program implementation, particularly using Informatica suite tools
Strong Communication, analytical and interpersonal skills at all levels
Degree Bachelor''s degree in Computer Science, Systems Engineering or equivalent experience