SUMMARY

• 5+ years of total IT experience mainly as SQL Server Database Administration.
• Proficient in managing OLTP and DSS environments and giving 24/7 production support
• Experience in Data migration 2008 to 2012.
• Expertise in SQL Server 2008 R2, SQL Server 2012, 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load.
• Expertise in Database Administration (DBA) tasks like Backups and Recovery, Log shipping, Mirroring, space utilization, load balance, process scheduling, security, replication, etc.
• Knowledge with OLEDB (Object Linking and Embedding, Database) with SQL Server 2012
• Improving Database accessibility andmodifying Dynamic Management Views and Functions in SQL Server 2012.
• Knowledge with Always on feature which includes Failover Clustering and Database Mirroring in SQL Server 2012.
• Implemented CLUSTERING, Mirroring, Log Shipping and Replication for DR.
• Understanding of ETL Process using Partitioned Tables, SSIS and Deploying SSIS Packages using Package Configuration along with Deployment utility.
• Using DMV’s for performance analysis and Implementing Index Rebuild process for performance improvements based on Built - in SSMS reports.
• Good knowledge in Azure.
• Expertise in system trouble shooting in production environment and development environments.
• Expertise in work with Business Analyst and Developers to resolve the issues.
• Good knowledge of data ware housing project with knowledge of OLAP and OLTP.
• Experience in SharePoint including Administration, Development & Configuration.
• Expertise in developing stored procedure, Jobs and trigger in SQL Server 2008 R2 and 2005.
• Upgrade/Migration from earlier / legacy version to SQL Server 2008 R2/2005 using suitable methods.
• Expertise in supporting team of application developers for .Net web and OLTP database application.
• Experience in the designing, developing, Implementation and testing on production server.
• Ability to perform all common Database Administration (DBA) tasks like performing database backups and disaster recovery, space utilization, load balance, process scheduling, security, clustering, etc.
• Experience in Performance Tuning, Indexing and Query Optimization. Understanding of Query Execution Plans.

TECHNICAL SKILLS

Operating Systems: Windows server 2014,2012, 2008 R2 / 2003, VMware

Database: SQL Server 2012, 2008 R2/2005/2000, MS- Access.

SQL Server Tools: SQL Profiler, SSIS, SSAS, SSRS

Programming Languages: C#, VB.NET, Power Shell

Tools: & Utilities: IDERA, Red-gate tool for back-up, Light speed, SQL Safe

Reporting Tools: SSRS, SSIS, Share point, Crystal Reports

Development Environment: Visual Source Safe, Serena

SQL Server Tool: Enterprise Manager, Profiler, Query Analyzer, Export and Import

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Performed Node Injection for the enhancements of hardware in the Clustered environment.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Migration of databases from SQL Server 2000/2005 to SQL Server 2005, 2008.to SQL Server 2008,2012.
• Involved in Configuration and Administration of SharePoint 2007 environment.
• Monitored Log shipping as high availability solution.
• Configured Server Memory for maximum Performance and effective utilization.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Integrated Performance monitor and SQL traces to have better graphical analysis to find system bottlenecks.
• Maintained exiting data migration program with occasional upgrades and enhancements.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Performed Compressed Backups for Huge databases.
• Migrated DTS packages to SSIS packages
• Having very good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Worked on Data portioning for high availability of data
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Worked with IP Mon Tool by setting up alerts for the Monitors of various SQL Servers
• Worked and generated reports using SQL Server 2005 Reporting Services (SSRS)
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Maintaining the database consistency with DBCC at regular intervals
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Created Maintenance Plans that helped in effective disk utilization and index maintenance.
• Effectively managed disk space using LITE SPEED for Data base Backups
• Worked on TFS and brought all the servers under Source control.
• Export all Maintenance Packages and brought them under Source control
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Worked on multiple instances of SQL server using VM Ware
• Extensively worked on Production support and involved in trouble shooting SQL servers in various levels.
• Review the Build level for all the servers every month.