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 duplicationMumbai local candidates or Native of Mumbai candidates only to be considered.Revert with attached tracker and CACIB Tracker format in daily submissions15 years of full time education mandatory.Technical Skill:MUST HAVEMust 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 InstancesEvent, 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 migrationOS 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 supportGOOD TO HAVEGood knowledge in MSBIShould 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 scriptingProcess ToolsITSM 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 QualificationsBachelor’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 skillsGood knowledge on PowerShell/Python and T-SQL Scripting.Having MSSQL/MSBI certification will be added advantage Read more