Job Description :
Location: Columbus OH
Duration:6+ months
Roll: Columbus, OH - IT - INS - Database Administrator 4/DBA4 61691
Ohio Department of Insurance – Contractor skill requirement (04/26/2019)
Database Administrator 4 (This position will likely extend into FY20
Columbus, OH - IT - INS - Database Administrator 4/DBA4 61691
Job Title: Database Administrator 4/DBA4
Interviews: Onsite Interviews Only
Will Close to Submissions on: Friday 3/5
06/30/2019
50 West Town Street
City
Columbus
State
Ohio
Zip
43215
Country
UNITED STATES
Job requirements
Skills
No of Years
Experience in Oracle 12c multi-tenancy administration
7
MS SQL server admin
5
SQL Performance tuning
5
Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
7
Experience in Oracle Data Guard administration
6
Expert with PL/SQL and stored procedures in Oracle and SQL Server
7
Experience with participating in SCRUM and/or Agile methodologies, and following timelines to complete projects on time
4
Experience leading/mentoring team members
5
Experience in triage and troubleshooting issues.
3
Demonstrate organizational and interpersonal skills
5
Complete Description: The ALPS project name: INS ODIIS ENH
The Department Of Insurance uses Oracle 12c as the primary database for their regulatory system. Microsoft SQL Server is used for the data warehouse, SharePoint, and Imaging systems. The department is also in the process of migrating all server hardware to the State’s SOCC which includes migrating the Oracle databases to an EXA data platform and virtualizing the SQL Servers.
The Contractor is responsible for administering the Oracle 12c database in multitenant mode. The candidate should have in depth knowledge about disaster recovery using Oracle Active data guard,
Database tuning, SQL tuning, Database Design Data Administration, Data View Creation & Management, Data Warehouse Development and Management, and Data Backup & Recovery. Tasks are performed to ensure data system availability throughout the development and testing lifecycle and production use of mission critical systems.
Candidates with extensive experience in PL/SQL, Debugging stored procedures, ETL will be