|Job Profile :||Database Administrator, MSSQL|
|Job Location :||Navi Mumbai|
|Experience Required :||4-5 yrs|
|Job Description :||MS SQL Server DBA L2 Activities as below mentioned: –
1. Perform DR Drill activity as per requirement.
2. Perform reboot activity for each server on monthly basis
3. Database Migration like in place and side by side
4. Installation of MS-SQL Server of different version of servers.
5. Create SSRS report as per the client requirement
6. Create batch file, Powershell scripts for different SQL operation
7. Create mail alert for database monitoring purpose
8. Coordinate with client and solve SQL server database level issue and providing RCA and POA
9. Create Login and give permission for access the database.
10. Create weakly report and monthly ppt
11. Organise weakly review meeting between client and Project Manager also create minutes of meeting (MOM) report
12. Create automation scripts with HTML reports on production server and create mail alert for the same.
13. Handle L1 team members and assign task given by client also maintain shift roster for team.
14. Create store procedure and tune the query and give suggestion to developer for improve SQL performance.