IT Oracle Database Administrator

A Brief Overview

The Oracle Database Administrator is responsible for the maintenance and support of the Oracle eBusiness Suite and ancillary applications while working directly with peers, application developers, and business analysts to meet the operational needs of the organization. In addition, this role acts as a liaison between the organization, application vendors, and their technology staff to ensure the database environment meets organization policies and regulatory requirements in conjunction with application requirements.

• Perform database system management functions (e.g. software installs, version upgrades and configuration management, security).
• Define database objects and relationships as indicated based on requirements of the Oracle application.
• Implement data models, database structure design, database documentation, backup, and recovery processes.
• Perform assessments to identify, test, and resolve moderately complex database performance issues (e.g. monitoring and tuning).
• Perform timely code and technical design reviews.
• Work directly with IT leaders, business partners, and vendors to implement database environments that meet organization security standards and regulatory requirements.
• Ensure database environments are properly installed and implemented and utilize appropriate backup strategies.
• Perform moderately complex modification, testing and debugging tasks on vendor-supplied utilities and packages to ensure fit with current operating environment.
• Support escalation of issues with appropriate internal resources.
• Support the development and maintenance of system documentation.
• Perform all technical support of assigned applications.
• Utilize and maintain appropriate change control procedures and standards.

Additional Responsibilities

• Perform on-call rotation duties in a 24x7 environment and other duties as required
• Performs other duties as assigned.
• Complies with all policies and standards.
• For specific duties and responsibilities, refer to documentation provided by the department during orientation.
• Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace.

Education Qualifications

• High School Equivalent / GED or equivalent (Required) and
• Bachelor's Degree in Computer Science/Business Management (Preferred)

Experience Qualifications

• 3+ years experience as a Oracle database administrator in an enterprise environment (Required) and
• Technical experience and functional knowledge supporting Oracle eBusiness Suite (EBS) R12.2 in an enterprise environment (Required) and
• Experience with Oracle PL/SQL (Required) and
• Experience performing controlled code migrations through development environments to production environments (Required) and
• Experience working with Oracle Support to analyze and resolve technical issues (Required) and
• Experience supporting the following technologies: OAM, OID, Oracle RAC, ASM, Weblogic on Linux/UNIX. (Preferred) and
• Experience supporting the following applications: Hyperion Financial Suite, OBIEE/OBIA, Kofax for Accounts Payable. (Preferred) and

Skills and Abilities

• Knowledge of shell scripting (Required proficiency)
• Strong problem solving skills with ability to research and analyze information (Preferred proficiency)
• Knowledge of MS Office (Required proficiency)
• Strong written and verbal communication skills with ability to organize and communicate thoughts in a user-friendly manner (Required proficiency)

Licenses and Certifications

• Oracle Database Administrator Certification (Preferred)

Physical Demands

• Standing Occasionally
• Walking Occasionally
• Sitting Constantly
• Lifting Rarely up to 20 lbs
• Carrying Rarely up to 20 lbs
• Pushing Rarely up to 20 lbs
• Pulling Rarely up to 20 lbs
• Climbing Rarely up to 20 lbs
• Balancing Rarely
• Stooping Rarely
• Kneeling Rarely
• Crouching Rarely
• Crawling Rarely
• Reaching Rarely
• Handling Occasionally
• Grasping Occasionally
• Feeling Rarely
• Talking Constantly
• Hearing Constantly
• Repetitive Motions Frequently
• Eye/Hand/Foot Coordination Frequently

Travel Requirements

• 10%