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 at www.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
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
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.
Top Skills
What We Do
Sopra Steria, a major Tech player in Europe with 56,000 employees in nearly 30 countries, is recognised for its consulting, digital services and software development. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group 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. In 2023, the Group generated revenues of €5.8 billion.
The world is how we shape it
