MSSQL DBA

• Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.
• Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
• Proposes service improvements for all Oracle/EBS services supported throughout the organization.
• Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.
• Works in line with policies based on LEAN-CA-CIB best practices.
• Actively engages during any high severity issue and drives for issue resolution.
• Reviews technology changes to identify potential risks.
• Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
• Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.
• Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.
• Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.
• Guarantees the production readiness.
• Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.
• Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.
• 24x7 Production support including scheduled and emergency night and weekend work.
• Follow the IT service management guideline while working with tools like Service Now.
• Preparedness to work in Shifts in rotation.

Qualifications:

• 7+ years relevant experience is mandatory.
• Ask the candidate if he recently applied, check duplication
• Mumbai local candidates or Native of Mumbai candidates only to be considered.
• Revert with attached tracker and CACIB Tracker format in daily submissions
• 15 years of full time education mandatory.

Technical Skill:
MUST HAVE

• Must have strong technical knowledge in MSSQL 2014 & above Administration.
• Execution of backup/recovery procedures and DB refreshes.
• Should have handled database installations as MSSQL DBA.
• Creation and Maintenance of Database Instances
• Event, database performance and availability monitoring.
• Exposure to Logical and Physical database design and Implementation.
• Install, configuring, applying patches to MSSQL servers.
• Knowledge and experience in Replication, Log Shipping, Clustering, Always On in SQL 2005 above– configure and basic troubleshooting.
• Backup monitoring, verification.
• Applying Database patches, upgrade and migration
• OS level activities related to database tasks.
• Log, scheduled Job Management through Control-M or similar products.
• Schema Object, Partition Management.
• Expertise in handling Database Maintenance related to Index and DBCC.
• Hands on expertise in Performance tuning.
• Development support/ debugging performance issues.
• Windows administration experience desired.
• Well averse with DB Scripting, SQL Profiler, Extended Events, Query Analyzer and Query Store and Intelligent query processing.
• Experience on ITIL/operations and production support

GOOD TO HAVE

• Good knowledge in MSBI
• Should have handled database installations as MSBI DBA.
• Experience in MSBI and its related components like SSAS/SSIS/SSRS and Power BI.
• Exposure to SSIS Packages, SSAS, SSRS and Power BI.
• Application DBA Exposure.
• PowerShell scripting

Process & Tools

• ITSM tool- Client Service Now – Ticketing tool for INC/SR/Change/Problem tickets.
• In-house tools.
• Client OMI for monitoring.
• Strong knowledge on ITIL Process & Practices.

Educational Qualifications

• Bachelor’s degree or Master’s degree in Information/Computer technology preferred.

Key Competencies:

• 7yrs (Min) of relevant experience in MSSQL/MSBI database administration.
• The candidate should have worked in a SLA driven environment.
• Ability to work in a flexible, team-oriented and constantly changing environment.
• Good Oral and Written communication skills
• Good knowledge on PowerShell/Python and T-SQL Scripting.
• Having MSSQL/MSBI certification will be added advantage