Senior SQL Database Administrator - Installation & Maintenance (7-10 yrs)

Position Title : MSSQL Database Administrator L2.

Location : Mumbai.

Relevant Experience : 7+ years.

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.

Role Summary :

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