SUMMARY

• Around 9 years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2014/ 2012/2008/2008 r 2/2005/2000.
• Experience in managing Windows 2000/2003/2008 servers in a clustered environment.
• Experience in supporting Very Large OLTP Databases of size 13 TB and troubleshooting the performance bottle necks.
• Experience with SQL Server 2008 R2/2005/2000 installation, Migration, configuration, SSIS, SSRS and administration.
• 2+ Years experience in upgrading and Migration to SQL Server 2012/2014.
• 4 + Years experience in Clustering ( Active/Active, Active/Passive )
• 1+ Years experience in Setting up Always ON availability groups
• 5+ Years experience in Mirroring, Log Shipping and Replication
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication.
• Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments.
• Experienced in physical, logical database design by using ERwin.
• Experience in Filtered Indexes and Data Compressions for Performance and Optimum space utilization in SQL Server 2008 R2
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Identifying the bottle necks using SQL Server Profiler and Perfmon.
• Experience in performing Online Indexing. Experience with monitoring, troubleshooting related issues.
• Experience in using Data Partitioning for large tables of data to increase performance.
• Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.).
• Experience in planning and implementing Microsoft SQL Server Security and database permissions
• Proficient with database backup and recovery models.
• Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
• Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.
• Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
• Configuration and Administration of SharePoint Server 2007.
• Experience in working with Share Point in MOSS.
• Experience with Normalized and de-normalized database design.
• Industry working experience in SQL Server and DB2 database management, maintenance, and troubleshooting.
• Expertise in SQL Server 2005 Reporting Services (SSRS) and SQL Server 2005 Integration Services (SSIS) in Business Intelligence
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and Sybase.
• Migration of Databases from MYSQL/ORACLE/SYBASE to SQL Server 2008 using SQL Server Migration Assistance (SSMS) tool.
• Proficient with SQL Server Analysis Services.(SSAS)
• Extensively worked on RDBMS concepts to design Relational Database model
• Extensively worked on VMware and Implemented SQL Server 2005/2008/2008 R2.
• Rebuilding the indexes at regular intervals for better performance.
• Extensive experience in using Version control system tools for deploying scripts in various stages of SQL Server.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008 R2, 2003, UNIX, Linux

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle, Sybase, MYSQL, DB2

ETL Tools: SQL Server Integration Services (SSIS), Informatics

Reporting Tools: SQL Server Reporting Server (SSRS), Business Objects, Crystal Reports

Database Tools: SQL Profiler, SQL Query Analyzer, Index Tuning Wizard,CluAdmin.exe, DTS Import/Export, SSRS, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, IP Mon, Lite Speed, TFS

Data Modeling: ER-Win v 4.0., Microsoft Visio.

Languages: T-SQL, HTML, XML, C, Microsoft.NET, Java.

Third Party Tools: Ideara Diagnostic Manager, Fog light, SQL Compare, Lite speed.

Virtualization: VMware

PROFESSIONAL EXPERIENCE

Confidential, CT

Senior SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2014/2012/2008 R2/2005 on windows 2003/2008 environment.
• Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.
• Worked extensively on SQL Server 2008 R2 Transactional Replication.
• Configured logical drives and RAID levels Using HP Array Configuration Utility.
• Involved in Monitoring and troubleshooting replication issues
• Configured Server Memory for maximum Performance and effective utilization.
• Configured Temp DB for to increase the performance of SQL Server.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization
• Involved Design, Troubleshooting and Deployment of SSIS packages
• Migrated DTS packages to SSIS packages
• Involved in deploying XMLA scripts to SSAS and also maintained the security of SSAS databases.
• Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.
• Refresh the Production databases to DEV and QA environments for new releases.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.
• Used new security feature called AUDIT in SQL 2008 on both server level and database level
• Worked with IDERA Tool by setting up alerts for the Monitors of various SQL Servers
• Worked and generated reports using SQL Server 2008 R2 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.
• 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 TORTOISE SVN and maintained the data in 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.
• Extensively worked on 24X7 Production support and also involved in on call rotation.
• Worked in REMEDY ticketing system and resolved tickets ranging from P1 to P4.
• Extensively worked with Native and SQL SAFE compression Backups.
• Extensively used IT Change Request (ITCR) tool to document, track, authorize and record implementation details of changes made to the various applications in the firm.
• Extensively worked on Documentation of run books and release documents with various application teams for production deployments and other processes.

Environment: Windows 2003/2008/2012 , MS SQL Server 2005/2008/2008 R2/2012/2014,MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, MS Visual Studio 6.0, REMEDY, IDERA, Oracle, Sybase.

Confidential, PLANTATION, FL

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2008/2005 on windows 2003/2008 on clustered environment.
• Worked across 60 servers and more than 600 databases.
• Worked extensively on SQL Server 2008 R2 Transactional Replication.
• Installed and configured and maintained failover clustering for SQL SERVER 2005
• Configured and maintained IIS 6.0.
• Involved in Monitoring and involved in trouble shooting replication issues
• 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.
• Involved Design, Troubleshooting and Deployment of DTS packages
• Migrated DTS packages to SSIS packages
• 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
• 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 VSS and maintained the data in 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.
• Extensively worked on 24X7 Production support and involved in trouble shooting SQL servers in various levels.

Environment: Windows 2000/2003/2008 , MS SQL Server 2000/2005/2008 R2,MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, MYSQL, MS Visual Studio 6.0, VSS, TFS.

Confidential

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Worked on 32 bit, 64 bit clustered environments
• 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.
• Installed and Configured Share Point Moss 2007 and WSS 3.0.
• 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.
• Extensively used Filtered indexes to improve query performance and lower storage and maintenance costs.
• Experience in performing Compression Backup for efficient utilization of disk space in SQL Server 2008.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies Implemented.
• Migrated DTS packages to SSIS packages
• 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.
• Developed ETL Packages and deployed them
• 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.
• Created Portals and sites using MOSS 2007
• Implemented security for sub sites and given permissions to the users using MOSS 2007
• 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

Environment: Windows 2000/2003/2008 , MS SQL Server 2000/2005/2008 , MSCS, Microsoft.NET, SSRS,SSAS, Oracle 9i, MS Office Access 2003, MS Visio Pro 2002.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Worked as a Junior DBA and managed and supported database systems / servers
• Developed stored procedures and triggers.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary.
• Logical and Physical design of database for projects on basis of user requirements using ERwin
• Reporting on a weekly basis to the project manager.
• Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Moved the entire phase from the Staging to the Production.

Environment: Windows 2003, MS SQL Server 2000/05, SQL, T-SQL, SQL Query Analyzer, Profiler