Expert - Redis

Job description

Responsibilities

Perform installation and maintenance of database server (Primarily Oracle)
- Work closely with different development teams to understand database requirements and provide support
- Be responsible for ensuring availability and performance of the databases that support the system
- Monitor and respond to database systems incidents to ensure secure production services to the business
- Be responsible for improvement and maintenance of the databases to include rollout and upgrades
- Be Responsible for implementation and release of database changes, as submitted by the development team
- Provide support for Development environments Refresh of UAT/Staging/pre-prod environments
- Carry out Database troubleshooting and problem root cause analysis
- Work with infrastructure team (co-ordinate with application support team) to ensure that the associated hardware resources are allocated to the database to ensure high availability and optimum performance'

Profile Required

Must have experience with the following:
- RDBMS Administration ( Oracle / MS SQL / UDB DB2 / Informix )
- Recovery Manager (RMAN), SQL loader and Data Pump
- Oracle Real Application Clusters (RAC), Oracle Data Guard
- Database Migrations, Patching, Upgradation and Partitioning of Tables
- System Centre Operations Manager (SCOM)
- Database Performance Tuning using Automatic Workload Repository (AWR) and Stats Pack
- Shell scripting and using KShell, Bourne Shell, Power Shell
- Logical Backup and Recovery using Data Pump, Export/Import
- Space, Undo, and User Management
- Managing Redo and Archive log files
- Net Configuration (Listener and TNSNames)
- Advanced Knowledge of SQL and PL/SQL
- Good knowledge of RDBMS Architecture concepts'
'- Experience in banking domain
- Trouble shooting database issues
- Understanding of Change Management
- Strong oral and written communication skills'

Business Insight

A 100% owned subsidiary of European banking and financial services major Societe Generale (SG), Societe Generale Global Solution Centre (SG GSC) came into existence in 2000. Established as an offshore development centre in Bangalore, also having a presence in Chennai, SG GSC has 15 years of sustainable delivery expertise to its credit, and develops global best practices to promote the strategic objectives of the Societe Generale Group.
SG GSC possesses in-depth understanding of the business processes and cutting-edge technologies across domains of Societe Generale's diverse portfolio. We deliver best-in-class solutions to the Group's entities in the realm of corporate and investment banking, retail banking, specialized financing and insurance, private banking, and global investment management and services.
We place the highest importance on our employees and provide extensive opportunities for career progression and development. SG GSC conforms to the group diversity principles, and has a multi-cultural staff representing seven nationalities, and speaking 20 languages. Women comprise 25% of our workforce.

All our positions are open to people with disabilities

Job code: 19000ONM
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 30/10/2019