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 .
Influence Architects, Consultants and Principal engineers on strategy and technical performance roadmap of the application.
Provide feedback , status and updates to PM, Project Leads with necessary details on work in progress. Ability to give enough status input to them on topics of development, risks, timelines, schedules , escalation and matters of urgent management attention.
Ability to share knowledge and coach other team members is essential.
Able to provide the necessary expertise to efficiently resolve complex optimization problems and guide the team members at expected speed.
Develop techno-functional understanding of all modules within application.
Key contributions to technical leads for defining the optimization goals. This includes code evaluate existing code and review, regression impacts, cost saving proposals, performance etc.
Enhances performance of current application as per the user stories keeping overall product quality, requirements and user experience.
Directs the development team in optimizing , testing and debugging of database stored procedures.
He / she is proficient in T-SQL stored procedures tuning, indexing, best practices in SQL development required to independently work on modules.
He / she is an expert in SQL Server query execution plan analysis, in concurency (isolation levels, locking models), has good understanding of database statistics and how they influence query execution performance and is able to use system DMVs in order to diagnose performance issues.
Understands SQL server advanced configuration topics like filegroups and partitioning. Has proven experience in using administration, profiling and monitoring tools for MS SQL Server.
He / she is good at estimating the tasks and helps the team arrive at the estimation fairly. Over time shows improved trend of estimation accuracy and maturity.
Ability to control overall quality assurance expected by the business for sprint delivered. He works and shows continous improvement on defect KPI defined for the delivered product evolutions.
Basic Qualifications :
Experience in performance tuning, query optimization using Execution Plans, IO Statistics, database statistics and tools like SSMS, Performance Monitor, SQL Profiler, Session Events or other related tools
Preferred Qualifications :