Information Technology Programmer/Analyst 12

State of Michigan; Dimondale (MI); Hybrid; USD 100,000 - 145,000; Full time

Job summary

State of Michigan – Department of Technology Management and Budget (DTMB) seeks a Senior Oracle Database Administrator to support the Michigan State Police (MSP). You will design and maintain the database environment, apply security patches, back up data, and optimize performance while ensuring regulatory compliance.

The role requires strong communication, documentation, and incident response skills. The position offers hybrid work from Dimondale, MI, with two days on-site and three remote

Qualifications

• Bachelor's degree with 21 semester credits in CS, IT or related field.
• Two years of professional IT experience equivalent to IT Infrastructure or Programmer/Analyst P11.
• Alternative education paths accepted with corresponding experience.

Responsibilities

• Support MSP databases for application dev teams and SaaS efforts.
• Install, configure, upgrade database software and ensure patches.
• Perform backups/restores and optimize performance; aid incident responses.
• Ensure database security and integrity per DTMB policies and standards.
• Coordinate go-live activities for production databases.

Skills

Data architecture

Security practices

Database backups

Performance tuning

Incident response

Education

Bachelor's degree in CS/IS/Math

Associate's degree + 2 years experience

High school + 4 years IT experience

Tools

Oracle Database

Tenable scans

Job description

Job Description

The Department of Technology, Management and Budget (DTMB) 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.

We are looking for a person who understands the value of public service and wants to help us meet the needs of our citizens. Above all, we are looking for someone that is passionate about IT database administration and support of database users. This person needs to be an excellent communicator, meaning you can effectively make oral and written reports, presentations and prepare clear and concise documentation. You need to be capable of establishing and maintaining effective relationships with clients and matrix support teams. We need someone who can resolve complex problems in a timely manner and seeks optimum solutions.

As a Senior Oracle Database Administrator supporting Michigan State Police (MSP), this team member is responsible for database structure and design, implementing and maintaining the database environment, and ensuring compliance with security and integrity needs across the database environment. The employee is responsible for understanding data architecture and design, install, configure, and upgrade database software, maintain, and implement security practices that would include reviewing tenable scans and implementing current patches and security updates. The employee will also be responsible for database backups and restorations, performance optimization/tuning and provide support to incident responses. The employee plays a key role in database administration and support, ensuring that database performance and minimize database downtime are tracked closely and that the database access and security controls are kept up to date with the current policies, procedures, and standards. The goal is to install and maintain the performance of database servers and develop processes for optimizing database security.

Specific Roles And Responsibilities

• Support the application development teams and vendor supplied Software-as-a-Service efforts for MSP, including small enhancements, maintenance, and operations for new and existing MSP databases.
• Implementing and maintaining the database environment and ensuring compliance with security and integrity needs across the database environment:
  • Assist data architecture team with database design.
  • Install, configure, and upgrade Database software.
  • Ensure all databases are current in all patches and updates.
  • Database backups and restores.
  • Database performance optimization/tuning.
  • Application/solution incident response SME.
  • Provide audit responses.
• Liaison with support team and product owner to assist MSP and delivering database connections and data information for reporting or analytics.
• Ensure Database Security and Integrity by following and maintaining DTMB security practices, policies, and procedures. Along with maintaining awareness of industry practices and ensure appropriate access and availability to data environments.
• Perform and Coordinate activities required to achieve application and database Go Live in production.

This position will require the selected candidate to complete and pass a Michigan State Police Fingerprint Background Check prior to beginning employment.

The state of Michigan offers a competitive work experience that includes a tuition reduction program at several key higher education institutes if you would like to advance your education, good benefits, excellent vacation and sick time policies and an ability to successfully juggle your work and family life. This position has the ability work in a hybrid/remote work environment. We would like the opportunity to share with you more about the benefits of working for the state and joining the State of Michigan employee family.

DTMB does not participate in STEM-OPT.

ITPA 12 --

Position Description

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.

Position Location/Remote Office:

The office location is Dimondale, 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.

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

Required Education And Experience

Education

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

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

Alternate Education And Experience

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.

OR

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.

Additional Requirements And Information

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

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

Accommodations

If you require a reasonable accommodation to participate in the application or selection processes, please contact the ADA coordinator for the agency that posted this position vacancy.