Job Description :
Role:-Oracle DBA with PL/SQL experience
Location:- Cincinnati, OH
Duration:- Fulltime Hire

- REQUIRED: 7 years of relevant experience as an Oracle DBA for Oracle 10g/11g and higher and Oracle PL/SQL experience required.
- HIGHLY PREFERRED: Experience in/around Identity Access Management applications.
- Ability to actively participate in technical discussions providing valuable input regarding RDBMS environment
- Ability to provide accurate and realistic effort estimates, commit and deliver accordingly
- Ability to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects.
- Ability to work productively in a team environment and participate as a positive and cooperative team member.
- Ability to perform data movements using export/import tools: DATA PUMP, EXP
- Ability to build databases, database cloning, and database refreshes
- Ability to backup and restoration using Data Pump and RMAN
- Ability to work in AIX UNIX environments and writing Shell scripts
- Add automation for database tasks where necessary
- Implement and maintain physical database designs for pre-production environments
- Configure and manage Oracle databases (RAC/Data Guard) for high availability and data synchronization
- Manage the process to define physical database design changes for production environments, get required approvals, and engage production DBA resources to perform the changes
- Create and maintain logical and physical data model designs
- Create database objects (tables, indexes, etc in pre-production
- Manage the process to promote database objects to production
- Develop database procedures, functions and triggers
- Assist developers with database activities
- Tune database queries
- Monitor application related jobs and data replication activities