Softenger Hiring for Database Administrator, MSSQL-L2 at Navi Mumbai, Maharashtra Full Time

Full Job Description
Job Profile : Database Administrator, MSSQL-L2
Job Location : Navi Mumbai
Experience Required : 4-7 yrs
Job Description : 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.

Database Support team performs the day-to-day tasks as mentioned below
Monitoring:Perform monitoring of all the critical parameters for the database such as:
o Table space, segment.
o Availability of background processes.
o Buffer cache utilization.
o Log contention.
o Resource intensive queries.
o Fragmentation of table spaces, tables and indexes.
Perform maintenance activities like index maintenance as per the Customer’s policy provided during transition-
o Memory for the RDBMSs
o Disk free space
o Alert logs for errors
o Database backup Logs
o Unsuccessful logins
o Indexing
Monitor system performance and provide performance data to CustomerAvailability monitoringDC and DR sync verification, if the sync check is automated (like sql log shipping and oracle data guard)Database Administration:Create, modify and delete database and database objectsCreate, modify and delete users and propertiesCreate, modify and delete jobsPerform periodic database performance tuning as per the documented proceduresAdhere to automated daily checklist for database maintenance as providedPerform maintenance activities like index maintenance as per the Customer’s policy provided during transition-Perform orderly start-up and shutdown of database servicesRemote delivery team will take onsite DC operations support personnel (at the Customer’s data center ) help to Restore databases in the event of a server crashAdd, modify and delete permissions to database objects and troubleshoot user loginsRectify database configuration problemsBased on Customer’s policy provided during transition:Perform regular defragmentation activities for better space management and performanceGrant and revoke database access to usersPerform DR Drill and coordinate with all stakeholders.Housekeeping on DC / DR server- cleaning up of Archive logs and Alert logs/transaction logsData or database objects or any queries/stored procedures (trigger/function/package/procedure) related changes will not be part of infrastructure support of databaseRe-build DR in case of crashAlways on experience.
1. RESILIENCY SERVICES
DR Drills ActivitiesSupport the DR DrillManages the DR related change, incident and problem execution.Co-ordinate with Application support and WAN management team to perform switchover / failover and switchback / fallback activities as per defined scope once in a yearCapture communication matrix and communication channel for DR declarationConsulting team will study the IT environment and understand current BCP process and create a detailed DR Run Book.Run book document will get updated every year based on changes