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 DescriptionPermanent/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
- S Retail-POS DM
- Many integrating apps(Hyperion)
- Hana 7.4 upgrade
- ABAP, Hana optimization
- POS DM 1.0 changes in Hana 7.4
- Greenfield approach - PCA Delta migration
- EhP5 to EhP7
- SAP PI integration platform
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
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.








