Database Administrator II - Report Developer

Brief Job Description: 

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 full-time position (40 hours a week). Work outside of regular hours may be required. Travel to other work locations may be required. Performs other duties as assigned.   

Essential Job Functions (EJFs): 

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

1. 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 for Production reports. Backup, restore, and recover tasks also apply to Development or Test Databases. (20%)  

2. 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. (25%)  

3. 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.  (25%)   

4. Evaluates users' requests for new data elements and systems and incorporates into existing shared data environment. (20%) 

• Entertaining user's request for data
• Creating tables and providing the data required
• Provide user access with proper privileges
• Creating users as required by application and user requests
• Helping secure the database environment 

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%)