Developer

About this role

• 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)
  
  

• 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
  
  

• 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
  
  

• Strong verbal and written communication skills
• Team management and motivation
• Flexibility, good attitude