Oracle Apps DBA (Database Analyst)

Description:

Position Summary:

As an Oracle Apps DBA (Database Analyst) at Penske you will support production, DR, QA and development of databases for multiple applications. In this role, you will be expected to perform day-to-day activities such as backup/error recovery, monitoring, performance tuning, application patching, and upgrades. Understanding of Oracle Cloud technologies is essential.Off hours support and on-call rotation are required.

Day to day workload will be 40% Oracle database and 60% Oracle Apps (HR Suite).

Major Responsibilities:

• Supporting EBS 11i, 12.1 Application and 11g, and Oracle 12c , 18c, 19c databases

• Working on the ticketing system and tool on production/development EBS Database/ Application issues. Coordination with Oracle, Application Support team, Unix/Linux/storage, and other Application interface teams.

• Performing patching, cloning, taking backups, managing archives, and regular maintenance activities.

• Working with DBA team of offshore and onsite. Collaborating to have 24/7 support of the entire Oracle environment, which includes Oracle EBS and other Oracle databases.

• Providing DB reports such as backup reports, DB performance reports weekly.

• Establishing and documenting Backup Policies and procedures

• Assisting in the creation of database development standards and practices

• Tuning and configuring servers. Assisting the system administrators with getting the most out of the DB servers.

• Creating an Oracle statistics gathering strategy for OLTP and Data Warehouse based applications.

• Performing database application reviews for inefficient database code

• Working with the development staff to fully understands their database needs

• Other projects as assigned by the manager

Qualifications:

Qualifications:

• Bachelor’s degree

• 5 years of experience as Oracle Apps and core DBA.

• 5 years of working experience on Oracle EBS (11.5, 12.1).

• 5 years of working experience on Oracle Database (10g,11g,12c)

• 5 years of working experience on Oracle RAC/ASM/Data Guard/RMAN Backups and Restore/OEM

• Experience in custom configurations related to Oracle EBS environment

• Excellent knowledge of Oracle Database Partitioning and indexing strategy.

• Deep Understand Oracle HR related modules.

• Ability to troubleshoot performance problems using Oracle Traces (TKPROF, Trace Analyzer) and stats pack

• Oracle Performance tuning, specifically SQL, PL/SQL, and General DB tuning

• Experienced in shell scripting.

• Regular, predictable, full attendance is an essential function of the job

• Willingness to travel as necessary, work the required schedule, work at the specific location required, complete Penske employment application, submit to a background investigation (to include past employment, education, and criminal history) and drug screening are required.

Physical Requirements:

• The physical and mental demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The associate will be required to: read; communicate verbally and/or in written form; remember and analyze certain information; and remember and understand certain instructions or guidelines.
• While performing the duties of this job, the associate may be required to stand, walk, and sit. The associate is frequently required to use hands to touch, handle, and feel, and to reach with hands and arms. The associate must be able to occasionally lift and/or move up to 25lbs/12kg.
• Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception and the ability to adjust focus.

Penske is an Equal Opportunity Employer.

About Penske Truck Leasing

Penske Truck Leasing Co., L.P., headquartered in Reading, Pennsylvania, is a partnership of Penske Corporation, Penske Automotive Group and Mitsui & Co., Ltd. A leading global transportation services provider, Penske operates a premier fleet of vehicles and serves its customers from locations in North America, South America, Europe, Australia, and Asia. Penske’s product lines include full-service truck leasing, contract maintenance, commercial and consumer truck rentals, used truck sales, transportation and warehousing management and supply chain management solutions. Visit www.GoPenske.com to learn more.

 Work Locations: 5401 West Kennedy Blvd Suite 100 Tampa, FL 33609

Primary Location: United States-Florida-Tampa

Zip: 33609

Job: Information Technology

Penske (Oracle) Job Name: Information Technology

Req ID: 2001623