Company Description
About Sopra Steria
Sopra Steria, a major Tech player in Europe with 50,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. 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 team-oriented 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 2024, the Group generated revenues of €5.8 billion.
Job Description
The world is how we shape it.
Role: Oracle Database Artchitect
Experience: 11 to 15 years
Location: Noida
Education: B.E./ B.Tech./ MCA
Oracle Database Architect is responsible fto manage, maintain, and optimize our products databases. The DBA will ensure data integrity, security,
and availability while supporting business requirements , applications and analytics. This role requires expertise in database design, performance tuning, backup/recovery, and troubleshooting.
Must Have:
- Query Optimization: Analyze and optimize very complex SQL queries for performance improvements.
- Performance Reporting: Generate and interpret AWR (Automatic Workload Repository) reports to identify bottlenecks and recommend solutions.
- Conceptual & Logical Design: Utilize enterprise data modelling tools such as PowerDesigner/ ERWIN for conceptual-level database modeling and ensure alignment with logical/physical design.
- PL/SQL Development: Provide strong expertise in PL/SQL programming for stored procedures, triggers, and packages.
- Scripting Knowledge: Develop and maintain scripts for automation, monitoring, and maintenance tasks (e.g., shell scripting, Python, or similar).
- Participate in architectural and environment volumetr