Title: Database Administrator 5
- Vendor submissions will close on 4/2 at 10 am ET. Late submissions will not be accepted
- Interview Process: In-person interview at 320 S Walnut St, Lansing, MI, with the senior leadership team
- Assignment duration: Ongoing contract with a possibility of extension based on performance and business needs
- Hybrid Work Schedule (Non-Negotiable): There is no remote-only option
Required onsite days- Mondays and Tuesdays
Remote eligible days- Wednesdays, Thursdays, and Fridays
The resource must meet these requirements from the beginning
- Candidates must be local to the Lansing, Michigan area (within 90 miles) at the time of submission. This requirement is non-negotiable
· 15+ years of Database administration, specifically on Oracle 18c and upwards
· 5+ years of experience creating, updating, and maintaining systems documentation
· Experience with high availability (HA) and disaster recovery (DR) database solutions
· Experience supporting database replication and backup environments
· Experience supporting clustered database environments
· Experience in monitoring production database environments and troubleshooting outages
Preferred Qualifications:
· Previous State of Michigan experience
· Evaluate impacts of change and new technology, recommend solutions to persistent problems, and serve as Agency Services liaison to external consultants.
· Follow and enforce database standards, policies & procedures. Research and draft guidelines within the boundaries of current policies and standards.
· Monitor space allocation across databases, 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
· Modify DBMS parameters based on capacity changes.
· Configure and execute database integrity checks.
· Monitor for database integrity checks
· Install database base management software for development and test environments.
· Install database patches and service packs for development and test environments.
· Implement the strategy to release unused space or repair fragmentation in test and development environments.
· Execute (run) scripts provided by Systems Analysts or Database Architect/Designer for creating and modifying database objects (tables, views, constraints, indexes, etc.
· Monitor database jobs and scheduled processes in development, test, and production environments. 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.