Job Description :
Title: Sr. Oracle DBA

Location: Columbia SC

Duration: 12 Months

Job Description

Scope Of The Project:
The Replacement Medicaid Management Information System (MMIS) project is one of the largest IT projects for the State of South Carolina. It is a multi-year effort to replace the State’s aging MMIS and related applications with more modern capabilities along with corresponding business operations services.

DAILY DUTIES / RESPONSIBILITIES:

The RMMIS ORACLE Application DBA is responsible for managing all database related technical aspects for the engineering and software development life-cycle (SDLC) for a replacement MMIS database. The project is a multi-year effort that will be one of the largest IT projects in the State. The State plans to conduct a multi-vendor design and development effort.

Duties And Responsibilities Include:

Installs and configures ORACLE database software, creates data models, develops naming conventions and DB change control procedures;
Install and configure ORACLE databases with a traditional configuration on a RedHat/ORACLE Linux server
Manage ORACLE database architecture, interconnections, and schemas for the storage and retrieval of MMIS information in a high transaction rate, mission critical 24x7 environments.

Support database operations and work closely with application and infrastructure group for MMIS Replacement initiatives.
Assist Enterprise Architect with overall planning needs for the database design and data modeling;
Provide formal and/or information training in DBMS administration and maintenance, database design, analysis, and management.
Contribute to service design and support for a service oriented architecture (SOAbased system

Required Skills (Rank In Order Of Importance):

Seven or more years in a development or service administration role using the following skills:

Oracle database 11g and 12c
Demonstrate knowledge and ability to perform all basic database management and administration skills
Demonstrate practical understanding of ORACLE database physical structure, overall architecture, and database performance analysis

Strong background in database planning, scaling, and capacity planning activities
Experience in database design and data modeling, index creation, database optimization, and performance tuning.
Strong understanding of software development life-cycles

Experience deploying and configuring ORACLE Data Guard, ORACLE Enterprise Manager, ORACLE Automatic Storage Management, ORACLE ACFS, ORACLE Golden Gate, and ORACLE Recovery Manager.
Experience performing/configuring RMAN backup and recovery.

Professional Skills:

Strong communication (written and oral) and interpersonal skills
Self-starter, with a keen interest in technology and highly motivated towards success
Must show initiative and desire to learn business and technology subjects
Able to work independently and provide updates to management
Strong analytical and problem solving capabilities
Excellent problem solving skills; proven teamwork and communication skills
Demonstrated teamwork and collaboration in a professional setting

Preferred Skills (Rank In Order Of Importance):
Experience in a healthcare insurance environment (Medicaid preferred
Public sector procurement experience is a plus.
Experience with Data Warehouses and/or Data Marts
Oracle or SQL certification
Experience in the design and application of service-oriented architectures.

Required Education/Certifications:
Bachelor’s degree in computer science, engineering, or another related field is required.
5+ years of ORACLE database administration experience
5+ years of experience working with development teams
Exposure to ITIL / ITSM / Managed Services / DevOps / SOA operational models



Skills:

Category


Name


Required


Importance


Level


Last Used


Experience


Database Platforms


Demonstrate practical understanding of ORACLE database physical structure, overall architecture, and database performance analysis


Yes


1


Advanced


Currently Using


4 - 6 Years


Database Platforms


Oracle 11G


Yes


1


Advanced


Currently Using


1 - 2 Years


Database Platforms


Oracle 12


Yes


1


Advanced


Currently Using


1 - 2 Years


Database Platforms


Oracle Architecture


Yes


1


Advanced


Currently Using


2 - 4 Years


Database Platforms


Oracle Installations


Yes


1


Advanced


Currently Using


2 - 4 Years


Database Platforms


Oracle RDBMS


Yes


1


Advanced


Within 6 Months


2 - 4 Years




If Interested please provide me below information:

Full Name:

Email ID:

Contact:

Address:

Availability:

Availability for Interview:

Visa Status:

Visa Expiry date (MM/DD/YYYY):

Relocation:

Rate:

SSN Last 4 Digits:



Professional Reference :

Full Name :

Company Name :

Title :

Telephone :

Email id :