sql dba - l3 in bangalore

randstad india
position type
apply now

bangalore, karnataka
Information Technology
position type
reference number
randstad india
apply now

job description

sql dba - l3 in bangalore

?responsible for implementing, monitoring and supporting all SQL Server environments used to support the Infrastructure
Experience � 7 :: 10 yrs.

?Opportunity to work with Large BFSI Captive
Competitive Salary

Client Introduction
?a Global In-house Center (GIC) of the Financial Corporation family of companies. Client provides comprehensive title insurance, closing/settlement, property data and technology solutions.


?sql dba


?Install, configure, troubleshoot and maintain all SQL Server environments used to support
� Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
- Configure SQL Server monitoring utilities to minimize false alarms
- On-call troubleshooting for SQL Server service outages
- Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem
- Check the backup failure alerts, correct the errors and rerun the backups
- Validate the backup files using restore verify only. We can create jobs to take care of the task and to send a notification if it fails to verify any backup.
- Monitor all backup and log history is cleaning if it is designed.
- Find out the newly added databases and define the backup plan
- Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL notification alert sends a mail to DBA team and also, we can design a customized SSRS report which reports all failed/success job details with delta value.
- Make sure that all process related jobs/ maintenance plans completed. That includes data pulling jobs, data update jobs etc.
- All cleanup jobs are running fine, temp tables, logs, history, backup files etc
- Request Handling
- High-Availability
- Manage security access, user logins, and user groups and object permissions
- Develop and maintain a disaster recovery/high availability solution in a geographically dispersed environment
- Perform capacity monitoring and performance tuning activities
- Interface with the departments business analysts, data architects and system administrators on daily support tasks and project-driven activities
- Work with the administration team to create and maintain best-practice standards and procedural guidelines