Consultant Technical Lead - Oracle Performance Tuning
Responsibilities
Department / Project Overview – GTS/PAS/DRE Team provides 24 * 7 production database support to all the MKT/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises.
Key Responsibilities –
- Database performance analysis and tuning
- Expert in Oracle DG, RAC and ASM
- Deep knowledge and understanding of Oracle database architecture
- Expert problem identification and trouble shooting skills
- Expert knowledge on OEM and other performance analysis tools
- Designing database for the applications best performance
- Extensive knowledge on Oracles memory components , wait events
- In depth knowledge on execution plan, plan baselines and predicates
- Knowledge on the features and functionality of features across database versions
- Experience in Exadata is a plus
- Oracle certification would be an added advantage
- Good knowledge in scripting
- Good understanding of sql and pl/sql codes
- Understanding of the ITIL processes
- Excellent written and verbal communication skills
- User and project management skills
Profile required
Years of Experience –15+ years and above
Qualification / Certification – Engineering graduate / MCA / Computer Science Graduate or PG. Any relevant RDBMS certification is an added advantage.
GTS/PAS/DRE Team provides 24 * 7 production database support to all the MKT/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises.
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
At Société Générale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious.
Whether you’re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA.
If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us!
Still hesitating?
You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices and sharing their skills with charities. There are many ways to get involved.