Celtic Management Services
Position Title : MSSQL Database Administrator
BAND
Location : Mumbai , India
Department Middleware
Shift/Oncall & Weekend Support
Flexible to work in shifts/ weekends/On-Call support as follows:
Shift Timings
Morning Shift 4.30AM to 1.30PM
Afternoon Shift 11.30AM to 8.30PM
Afternoon Shift 1 12.30PM to 9.30PM **
Evening Shift 2.30PM to 11.30PM
Evening Shift 1 3.30PM to 12:30AM **
** Day light savings Period- Nov to Mar ( 1hour ahead)
Role Summary
As a L2 resource of his /her team, he /she:
· 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.
· 24×7 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.
Technical Expertise
Must Have Skills
- 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 Skills
- 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- HP Service Now – Ticketing tool for INC/SR/Change/Problem tickets.
- In-house tools.
- HP 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:
- 5yrs (Min) to 8yrs (Max) 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.
- Having previous banking BAU support will be added advantage.