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.
- Role: Oracle DBA
- Skillset: Oracle, High Availability, OCI or Oracle Cloud, RAC, 19c, Patching, Exadata, OEM, ASM
- Experience: 6-8 years
- Location: Noida & Chennai
Skills, Role And Responsibility
- Responsible for managing Oracle (10g/ 11g/ 12c/ 19c) database server on different OS platforms.
- Manage database objects like tablespace, user, table, Index, roles, privileges, profiles, DB Links, materialized views, partitioning, synonyms, sequences, views and indexes and other database objects etc.
- Create physical/ logical standby database and performing switch- over and fail- over.
- Drive performance & tuning, monitoring the performance using tools.
- Experience in core oracle database administration
- Experience in Oracle software installation, upgrades, patching, database creation & configuration
- Proven expertise to manage RMAN backup, restore and recovery, database performance trouble- shooting, fix and configurations.
- Demonstrated expertise in VLDB Database migration with TTS, DR build, RMAN restore, BCV backup, Fine tuning, DG, ASM
- Sound knowledge in cloud (IaaS and PaaS)
- Any entrant or Professional skill on shell scripting with AIX or Linux
- Minimum of 6 to 8 Yrs. of experience in Oracle DBA administration
- Sound knowledge in Migration, patching, Upgrades
- Hands on experience in Oracle database management
- Solving critical technical P1 / P2 issues
- Good Communication skills
- Conduct client calls.
- Participate in RCA and CAB calls.
- Leveraging Cloud, Analytics, Digital and Security paradigms
- Mentoring team for quality delivery
- Administration over DB Objects including Tables, Clusters, Views, Procedures etc.
- Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.
- Responsible for installation, upgrades (Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning
- Able to work in 24 by 7 support.
- Good scripting skills to automate regular DBA admin tasks.
- Applying grid and DB PSU patch in standalone and multi-node RAC cluster servers
- Strong experience on database and SQL queries tuning for Oracle and RAC databases.
- Should have knowledge of oracle OEM 12C/13C
- Should have good documentation skills
- Technology Certifications would be plus
- Exposure to other DB technology like MySQL, MS-SQL, PostgreSQL will be plus
Qualifications
Any Graduate or B.Tech or Equivalent
Additional Information
We need to follow shifts, as per client requirement.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.