Lead-Oracle Database Administrator

 Chennai, India       Permanent contract        Information Technology

Responsibilities


  • Providing on-call database support during week-ends & out of business hours.
  • Provide 24x7 support for critical production systems.
  • Strong knowledge on Production Database Operations & understanding the importance of BAU
  • Good Knowledge on  ITIL Framework
  • Effective communication (Written & Verbal)
  • Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients
  • Strong analysis skills, Problem Solving and Decision making
  • Willing to accept/take responsibility and problem ownership
  • Skill-up on new concepts, features and Open source technology and being Mentors
  • Ability to work in a rapidly changing environment
  • Planning and execution of PSU Patching & Upgradation of SQL Server (Legacy Mgt)
  • Good Experience on automating PSU Patching, installations and other BAU tasks
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries, blockings and deadlocks.
  • Account Management (Login Creation, Deletion, Profile Modification) & managing Security/Audit parameters
  • Knowledge on index de-fragmentation, re-indexing and update the index statistics
  • Configuration & Monitoring High Availability, Log-Shipping, DB Mirroring, Replication, Clustering and Always-ON
  • Periodical Backups of the database and timely recovery when required. Scheduling the automated backup jobs
Scheduling, Monitoring and Trouble shooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans

Profile Required

Role / Job Summary:  Oracle DBA Expert accountable & responsible for handling global database operations.


Years of Experience:      8+ years

 

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.

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.

Proficient on Exadata engineered systems.

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

Why Join Us

Societe Generale is one of the leading European financial services groups. Based on a diversified and integrated banking model, the Group combines financial strength and proven expertise in innovation with a strategy of sustainable growth, aiming to be the trusted partner for its clients, committed to the positive transformations of society and the economy

 

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: 20000GU2
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 20/08/2020
Share on

Lead-Oracle Database Administrator

Permanent contract   |   Chennai   |   Information Technology