Short Description:
The Database Administrator is responsible for data analysis and database architecting services.
Complete Description
This position is for the BWC Core Direction project. BWC is currently operating in an environment with limited to moderate automated functionality and data access. Many business processes have manual or system (e.g., Excel, Access, etc.) workarounds. Multiple applications are used to support single processes. Lack of data, when and where needed, lack of integration between existing legacy applications and implementation of business process change regardless of application support drive many of the workarounds. A portion of correspondence is manually generated and custom letter databases exist throughout BWC. Multiple processes utilize the same workarounds. Claims processes are the most mature, followed by billing processes with policy processes being the least mature.
The BWC Core System initiative, will replace several legacy systems with a claims, policy and billing COTS software solution known as Powersuite. These legacy systems include:
1. Claims processing – Version 3
2.Claims processing – Imaging
3.Policy Management and Billing – WCIS
The following legacy system’s functionality may be impacted by the BWC Core System initiative:
1. Rates and Payments – R&P
2.Ohiobwc.com
DBA (Oracle DBA)
•In-Depth Knowledge and Significant Experience with
-IBM Mainframe
ZOS 1.12
SAS
Oracle 10g
•DBMS Tools
-Oracle Enterprise Manager (OEM)
DB2 version 9
•DBMS Tools
-BMC Tools & Utilities
BMC Change Manager
-Sun Hardware
Solaris 8.X
Oracle 11G & 10.xG
Oracle Financials version 11.5
Perl
-Red Hat Enterprise Linux on X86 Hardware
Red Hat Enterprise Version 5.6/6.x
Oracle 12c
Perl
DBA would provide:
•Database analysis
•Troubleshooting services
•Database architecting services
•Services to optimize database performance
•Services to improve operations
•Documentation on installations and configurations
•Consulting services
•Installation services
•Implementation services
•Configuration services
•Customization services
•Responses to customer inquires
•Responses to trouble tickets
DBA would work approximately forty hours per week (more or less):
•Majority of hours would be during normal business hours (7AM – 5 PM)
Skills:
Oracle DBA in one of the following: IBM M/F- ZOS 1.12, SAS, Oracle 10g, BMC or Sun Hardware-Solaris 8.X, Oracle 10g&11g or Red Hat Enterprise 5.6/6.
Required 6 Years