Senior Oracle Infrastructure DBA

Job Title: Senior Oracle Infrastructure DBA

Location: Lansing, MI (Hybrid)

Duration: Long-term Contract

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