SR Location: Bengaluru Whitefield
Note - customer interview F2F bengalore whitefield location
Key responsibilities:
Technical Tasks:
-
- Responsible for identifying recording registering and performing the correct troubleshooting of tickets as mentioned in the service catalog for SQL service.
- SQL administration tasks
- Provide escalated support for SQL CTW services on CTW servers
- Provide escalated support for the SQL servers of the SCOM and SCCM teams.
- Provide support to the Citrix team for SQL related activities.
- Administer backup recover hosted instances
- Advise provide performance checks and escalated support about performance tasks to SAP SMEs.
- Provide support to the SCCM team for creating reports based on SQL.
- Handle all tickets escalated by Field IT or Service Desk or forwarded from other service teams.
Expert knowledge of:
-
- Installation configuration and troubleshooting of current and previous MS SQL server versions/ ditions dating back to 2016
- SQL server maintenance tasks
- SQL server high availability / disaster recovery solutions especially SQL Cluster and Always On
- SQL server backup strategies and recovery of instances and databases
- Performance tuning/optimisation of SQL server
- Data encryption
Good knowledge of:
-
- SQL server monitoring concepts
- Data protection (GDPR/SOX etc. concepts)
- Security secure SQL server access and user/role assignment
- Secure SQL networking
- T-SQLPowerShell
- Cloud concepts optional (e.g. AzureAWSGCP)