Database Consultant » EltasJobs

The Official Employment Site of Wisconsin State Government

Home/Job Search

Application Information

Veterans Resources

Benefits of State Employment

Monthly State Exams

Current/Former State Employee

Diversity Zone

Labor and Service Positions

Short Term Employment Opportunities

Other Government Jobs

What’s New

Applying for University of Wisconsin jobs as of July 1, 2015

We are an Equal Opportunity Employer seeking a diverse and talented workforce.

Children and Families, Department of

Database Consultant

Job Announcement Code(s): 17-01082

County(ies):
Dane

Classification Title : / JAC :
Job Working Title :
IS DATA SERVICES CONSULTANT/ADMIN 17-01082

Database Consultant

Type of Employment :
Full Time (40 hrs/week)

Salary :
The starting salary will be between $32.64 and $49.66 per hour ($67,891-$103,293 annually) and is in pay schedule/range 07-32. A twelve-month probationary period may be required.

Contact :
Jennifer Wilkie, Human Resources Spec – Senior, 608-422-6425, Jennifer.Wilkie@wisconsin.gov

Bargaining Unit :
Non-Represented

Area of Competition :
Open

Deadline to Apply :
5/15/2017

Assessment Information :
13304 –

029

IS DATA SERVICES CONSULTANT/ADMIN

Preview Assessment

The State of Wisconsin Department of Children and Families is currently looking to fill a Database Consultant , in the Division of Management Services, Bureau of Information Technology Services, Technical Services Section.

We are located in downtown Madison, near the state capitol, the Madison Metro route and the Capital City bike path. We offer amazing benefits such as a casual office atmosphere, ample vacation time, excellent health benefits, and an exceptional employee assistance program that offers a variety of programs and tools to help promote an employee’s wellness and health. If you live outside of the Madison area, there are ride sharing/van pool options available. Check out www.doa.state.wi.us “vanpools” for more information.

DCF is committed to the important work of helping children, youth and families become safer, more secure and progress down the road to true independence. For more information about DCF, visit our website at http://dcf.wi.gov

Come see why DCF is such a great place to work!

Position Summary :
Under broad policy guidance and general supervision, this position will lead the Department of Children and Families (DCF) Enhanced Services Team in daily operations, support, consulting and technical implementations. This role provides advanced level IT database expertise and support within the Technical Support Services (TSS) Section. The role provides the Department with guidance and consultation on IS technical issues specific to database administration, including establishing technical database policies, setting priorities, and determining parameters and standards. This role requires interaction with diverse groups of technology and business professionals including infrastructure, application development, business partners, and 3rd party subject matter experts to ensure that solutions are planned, developed, deployed, and maintained in accordance with the DCF’s security, policies and business requirements.

This position interacts with IT Development staff within DCF and in other agencies to manage shared data, and interacts with the Department of Administration (DOA) Division of Enterprise Technology (DET) database team to consult on high-level technical database software, infrastructure, architecture and support. The Database Administrator Consultant will focus on database design and the ongoing support and administration of Oracle and Microsoft SQL databases for specific applications and development work for DCF program areas. The DBA should be an expert at Oracle Data OLAP data warehouse management and will also have responsibilities in the design and build of operational OLTP databases. The candidate will analyze and model data requirements, application and processing architectures, data dictionaries, and database schema(s), and then design, develop, amend, optimize, and certify database schema design to meet system(s) requirements. This position requires strong written and oral communication skills and sound organizational skills.

For a complete copy of the position description please click here.

Special Notes :
Applicants must be legally entitled to work in the United States (i.e., a citizen or national of the U.S., a lawful permanent resident, an alien authorized to work in the U.S. without DCF sponsorship). The Department of Children and Families does not sponsor visas, either at time of hire or at any later time.

Due to the nature of the position, all applicants who may be appointed may be required to allow DCF to conduct a security background check to determine whether the circumstances of any conviction may be related to the job being filled.

Qualifications :
Minimally qualified applicants will have :

Experience with Oracle database administration within a data warehouse environment.
Experience working with and supporting application development teams
Experience with PL/SQL development.
Experience with database administration experience in Oracle 12c and 11g, SQL 2012.

Well qualified applicants will have:

Experience developing database level monitoring for application related issues, tuning database queries, user security and access, and other application database functions.
Business Objects experience.
Experience using RMAN, Erwin, SqlPlus, SQL Developer, TOAD.
Experience with supporting diverse database platforms beyond Oracle and SQL to include but not limited to Linux OS, Windows OS, RAC, DB2 and MySQL
Team Lead Experience

The starting salary will be between $32.64 and $49.66 per hour ($67,891-$103,293 annually) and is in pay schedule/range 07-32. A twelve-month probationary period may be required.