Job Details

Email to Friend Save Back

Senior Oracle DBA

CHICAGO-60606, IL, US
01/04/2019

-

Required Skills

Linux

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

Oracle DBA

Position Purpose: The Oracle DBA works in and manages a complex Oracle production and development environment.

This environment consists of Oracle databases, Oracle RAC/ASM, Banner Student System, Oracle Internet Directory, Oracle BPEL, and an Enterprise Data Warehouse.

In addition, this person will interact with many constituencies to develop database solutions to business problems.

Also, assists Development DBAs with the design of tables, relationships, stored procedures and triggers.

Works independently to ensure that the database is operating efficiently and ensures that proper backup and disaster recovery methods are maintained

Primary Accountabilities/Responsibilities:

Support, design, tune and maintain a complex Murex installation

Uses skills and knowledge of Database architecture, development, support, maintenance, plans and coordinates the activities related to running production development/ test/ QA
Applications environments. Develops and implements solutions for database sizing/capacity, server requirements and space requirements.

Resolves help desk tickets as assigned and provides 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.

Designs, develops, implements, and supports physical database design structures that accommodate large transactions and high availability architecture.

Designs, develops, implements, and tests enterprise backup and recovery solution, including Disaster Recovery initiatives.

Applies significant experience with Performance Monitoring, database tuning, identification and correction of performance bottlenecks to ensure peak performance.
Creates and maintains knowledge base to improve maintenance and reliability.

Provides input to forecasts future of database/ application administration, monitoring, and testing tools. Provides training to enhance the use and value of these tools.

As assigned researches, plans, and performs database upgrades, application of bug fixes, and the implementation of security policies.

Works with the Networks and Systems groups to design platforms that are robust enough to support the needs of the database.

Works with development team to implement change management for custom code migrated into environments.

In accordance with established guidelines designs/ develops processes/ procedures for loading data, conversions, batch job operation, and does high level trouble-shooting of development and production systems independently.

Provides training and ongoing support of these processes/ procedures and helps to build the knowledge of less senior DBA's.

Job Requirements:

Minimum 5 years of experience in Information Technology with a minimum 3 years as an
Oracle DBA.

Experience with MS SQL Server or MySQL would be a plus.

Experience creating data models of databases, and monitoring/tuning database performance

Experience working in a 24/7/365 operation.

Bachelor's Degree in Computer Science, or equivalent required. Masters preferred.
Additional Certification a plus.

Experience supporting ERP Systems. Banner Student System preferred.

Experience installing and supporting middleware technologies a strong plus, preferably
Oracle Application Server (OAS), Apache, Tomcat, Oracle Fusion Middleware, Oracle WebLogic Server.

Experience with RMAN, OID, LDAP, Data Guard and Data Warehouse preferred.

Proven track record in managing and tuning large volume Oracle databases.

Experience in UNIX or Linux environment required.

Experience developing applications in an Oracle environment (Forms, Reports, PL/SQL) a plus.

Excellent communications skills.

Experience with backup, recovery, and disaster recovery process/scenarios.