Specialist SE App Dev ( SQL Server Performance )
SG Global Solution Centre
India
36d ago
source : Boursorama Banque

Environment

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 .

Mission

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.

Profile

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 :

  • 8+ years' experience in software and / or database development
  • 5+ years' experience with MS SQL Server Database Development
  • 5+ years developing stored procedures, triggers, tables, views, indexes and trouble shooting SQL scripts
  • 1+ years’ experience MS SQL Server Database Administration
  • SQL development ability to write and troubleshoot SQL code and develop stored procedures, functions, tables, views, triggers, indexes and constraints.
  • 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

  • Professional knowledge at least two of the following SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, etc)
  • Preferred Qualifications :

  • 3+ years' experience MS SQL Server Database Development Tech Lead
  • Experience with low level performance diagnostic tools like sqlio
  • Experience with AppDynamics
  • Experience with SentryOne
  • Experience with table partitioning
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form