IT Database Analyst
Description:
IT Database Analyst
Medical Mutual employees must submit their applications through MySource. This is a hybrid-remote role based out of the Brooklyn, OH or Dublin, OH office, with employees expected to work onsite on designated in-office days each week. Seeking Oracle DBAs experienced in Oracle E-Business Suite.
Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.2 million members through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.
Database Analyst IV
Job Summary:
Provides increasingly complex cross-functional strategic, analytical and technical support for database-related activities while working under some supervision. Performs activities as directed by management and senior staff to support projects that require DBA staff involvement. Assist in problem identification and issue resolutions. As needed, work with IT project teams and technical staff to collect, clarify and translate project requirements into required database design.
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.
Qualifications:
Education and Experience:
Bachelors degree in Computer Science, Business or related field or equivalent experience.
Six years experience in database analysis and design concepts.
Technical Skills and Knowledge:
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
Database Analyst V
Job Summary:
Provides increasingly complex cross-functional strategic, analytical and technical support for database-related activities while working under some supervision. Performs activities as directed by management and senior staff to support projects that require DBA staff involvement. Assist in problem identification and issue resolutions. As needed, work with IT project teams and technical staff to collect, clarify and translate project requirements into required database design.
Responsibilities:
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.
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 applications.
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.
Qualifications:
Education and Experience:
Bachelors degree in Computer Science, Business or related field or equivalent experience
Eight years experience in database analysis and design concepts
Technical Skills and Knowledge:
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
Advanced analytical, problem solving and time management skills
Advance technical writing skills
Advanced understanding of Database Management System software
Medical Mutual is looking to grow our team! We truly value and respect the talents and abilities of all of our employees. That's why we offer an exceptional package that includes:
A Great Place to Work:
We will provide the equipment you need for this role, including a laptop, monitors, keyboard, mouse and headset.
Whether you are working remote or in the office, employees have access to on-site fitness centers at many locations, or a gym membership reimbursement when there is no Medical Mutual facility available. Enjoy the use of weights, cardio machines, locker rooms, classes and more.
On-site cafeteria, serving hot breakfast and lunch, at the Brooklyn, OH headquarters.
Discounts at many places in and around town, just for being a Medical Mutual team member.
The opportunity to earn cash rewards for shopping with our customers.
Business casual attire, including jeans.
Excellent Benefits and Compensation:
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 — insurance is what we do best, and we make affordable coverage for our team a priority.
Access to an Employee Assistance Program, which includes professional counseling, personal and professional coaching, self-help resources and assistance with work/life benefits.
Company holidays and up to 16 PTO days during the first year of employment with options to carry over unused PTO time.
After 120 days of service, parental leave for eligible employees who become parents through maternity, paternity or adoption.
An Investment in You:
Career development programs and classes.
Mentoring and coaching to help you advance in your career.
Tuition reimbursement up to $5,250 per year, the IRS maximum.
Diverse, inclusive and welcoming culture with Business Resource Groups.
About Medical Mutual:
Medical Mutual's status as a mutual company means we are owned by our policyholders, not stockholders, so we don't answer to Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us.
There's a good chance you already know many of our Medical Mutual customers. As the official insurer of everything you love, we are trusted by businesses and nonprofit organizations throughout Ohio to provide high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement and individual plans. Our plans provide peace of mind to more than 1.2 million Ohioans.
We're not just one of the largest health insurance companies based in Ohio, we're also the longest running. Founded in 1934, we're proud of our rich history with the communities where we live and work.
We maintain a drug-free workplace and perform pre-employment substance abuse and nicotine testing.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.