SUMMARY:

• Senior MS SQL Server DBA with 8+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2016/ 2014/2012/2008 R2/2005 in Production, Testing and Development Environment’s.
• Worked on Enterprise / Standard and Developer edition
• Experience in Data Migration from MS SQL server 2016/ 2014/2 to 2005/2008/2012 .
• Extensive Monitoring of SQL Server with DMVs and Third Party Tools like IDERA, FOGLIGHT, QUEST
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Intensive experience in Performance Tuning and monitoring SQL Server and database performance using Database Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2005, MS SQL Server 2008R2 and MS SQL Server 2012 databases.
• Expert in monitoring and Troubleshooting SQL Injection
• Experience in MS SQL Server installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC
• Expert in converting Legacy Systems like AS/400, Access and SQL to higher version of SQL Server
• Expert skills in VMware and Virtual environments
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Experience in implementing Log Shipping, Data Mirroring Techniques for Disaster Recovery(DR) and HA
• Expert in other databases like Oracle, Sybase and MYSQL.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T - SQL, PL/SQL on Unix and Windows environment
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Provided 24/7 database maintenance and production support.
• Good Team Player, Strong Interpersonal and Communication Skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, SSRS, SSIS, SSAS, MS Access, ERWIN 4.0/4.1/4.2, Windows 2008, T-SQL, Visual Studio 2008, MS Office, XML,Diagnostic Manager, Visio, SQL Profiler, Query Analyzer, VERITAS NetBackup, RedGate,LiteSpeed, SQL Sentry.

PROFESSIONAL EXPERIENCE:

Confidential, MILWAUKEE, WI

Sr. MS SQL Server DBA

Roles and Responsibilities:

• Primary responsibility to manage SQL Servers in Production and give 24/7 support.
• Worked on Ticketing and Change Management software to resolve and escalate production problems
• Worked individually and part of team in an on-shore off-shore model.
• Installed/configured and applied service packs for SQL Server 2014/2012/2008 R2/2005 on physical and Virtual environments.
• Configured and maintained environments for High Availability (HA) and Disaster Recovery (DR).
• Implemented AlwaysON availability groups with 3 replicas for reporting and maintenance
• Implemented various replication topologies which include snapshot and transaction models.
• Extensively worked on Dynamic Management Views (DMV’s).
• Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008R2/2012/2014 which include installing of SQL Server.
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Installed and Implemented Async and Sync Mirroring / Log Shipping for Disaster Recovery
• Implemented AlwaysOn Functionality for availability groups
• Move SSRS reports from one server to another server and create Data source in SSRS reports
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008, Windows 2008/2012, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring, MS SQL Server 2008R2/2012, MS SQL Server Integration Services 2008R2/2012, MS SQL Server Reporting Services 2012/2008R2, T-SQL, Microsoft Visual SourceSafe 6.0, Microsoft Office Visio 2007

Confidential, Bloomington, IL

Sr. MS SQL Server DBA

Roles and Responsibilities:

• As a Production support DBA responsible for managing production, development and QA environments for OLTP and Decision Support systems.
• Managed SQL Server and 2008 R2 in Enterprise Versions and patching them
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments for SQL Server
• Upgraded and migrated Legacy and SQL databases to latest version of SQL Server
• Managed Production environments and participated in on call 24/7 support
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2014/2012/2008 R2.
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2012/2008 R2/2008 on windows 2012 and 2008 servers, applied service packs and security fix for all servers.
• Exclusive Knowledge of Database security implementing Windows and SQL Authentication.
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2012.
• Experience with HA/DR SAN Production environment - AlwaysOn, Mirrored Cluster, Log Shipping & Replication
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2012.
• Worked in troubleshooting and monitoring SQL injection from various applications
• Monitored SQL Server Environments with tools like diagnostic manager and Foglight
• Implemented replication for database objects, managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Worked on creating .NET/VB and C# applications and supporting those applications
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers, in conjunction with Recovery Time Objectives.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2012/2008R2/2008, Windows 2008/2012, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring, MS SQL Server 2008R2/2012, MS SQL Server Integration Services 2008R2/2012, MS SQL Server Reporting Services 2012/2008R2, T-SQL, Microsoft Visual SourceSafe 6.0, Microsoft Office Visio 2007

Confidential, Los Angeles, CA

Sr. MS SQL Server DBA

Roles and Responsibilities:

• 24/7 Production support for SQL server environment.
• Installing and configuring of SQL Server 2012 and 2008R2.
• Fine-tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Configured and maintained database mirroring for high availability.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV’s).
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2012 and 2008R2 environments.
• Performed DBCC utilities and fixed data corruption in User databases.
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
• Migrated SQL Server 2008 to SQL Server 2012 and SQL Server 2008R2 to SQL Server 2012which include installing of SQL Server.
• Strong in developing, deploying packagesusing SSIS from OLTP to OLAP
• Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintained Referential Integrity.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support

Environment: MS SQL Server 2012/2008R2 Oracle, Windows 2008/2012, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring, MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012, MS SQL Server Reporting Services 2008/2012, T-SQL

Confidential, Los Angeles, CA

MS SQL Server DBA

Roles and Responsibilities:

• Production support for SQL server environment.
• Installed SQL Server 2012 and SQL Server 2008R2 on windows 2012 and 2005 servers, applied service packs and security fix for all servers.
• Developed system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication
• Involved in Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64-bit environment
• Managed SQL Servers in 32/64 bit Clustered environments
• Successfully implemented Database Mirroring in SQL Server 2005/2008R2/2012 for high availability.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Created extensive stored procedure, trigger, view and functions
• Monitored SQL Server for performance bottlenecks
• Tuned stored procedures for maximum output
• Involved in tuning the database and server performance and worked with profiler to trace and tune the database using index tuning wizard
• Administrated the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation, and the impact on the system performance.
• Analyzed potential problems (Response delay, locking, server downtime, etc) to avoid and optimize
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2008R2 to MS SQL Server 2012
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Created proactive scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, database size and service status monitoring
• Created the standard documents for Disaster recovery testing and implemented them.
• Involved in 24x7 on call support

Environment: Windows XP, T-SQL, MS SQL Server 2012/2008R2, MS SQL Server Analysis Services 2012/2008R2, MS SQL Server Integration Services 2012/2008R2, Crystal Report, SharePoint 2007, MS SQL Server Reporting Services 2005, ProClarity

Confidential, Long Beach, CA

MS SQL Server DBA

Roles and Responsibilities:

• Production support for SQL server environment.
• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2005 and 2008R2 environments.
• Involved in Migration from SQL 2005 to SQL 2008R2.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• 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.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler
• Implemented Backup and restore in SQL Server using Third party tool Idera SQL safe.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting service 2008, MS SQL Server Integration service 2008, T-SQL, DTS, SSIS, C#, .Net, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2008, Crystal Report