Request ID:BL-9287-1 (912190427)
Oracle DBA with MarkLogic, NoSQL, modeling, optimization, tuning, Data Guard, RAC, OEM, ASM, ORM, SQL Server Management Studio, DW/Data Marts, SOA, ITIL/ITSM, DevOps, Managed Services and healthcare/Medicaid experience
Location:Columbia SC
Duration:12 Months Hrs/Wk:40.00
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• MarkLogic Nosql Database
• 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, and ORACLE Recovery Manager
• Understanding of SqlServer Management Studio
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 architecture
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
Experience
Database PlatformsOracle Active Data GuardYes3AdvancedWithin 6 Months4 – 6 Years
Database PlatformsOracle RACYes2AdvancedWithin 6 Months4 – 6 Years
Database PlatformsSQL ServerYes4AdvancedWithin 6 Months1 – 2 Years
ERPOracle Enterprise Manager (OEM)Yes2ExpertWithin 6 Months4 – 6 Years
ProtocolsOracle DatabaseYes1ExpertWithin 6 Months4 – 6 Years
Additional Skills:Experience with MarkLogic and NoSQL database administration and maintenance.
Remote Work Availability:0%
Notes to recruiters:
• This position requires both technical skills and people skills.
• This position is planned to be multi-year.
• This position requires excellent communications skills.
Serious candidates should read the following document prior to an interview:
https://www.scdhhs.gov/sites/default/files/SCDHHS_Replacement_MMIS_RFI_6.pdf
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, upgrades and perform backups for MarkLogic NoSql Databases.
• 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 24×7 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.
• Provide support for SQLServer databases by performing database management and performing daily routines in a mission critical 24X7 environment.