Mahender Macha Email and Phone Number

 Over all 4+ years of IT experience in SQL Server Database Administration. Experience in Database Administration, Management using RDBMS such as SQL Server under WINDOWS environment. Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2012. Provide 24*7 Production support as well on call support for SQL Server Databases. Experience in investigating and applying necessary SQL Server database service packs and patches.  Experience in managing multiple MS SQL 2012 & 2008 RDBMS on large systems. Maintaining Backup and Restore Policies Monitoring the Scheduled job Executing DBCC as a part of Maintenance activities Identifying and Resolving Blocking and Locking related issues Responsible for migrating databases Allocating, shrinking and altering the Database files Maintain Database Security Performing Health Checks of all the servers in Support Environment Maintained and developed Fail-Over databases using Database Mirroring Configuring and monitoring Replication As a part of the DBA team providing 24/7 production support to the clients Performing Back-ups, Restores, Scheduling jobs, maintenance plans and Disaster Recovery Planning Setup email configuration, Operators and Alerts on SQL Server Agent for automated job notification Security Architecture (Managing Database User and Security) Using SQL Server technologies like Database Migration, Log Shipping, and Database Mirroring & Replication Have good knowledge with Clustering Strong troubleshooting and organizational skills. Having knowledge in developing and monitoring SSIS, and SSRS Packages \​ Importing and exporting Data. Expertise in SQL server authentication modes, server roles, database roles and permissions. Creating and Managing Domain User Accounts and Groups. Managing clients in Windows domain and Disk management. Configuration of TCP/IP Services.