Location
Bangalore | India
Job description
MS SQL Administrator
Exp – 7-8 Years
Role & Responsibilities:
- Handle large database estates and managed TB size of databases
- Define backup and restore strategy
- Should have experience in Database Migration and up gradation and should be aware of the pre and post steps.
- Proactively analysis the performance and tuning recommendation
- Should be worked on High Availability Features (Always on, Replication, DB Mirroring, Log Shipping & DB Clustering)
and should have good troubleshooting experience
- Building rebuilding indexes, defragment indexes and update statistics
- OS level activities related to database tasks and windows administration
- Coordinate and work with vendors for bug fixes and major incident resolution
- Should be able to understand Query execution plan, SQL Profiler Windows performance counters
- Creating, scheduling and Monitoring SQL Server Jobs
- Managing SQL Server security and logins (Assigning Server/Database roles & schemas)
- Knowledge on Database Security Management
Technical Skills (Core & Top-Up)
- Strong installation and database administration experience on 2014 / 2012 / 2008 R2 and 2005
- Strong experience on log shipping, mirroring and replication, AOAG
- Design and implement cluster high availability solution (Active-Active/Active-Passive)
- Strong experience in performance tuning and troubleshooting
- PowerShell /DB scripting and automate routine tasks
- Experience windows administration on database activities
- Experience in SSL certificate issues
Behavioral Skill
- Strong verbal and written communication skills
- Team management and motivation
- Flexibility, good attitude
MSSQL Database Admin
Job tags
Salary
