ITPA12 - Senior Data Warehouse Database Administrator

State-of-Michigan; Lansing (MI); Hybrid; USD 65,000 - 90,000; Full time

Job summary

State of Michigan is seeking an Information Technology Programmer/Analyst 12 to design, develop, test and implement database systems for the MDHHS Data Warehouse on the EDW. The role includes maintenance and collaboration with specialist DBAs on high-availability configurations.

The position offers a hybrid work option (two days on-site, three days remote) and requires a Bachelor's degree with IT-related credits plus two years of professional IT experience. Signing bonus up to $2,500 may apply.

Qualifications

• Bachelor's degree with required IT/CS credits and coursework.
• Two years of professional IT experience equivalent to IT Infrastructure or Programmer/Analyst P11.
• Alternative education paths include associate's degree with required credits and two years of related experience, or high school plus four years of related experience.

Responsibilities

• Design, develop, test, and implement database systems for the MDHHS Data Warehouse on the State EDW.
• Provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, replication and backup solutions.

Education

Bachelor's degree with 21 semester credits in one or a combination of: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management or mathematics

Job description

The Department of Technology, Management and Budget supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budget and financial management, space planning and leasing, construction management, motor vehicle fleet operations, and oversight of the state retirement systems. This position is with the Agency Services area of DTMB.

As a Senior Database Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database systems for the Michigan Department of Health and Human Services (MDHHS) Data Warehouse (DW) located on the State of Michigan Enterprise Data Warehouse (EDW). This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies. They will provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.

DTMB does not participate in STEM-OPT.

ITPA 12 -- Position Description

Position Location/Remote Office:

The office location is Lansing, MI. The State of Michigan is not able to offer employment to out-of-state applicants that do not plan to relocate. The Department of Technology Management and Budget currently offers a hybrid work option which requires two days working on-site at the official work location and three days of remote work per week.

SIGNING BONUS:

This position may be eligible for a sign-on bonus of up to $2,500. Up to $1,250 to be paid upon new hire and the remainder to be paid after satisfactory completion of the initial probationary period (12-month period). This does not apply to current state employees.

DTMB is proud to be a Michigan Veteran’s Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.

Education

Information Technology Programmer/Analyst 12

Possession of a Bachelor's degree with 21 semester (32 term) credits in one or a combination of thefollowing: computer science, data processing, computer information systems, data communications,networking, systems analysis, computer programming, information assurance, IT project managementor mathematics.

Experience

Information Technology Programmer/Analyst 12

Two years of professional experience equivalent to an Information Technology Infrastructure orProgrammer/Analyst P11.

Information Technology Programmer/Analyst 12

Possession of an associate's degree with 16 semester (24 term) credits in computer science,information assurance, data processing, computer information, data communications, networking,systems analysis, computer programming, IT project management, or mathematics and two years ofexperience as an application programmer, computer operator, or information technology technician; ortwo years (4,160 hours) of experience as an Information Technology Student Assistant may besubstituted for the education requirement.

OR Educational level typically acquired through completion of high school and four years of experience asan application programmer, computer operator, information technology technician, or four years (8,320hours) of experience as an Information Technology Student Assistant may be substituted for theeducation requirement.

To be considered for this position you must:

• Relevant experience and/or education referred to in the supplemental questions must be documented in the resume, transcript and/or application to allow for accurate screening.
• Attach a resume identifying specific experience and dates of employment. Dates of employmentshould include month and year and hours per week.
• Attach a cover letter.
• If applicable, attach a copy of an official transcript(s). We accept scanned copies of official transcripts. We do not accept web-based, internet, or copies of unofficial transcripts. Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature.

Failure to complete any of the above items may result in your application not being considered and screened out.

In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States.

Certain positions may require certification in specific information technology programs.

View the job specification at: https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/I/InformationTechnologyProgrammerAnalyst.pdf