PROFESSIONAL SUMMARY:

• Senior Microsoft SQL Server DBA with 10+ years of quality experience.
• 7+ years of experience in handling production systems in 24/7 environment (rotating on - call)
• 7+ years experience in Administering and managing Databases VLDB (very large database)
• Expert in managing multiple instances of database servers on-site and remotely.
• Experience in installation, maintenance of different versions of SQL Servers (2014, 2012, 2008R 2/ 2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments (standalone & clustered Servers)
• Expert in migration/upgrade of SQL 2008, 2005, 2000 to SQL 2016, 2014, 2012, 2008 R2.
• Installed security patches, service packs and hot fixes for windows and SQL Systems
• 7+ years of experience upgrading and migrating SQL Systems from lower version to higher version
• 6+ years of experience in Implementing and handing SQL Server systems in Clustered environments
• 8+ years in Implementing SQL Server 2014 to 2008 Version in a Virtual Environment
• Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring, Replication (Transactional, Snapshot & Merge Replication) and AlwaysON
• Hands on experience in working with MSSQL SERVER 2005, 2008, 2008R2 and 2012 Versions features
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
• Implemented Database Mirroring in MS SQL Server 2005, 2008, 2008R2.
• Implemented AlwaysOn Availability in MS SQL Server 2012.
• Expert in setting up Alerts for 24/7 availability.
• Expert in keeping system up to date by patching with third party software like PDQ.
• 10+ years of experience in capacity planning and implementing disaster recovery
• Expert in FULL, Differential and LOG Backup for all production, development & QA systems
• Extensive Experienced in using of Avamar, VERITAS Netbackup and SQL Litespeed for SQL Backup.
• Experienced in disaster Recovery with Bubble testing.
• Expert in resolving backup failure issues.
• Worked extensively on MS SQL Server /2012/2008r2/2008 Integration Services (SSIS) (ETL)
• 7+ years of experience in SSIS, SSRS
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports
• Created SSIS packages to Extract and Load data from diverse sources (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Scheduling package execution in SSIS and SSMS and Windows Task Manager.
• Deploying packages on multiple SSIS servers.
• Used SSRS to Reporting for a Data warehouse system
• 6+ years of experience in performance tuning MS SQL Server 2012/2008R2 for best performance.
• Hand-on experience with IDERA Diagnostic Manager Installation, configuration and management.
• Experience with configuring Alert with IDERA Diagnostic Manager for SQL Server
• 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.
• Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multi valued Table functions.).
• Experience in performing Online Indexing. Experience with monitoring, troubleshooting related issues.

TECHNICAL SKILLS:

RDBMS: SQL Server 2014/2012/2008 R 2/2008//2005/2000, Sybase, Oracle 9i/10g, Microsoft Access.

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Management Data Warehouse, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), SQL Query Analyzer, Index Tuning Wizard, DTS Import/Export, SQL Agents, SQL Alerts, SQL Mail, Lite Speed, TFS, Symantec Net Backup, IDERA Diagnostic Manager, Foglight, Redgate.

Data Modeling: ER-Win v 4.0., VISIO

Languages: SQL, TSQL, Visual Basic 6.0, HTML, XML, C, Microsoft.NET, Java.

Applications: Microsoft Office, Erwin, MS VISIO 2008/2010.

Operating Systems: Windows 95/98/2000/2003/2008 R2/2012/NT 4.0/XP, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

Senior MS SQL Server DBA

Responsibilities:

• Provided 24/7 production support on a rotating roster schedule.
• Worked extensively with IBM Tivoli for Back-up / Restore .
• Worked extensively on VMware and Virtual instances of MS SQL Server
• Implemented SQL Server 2012/08R2 Active/Active cluster setup on Windows 2012/08/R2 servers.
• Implemented SQL Server 2012 on Prod, Development and QA Environment
• Implemented Always-On Availability Group in SQL Server 2012
• Drafted Patch Policy for SQL Server for the company that helped keeping servers up to Date
• Suggested backup strategies, Scheduled backups and Performed restoration operations.
• Worked extensively with Avamar Backup client for different Backup/Restore scenarios.
• Worked extensively on Database space management, performance monitoring and alert management.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Created Jobs and scheduled jobs according to the requirements
• Created Linked Server between SQL servers and AS400 .
• Monitoring / Alerting SQL Server Instances with IDERA diagnostic Manager
• Extensively used SSIS to move data from text files to SQL Server.
• Configured SSRS report server
• Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.
• Dropped and recreated the indexes and applied Smart Reindex strategy on tables for performance improvements.
• Worked extensively on Database space management, performance monitoring and alert management.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Implemented Registered Servers and Central Management Servers .
• Installed Standalone and Clustered SQL Server 2008 R2/2012/2014 instances in Production, Development, Test, Staging environments

Confidential, Houston, TX.

Senior MS SQL Server DBA

Responsibilities:

• Provided 24/7 production support on a rotating roster schedule.
• Worked extensively on VMware and Virtual instances of MS SQL Server
• Implemented SQL Server 2012/08R2 Active/Active cluster setup on Windows 2012/08/R2 servers.
• Implemented SQL Server 2012 on Prod, Development and QA Environment
• Implemented Always-On Availability Group in SQL Server 2012
• Actively participation in Patching process .
• Worked extensively with Avamar Backup client for different Backup/Restore scenarios.
• Worked extensively on Database space management, performance monitoring and alert management.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Created Jobs and scheduled jobs according to the requirements
• Created Linked Server between SQL servers and AS400 .
• Monitoring / Alerting SQL Server Instances with IDERA diagnostic Manager
• Extensively used SSIS to move data from text files to SQL Server.
• Configured SSRS report server
• Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.
• Dropped and recreated the indexes and applied Smart Reindex strategy on tables for performance improvements.
• Worked extensively on Database space management, performance monitoring and alert management.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Implemented Registered Servers and Central Management Servers .
• Installed Standalone and Clustered SQL Server 2008 R2/2012/2014 instances in Production, Development, Test, Staging environments

Confidential, New York, NY

Senior MS SQL Server DBA

Responsibilities:

• Extensively worked in OLTP & OLAP environments that include Production, UAT and Development databases in SQL Server.
• Provided 24/7 production support on a rotating roster schedule.
• Worked extensively on VMware and Virtual instances of MS SQL Server
• Worked extensively with writing T-SQL, Stored Procedure, Functions, Views, Triggers and Excel Macros
• Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
• Implemented SQL Server 2012 on Development and QA Environment
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Configured and Monitored MS SQL Server 2008 R2 in Log Shipping for Disaster Recovery.
• Installed and configured SQL Server 2008R2 with Service Packs in UAT, Development & Production environments
• Worked with SAN Technology and SAN boxes.
• Implemented SQL Server 2012 in a Beta Release
• Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
• Designed and implemented high level backups/restore strategies for point in time recovery purposes.
• Used Idera SQL Safe backup tool to backup databases.
• Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.
• Worked with different teams to deploy projects to UAT (Testing), Development, and Production environments.
• Migrating SQL Server 2000/2005 7.0 databases to SQL Server 2008 and then to 2008R2.
• Used SQL Server Upgrade Advisor to analyze SQL server 7.0 in the process of migration.
• Converted DTS Packages to SSIS Packages using DTS Package Migration Wizard
• Created solid ETL packages with SSIS using various transformations, sources and destinations
• Created packages in SSIS with solid error handling, logging and error re-direction
• Used VB Scripting in SSIS transformations
• Deployed SSIS packages from one server to another and scheduled the packages for automation
• Created heavy duty reports with SSRS, parameterized and drill down reports
• Configured SSRS report server
• Created packages successfully using SSIS to transfer large volume of Data.
• Monitoring SQL Server Instances with IDERA diagnostic Manager

Environment: Windows 2008 R2/2003/2000 Server, Oracle 10G, VMWare, Excel, SAN, MS SQL Server 2012/2008 R 2/2005/2000/7.0, Business Intelligence Development Studio, DTS, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS,VB Script Performance Monitor, SQL Profiler.

Confidential, Baskin Ridge, NJ

Senior MS SQL Server DBA

Responsibilities:

• Installed Standalone and Clustered SQL Server 2005/2008 R2 instances in Production, Development, Test, Staging environments.
• Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Worked extensively on Database space management, performance monitoring and alert management.
• Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Suggested backup strategies, Scheduled backups and Performed restoration operations.
• Worked with migrating data from SQL Server 2000 and 2005 to SQL Server 2008.
• Created Jobs and scheduled jobs according to the requirements.
• Created linked server between SQL servers.
• Designed and created ETL process and design in SSIS
• Implemented various transformations and created SSIS packages
• Created SSRS simple and Drill-down reports depending on client requirement
• Dropped and recreated the indexes on tables for performance improvements.
• Written complex stored procedures and functions and integrated it with the front end application.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Data transfers between various servers using BCP and DTS.
• Extensively used SSIS to move data from text files to SQL Server.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• Involved in development activities including hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
• Responsible for configuration, Tuning of MS SQL Server 2005 and provided 24 X 7 dedicated support to all production and development servers.
• Involved with Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005 Databases and Servers.
• Responsible for migration of databases from one version to other versions and applying patches.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in replication problems.
• Used DDM (Data Dependency Mechanism) to balance the load of data across multiple servers.
• Involved in capacity planning in estimating troubleshooting and sizing of tables.
• Developed complex Stored Procedures.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: Windows Server 2003, SQL Server 2005/2000, SQL Server Analysis Services, VB, SAN, DTS, SSIS