sql dba - l3 in bangalore

posted
job type
permanent
apply now

job details

posted
location
bangalore, karnataka
job category
Information Technology
job type
permanent
reference number
931564
apply now

job description

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


Benefits
?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.

skills

?sql dba

qualification

?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