SUMMARY

• Senior Microsoft SQL Server 2016/ 2014/2012/2008 R2 DBA with 8+ years of quality experience.
• 8+ years of experience in handling production systems in 24/7 environment (rotating on - call)
• 8+ years experience in Administering and managing Databases VLDB (very large database)
• Expert in managing multiple instances of database servers on-site and remotely
• Provide Production Support Level I /Level II Support
• Installed and configured MS SQL Server 2016/2 R2 in standalone & clustered environment
• Expert in migrate/upgrade of SQL 2008R2 SQL 2012/2014/Azure/AWS.
• Installed security patches, services packs and hot fixes for windows and SQL Systems
• 5+ 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
• 3+ years of experience with AlwaysON availability groups
• 5+ years in Implementing SQL Server 2008\2012 environment in a Virtual Environment
• Expert in implementing High Availability options Failover Clustering, AlwaysOn, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge)
• Implemented Database Mirroring in MS SQL Server 2008 R2/2012
• 5+ years of experience in capacity planning and implementing disaster recovery
• 5+ years experience in implementing full backup, differential and transaction log backup for all production, development & QA systems including Compression
• 6+ Years in using Netbackups, Tivoli, SQL LiteSpeed, Redgate and third Party software’s for backup
• Expert in restoring databases from disaster
• MS SQL Server 2 R2/2008/SSIS/SSRS/SSASA/AZURE/AWS:
• Worked extensively on MS SQL Server 2008/2012/2014 Integration Services (SSIS) (ETL)
• 6+ years of experience in SSIS, SSRS and SSAS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used looping, lookup, fuzzy lookup, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Migrated Data from diverse source to MS SQL Server environment with SSIS and to AZURE/AWS (Iaas /paas) cloud.
• Scheduling package execution in SSIS
• Used SSRS to Reporting for a Data warehouse system
• Extensive use of DMV’s in MS SQL Server 2 R2/2008
• 8+ years of experience in performance tuning MS SQL Server 2014/2012/ 2008 R2 for best performance
• Expert in using latest SQL Server DMV's for maximum performance
• Expert in using SQL Server profiler trace for bottlenecks and long running queries
• Excellent knowledge in fine tuning stored procedure for super performance
• Excellent knowledge in fine tuning queries taking a long time
• Good knowledge in understanding Query Execution Plans and Statistics data
• Expert in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered, Unique)
• Expert in verifying output of DBCC SHOWCONTIG and suggesting changes
• 6+ years of experience in using tuning wizard in MS SQL Server 2014/2012/2008 R2

TECHNICAL SKILLS

RDBMS: SQL Server 2016/ 2014/2012/2008 R2/2008, Oracle 9i/10g, MySQL 5.8.

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), IDEARA, RedGate, FogLight, SQL LiteSpeed, IBM TSM.

Languages: SQL, TSQL, Visual Studio 2010, .NET, Visual Basic 6.0, HTML

Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express/ Exchange.

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Operating Systems: Windows 2003/2008 R2/2012 R2, VMWARE, Linux, MS-DOS, AZURE (Cloud) platform.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. SQL Server DBA

Responsibilities:

• As a Production support DBA responsible for managing production, development and QA environments.
• Implemented Always-On (AAG) on SQL Server 2012/2014/2016 SP2 CU5
• Installed SQL 2016 with Always-On (2&3 replicas)
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Hands-On experience in creating/maintaining integrations jobs using SSIS and scheduling them using task scheduler and also using SQL Agent.
• Subscribe SQL Server Azure Cloud Services.
• Created Database(s) on SQL AZURE and setting up SQL Azure Firewall.
• Created & managed SQL Server AZURE Databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes
• Worked on creating extensive T-SQL, queries, views, triggers and stored procedures
• Updating Statistics\Rebuilding Indexes on the database using Ola Hallengren approach.
• Designed Backup\Recovery solution for VLDB system using SQL Server 2012/2014/2016 T-SQL and SQL Server maintenance plans
• Installation, configuration, and maintenance of SQL Server 2008\2012\2016 with SP1\SP2 in development QA, staging and Production environments.
• Configured Log-Shipping for Reporting database on 2014 and also on 2016.
• Installed and Configured Reporting Services URL for Test and Production Reporting databases.
• Installed and Configured Monitoring Tools (SQL DM and SQL CM) Idera Products.
• Provided 24 X 7 supports for Production environment.
• Migrated Databases, SSIS packages from SQL /2014/2016.
• Created extensive ETL and SSIS packages and deployed them to various environments
• Provided Support for database processes and ETL processes from database and server standpoint, worked with developer teams to develop and implement the database changes.
• Managed SQL server usingPowerShell scripts.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008 AZURE, AWS, Windows Server 2012/2008 R2/ 2003, DTS, SSIS, SSRS, SSAS, VMware, .NET, MySQL, IBM TSM, LiteSpeed, Redgate, Oracle, Putty, PowerShell.

Confidential, Charlotte, NC

Sr. SQL Server DBA

Responsibilities:

• Provided On call support for mission critical applications
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Installed and Upgraded from SQL Server 2008R2 to SQL server on Multiple DEV / UAT / PROD/ DR Servers.
• Migrating Databases ranging from 20 GB to 15 TB from SQL Server 2008R2 to SQL server /2016.
• Importing and Reconfigurations of SSIS packages and creating new SSIS packages
• Implementing high availability with AlwaysOn Availability Groups and failover clustering
• Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
• Setup Monitoring Alerts using IDERA diagnostic manager
• Migrating application code and objects from development/test environments to production.
• Fine tuned queries, stored procedures and slow running SQL Server 2016, 2014, 2012, 2008 performance tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Troubleshoot SQL Agent jobs / Maintenance plans, Implemented Ola Hallengren’s maintenance scripts.
• Running extensive backup using VERITAS Netbackup and SQL Litespeed.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Setup, Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
• Checking Database Health by using DBCC Commands and DMVs.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Managing SQL server usingPowerShell scripts

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008, Windows Server 2012/2008 R2, DTS, SSIS, SSRS, SSAS, VMware, .NET, MySQL, LiteSpeed, Putty, Oracle, PoweShell.

Confidential, York, PA

SQL Server DBA

Responsibilities:

• Worked as a production DBA supporting 100+ SQL Servers and resolving Level I, Level II issues
• Administration and maintenance of SQL Server Instances into DEV/UAT/PROD/DR environments.
• Installing and maintaining SQL Server database systems with version 2012/2008 R2.
• Implementing sound backup strategy which includes Full, Differential and Log backups
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Installed and Upgraded from SQL Server 2005 to SQL server 2012 on multiple prod and UAT servers.
• Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Setup, Monitor and troubleshooting Log Shipping.
• Created solid SSIS packages for production environments
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
• Implementing high availability with AlwaysOn Availability Groups and failover clustering
• Checking Database Health by using DBCC Commands and DMVs.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Installed and configured LiteSpeed (Quest Software) for Maintenance of SQL Agent Jobs and Maintenance Plans.

Confidential, Pittsburg, PA

SQL Server DBA

Responsibilities:

• Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Migrating application code and objects from development/test environments to production.
• SQL Server 2014, 2012, 2008 R2 performance tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2008R2 to SQL server .
• Importing and Reconfigurations of SSIS - DTSX packages to Upgraded Instances.
• Setup Maintenance Plans and SQL Server Agent Jobs in Upgraded Instances.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Responsible to Setup, Monitor and troubleshooting Log Shipping.
• Worked in Active / Active, Active/ Passive Cluster environment as a High availability solution.
• Implementing high availability with AlwaysOn Availability Groups and failover clustering
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL Server 2014/2012/2008 R2/2008, Windows Server 2012/2008 R2, SSIS, SSRS, SSAS, VMware, .NET, MySQL, LiteSpeed, Remedy, Putty, Oracle, Powershell.