Database Administrator II
Full-time
8 months ago
Employment Information
Database Administrator II
Works under the general supervision of the IDD Behavioral Health Services Software Applications Manager or their designee. Performs moderate to advanced work in providing for the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets to ensure an integrated database system for the Behavioral Health Services portfolio. Performs logical database administration duties such as creating and maintaining tables, procedures, indexes, keys, and triggers. Designs, maintains, schedules and monitors production reports that run with specific job schedulers in the database environment and other needed functions. Work may involve the coordination of a group of developers who are assigned analytical and programming components of the database environment. Works under supervision with latitude for the use of initiative and independent judgment. This position is classified as a fulltime position (40 hours a week). Work outside of regular hours may be required. Travel to other work location may be required. Performs other duties as assigned.
Works under the general supervision of the IDD Behavioral Health Services Software Applications Manager or their designee. Performs moderate to advanced work in providing for the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets to ensure an integrated database system for the Behavioral Health Services portfolio. Performs logical database administration duties such as creating and maintaining tables, procedures, indexes, keys, and triggers. Designs, maintains, schedules and monitors production reports that run with specific job schedulers in the database environment and other needed functions. Work may involve the coordination of a group of developers who are assigned analytical and programming components of the database environment. Works under supervision with latitude for the use of initiative and independent judgment. This position is classified as a fulltime position (40 hours a week). Work outside of regular hours may be required. Travel to other work location may be required. Performs other duties as assigned.
Essential Job Functions:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
1. Analyze, design, plan and perform database upgrades and maintenance. Coordinates with service provider and application groups to install new versions, new enhancements, and newly released databases to HHSC database system. (30%)
2. Coordinates with application development and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, user security, archiving, and system parameters setting to Production databases. Backup, restore, and recover tasks also apply to Development or Test Databases. (30%)
3. Setup views, roles, stored procedures, and database links to allow use of databases while preserving data integrity and maintaining security within established policies, regulations, and guidelines. Assist, help, and resolve problems for other groups. (20%)
4. Administers assigned division agency data warehouse. Analyzes and evaluates requests for new or modified reporting needs to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Consults with customer to identify current operating procedures and clarify objectives. Formulates plan outlining steps required to develop program and submits plan to user for approval. (10%)
5. Develops and maintains expertise in database management software and performance management tools necessary to meet the needs of the division. This includes staying current on the latest technology updates and development techniques for the area(s) of responsibility. Provides technical assistance to other systems personnel as required. (5%)
6. Other duties as assigned include but are 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. (5%)
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
1. Analyze, design, plan and perform database upgrades and maintenance. Coordinates with service provider and application groups to install new versions, new enhancements, and newly released databases to HHSC database system. (30%)
2. Coordinates with application development and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, user security, archiving, and system parameters setting to Production databases. Backup, restore, and recover tasks also apply to Development or Test Databases. (30%)
3. Setup views, roles, stored procedures, and database links to allow use of databases while preserving data integrity and maintaining security within established policies, regulations, and guidelines. Assist, help, and resolve problems for other groups. (20%)
4. Administers assigned division agency data warehouse. Analyzes and evaluates requests for new or modified reporting needs to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Consults with customer to identify current operating procedures and clarify objectives. Formulates plan outlining steps required to develop program and submits plan to user for approval. (10%)
5. Develops and maintains expertise in database management software and performance management tools necessary to meet the needs of the division. This includes staying current on the latest technology updates and development techniques for the area(s) of responsibility. Provides technical assistance to other systems personnel as required. (5%)
6. Other duties as assigned include but are 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. (5%)
Knowledge Skills Abilities:
Knowledge of Software Development Life Cycle (SDLC) principals and procedures.
Knowledge website and database development processes and practices.
Knowledge of and familiarity with the Visual Studio development suite.
Knowledge of Project Management tools such as MS Azure DevOps, MS Team Foundation Server, or similar.
Skills in database management systems such as Sybase, Oracle and/or SQL Server.
Skills in common practices and techniques for the electronic exchange of data such as Informatica and/or Oracle Data Integrator.
Skills in report development on platforms such as SSRS or equivalent.
Skills in testing principles and methodologies.
Skills in working collaboratively with multiple stakeholders to achieve consensus and common goals.
Skills in working collaboratively with website and database developers.
Skills in planning, scheduling, and prioritizing work assignments.
Skills in written and verbal communications.
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 meet deadlines and work on projects with changing priorities.
Knowledge of Software Development Life Cycle (SDLC) principals and procedures.
Knowledge website and database development processes and practices.
Knowledge of and familiarity with the Visual Studio development suite.
Knowledge of Project Management tools such as MS Azure DevOps, MS Team Foundation Server, or similar.
Skills in database management systems such as Sybase, Oracle and/or SQL Server.
Skills in common practices and techniques for the electronic exchange of data such as Informatica and/or Oracle Data Integrator.
Skills in report development on platforms such as SSRS or equivalent.
Skills in testing principles and methodologies.
Skills in working collaboratively with multiple stakeholders to achieve consensus and common goals.
Skills in working collaboratively with website and database developers.
Skills in planning, scheduling, and prioritizing work assignments.
Skills in written and verbal communications.
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 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 in Software Engineering or Computer Science. May substitute direct work experience on a year-for-year basis. Minimum of 3 years’ experience as an Oracle Database Administrator/Developer or similar job function
Graduation from an accredited four-year college or university in Software Engineering or Computer Science. May substitute direct work experience on a year-for-year basis. Minimum of 3 years’ experience as an Oracle Database Administrator/Developer or similar job function
Additional Information:
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, 0171, 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.
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, 0171, 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.
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.
Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS
Share this
