Oracle Database Administrator

DBA, Oracle EBS, Oracle DBA, Troubleshooting, apps dba
Full Time
$100,000 - $130,000

Job Description

Oracle Database Administrator 

Winston Salem, NC

Full-Time/Permanent

 

Salary range + 8% Bonus + Relocation assistance

 

We are not able to provide sponsorship, So no H1B transfers

 

  • Here requiring 5+ years exp.as a 24x7 Database Administrator, performing Oracle e-Business Suite R12.2.x administration and Oracle RAC administration on first shift but will have to be on call, on an on call rotation schedule and provide support every other weekend and also will have to work on 2nd shift for a month at a time 1 to 2 times per year also.
  • Bachelor's in Information Technology or equivalent is required.
  • We are not able to provide sponsorship at this time so would need someone that will not require visa sponsorship now or in the future!

 

POSITION SUMMARY STATEMENT:

The Database Administrator III is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators are also responsible for understanding, configuring, and managing database administration tools

 

 

DETAILED RESPONSIBILITIES/DUTIES:

Level III

Provides shift and non-shift support for Oracle e-Business Suite R12.2.x  database support for business applications and schedule back up jobs for user databases

Meet service level agreements for production support response and resolution.

Troubleshoot and tune Oracle e-Business and Non-ERP Oracle Databases and contribute to technical performance analyses and enhancements.

Provides access control (password resets /account creation/deletion) and check IP compliance (violation report review, compliance updates and compliance set ups)

Performs data purging and data replication activities

Researches on connectivity issues and recurring errors in Application database.

Responds to database alerts and take appropriate actions

Supports database creations

Performs performance tuning and troubleshooting for database

Performs application database maintenance and provide technical assistance to the users

Manages database account access and database object changes

Ensures that monitoring and alerts are properly in place to meet monitoring requirements

Performs application database and OS scripting

Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set ups)

Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery.

Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations. Also involved in database, schema and object refresh activities

Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective resource utilization/emergency recovery procedures.

Performs Business Continuity/Disaster Recovery activities during Business Continuity Plan events

Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes

Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes

Implements database security and auditing features and periodic reviews. Conducts root cause analysis for repeated incidents

Performs heterogeneous database interface deployment and support for various data interfaces with applications, Middleware interface and functionality deployment with database architecture

Plans and develops processes for database updates and migrations to a higher/lower version or cross platform migrations. Also, involved in database, schema and object refresh activities

Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures

Conducts team training. Also responsible for resource management

Provides escalation Level 2 and 3 Technical 24x7 support

Researches new technologies to address operations reliability and compliance

Implements and performs configuration management of database cluster and replications

 

QUALIFICATIONS:

Skills:

 

Required

Strong written and verbal communication skills

Attention to detail, and excels operating in a fast-paced technical environment

Ability to solve problems, identify solutions, and appropriately escalate issues

Expertise in relational databases (e.g., Oracle)

Proficiency in database architecture, logical and physical design, documentation, installs, shell scripting, programming (e.g., PL/SQL), query tuning, system tuning, automation, backup and recovery, standby

 

Certificates / Training:

Preferred: Database Certifications (e.g., Oracle Certified Professional)

 

Experience:

Level III

5+ years experience as a 24x7 Database Administrator, performing Oracle e-Business Suite R12.2.x administration and Oracle RAC administration

Ability to provide shift and non-shift support as well as support every other weekend.

Knowledge of GoldenGate and OBIEE is preferred

 

Education:

Required

Bachelor's in Information Technology or equivalent

Dice Id : objectwi
Position Id : MK- 20052021
Originally Posted : 5 months ago
Have a Job? Post it