Database Administrator II

Recruitment #110122-MADD02-350100

Introduction

Make a Difference with DHSS

Our mission at the Department of Health and Social Services (DHSS) is to improve the quality of life of Delaware citizens by promoting health and well-being, fostering self-sufficiency, and protecting vulnerable populations. We prioritize personal and family independence by assisting individuals and families in a variety of life areas.

We offer numerous career opportunities and are dedicated to attracting and retaining highly talented individuals who are ready to make a difference in their community today. DHSS is a great place to kick-start your profession.

For more information, please visit https://dhss.delaware.gov/dhss/ today!

Summary Statement

The incumbent is responsible for the administration of the Oracle Database. Oracle, a relational database management system, is an integral part of the Enterprise Identity Access Management (EIAM) system that grants roles in the ASSIST application ( a single access point for individuals to screen and apply for a broad range of social service programs). The incumbent works with support vendors to monitor and maintain the Oracle Database as well as other systems in the DHSS application portfolio.

Essential Functions

Essential functions are fundamental, core functions common to all positions in the class series and are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are descriptive and not restrictive, incumbents can complete job duties of similar kind not specifically listed here.
  • Monitors, coordinates and manages the selection, physical design, development, security, operation, processing, performance and maintenance of relational and/or other database, data storage and retrieval systems.
     
  • Coordinates and ensures database management systems interface with other information technology for sharing of data. Meets with customers to determine database requirements.
       
  • Develops database standards, documentation, security and authorization procedures.
      
  • Develops physical database and data warehouse/data mart designs and ensures appropriate modifications to databases; establishes databases; creates primary database storage structures (tablespaces/files, views and indices) based on estimated storage requirements. Modifies physical database objects/structures to reflect changes to the data model.
      
  • Establishes backup and recovery or replication plans to minimize data loss and system downtime.
      
  • Monitors and troubleshoots databases for potential or existing performance or security, problems, capacity requirements and makes modifications/adjustments to ensure availability of data.
      
  • Installs, monitors, diagnoses and debugs the database system software. Plans for projected software requirements and increased computer capacity relating to database requirements. Prepares plans for feasibility of conversion to database management systems from existing file structures.
      
  • Keeps current on new developments and techniques in data storage and database management. Identifies and evaluates the use of new and emerging tools, methods and technologies to improve database management, and data storage. Establishes and maintains contact with vendors and recommends database software and services.
      
  • May plan, assign, review and evaluate the work of two or more merit and/or contractual staff involved in database implementation and management.

Job Requirements

JOB REQUIREMENTS for Database Administrator II
Applicants must have education, training and/or experience demonstrating competence in each of the following areas:
  1. Six months experience in data resource management which includes systems analysis, design, and implementation.
  2. Three years experience in designing, maintaining, analyzing and implementing database management systems which includes systems performance tuning, maintaining backup/recovery systems, using system tools to identify, correct or refer system issues such as system space management and database integrity.
  3. Three years experience in applying database query languages such as using MS SQL Server, Sybase, DB2, Informix, Oracle, ADABAS, PL/SQL and other Oracle Based Tools.
  4. Six months experience in database security which includes developing internal database security mechanisms and defining user requirements.
  5. Six months experience in managing database management systems which includes installing upgrades, planning for future expansion, systems architecture, systems maintenance and integrating systems across operating units.

Additional Posting Information

Due to a new requirement from the Centers for Medicare & Medicaid Services (CMS) the following mandate is effective January 27, 2022: As a condition of employment, employees providing health care services and/or support services in covered facilities must show proof that they have received the dose of a single J&J dose or the 1st dose of Moderna/Pfizer two-dose vaccine effective date January 27, 2022, and proof of the single J&J dose or the 2nd dose of Moderna/Pfizer two-dose vaccine by February. 28, 2022. Employees may not provide any care, treatment, or other services until proof is provided.  Based on CMS guidance, the date for compliance may extend into March due to the health care facilities high vaccination rate of staff.  If you accept a position with the facility, your Human Resources representative can provide more guidance.  The only exception to these requirements is for those employees granted medical or religious exemptions from the COVID-19 vaccine as recommended by the Centers for Disease Control and Prevention, which may require weekly COVID-19 testing. This will be in effect until further notice.  More information can be found here

Conditions of Hire

Applicants must be legally authorized to work in the United States. The State of Delaware participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. For more information refer to our Job Seeker Resources.

DHSS does not provide employment-based sponsorship.

 Criminal background check:  A satisfactory criminal background check is required as a condition of hire.  The recruiting agency may require the applicant to pay for the criminal background check as part of the conditional offer of hire.

Benefits

To learn more about the comprehensive benefit package please visit our website at https://dhr.delaware.gov/benefits/

Selection Process

The application and supplemental questionnaire are evaluated based upon a rating of your education, training and experience as they relate to the job requirements of the position.  It is essential that you provide complete and accurate information on your application and the supplemental questionnaire to include dates of employment, job title and job duties.  For education and training, list name of educational provider, training course titles and summary of course content.   Narrative information supplied in response to the questions must be supported by the information supplied on the application including your employment, education and training history as it relates to the job requirements.

Once you have submitted your application on-line, all future correspondence related to your application will be sent via email.  Please keep your contact information current.  You may also view all correspondence sent to you by the State of Delaware in the “My Applications” tab at StateJobs.Delaware.gov.

Accommodations

Accommodations are available for applicants with disabilities in all phases of the application and employment process.  To request an auxiliary aid or service please call (302) 739-5458. TDD users should call the Delaware Relay Service Number 1-800-232-5460 for assistance.

The State of Delaware is an Equal Opportunity employer and values a diverse workforce. We strongly encourage and seek out a workforce representative of Delaware including race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression.