SAP DBA Oracle

Posted 3 Days Ago
Be an Early Applicant
New York, NY, USA
In-Office
Senior level
Professional Services • Industrial • Manufacturing
The Role
Manage and support SAP Oracle databases in a 24x7 production environment: install/configure RAC and non-RAC databases, configure Data Guard, tune performance, develop PL/SQL, handle backups/migrations, and provide on-call support while coordinating with teams and stakeholders.
Summary Generated by Built In
Company Description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com.

Job Description

Permanent/Fulltime & Onsite


 Technical/Functional Skills  

Proficient different phases of database administration, architecture and capacity planning. Responsible for the daily technical support of SAP database systems. Works with the application development team, the infrastructure team, business units and the software vendors to develop and ensure a viable and consistent capacity and recovery solution.  

Roles & Responsibilities 

  • Oracle DBA experience (11g/12c)
  • Experience working with Oracle Database supporting SAP Applications. 
  • Manage SAP databases in a 24x7 mission-critical production environment.
  • Install / configure new databases in both RAC and non-RAC environments. 
  • Install / configure new Data Guard physical standby databases. 
  • Prepare / update storage diagrams for both ASM and non-ASM environments.
  • Use appropriate tuning methodology and tools to triage and resolve performance issues of SAP Oracle databases. 
  • Develop and maintain PL/SQL codes, primarily as store procedures.
  • Advanced knowledge of performance tuning methodologies and understanding of
  • Relational database join techniques like HASH, NESTED LOOPS etc. and the use of Oracle Hints.
  • Handle daily production issues and migration of SAP to new hardware and data center.
  • Experience with Oracle Advanced Compression  
  • Excellent communication skills are a must
  • Work comfortable with minimal supervision
  • 24x7 production on-call support during off-hours and weekend may be required
  • Establish and maintain good working relationships with the peers, management & leaders of the business area supported as well as within IT structure.
  • Ensure the smooth integration and / or roll-out of systems into the operational environment by communicating and coordinating closely with the affected functional and technical areas
  • Customer and results focused. A wide degree of creativity and latitude is expected.Excellent verbal, presentation and written communications skills. Ability to communicate with technical, non-technical, and senior management audiences.
  • Assume accountability for ALL projects that you and / or your team are responsible and involved in. 
  • Fully support the PMO process and other standards as adopted by the IT Department
  • Must have 5+ years of prior hands-on experience supporting SAP environment. 
  • Oracle PL/SQL in 11g/12c environment.
  •  Experience in SQL*Plus, UNIX (Solaris and Linux) and shell scripts. 
  • Strong hands on experience with Oracle GRID Control, RAC infrastructure, ASM and dataguard.
  • Extensive experience working with Oracle Recovery Manager and other backup solutions.
  • Must be able to lead initiatives in with a willingness to identify and drive consensus. 
  • Must have strong ability to multi-task.

Qualifications

Experience / Exposure in the following

  1. S Retail-POS DM
  2. Many integrating apps(Hyperion)
  3. Hana 7.4 upgrade
  4. ABAP, Hana optimization
  5. POS DM 1.0 changes in Hana 7.4
  6. Greenfield approach - PCA Delta migration
  7. EhP5 to EhP7
  8. SAP PI integration platform

Additional Information


Skills Required

  • Oracle DBA experience (11g/12c)
  • Experience supporting Oracle databases for SAP applications
  • 5+ years hands-on experience supporting SAP environments
  • Install/configure databases in RAC and non-RAC environments
  • Install/configure Oracle Data Guard physical standby databases
  • ASM and non-ASM storage planning and diagrams
  • Performance tuning of SAP Oracle databases (including Oracle hints and join techniques)
  • Develop and maintain PL/SQL code (stored procedures) in 11g/12c
  • Experience with Oracle Advanced Compression
  • Experience with SQL*Plus, UNIX (Solaris and Linux), and shell scripting
  • Hands-on experience with Oracle Grid Control, RAC infrastructure, ASM and Data Guard
  • Extensive experience with Oracle Recovery Manager (RMAN) and backup solutions
  • Ability to manage 24x7 mission-critical production environments and provide on-call support
  • Excellent communication skills and ability to work with minimal supervision
  • Experience/exposure to SAP HANA 7.4
  • Experience/exposure to ABAP and HANA optimization
  • Experience/exposure to SAP PI integration platform
  • Experience/exposure to Hyperion and POS DM
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
6 Employees
Year Founded: 2011

What We Do

EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.

Similar Jobs

Comcast Logo Comcast

Machine Learning Engineer

Digital Media • Information Technology • News + Entertainment
Hybrid
New York, NY, USA
115000 Employees
126K-189K Annually
Hybrid
3 Locations
1100 Employees
147K-278K Annually

PwC Logo PwC

Internal Audit/SOX Business Controls - Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
7 Locations
370000 Employees
77K-202K Annually

PwC Logo PwC

Oracle Alliance Driver, Senior Director

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
New York, NY, USA
370000 Employees
123K-123K Annually

Similar Companies Hiring

True Anomaly Thumbnail
Aerospace • Artificial Intelligence • Hardware • Machine Learning • Software • Defense • Manufacturing
Centennial, CO
300 Employees
Fortune Brands Innovations Thumbnail
Manufacturing
Deerfield, IL
10000 Employees
Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account