Senior Software Engineer
CurrentExperience in Installation, configuration Microsoft SQL Server 2008 and 2012 with latest service packs. • Hands on experience in SQL Server version Upgrade and performing database refresh and scheme refresh. • Having Experience in database Backup\restore, Attach\Detach & import export methods. • Implementing the backup plans and configuring Database Maintenance Plan. • Administering the SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, granting the privileges to users and groups. SQL Authentication.• Configuring and managing High-availability solutions Mirroring and Log Shipping.• Worked on the data synchronization solution replication.• Used BCP utility to publish table output to text files.• Scheduling SQL Server Agent Jobs, configuring database mail, alerts and operators.• Creating and managing schema objects such as tables, views, cursors, indexes and stored procedures • Experience in using DBCC Commands and DMV Commands• Analyzing Error Logs and take appropriate action to resolve any issues. • Resolve Database related trouble tickets assigned to the DBA group.• Experience on BMC ticketing and SCOM monitor\alerting system.• Good analytical and troubleshooting and problem solving skills.