ITPA12 - Senior Data Warehouse Database Administrator

State of Michigan
Lansing, MI, United States
15 days ago
Apply on jobs.mitalent.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Compensation
$69,576.0 - $100,027.0
Working hours
Regular working hours

Tech stack

Information Systems Computer Programming Databases Data Transmissions Data Warehousing Systems Analysis Data Processing Information Technology Database Replication

Job description

TheDepartment of Technology, Management and Budget (https://youtu.be/H_IrVnVjcoA) 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., * 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 employment should 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. See instructions for attaching files here: Instructions (http://www.michigan.gov/documents/mdcs/New_Online_Employment_Application_Guide_-_First_Time_User_446027_7.pdf) (Download PDF reader)

Requirements

Information Technology Programmer/Analyst 12

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

Experience

Information Technology Programmer/Analyst 12

Two years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11., 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 of experience as an application programmer, computer operator, or information technology technician; or two years (4,160 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement., Educational level typically acquired through completion of high school and four years of experience as an application programmer, computer operator, information technology technician, or four years (8,320 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.

Benefits & conditions

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.

Required Education and Experience

About the company

State employment also offers rewarding careers where you can help Michiganders enjoy better lives. Many State of Michigan jobs offer alternate work schedules and remote-work options that can help give the flexibility you need. The State of Michigan has been recognized as a leading U.S. employer by new graduates from 2021-2023 and a best large U.S. and state employer. Recognized on the international stage for fostering positive employee engagement, the State of Michigan is a past recipient of a North America Government Agency Employees Engagement Award.

More details on benefits for our new hires are below:

Rewarding Work:State of Michigan jobs allow you to serve Michiganders in many different ways depending on your interests and skills. Help preserve and protect our environment and the public health; enforce state laws and regulations; advocate for children, families, and victims of discrimination; support our state’s military and veterans; rebuild our state’s infrastructure; or support other state agencies through our fiscal, IT, and HR systems.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.mitalent.org
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:08 min

Discovering technical colleges through public employment centers

Lea Fragner ¡ LIVE

3:22 min

Embracing polyglot persistence versus strictly relational databases

Stefan Priebsch ¡ World Congress 2021

2:10 min

Defining stream data processing versus standard event processing

Soroosh Khodami Soroosh Khodami ¡ World Congress 2024

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg ¡ LIVE

5:08 min

Transitioning from economics to a tech career path

Katrin Lehmann Katrin Lehmann +1 ¡ Coffee With Developers

3:06 min

Automating image resizing and data streaming tasks

Menaka Baskerpillai ¡ LIVE

Videos

See all

Related articles

See all