Job Information
State of Michigan Senior Oracle Database Administrator (ITPA12) supporting Michigan State Police in Dimondale, Michigan
Senior Oracle Database Administrator (ITPA12) supporting Michigan State Police
Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/4746773)
Apply
Senior Oracle Database Administrator (ITPA12) supporting Michigan State Police
Salary
$32.48 - $46.69 Hourly
Location
Dimondale, MI
Job Type
Permanent Full Time
Remote Employment
Flexible/Hybrid
Job Number
0801-24-21-279AM
Department
Technology, Management and Budget
Opening Date
12/03/2024
Closing Date
12/17/2024 11:59 PM Eastern
Bargaining Unit
NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)
Description
Benefits
Questions
Job Description
The Department of Technology, Management and Budget (DTMB) (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.
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.
SIGNING BONUS:
This position may be eligible for a sign-on bonus 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.
Classifications for the $2,500 bonus are:
Information Technology Infrastructure Analyst
Information Technology Programmer/Analyst
Information Technology Project Coordinator
Information Technology Project Manager
Information Technology Specialist
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.
ITPA 12 - Position Description (https://MCSC.state.mi.us/AgencyPDFs/PD 24-21-279 ITPA 12.pdf)
DTMB is proud to be a Michigan Veteran’s Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.
Required Education and Experience
Education
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.
Alternate Education and Experience
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 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:
Apply for this position online via NEOGOV; click on "Apply" in the job posting for instructions on submitting your electronic application. Hard copy applications are not accepted.
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)
Your application for any position does not guarantee that you will be contacted by the Department/Agency for further consideration. Only those applicants interviewed will be notified of the results.
The Office of Career Services (https://www.michigan.gov/mdcs/0,4614,7-147-6876---,00.html) offers current State Employees and interested applicants access to the job application process and a variety of career planning resources.
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 theADA coordinator (https://www.michigan.gov/ose/-/media/Project/Websites/ose/Contact/RACs.pdf) for the agency that posted this position vacancy.
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.
Insurance Benefits:The State of Michigan offers health, mental health, dental, and vision insurance to eligible career employees, their spouses, and their children. The state also covers a life-insurance benefit of two times employees’ annual salary (up to $200,000). The state also offers long-term-disability insurance that can provide continuing benefits if an injury or illness prevents employees from working. More information is available at www.mi.gov/employeebenefits.
Retirement Programs:The State of Michigan offers 401(k) and 457 plans for new hires to save for retirement. The state will automatically contribute an amount equal to 4% of your pay to a 401(k) account. The state will also match up to 5% of your pay if you contribute to your 401(k) account. Your contributions vest immediately, and the state’s contributions fully vest after just 4 years. More information is available athttp://www.mi.gov/orsstatedc.
Vacation and Sick Leave:Eligible full-time employees receive between15 and 35 personal daysand 13 sick daysper year that may be rolled over to the following year if not used. Eligible employees also receive an additional day each year for community service or school functions.
Paid Parental Leave:Eligible employees can take 12 weeks of paid leaveimmediately after a birth or adoption to allow needed time together at home with a new child.
Paid Holidays:Eligible employees receive 13 or 14 paid holidays each year including New Year’s Eve and Day, Martin Luther King Jr. Day, Presidents’ Day, Memorial Day, Juneteenth, the Fourth of July, Labor Day, Election Day, Veterans Day, Thanksgiving, Thanksgiving Friday, Christmas Eve and Day.
Bonus Programs:Eligible employees with five years of service also receive annual longevity bonuses that grow as seniority increases. Some positions also may qualify for recruitment, retention, and performance bonuses or other special pay premiums.
Military Pay Differential:Employees in the guard or reserves may also qualify for supplemental pay benefits if miliary pay during qualifying duty is less than normal state pay. Prior military service may also allow seniority credits to accelerate eligibility for longevity bonuses and additional personal leave accrual.
Tax-Advantaged Programs:In addition to 401(k) and 457 retirement accounts, the state also offers flexible spending account (FSA), health savings account (HSA), and qualified transportation fringe benefit (QTFB) programs that can help you save money by reducing your taxable income.
Student Loan Forgiveness:Working for the State of Michigan may allow you to participate in programs that forgive the balance of qualifying student loans. Information (https://studentaid.gov/manage-loans/forgiveness-cancellation) to help determine if you could qualify is available from the U.S. Department of Education.
Tuition Reduction:Some colleges and universities offer savings to eligible employees and family members to further their education while working for the State of Michigan.
Professional Development: To help develop your career, programs are available to apply for reimbursement of up to $2,000 a year for education and training for college course credits and non-degree programs.
Alternative and Remote Work Schedules:Depending on the nature of their duties, many state jobs offer flexible work schedules and remote or hybrid telecommuting options that can help obtain the work-life balance that you seek.
Great Lakes and Great Times:Michigan boasts four Great Lakes, 11,000 inland lakes, 36,000 miles of rivers and streams, 20 million acres of forests, 100 state and national parks and recreation areas, 1,300 miles of bike trails, 6,500 miles of snowmobile trails, the second-most ski areas in the nation, 650 public golf courses, 600 campgrounds, and an international dark-sky park—just for starters. Our cities offer concerts and cultural events, storied sports teams, education hubs, vibrant downtowns, one-of-a-kind craft beverages, and renowned restaurants for every appetite. From urban centers to beach towns to the great outdoors, the opportunities are endless. With your state salary and benefits and Michigan’s affordable cost of living, you can explore all that Michigan has to offer.
Updated: 2/28/24
01
ITPRAN11 - Do you possess one of the following? A bachelor's degree or higher with at least 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. If so, please attach a copy of your official college transcripts. OR An associate's degree or higher with at least 16 semester (24 term) credits in one or a combination of the following: computer science, data processing, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics; and at least 2 years of experience as an application programmer, computer operator, or information technology technician; or at least two years (4,160 hours) of experience as an Information Technology Student Assistant. If so, please attach a copy of your official college transcripts. OR At least an educational level typically acquired through the completion of high school, and at least 4 years of experience as an application programmer, computer operator, information technology technician, or at least four years (8,320 hours) of experience as an Information Technology Student Assistant.
Yes
No
02
How many years of experience do you have in managing enterprise databases?
0 to 1 year
1 to 3 years
3 to 5 years
More than 5 years
03
If you stated you have experience, please describe that experience below. If you stated none, write N/A.
04
How many years of experience do you have as a DBA in supporting Oracle databases?
0 to 1 year
1 to 3 years
3 to 5 years
More than 5 years
05
If you stated you have experience, please describe that experience below. If you stated none, write N/A.
06
How many years of experience do you have as a DBA in supporting Microsoft SQL Server databases?
0 to 1 year
1 to 3 years
3 to 5 years
More than 5 years
07
If you stated you have experience, please describe that experience below. If you stated none, write N/A.
08
How many years of experience do you have in developing and implementing process improvements?
0 to 1 year
1 to 3 years
3 to 5 years
More than 5 years
09
If you stated you have experience developing and implementing processes, please describe that experience below. If you stated none, write N/A.
10
Did you attach your official transcript? If not please do so.
Yes
No
Required Question
Agency
State of Michigan
Department
Technology, Management and Budget
Address
DTMB-HR@michigan.gov
Elliott-Larsen Bldg., 2nd fl., 320 S. Walnut Street
Lansing, Michigan, 48909
Phone
Attn: HR Office
Website
www.michigan.gov/dtmb
Apply
Please verify your email addressVerify Email