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
             

Similar Jobs you may be interested in ..