Oracle Applications DBA

Skills

Develop and maintain both application and database tuning and connectivity standards policies and procedures ensuring compliance with industry best practices and security regulations Follows defines and manages enterprise level policies and procedures that ensure the security optimization and integrity of Oracle database environments Manages database backup & recovery procedures disaster recovery preparation and the associated exercises Migrating code database changes and data through the various stages of development Database patching and upgrade support Diagnoses/anticipates and resolves database performance capacity and replication issues Participates in client/project meeting(s) for needs assessment and design review Manages database backup & recovery procedures disaster recovery preparation and the associated exercises Collaborates with SAN server applications and operational staff in support of database objectives Manage Concurrent Programs Request Sets Request Groups Workflows and troubleshoot Workflow Mailer/Notification issues and take care of user access. Use monitoring tools to proactively monitor systems and respond to various system generated alerts. Administer and maintain Single Sign- On for Oracle Applications Utilize Applications DBA utilities to support/maintain the multi-node environment to tune and improve database performance. Administer and maintain the Oracle Service Oriented Architecture (SOA) Oracle WebLogic Server to support Oracle EBS system connectivity with integrated systems Analyze Patches and build execution steps. Perform Oracle EBS Applications database administration (DBA) tasks including patching (adop cycle and opatch) cloning creating backup/recovery strategies upgrading performance tuning. Setup DR environment and supporting periodic DR drills. Perform code and patch migration to non-prod and production environment using the deployed tool or manually by adhering to the set change control policies and procedures. Establish contribute and adhere to all key departmental operating procedures around governance project management software lifecycle management change management and provide oversight on key delivery of application topology solutions and enhancements as needed. Work closely with Oracle Support and partners. Perform other Oracle EBS DBA related activities.

Description

The Database Administrator maintains the integrity of data including the logical, physical design and implementation of databases. In this role, you'll be responsible for database management including the performance and recoverability of databases, application administration, patching and upgrades. This position will work closely with our Application, Operation and Security teams to build out future application roadmaps.

The employee’s primary duty must be the performance of office or non-manual work directly related to the management or general business operations of Helena or Helena’s customers. This also includes the exercise of discretion and independent judgement with respect to matters of significance.

Responsibilities

• Bachelor's degree in computer science, IT or related field is required.
• 5+ years of solid hands-on experience as an Oracle EBS Applications DBA combined with Oracle Applications system administrator, Oracle WebLogic Administrator and related technologies to maintain, upgrade, and support a multi-node Oracle EBS database 12c/19c and Oracle ERP Application R12.2
• Strong hands-on experience with scripting on Unix and Linux environments using Shell, Perl, SQL, PL/SQL.
• Knowledge in AIX v7.1/v7.2, Linux, IBM P series hardware, Storage Area Network, Rubrik maintenance is required.
• Experience in application monitoring using Grid Control and other tools is required.
• Experience in cloud migration is preferred.

Educational Requirements

• · Strong analytical skills
• Familiarity with Oracle EBS technical tools like Oracle Application Framework, BI/XML Reports, Java, JVM, JSP, Oracle Forms/Reports, Interfaces, Workflow etc.
• Technical and functional knowledge of the Oracle E-Business Suite.
• Web services (REST or SOAP) Development.
• Architecture (Cloud, Web Services, SOA).
• Self-starter and able to deliver results on a proactive and independent basis.
• Ability to work independently with limited general supervision.
• Verbal and written communication skills.
• Interpersonal skills.
• Works well in a team environment.
• Partners with both business and technical team members.