Lead Software Engineer - Oracle PL/SQL

 Bangalore, India       Permanent contract        Information Technology

Responsibilities

Key Responsibilities:

  • Assess database/system performance and fix the problems that arise.
  • Assist with schema design, code review, SQL query tuning.
  • Provide guidance and support to Application Developers.
  • Provide end-to-end technical support and problem resolution.
  • Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.
  • Schedule and perform regular server maintenance.
  • Reporting on metrics regarding usage and performance.
  • Handle a transversal role in the business line.
  • Hands-on on Agile methodology and the CD practices.

Profile Required

Technical Expertise:

  • Good understanding of database design, implementation, troubleshooting and maintenance
  • Must have RAC knowledge and work experience on all recent versions of Oracle.
  • Excellent in Performance tuning at Database and Application level.
  • Well verse in creating autonomous database backups and recoveries.
  • Expertise in RMAN, hot and cold backups.
  • Monitoring database using OEM.
  • Expertise in concepts of Database lock, space management, export and import of the database etc.
  • Expert in SQL and PL/SQL coding.
  • Tuning of Oracle objects.
  • Optimization of SQL query.
  • Create accounts for users and assign security levels.
  • Oracle work experience on UNIX Flavors is Must.
  • Must have good troubleshooting skills.
  • Prefer to have experience on Oracle Dataguard, Oracle Grid, ASM.
  • Support on production DB.
  • Strong knowledge of source control and release management tools.


Why Join Us

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

Société Générale Global Solution Centre (SG GSC), a 100% owned subsidiary of European banking major Société Générale (SG). Our role and purpose is to enable the strategic vision of Société Générale 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 Société Générale’s business lines around the world.


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: 2000080J
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 23/07/2020
Share on

Lead Software Engineer - Oracle PL/SQL

Permanent contract   |   Bangalore   |   Information Technology