It In-Charge
• Over all responsibilities included Install / Upgrade, Configure and Maintain Microsoft SQL Servers for the group companies engaged in o Money Transfer, o Jewellery Whole Sale / Retail / Gold Factoryo Steel Plant• Responsible for 29 Critical Production - Microsoft SQL Servers, used in the Remittance business, replicating data to central site using Transactional Replication, UAT servers, Backup Servers, Archive Servers.• Set up and monitor Warm Standby Server using Log Shipping.• SQL Server version upgrade / migration from 2005, 2008, 2012.• Develop and implement database security features (roles, privileges, and authentication).• Control system resources usage and perform capacity planning.• Collect and analyze database performance information.• Query optimization and tuning.• Manage the indexing, database consistency checks, back-ups/recovery, security, and replication.• Creating database tables, setting up indexes, data constraints and DB Views.• Review and implement database changes.• Provide timely response to system alerts and participate in the on-call schedule.• Design and implement Backup and Recovery Strategy• Troubleshooting to Identify and Resolving performance problems.• Setup and monitor routine database maintenance tasks and health checkup.• Regular Backing up of System Databases.• Co-ordinate with application development team.• Participate and contribute towards organization’s goals and objectives, collaborating with multiple teams and solutions.