SUMMARY:

• 8+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005 in Production, Test, Development and Cluster Server Environments.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/ 2008/2012/2014/2016 .
• Experience in Disaster Recovery Planning, Capacity Planning, Execution and Testing at remote side.
• Migration experience from MS SQL Server 2008/2008 R2 to MS SQL Server 2012 and MS SQL Server 2012 to MS SQL Server 2014.
• Worked on ORACLE and DB2 environments, DB2 experience is limited to script deployment and validation.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Plan and implement proper HA/DR solutions for critical business systems utilizing Always On Availability Groups
• Experience in upgrading SQL server software to new versions and applying service packs and hot fixes.
• Provide production support in a 24x7 environment, including after hours and weekend support as required.
• Creating Database(s) on SQL AZURE and new SQL Server Azure Cloud Services subscriptions.
• Creating New Storage Account, selecting Disk Types, configurations and attaching them to Servers.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Participated in Maintenance activities of SQL Azure, Writing stored procedures, functions and complex T - SQL queries in SQL AZURE Cloud.
• Worked on SQL safe and Avamar third party tools for backup and Restore operations.
• Applied service packs to Non-Prod, PROD servers in both stand alone and clustered environments as needed.
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Implemented high availability on the various servers using replication model like Snapshot replication, Transactional replication.
• Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT and Production environments.
• Experience in configuring and managing Cluster SQL Servers in Active/Passive and Active/Active.
• Experience in design, implement, and execute database backup/restore strategy based on service level requirements
• Expertise in working with large scale enterprise level environment with VLDB’s.
• Expert in troubleshooting replication and mirroring issues.
• Troubleshooting different connectivity issues, linked server security delegation (NTLM, Kerberos) issues and SPN issues.
• Experience in working with Transparent Data Encryption (TDE) to encrypt database files.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Experience in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Expert in implementing high availability using Log shipping, Replication (Snapshot &Transactional) and Mirroring in SQL Server 2014.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2008 Business Intelligence Reports, SQL Server 2008r2 Reporting Services (SSRS), Crystal Reports.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Proven and recognized for communication skills, self-motivation, multi-task oriented with strong work ethics and ability to work efficiently.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2016/2012, Windows Server 2008, Windows 2003 Server/ Advanced Server, Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS,SSRS

Web Technologies: XML, HTML, VBScript

GUI Tools: Visual Studio (VB), Visual Studio 11.0/12.0/14.0

Languages: VB 6.0, VB.Net, T-SQL

.Net Technologies: VB. NET, ASP.NET

Web Server: Internet Information Server

Databases: SQL Server 2014/2012/2008 R2/2008/2005, MS Access, Oracle 9i.10g, 11g

Version Tool: Visual Source Safe

Reporting Tools: Business Objects, Crystal Reports

OLAP Tools: SQL Server Reporting Server 2012/2008, SSIS (as ETL)

Third Party Tools: Lite speed, Erwin, DB Moto, Idera, Red Gates tools, AQT, AVAMAR, Sql safe

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr. SQL Server DBA

Responsibilities:

• Designed and implemented Always On Infrastructure to provide End-to-end Database/application hosting for over 25 applications.
• Implemented Always On SQL Server 2016, Clustering, Mirroring and Log shipping for High Availability & Disaster recovery.
• Installed, configured, administered, secured SQL databases on production and non-production servers.
• Worked on SQL Server migration, upgrade and data recovery projects.
• Involved in constant security and Data Audit projects.
• Experience in deploying SQL Databases in AZURE.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure
• Adhered to SLAs, fixed issues involving in-depth knowledge of SQL Server.
• Troubleshoot and fix connectivity issues, disaster recovery problems, and replication ensuring we made sure that we maintain High Availability always.
• Implemented DR Failover exercise, Capacity planning and migration projects.
• Worked closely with Bug fixes and release management projects with Application/Development teams.
• Knowledge using Business Intelligence on SSIS and SSRS.
• Experience in deploying scripts in Oracle and exports/ import as part of lower environments refresh.
• Deployed scripts in DB2 databases on AS400.
• Applied patches and service packs, hot fixes to update different versions of MSSQL server.
• Installed and configured Avamar software in Standalone and Clustered sql server instances.
• Experience in working with SQL safe backup and restore operation.
• Troubleshooting Avamar failures and validating the backups.
• Developed and documented backups & recovery strategies, disaster recovery mechanism and participated disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.

Environment: SQL Server 2005/2008R 2/2012/2014/2016, Windows Enterprise Server 2008R2, 2012 and 2016 cluster, IIS 6.0, T-SQL, SSIS, SSRS, ServiceNow, PowerShell, Idera, Azure, Perfmon, SCOM, SQL DATA Compare, AQT, SQL developer, Putty, DB2 tools, Avamar, SQL safe, SSAS, Oracle, DB2.

Confidential, Charlotte, NC

Sr. SQL Server DBA

Responsibilities:

• Provides ongoing support for MS SQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade.
• Installed and Configured MS SQL SERVER 2012/14/16 on Stand-Alone, and Failover Cluster.
• Designed and implemented SQL server's migrations from 2008R2 to 2012/14/16.
• Configured and Managed the High Availability and Disaster Recovery Solutions Always On, Replication, Clustering on Critical Production Servers.
• Configured and Managed Always on Availability Mirror Groups and Replica Databases.
• Upgrading the existing servers with Service Packs, Patches and Hotfixes.
• Installation of SQL 2012 on Windows Azure environments and creating, managing databases in Azure.
• Experience in working and troubleshooting Very Large Database (VLDB) in OLTP Environment.
• Experience moving backups from Data Domain to Azure cloud storage.
• Perform database troubleshooting, management, backup, restore and routine maintenance DBCC, Re-index of database table indexes, database performance tuning.
• Management and maintenance of backups and recovery procedures in Oracle.
• Managed Users, Roles, Principals and Securable Administration to access the databases at various levels to provide better security on both SQL Server and Windows Authentication Modes.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Migrated SSIS packages from development to test to Production environments using SSIS configuration files and deployment wizard.
• Managing Windows Cluster Services Installation & Administration.
• Reviewing and Implementing Service now changes in PROD as planned.
• Incident Management and Change Management Requests on Production, UAT and QA Servers were Handled and Resolved Using Service now application.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• Worked with RDBMS principals such as table design, normalization, ACID properties, relationships, and referential integrity
• Supported 24 X 7 Production On call.

Environment: SQL Server 2008R 2/2012/2014/2016, Windows Enterprise Server 2008R2, 2012 and 2016 cluster, IIS 6.0, T-SQL, SSIS, SSRS, ServiceNow, PowerShell, Idera, Azure, Perfmon and SCOM, Sql Compare, SQL Safe.

Confidential, Des Moines, IA

SQL Server DBA

Responsibilities:

• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2012/2014.
• Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers
• Provide ON-Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).
• Architected and built SQL Multi node HA/DR Design using SQL Always On (AG). The infrastructure contains multiple AG groups to host SharePoint databases in order to balance online traffic.
• Strong experience in capacity planning, implementing backup and recovery strategy for application and database.
• Encrypted database files using Transparent Data Encryption.
• Created and maintained various logins and managed database security based on the required access on Production and Development environments.
• Applying service packs, cumulative updates and hot fixes in as required.
• Migration experience MS SQL Server 2005, MS SQL Server 2008 R2 to MS SQL Server 2012 and MS SQL Server 2014.
• Configured SQL Server jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Installed SQL server 2012, 2014 on Production and 2016 on a test environment to be the future production environment.
• Implemented high availability on the various servers using replication/mirroring.
• Performed data transformations between servers using BCP, DTS, SSIS, and bulk insert.
• Experience in administering SQL Server Reporting Services and SQL Server Analysis Services
• Created various SSIS packages based upon the requirement and Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Installed and configured SQL Server Reporting Services and created various reports using SSRS.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).

Environment: Windows 2008/2012, MS SQL Server 2008/2012/2014/2016, Oracle10g/11g, SSRS, DTS, SSIS, BCP, SQL Server Profiler, VB.NET, T-SQL, Erwin, Database engine tuning Advisor, IIS.

Confidential, San Antonio, TX

SQL Server DBA

Responsibilities:

• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2008r2/2012.
• Ensure database availability in a production environment, including backups and disaster recovery. Implement SQL Server High Availability (HA) using Windows clustering, and Disaster Recovery (DR) solutions like database mirroring and/or log shipping.
• Managed database security on Production and Development environments.
• Applying service packs and upgrades to the SQL Server instances.
• Upgraded and migrated the servers from SQL Server 2005 to SQL Server 2008R2/12.
• Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities
• Upgraded legacy 2005 databases to SQL server 2012.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Highly experienced in configuring and maintaining High Availability Solutions including Mirroring, Log shipping, and Replication in SQL Server 2008, 2008 R2 and 2012.
• Exceptional T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers and Views and complex query writing.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Supported SSRS reporting and SSIS integration on all platforms.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Created necessary templates for various requirements gathering and documentation.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, Microsoft Windows2003/2008r2 Server.

Confidential, Fort worth, TX

SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2008, 2008 r2 and 2012 in a multi-instance environment
• Executed database upgrade and migration, & applied service packs, security updates & hot fixes.
• Performed logical and physical database design, configuration and deployment
• Created database objects including tables, triggers, views, stored procedures, and indexes
• Set up database maintenance plan, disaster recovery plans and procedures
• Performed and managed database backup and restore
• Responsible for Database Backup and recovery. Monitoring the database backup, drive space, log space and Critical errors for all production servers,
• Implemented high availability technologies: Replication/Mirroring/Clustering/Log shipping and Always On.
• Enforced SQL server security by managing logins, server roles, database users, roles and permissions
• Maintained system performance and troubleshoot issues related to database integrity, performance and security
• Created, automated and monitored jobs and resolved jobs that have filed
• Configured and managed database mail, operators and alerts
• Configured and monitored log shipping, database mirroring and replication
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Installed and configured SQL Server Reporting Services.
• Deployed SSIS packages & SSRS reports and migrated data from MS Access, MS Excel and text files to SQL Server.
• Involved in complete database design including conceptual, logical and physical models
• Used third party tool, Lite Speed to speed up backup operations.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: Windows 2003,MS SQL Server 2005/2008, Oracle 9i, T-SQL, Visual Studio.Net 2003, Crystal Reports 8.5,Business Objects 6.1b,SQL Loader, CommVault, Lite Speed, MS Access, DTS, BCP,SSIS, SSAS,SSRS, SQL Profiler.

Confidential, Fort Worth, TX

SQL Server DBA

Responsibilities:

• Installed SQL Server service packs based on the errors and flaws that are found in the application
• Supported 24 X 7 Production environment
• Configured and supported replication and log shipping in 2008.
• Performed day to day DBA activities such as monitoring SQL Server health, job status and addressing user requirements.
• Monitored and optimized system performance using DMVs, Activity monitor, DBCC utilities, SQL Profiler and Database Engine Tuning Advisor.
• Participate in implementation of new releases into production.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Used Erwin for physical and logical data modeling.
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Created multi-format reports using Crystal 9.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Controlled user access rights, and managed data security.
• Traced long running queries and deadlocks using SQL Profiler.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, Visual Studio.Net, Erwin, Business Objects 6.x, Crystal reports 9, T-SQL, MS Access, SQL Profiler, System/Performance Monitor, DTS, Power Shell.