Job description

Title: Oracle Database Administrator Duration: 12+ months Location: Columbia, SC Description: Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. May require a bachelor's or master's degree in a related area and 7+ years of experience in the field or in a related area. SCOPE OF THE PROJECT: The Replacement Medicaid Management Information System (RMMIS) 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, eligibility system, and related applications with a modern, service oriented architecture based system. The South Carolina Department of Health and Human Services (SCDHHS) is planning a multi-vendor approach, which will demand exceptionally high quality team members. 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 both a traditional and RAC 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 (SOA)-based system REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): • 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. • Upgrading/migrating from one version of Fusion Middleware products to another version as needed. 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: • Bachelors 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 All your information will be kept confidential according to EEO guidelines.

Requirements

Must-haves

Oracle Database Administrator
Duration: 12+ months
Location: Columbia, SC
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 both a traditional and RAC 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 (SOA)-based system
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): • 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.
Upgrading/migrating from one version of Fusion Middleware products to another version as needed.
Experience with Data Warehouses and/or Data Marts
Oracle or SQL certification
Experience in the design and application of service-oriented architectures.
REQUIRED EDUCATION: • Bachelors degree in computer science, engineering, or another related field is required.

Nice-to-haves

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE): • Experience in a healthcare insurance environment (Medicaid preferred).
Public sector procurement experience is a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium