Database Administrator Iv Jobs

Works under the general supervision of the Regulatory LTC Application Manager or their designee. This position is responsible for leading complex technical database activities for the information systems supporting the HHSC Division of regulatory Services. Provides support in the development and maintenance of data warehouse and reporting systems. Develops, tests, debugs and documents highly complex program code to implement functional and design requirements for reporting systems in the agency. Participates in code walk-thrus. Assists in the development and maintenance of system documentation. Works with other members of the development team and end-users. Develops and maintains expertise in a variety of programming and database management tools. Develops technical and user documentation and supports training as required.

Essential Job Functions:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

1. Evaluates users' requests for new data elements and systems and incorporates into the existing shared data environment. Coordinates use of data to ensure data integrity and control redundancy. Loads databases and reorganizes as needed. Performs data modeling and prototyping.

Install and use Data Modeling tools like Erwin, Sql developer data modeler etc

Develop logical and physical Data Models and Entity Relationship Diagrams

Implement database objects in a Oracle RDBMS.

Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases.

Generate scripts to be in the database using data modeler tools

Incorporating changes to data model design

Write source to target mapping instructions as needed to support ETL development

Develop stored procedures, database triggers and complex PL/SQL packages where needed.

Perform requirement analysis and provide data mapping guidance to application and development teams.

PL/SQL skills

2. Analyzes, designs, and implements databases. Determines and implements database search strategies. Determines database storage requirements. Develops and maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. Establishes and controls necessary database security.

Evaluate the database server Hardware

Install database and grid software

Plan database for logical structure, overall database design and backup, restore strategy

Database performance analysis

Implement ASM for database storage or filesystem based database strategy

Follow database naming conventions per guidelines

If needed implement Oracle advanced security and Oracle database Vault

Database security solutions to ensure data privacy, protect against insider threats, and enable regulatory compliance

Implement oracle identity management to secure critical applications and sensitive data, lower operational costs, and comply with regulatory requirements.

- Directs the design, analysis and development of backup and recovery systems by working with the customer for support and implementation of more complex databases and environments. Serves as primary contact for vendors and system architects to represent customer requirements. Creates documentation for backup and recovery. Defines database validation requirements to ensure database integrity -Develops a plan and directs implementation of database security infrastructure that coincides with policy requirements, Makes recommendations for security best practices

3. Designs, codes and modifies complex computer programs, subroutines, triggers, stored procedures, objects, classes and scripts to maintain reporting systems. Performs necessary testing of assigned programs, including the generation of test data, writing test scripts/execution sequences, examining test results, debugging detected errors, etc. Uses current software development methods/techniques and established development standards (which include programming standards, documentation standards and testing standards) to ensure the quality and maintainability of reports/applications. Participates in code walk-thrus to ensure compliance with development standards and system/business requirements.

4. Works with trainers, technical support staff, network specialists and contract staff to perform modifications and/or updates to existing systems or to implement new systems. Identifies, investigates and resolves production problems. This may include analyzing problems, coding, testing, implementing and training of other technical staff and/or customers.

5. Other duties as assigned. (Note: This includes but is not limited to actively participating and/or serving in a supporting role to meet the agency’s obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation. Such participation may require an alternate shift pattern assignment and/or location.

Knowledge Skills Abilities:
Knowledge of database management systems such as MS SQL Server and Oracle.
Knowledge of information systems project methodologies
Knowledge of general technical knowledge
Knowledge of and familiarity with personal computer hardware and peripheral equipment

Skills in computer programming
Skills in planning, scheduling and prioritizing work assignments
Skills in written and verbal communications
Skills in writing and testing code, including new and maintenance

Ability to analyze problems and develop solutions to correct the problems
Ability to analyze functional/design requirements and to develop solutions to implement the requirements
Ability to perform detailed work accurately and in accordance with standards
Ability to work and communicate effectively with others
Ability to meet deadlines and work on projects with changing priorities

Registration or Licensure Requirements:

Initial Selection Criteria:
Graduation from an accredited four-year college or university with a major in computer Science, Engineering, Business Administration, Management, or related field. May substitute direct work experience on a year-for-year basis.
Minimum of 7 years of experience as a Database Administrator.

Additional Information:
Req 571086
This position can telework 100% from any location in Texas consistent with HHS telework policies. Applicants from outside Texas must be willing to relocate within 60 days of hire.

MOS Code:
Note: Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to: 25B, IT, 275, 0651, 3D0X2. All active duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information see the Texas State Auditor’s Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.