Oracle Apps DBA Technical Lead

About Sopra Steria
Sopra Steria, a European tech leader recognised for its consulting, digital services and software development, helps its clients drive their digital transformation to obtain tangible and sustainable benefits. It provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a fully collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. With 50,000 employees in nearly 30 countries, the Group generated revenue of €5.1 billion in 2022.  The world is how we shape it.

Sopra Steria (SOP) is listed on Euronext Paris (Compartment A) – ISIN: FR0000050809  For more information, visit us at www.soprasteria.com

Job Highlights

• Strong Experience in handling System Administration, Application Developer and Functional Administration Responsibility
• Good experience on EBS Patching and Cloning Activities
• OEM Monitoring Experience Configurations and Support
• Good communication skills

Roles and Responsibilities of Oracle APPS DBA

• Installation, configuration and upgrading of Oracle server software and related products.
• Starting and Stopping the application
• Monitoring the application related products like oacore, oafm apache etc.
• Bouncing apache,oacore,oafm if needed
• Establish and maintain backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Work as part of a team and provide 24×7 support when required
• Perform general technical trouble shooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Patch Management and Version Control.
• Perform database tuning and performance monitoring.
• Perform application tuning and performance monitoring.
• Cloning DEV and TEST from PROD.
• Perform all core DBA activities.
• Support and migrate databases from on prim to cloud with Oracle e-business suite part of setup.

Daily activities:

L2 Apps DBAs mainly work on daily/scheduled/ad-hoc activities such as:

• Code Migration Support to Functional Consultants
• Handling tickets raised by functional/technical/business users
• Handling Alerts raised by alert monitoring system from Database and applications
• Tablespace Reorg Activities to improve the performance/to reclaim the unused space
• Schema Reorg Activities to improve the performance
• Patch Analysis where there is a patch needs to be applied
• Patch Application as per schedule
• Cloning as per schedules
• Backups and issues related to them
• Query response time and other Performance Issues
• Work with Oracle Support by raising SRs on several issues
• Monitoring Standby Databases and resolve respective issues
• Regular database maintenance activities (tablespace management, datapump, purging logfiles……)

• New Environments Build/Setups
• Designing Backup/Recovery policies
• Installing new Application environments
• Post-Installation Tasks of New environments
• Integrating E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM …)
• Work on integration issues
• Work on Cluster setups for both applications and databases
• Work on Standby site setups for both applications and databases
• Interact with Network/OS teams on network setups and load balancer setups.
• Fail-over capabilities testing of E-Business Suite and database
• Design Cloning strategies.
• Work on design related issues.
• Capable to support Oracle cloud environment.
• Capable to perform DB migration from on-prim to cloud where ON-Prim environment consists of Oracle e-business suite.

Total Experience Expected: 06-08 years

.

At Sopra Steria, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.