DEPT OF HEALTH SERVICES

Address:

 150 N 18th Ave.

Phoenix, AZ 85007

Salary: $101,970 

Grade: 29

This position will support the Arizona Department of Health Services, WIC Program's automated management information system, Health and Nutrition Delivery System (HANDS) a .net application. Responsibilities include logical and physical database design, analysis of requirements, develop requirements for database modifications, monitor outside contractors performance, understand database internal effectively, outline and oversee corrective actions to resolve technical problems, database patching and ensure documentation of all modifications of the database.

Analyze WIC user needs and database requirements. Analyze database scripts and logic, assist with debugging, make recommendations for appropriate changes required for performance improvement, supervise scripting, coordinate with internal and external database support teams, and provide training and guidance to other staff.

Analyze database performance, design logic, physical database structures, and monitor database and the external contractor's installation, maintenance and upgrading of the database on multiple platforms as needed. Assist users' acceptance testing, oversee the design of the testing databases, and approval of code changes.

Effectively communicate with all users, application support/development teams, supervisors and others. Participate in weekly technical discussions, and able to accomplish and perform well as a good team player. Must be adaptable to changing environment and WIC program requirements.

Oracle and Discoverer support of users, assists with the planning, and training of the WIC staff and provides effective and efficient customer service in a timely manner.

Write RFQ requirements for changes (change orders) in the database.

Other duties as assigned as related to the position (typically 5% - 10%).

Knowledge of:
-Unix, EPe, and Windows operating systems and procedures.
-Application programming, system requirements, and documentation procedures.
-Considerable knowledge of Oracle technology.
-Considerable knowledge of Microsoft SQL database technology.
-Considerable knowledge of Discover and Crystal Reports software.

-Performance Management (PM), and Continuous Quality Improvement (CQI) and Lean methodologies.

Skill in:
-Operating a computer with Windows operating system.
-Using Microsoft software applications: word processing, graphics, presentations, and database.
-Report preparation and documentation.
-Organizing and prioritizing multiple projects.
-Communication, both verbal and written.
-Negotiation and team building.
-Considerable skills in analyzing system requirements and capabilities of the system.

Ability to:
-Work effectively with WIC program staff as well as contractors to accomplish all changes and modifications of the database/assigned projects.
-Plan and effectively manage projects in a timely manner.
-Write and verbally communicate ideas to team members as well as other groups: task forces and committees.
-Demonstrate creative thinking and improve operations in a cost effective manner.

-Support a diverse multi-cultural workforce that reflects the community, promotes equal opportunity at all levels of public employment, and creates an inclusive work environment that enables all individuals to perform to their fullest potential free from discrimination.

Bachelor's degree in Computer Science, Management Information System Technology or related field and 2 years of experience (5 years of equivalent experience may be substituted for degree requirements). Advanced training in Oracle technology, DQL, Discover and Crystal Reports.

Must possess a valid level one fingerprint clearance card issues pursuant to A.R.S. §36-113.

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver’s License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

The State of Arizona provides an excellent comprehensive benefits package including:
− Affordable medical and dental insurance plans
− Paid vacation and sick time
− Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
− 10 paid holidays per year
− Wellness program and plans
− Life insurance
− Short/long-term disability insurance
− Defined retirement plan
− Award winning Infant at Work program
− Credit union membership
− Transit subsidy
− ADHS Student Assistance Pilot Program

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

To help you build a financially secure future, the State makes monthly contributions to finance your retirement benefit. The State will contribute to the ASRS in an amount equal to your contribution. In other words, you and the State will each pay 50% of the total cost of the benefit. New State employees have a 27-week wait period for contributions to begin.

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by calling (602) 542-1085. Requests should be made as early as possible to allow sufficient time to arrange the accommodation. DHS is an Equal Employment Opportunity Employer. All newly hired employees will be subject to E-Verify Employment Eligibility Verification.