Senior Oracle DBA

Required onsite days- Mondays and Tuesdays
Remote eligible days- Wednesdays, Thursdays, and Fridays 

Candidates must be local to the Lansing, Michigan area (within 90 miles) at time of submission. This requirement is non-negotiable

Job Responsibilities:

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

Required Qualifications:

• 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 monitoring production database environments and troubleshooting outages

Preferred Qualifications:

• Previous State of Michigan experience