Oracle Database Administrator

AAR - Wood Dale, IL

Full-time - Mid Level

Wood Dale, IL

Transportation Equipment Manufacturing

About the position

The Database Administrator will work with all aspects of Oracle database administration including but not limited to design, installation, configuration, upgrades, capacity planning, performance tuning, backup recovery, and patch management. Work across multiple Database Management Platforms e.g., Oracle, PostgreSQL, MS SQL, MySQL.

Responsibilities

• Fully support, configure, maintain, and upgrade database environments on premise and in the cloud.
• Support all database efforts including day to day workloads and large, high-impact projects.
• Monitor and support Oracle WebLogic Middleware.
• Develop and maintain standards and procedures for the DBA team and automate routine tasks.
• Participate in migration efforts of legacy on-prem databases to SaaS or IaaS options.
• Responsible for application deployments, configurations, certificate management, analyzing error logs, tuning, and http server troubleshooting.
• Performs database modifications as required to support system enhancements, implementations, maintenance, and data recovery.
• Monitors database integrity in a proactive manner with respect to hardware corruption, software malfunctions, and user error.
• Supports the AAR development staff in the areas of database design as it relates to reliability, resource utilization, practical operations, database environment, bug fixes, and interaction with vendor support.
• Database backup and recovery.
• Disaster recovery planning and testing.
• Provide analysis for system updates.
• Monitor and action environment performance and tuning.
• Resolve problems reported by end users and remote admins.
• Research and make recommendations on environment administration.

Requirements

• Should have advanced knowledge of administration of but not limited to MS SQL, PostgreSQL, and Oracle for performing maintenance of the databases and upgrading the system, including patches, service packs, security configurations, hot fixes and disaster recovery.
• Must be capable of acquiring more knowledge by continuing education or through other avenues.
• Strong interpersonal skills: the ability to work well with people from many disciplines and with varying degrees of business and technical experience.
• Must have experience working with Cloud database offerings and migrating applications data from legacy databases.
• Strong, recent database administration technical skills, knowledge and background.
• Excellent knowledge of best practices around management, control, and monitoring of database infrastructure.
• Excellent written and oral communication skills; ability to describe complex, highly technical issues using simple, clear, and precise language.
• Great at organizing, prioritizing, and multitasking.
• Strong troubleshooting skills.
• Technical writing skills are required for database management documentation and procedures.
• Bachelor's degree in related field or 5 years' work experience in database administration and other related database technologies.
• Holding credentials that demonstrates ability to perform a specific level of tasks related to database administration.
• Able to review and make decisions regarding the software and hardware required to meet the organization's needs.
• Training users in the proper use of company computer technology.
• Troubleshoot database operation errors and slowness.
• Experience working with RHEL and Windows environments.

Benefits

• Competitive salary and bonus package
• Comprehensive benefits package including medical, dental, and vision coverage.
• 401(k) retirement plan with company match
• Generous paid time off program
• Professional development and career advancement opportunities