ITS14 - Database Administrator Specialist

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

Benefits offered by this job

Sign-on bonus up to $2,500

MVAA Gold Level Veteran-Friendly

Job summary

State of Michigan seeks an IT specialist to support Oracle databases for MDDHS applications, ensuring security, integrity, and availability. The role involves policy development for backup/recovery, monitoring, and performance tuning, plus production support and creating database objects.

The position offers a hybrid work option with two days on-site and three days remote. Ideal candidates will have an associate degree with IT experience or a high school diploma with substantial IT

Qualifications

• Associate's degree with 16 semester credits in CS, data processing, or related; four years IT experience.
• High school diploma with three years IT programming/ops experience and four years professional IT experience equivalent to IT Infra or Programmer/Analyst P11 or 12.

Responsibilities

• Maintain integrity, security, and availability of Oracle databases.
• Ensure databases comply with DTMB standards, policies, procedures.
• Develop policy for backup/recovery, startup, shutdown, monitoring, planning, and performance tuning.
• Provide ongoing production support for new tables, columns, indexes, scripts, etc.
• Assist in creating and maintaining database scripts and maintenance tasks.

Skills

Oracle databases

Database tuning

Production support

Policy development

Education

Associate's degree in CS/DC/IS or equivalent

High school diploma + 3+ years IT experience

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.

This position will provide support for the Oracle databases of MDDHS applications such as MPI, MiAIMS, and Child Day Care I-Billing. The incumbent will maintain the integrity, security, and availability of their assigned databases and ensure the Oracle databases comply with all DTMB database standards, policies, and procedures. This position will assist in the development of policy for managing databases such as backup/recovery, startup, and shutdown; monitoring, estimating, and planning; performing performance tuning: identifying and solving minor and major, bugs and issues; and providing ongoing production support regarding the creation of new tables, columns, indexes, scripts, etc.

DTMB does not participate in STEM-OPT.

ITS 14 -- 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.

An associate's degree with 16 semester (24 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, mathematics or equivalent; and at least two years of experience as an application programmer, computer operator, or information technology technician and four years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11 or one year equivalent to an Information Technology Infrastructure or Programmer/Analyst 12.

OR

At least an educational level typically acquired through the completion of high school and at least three years of experience as an application programmer, computer operator, or information technology technician and four years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11 or one year equivalent to an Information Technology Infrastructure or Programmer/Analyst 12.

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 be assigned subclass codes and individuals appointed must possess the required specialized experience.

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