IT Database Analyst

Medical Mutual•Cleveland, OH

16h•Hybrid

About The Position

Medical Mutual is seeking experienced Oracle DBAs for a hybrid-remote IT Database Analyst role, based out of the Brooklyn, OH or Dublin, OH office. This position involves providing complex strategic, analytical, and technical support for database-related activities, assisting with problem identification and issue resolution, and collaborating with IT project teams to translate requirements into database designs. The role requires ensuring database best practices, monitoring system performance, developing solutions for process improvements, and maintaining data integrity through robust backup and recovery procedures. Responsibilities include supporting testing, implementation, troubleshooting, and root cause analysis of database systems and related software.

Requirements

Bachelors degree in Computer Science, Business or related field or equivalent experience.
Six years experience in database analysis and design concepts.
Extensive knowledge of both the EBS application and database with version 19C
General overall Oracle DBA experience with VLDB (very large databases) in a production environment
Bi-weekly EBS patching experience required
Solid understanding of software development methodologies including Waterfall and Agile
Advanced SQL coding and operating systems skills
Advanced understanding of logical and physical database design concepts
Solid analytical, problem solving and time management skills
Strong technical writing skills
Advanced understanding of Database Management System software
Eight years experience in database analysis and design concepts

Nice To Haves

Seeking a senior Oracle E-Business Suite application database administrator with experience in operational dba work as well
Expertise must include upgrading, patching, performance tuning strong EBS knowledge
Familiarity with EBS purging functionality
Ability to do independent research and find solutions on their own
EBS password administrator
Experience with GL wand would be a plus
Ability to work in team environment and excellent trouble-shooting skills
Available for on-call rotational shift
Ability to work in a fast-paced environment with minimal direction
Expert knowledge of Unix (preferably AIX)
Advanced analytical, problem solving and time management skills
Advance technical writing skills

Responsibilities

Provides continuous support and education to IT analyst and development staff to ensure DB best practices are used in all projects.
Ensures optimum performance and efficient use of system resources for new applications by monitoring application processes during development and production installs.
Regularly monitors DB system and alerts DBAs, capacity or tech teams, as appropriate, of potential issues.
Develops solutions to improve the effectiveness of the processes and procedures used by DBA staff.
Provide documentation to DBA staff on improvements.
Following DBA guidelines and best practices for backup and recovery - ensures data integrity for assigned applications by designing backup procedures with consideration for quick onsite recovery and disaster recovery at an offsite location.
Supports testing, implementation and break-fix troubleshooting and root cause analysis.
Participates in the testing of the database system when new releases or maintenance is applied to the RDBMS and related software and identifies and documents issues.
Performs other duties as assigned.
Overall responsibility for DB system, including but not limited to, tuning, performance, maintenance, backup and recovery, OS compatibility and issue resolution.
Coordinates activities with Capacity, Tech Support, DASD/SAN Admin, Server/Desktop Support and IT operations.

Benefits

Laptop, monitors, keyboard, mouse and headset provided.
Access to on-site fitness centers or gym membership reimbursement.
On-site cafeteria at Brooklyn, OH headquarters.
Discounts at many places in and around town.
Opportunity to earn cash rewards for shopping with customers.
Business casual attire, including jeans.
Employee bonus program.
401(k) with company match up to 4% and an additional company contribution.
Health Savings Account with a company matching contribution.
Excellent medical, dental, vision, life and disability insurance.
Access to an Employee Assistance Program.
Company holidays.
Up to 16 PTO days during the first year of employment with options to carry over unused PTO time.
Parental leave for eligible employees who become parents through maternity, paternity or adoption (after 120 days of service).
Career development programs and classes.
Mentoring and coaching.
Tuition reimbursement up to $5,250 per year.
Diverse, inclusive and welcoming culture with Business Resource Groups.