Company Description
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 atwww.soprasteria.com
Job Description
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
- 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.
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.
Qualifications
Additional Information
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.
Skills: EBS, ipm, Soa, Otm, Oracle, Oracle Cloud, Osb, Database, Obiee
Experience: 6.00-8.00 Years