About Me

9 + years of experience in SQL Server Database Administration in Production, Test and Development environments, with MS SQL Server 2014, 2012, 2008R2, 2008, 2005 systems along with experience in Business Intelligence development, Data Modeling and An... 2008, 2005 systems along with experience in Business Intelligence development, Data Modeling and Analytics in different fields like Finance, Insurance, Transportation and Healthcare. 5 + years of experience in SQL Server Database Administration. 4 + years of experience in SQL Server Database Development. Expert knowledge of SQL Server Architecture both 32-bit and 64-bit systems in Cluster and Stand alone Server environments in terms of Installation and Configuration. Sufficient hands-on experience in HA DR High Availability Disaster Recovery techniques like Log Shipping , Mirroring High safety High performance , Replication Snapshot Transactional and Clustering Active - Passive and Active- Active . Experience in Migrating SQL Server 2008/2008R2/2012/2014/2017. Experience working with Team Foundation Server TFS , Visual Source Safe for Data Archival. Well experienced in analyzing Performance, Query optimization and tuning. Good experience in creating objects such as Databases, Tables, Stored Procedures, Triggers, Cursors, Constraints, Indexes, Full-text Indexes, Views, Indexed Views, T-SQL Merge Command Experience in Index Maintenance Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity. Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. Troubleshooting performance issues and fine-tuning Performance Tuning queries and stored procedures. Good knowledge about Database Recovery models. Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer. Experience in automation of administrative tasks like creating maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs. Experience in Error handling through TRY-CATCH statement and Common Table Expressions. Expertise in implementing Business logic by using T-SQL DDL, DML , stored procedures, triggers and User Defined Functions UDF . Extensive experience in planning and controlling the User Privileges, Monitoring the Security and Audit issues as per Standards. Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans. Experience in performing database regular Backups Full/Differential/Transaction Log Backups into Disk and Restoring on requirement. Experience in handling the Isolation Levels and Concurrency Effects. Experience in configuring Registered Servers, Linked Servers and Multi Server Administration. Involved in SQL server default port number changing to nonstandard port number, created Server aliases as part of SQL Server hardening. Involved in Clustering at both Windows and SQL Server levels and maintenance. Auditing of database for user transactions, login and database action and removing orphan users. Strong knowledge and experience in error handling of using transactions, check points, break points and error logging procedures. Created object visibility to modified report, assigned item level permissions and site security roles. Provided support for 24x7 availability of database services. Handling locking, Blocking & Deadlock Scenarios Troubleshooting log file space issues, tempDb contention Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies like Agile, Scrum & Waterfall etc. and capable of handling responsibilities independently as well as a proactive team member