Database Architect

Job Summary :

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.

Job Duties :

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, Skills & Abilities (KSAs) :

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 :

Ability to :

Selective Preference(s) :

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.

Pre-Employment Requirements :

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 :

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

Benefits :

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 . For a complete list of benefits provided by The State of Arizona, please visit our

Retirement :

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.