SQL Server - Bengaluru, India - Change Leader
Description
JOB DESCRIPTION
SQL Server DB Administration
Experience: 3-6 years
Locations:
Mumbai, Pune, Chennai, Bangalore, Airoli
Primary Skills:
SQL server admin
Desired Skills & Responsibilities
SQL Server Installation and configuration
- Handson knowledge of HA Features (Replication, Log shipping, Always On, Clustering, Mirroring). Good knowledge on troubleshooting on HA related features.
- Understanding of WaitStats and Perfmon
- Understanding of SQL Profiler and handson experience on performance issue troubleshooting
- Reorganizing & Rebuild indexes, reclaim space/ Update Stats
- Server Monitoring
- Create Users, Profiles and Roles, Grant/Revoke Rights
- Kill sessions.
- Export object, schema data
- Execute Client Provided script on database
- Taking Backup
- Creating SOP's
- Troubleshoot Backup Failures
- Backup Restoration
- Create, Drop/Modify users, profiles & roles
- Database Installation as per defined standards
- Identify Long Running Queries and terminate blocking sessions
- Data Migration
- Create, Modify & Drop a database object
- Managing Critical Alerts
- Managing Critical Issues (Sev 1)
- Ensure Fast Recovery in Disaster Situation
- Database Instance Tuning & Performance Analysis
- Good understanding of T-SQL
- Capacity Planning
- SQL Server Patching
- Troubleshooting Critical Issues
- Working knowledge on Dynamic Data Masking, Database Audit, Transparent Data Encryption features related to Database Security
- Good understanding of Azure SQL and Managed Instance
- Prior working experience on Database Compliance Tasks and handling Internal and External Auditors Queries
- Performance Tuning using Query Store
- Good to have
- Automating Routine DBA Tasks using TSQL and PowerShell scripts
More jobs from Change Leader
-
Hil Testing
Bengaluru, India - 2 weeks ago
-
Was Admin
Mumbai, India - 2 weeks ago
-
SAP ABAP Fiori
Noida, India - 2 weeks ago
-
Matrix Sme
Patper Ganj, India - 3 weeks ago
-
System Admin
Bengaluru, India - 3 weeks ago
-
Principal Data Architect
Pune, India - 4 weeks ago