Oracle Database Administrator

Job description

Responsibilities

Key Responsibilities

·  Own 24* 7 database support; handling incidents, requests, problems & changes.
·  Handle on-call database support during week-ends & out of business hours.
·  Own & deliver various client & infra projects.
·  Plan & deliver various projects around database patching, upgrades & migrations.
·  Management of various tools/scripts being used for databases.
·  Managing Primary DBA roles for multiple applications.
·  Contribution towards automation of recurrent tasks.
·  Ticket reduction through problem management.
·  Manage disaster recovery tests & exercises.
·  Identify & deliver various POCs (Proof of concepts) for latest RDBMS features, open source & new technologies.
·  Work closely with application teams to provide solutions across various requirements & problems.
·  Proactively identify the problems and provide solutions to avoid incidents & application outages.
·  Work with other infra teams to optimize databases performance and reduce incidents probability

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'

Why Join Us

Societe Generale Global Solution Centre (SG GSC), a 100% owned subsidiary of European banking major Societe Generale (SG), Our role and purpose is to enable the strategic vision of Societe Generale Group. We are doing this by pioneering cutting edge innovation from Design Thinking to Smart Automation & Artificial Intelligence, and applying it to banking.

SG Global Solution Centre provides services in the areas of Application Development and Maintenance, Infrastructure Management, Business Process Management, and Knowledge Process Management, to Societe Generale's business lines around the world.

“We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status”.

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.

We are an equal opportunities employer and we are proud to make diversity a strength for our company. Societe Generale is committed to recognizing and promoting all talents, regardless of their beliefs, age, disability, parental status, ethnic origin, nationality, sexual or gender identity, sexual orientation, membership of a political, religious, trade union or minority organisation, or any other characteristic that could be subject to discrimination.

Job code: 19000SA7
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 20/01/2020