Oracle Database Architect at Sopra Steria

Noida, Uttar Pradesh, India -

Full Time

Start Date

Immediate

Expiry Date

22 Apr, 26

Salary

0.0

Posted On

22 Jan, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Query Optimization, Performance Reporting, Conceptual Design, Logical Design, PL/SQL Development, Scripting Knowledge, Production Support, Database Security, Backup Procedures, Recovery Procedures, Disaster Recovery, Troubleshooting, Performance Tuning, Data Integrity, User Access Control, Compliance

Industry

Information Technology & Services

Description

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 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 2024, the Group generated revenues of €5.8 billion. The world is how we shape it. Job Description Role: Oracle Database Artchitect Experience: 12 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 tools such as PowerDesigner 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 volumetric discussions for new initiatives and business areas based on knowledge gained from benchmarking of the product. Production Support: Troubleshoot and resolve database-related issues in production environments, ensuring high availability and minimal downtime. onitor database performance and implement tuning strategies. Ensure database security, user access control, and compliance with policies. Develop and maintain backup, recovery, and disaster recovery procedures. Communicate progress and issues through regular Status Reports. Additional Information Minimum 12 years of experience in database administration & performance tuning . Good to have: Certification of Oracle will be an added advantage . Understanding of Agile, and ideally a background working in a Scrum environment. Experience in Product development. Experience working with Cloud computing services and framework At our organization, 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.

Responsibilities

The Oracle Database Architect is responsible for managing, maintaining, and optimizing databases, ensuring data integrity, security, and availability. This role involves troubleshooting database-related issues and implementing performance tuning strategies.