Lead Administrator at Appirio


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

Remember to mention that you found this position on MyCareer