Job description:

MSSQL Cloud Admin JD Certification Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE). Responsibilities Experience in Supporting & implementing solution in mentioned areas: Experience in managing MSSQL databases 2014,2016. Upgrade and manage new MSSQL database versions. Install MSSQL Databases software. Create and configure MSSQL database Prod, Non-Prod Environment. Configure database native HADR solution i.e. Always-On AG. Perform Test Drills to validate Database backup and restore. Configure database backup as per backup policies. Install and Configure database monitoring tools Alerts and Metrices. Database user life cycle management Creating, providing access, delete. Manage database schema, objects and users security. Support database and data migration Monitor, analyse and resolve Database performance issues. Day to Day database maintenance tasks i.e. Database Jobs, Monitoring Alerts and Logs, Database objects, database statistics status. Restore and refresh database as per request. Work with cross functional and application team to support database activities. Deploy approved Scripts provided by Application team. Responsible for providing end-to-end operations support for MSSQL through monitoring, incident response, and incident resolution. Participating in root cause analysis on incidents to ensure issues around are acted up on in a timely manner. Understanding of ITIL framework of ticketing /Problem ticket/Change process, Emergency change Work on Service Improvement Plan and Innovations. Troubleshooting complex and business critical issues. Work on team skill enhancement and training need identification. Coordinate with vendor and other cross functional teams to understand and solve the issues. Creating best practice documents, known error records, knowledgebase articles etc. Maintain Agreed SLA s Provide reports as agreed in SOW.To provide support for on call escalations and doing root cause analysis of given issueTo independently resolve tickets within agreed SLA of ticket volume and timeTo adhere to quality standards, regulatory requirements and company policiesWork on value adding activities such Knowledge base update & management, Training freshers, coaching analystsTo ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases

• To clearly understand the client's cybersecurity environment and respective product.
• To monitor, configure, and troubleshoot cybersecurity issues and related monitoring tools
• To analyse and validate cybersecurity incidents in-detail and help the L3 team with RCA/data or logs collection
• To enable knowledge transfer/trainings through creation/ maintenance of configuration documents, test plans, operational manuals and provide operational training to L1 team.
• To analyse and fine-tune cybersecurity policies, participate in cybersecurity review calls pertaining to change requests & recommendations on cybersecurity policy changes.
• To implement changes, monitor security device performance and implements performance tuning when necessary.
• To prepare analyses and reports to highlight the project progress/challenges and ensure quality and accuracy to the client