Database Administrator 3

The State of Michigan is looking for a Database Administrator 3

Top Skills & Years of Experience:
5 years of Database administration specifically on oracle platform version 19c and above.
1 years of experience creating updating and maintaining systems documentation.
Solaris and Red Hat Linux experience required.
SQL experience required.
Additional details on job description attachment.

Interview Process: Virtual Interview via MS Teams video or onsite interviews could also be requested. For all virtual please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screenshot photo of candidate will be required for any Teams interviews as well as a vendor present at beginning of interview to validate candidate.

Duration: 1 year with possible extension.
Remote or Onsite: Candidates MUST be local at time of submission. Hiring manger is not interested in candidates who will need to relocate for the role. Position will be hybrid inoffice 2 days a week.

Full Job Description Attached

As an midlevel Database Administrator under guidance of immediate supervisor or senior DBA participates in 24x7 software and hardware support for Application Lifecycle Management (ALM) tools following industry and DTMB development standards. Helps develop and/or submit for approval plans for testing and implementation of ALM tools. Evaluate impacts of change and new technology recommend solutions to persistent problems and serve Agency Services liaison to external consultants.
Individual tasks related to the duty:
Follow and enforce database standards policies & procedures. Research and draft guidelines within the boundaries of current policies and standards.
Monitor space allocation across databases. Under direction of a seniorlevel DBA perform adjustments in test and development environments as necessary and as prescribed by predefined standards/guidelines.
Calculate disk space requirements for existing and/or new installations of existing business needs working with a seniorlevel DBA as necessary.
Modify DBMS parameters based on capacity changes as determined by seniorlevel DBA as necessary.
Under the authorization of a seniorlevel DBA configure and execute database integrity checks.
Monitor for database integrity checks. Report integrity issues to senior level DBAs.
Under the authorization of a seniorlevel DBA install database management software for development and test environments.
Under the authorization of a seniorlevel DBA install database patches and service packs for development and test environments.
Under the authorization of a seniorlevel DBA monitor and support clustered database environments.
Under the authorization of a seniorlevel DBA monitor and support database replication and backup environments.
Under the authorization of a seniorlevel DBA implement the strategy to release unused space or repair fragmentation in test and development environments.
Under the authorization of a seniorlevel DBA execute (run) scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects (tables views constraints indexes etc.)
Monitor database backups to ensure recoverability. Troubleshoot backup errors and report unresolved issues to a seniorlevel DBA.
Monitor database jobs and scheduled processes in development test and production environments. Notify seniorlevel DBAs and application support staff about any issues. Participate in troubleshooting.
Monitor database environments (using alert logs trace files alert mechanisms and other tools) for issues and problems with database functionality connectivity or downtime.
Follow standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.