Job Description
• Having experience of 7+ years as MSSQL DBA
• Architect database mirroring, replication, high availability concepts
• Installation and upgrade of mssql database and clusters on version 2008/2014/2016/2019 under Linux/windows platforms
• Must have MSSQL cluster databases with Microsoft cluster implementation experience
• Good scripting skills to automate regular DBA admin tasks
• Strong experience on full and differential backups and backup tools like NetBackup, Networker
• Applying service pack and hotfix patch in standalone and Microsoft cluster servers
• Should have good command over speaking and writing.
• Strong experience on database and SQL queries tuning for critical databases
• Should have knowledge of netgain and truesight db monitoring configuration
• He will be customer facing for all operational issues and activities
• Strong experience on configure and troubleshoot Always on high availability and DR solutions
• Strong experience on configure and troubleshoot Snapshot, transaction, merge replication databases
• Good Grip over Tables fine tuning and troubleshooting
• Implement backup and recovery of mssql databases for various scenarios
• Administration over DB Objects including Tables , Clusters , Views , Procedures etc.
• Good in Impact Analysis of DB Change / DB Design Change etc.
• In-depth understanding of Always on high availability and DR solutions
• Good understanding of core support processes and change management, maintain documentation standards
• Must have experience in Database tuning including I/O, Load Analysis, SQL tuning advisor, SQL Profiling etc
• Responsible for installation, upgrades (Database and clusters), patches, Microsoft support, database tuning, cloning
• Able to work in 24 by 7 Support
Requirements
• Candidate must possess at least a bachelor’s degree, Post Graduate Diploma, Professional Degree (MCA / BE / BSC or SC computer science)
• Microsoft SQL Server DBA expert certification is must
• Having experience in always on solution will be added advantage
• Having previous banking BAU support will be added advantage
• Having experience on additional database technologies DB2 or oracle or Sybase will be added advantage
• At least 7 year(s) of working experience in the related field is required for this position.
• Preferably Senior Executives specializing in IT/Computer – Network / System/ Database Admin or equivalent.
• Full-Time position(s) available