Greetings from Maneva!
Job Description
Job Title MSSQL Database Administrator
Location PAN India
Experience 7 10 Years
Notice Immediate to 15 days
Requirements:
- Takes up technical tasks and support day to day BAU tasks/Incidents/RFC.
- 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 LEANCACIB 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.
sponsibilities
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 ControlM 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 HP Service Now Ticketing tool for INC/SR/Change/Problem tickets.
- Inhouse tools.
- HP OMI for monitoring.
- Strong knowledge on ITIL Process & Practices.
Educational Qualifications
- Bachelors degree or Masters degree in Information/Computer technology preferred.
If you are excited to grab this opportunity please apply directly or share your CV at and