MS SQL

Job description

Responsibilities

Experience

12+ Yrs

Level

SME/Architect

SQL Version

2005 to 2016, 2017

Preferred Programming

SQL Programming, Python, Powershell or Perl

Operating System

Windows Server 2003, 2008, 2008R2, 2012R2
Linux

Tools

SSMS/Enterprise Manager, Query Analyzer
Bartizan
ITSM
SERVICENOW

T-SQL Scripting

JD

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)
Being a mentor to Joiners and subordinators
Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients
Good Experience on Problem Mgt to reduce the reoccuring incidents
Good knowledge on Presentation skills with PPT and expert in Excel with functions & Macros
Good Experience on Client projects/domain, End-to-End Project management, setting-up technology Roadmap
Preferred Experience on LEAN methodology to optimize the BAU tasks
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
Performance Tuning, Query Optimization, Client/Server Connectivity
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
Good knowledge on troubleshooting of Always-ON, Clustering and other HA components
Good Knowledge on Storage level replication like SRDF
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
Trouble Shooting and fixing Data corruption (Page, table level)
Preparing/Updating SOPs documents (Technical & Operational)

Profile Required

? Experience with RDBMS admininstration ( Oracle or MS SQL or UDB DB2 or Informix )
? Knowledge of RMAN, Sql loader & Data Pump.
? Knowledge of RAC, Datagaurd
? Understanding of Performanc tunning
? Understanding of Change management
? Knowledge of migrations
? Must have Trouble shooting skills
? Knowledge of SCOM, AWR
? Experience with shell scripting, power shell
? Working experience in banking domain.
? Good in RDBMS architecture concepts
? Space management, Undo Management, User management
? Partitioning of tables
? Experience in database patching, up-gradation.
? Experience in migrating of database.
? Managing Redo log and Archive log files
? Working experience in RMAN, Sql loader & Data Pump
? Backup and recovery methods
? Logical backup and recovery using data pump , export/import
? Net configuration (listener and tnsnames)
? Trouble shooting database issues
? Strong experience SQL and PL/SQL knowledge
? Shell scripting kshell, Born & c shell.
? Performance tuning using AWR and Stats pack.
? Oracle RAC experience
? Oracle Data Guard experience'

Why Join Us

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”.

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: 19000T34
Business unit: SG Global Solution Centre
Starting date: Immediate
Date of publication: 20/01/2020