Database Administrator

 Bangalore - India       Permanent contract        Information Technology

Responsibilities

Role / Job Summary:  Oracle & Postgres DBA L2 accountable & responsible for handling global database operations.  Candidates must be willing to work in rotational shifts(24*7).

 

Location: Bangalore

 

Years of Experience:      4 – 8 years

 

 

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.

 

Mandatory Skills and Experience:

Proven working experience as an Oracle Database administrator.

Working knowledge across multiple infrastructure components with strong experience on the database perimeter.

Hands-on experience with database standards and end user applications.

Excellent knowledge of Oracle RDBMS (all versions) architecture & design.

Excellent knowledge of PostgreSQL DBA with Backup, recovery, replication & performance tuning concepts.

Proficient in RMAN Backup & recovery, Security, Data Guard, ASM & RAC.

Proficient in troubleshooting & solving complex performance problems.

Proficient in Oracle Database Patching, Upgrades & Migrations.

Proficient in monitoring & performance analysis through OEM.

Proficient in Oracle Golden Gate.

Experience in handling Disaster Recovery tests & exercises.

Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).

Working experience in banking domain (preferred).

Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.

Exceptional coordination, communication and interpersonal skills to work across global teams and clients.

Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.

Demonstrable crisis management skills in a large, globally distributed environment.

Experience working with or in an automated operations environment

Experience managing operations on core & cloud-based infra environments – ‘AaS platform’ experience ideal.

 

 

Preferred Education, Skills and Experience:

Experience supporting operations in an ‘As a Service Platform’ environment

Experience in Shell / Perl / Python Scripting

Experience supporting Open Source RDBMS (PostgreSQL / MongoDB / MySQL)

Oracle DBA Certifications – OCM / OCE / OCP / EXADATA

Undergraduate degree (mandatory)

Postgraduate degree (preferred)

ITIL Foundation / Intermediate / expert certification

 

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: 19000T0I
Business unit: SG Global Solution Centre
Starting date: 23/12/2019
Date of publication: 10/11/2019
Share on

Database Administrator

Permanent contract   |   Bangalore - India   |   Information Technology