SUMMARY

• 8 years of Administration experience on Data Design using SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 systems in OLTPand OLAP environments.
• Expertise in installing MS SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Expertise in setting up Active/Passive and Active/Active Clusters, Load balancing and Failover for High availability.
• Implemented In Place and Side - by-Side Migration of MS SQL SERVER 2000/ R2 and from lower versions to 2012, 2014 and 2016.
• Dexterity in implementing different types of High Availability & Disaster Recovery scenarios like Always ONAvailability Groups, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Data modeling Experience including Physical and logical data modeling using ERWIN & VISIO.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Proficient in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon Counters.Experience in resolving locks deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Acquaintance in supporting Very Large databases (VLDB) 2TB and troubleshooting the problems in OLTPand OLAPEnvironment.
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach. Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and Reporting Services (SSRS) reports.Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
• Good hands on experience with T-SQL.
• Experienced in monitoring servers health using SCOM.
• Involved in Change data capture process.
• Flexible, Enthusiastic and project oriented team player with excellent communicationskills and analytical skills to develop creative solution for challenging client needs.
• Ability to work within team environment and independently as needed
• 24 X 7 Production Database on Call Support.
• Strong analytical and problem solving skills

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008, 2003, 2000, Windows XP Professional, Vista and Windows 7

Databases: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MYSQL, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Integrator, Data transformation services (DTS)

Data Modeling/Third party tools: Erwin, Red gate, Litespeed, fog light

Languages: T-SQL, C/C++, javascript, Visual Studio2005/2003, ASP.NET, VB.NET, Shell scripting

Applications: Microsoft Office Suite, Adobe Photoshop, Macromedia Dreamweaver, Adobe Professional Suite

Tuning Tools: Perfmon, SQL Profiler, Idera tools

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. SQL Server DBA

Responsibilities:

• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Managed databases during the P2V and V2V Server Conversions.
• Installed and Upgradedfrom SQL Server2005/2008to SQL server 2008 R 2/2012/2014/2016.
• Migrated Databases on SQL server2005, 2008/R2, 2012, 2014&2016 from local datacenter to cloud based environment
• Worked on 2-node(Active-Passive, Active-Active) and 3-node (Active-Active-Passive) Clusters and DB Mirroringenvironment as a High availability solution.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP.
• Managed Security using SQL Logins, Permission, Roles and Security Modes as a part of Security Policies for various categories of users.
• Controlled and coordinated the installation of Security Patches and Service Packs.
• Responsible for IIS Administration for web applications includes creating virtual directories, connecting to servers, managing Services and configuring IIS backup and recovery.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Deployed and managed reports using SQL Server Reporting Services (SSRS).
• Deployed database objects from development/testing environment to production environment.
• Extensively worked on SQL Profiler & Performance Center to perform day to day tasks and tune the databases, servers and query tuning respectively.
• Review the blockings/deadlocks issues and work on it to get those corrected.
• Assist DBA team in Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc).
• Responsible for monitoring Jobs, Disk spaces, Error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
• Responsible for Application support for front end feeds and Resolved Application connectivity issues like connection time-outs, connection pooling issues and memory leaks.
• Setting up and Monitored transactional replication, Database mirroring and log shipping, Always On Availability Groups on Production, QA and Dev servers.
• Resolve SQL Server problems in conformance with SLAs which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, database corruption, security and log-shipping.
• Documented Trouble-shooting guide for various issues.

Environment: Windows Server NT,2003,2008,2008R2 & 2012 MS SQL Server 2016, 2014,2012/2008 & R2/2005/2000, SQL Management Studio, SQL Profiler & Performance Center, Query Analyzer, SSIS, SSRS, Configuration Manager, System Monitor/Performance Monitor.

Confidential, Memphis, TN

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Migrated In-place and side-by-side SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and 2008 R2 to 2012 mentored other technical staff.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2012 like Always on Availability Groups.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Maintained Production and Test Database Environment in SQL server 2012, 2008R 2/2008/2005.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file. Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.

Environment: Microsoft Windows 2008R2, 2008, 2003 Server, Microsoft SQL Server 2012,2008 R2, 2008, 2005, IDERA Management Tools, MS Visual Source Safe, IIS 6.0, XML.

Confidential, Brisbane, CA

SQL Server DBA

Responsibilities:

• Extensively managed and administered SQL Server 2008 R2/2008/2005 and 2000 servers.
• Installation ofSQL Server 2008R2/2008/2005on DEV, Staging and Production Servers for teams.
• Migrated SQL server 2000 databases into SQL server 2005/2008R2 databases.
• Monitored SSIS packages and job workflows for used database partitions to manage data.
• Transferred SQL Server Objects from QA to Production Using SSIS Packages.
• Used SQL Server Dynamic Management Views (DMVs) to track performance and usage.
• Configured Reporting Server Using Reporting Services Configuration Tool.
• Worked with SQL server Profiler to generate traces and fine-tuned databases and T-SQL.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns.
• Managed SQL Object Permissions, Roles and Authentication Modes for security policies.
• Rebuilding the indexes at regular intervals for better performance and updated statistics.
• Maintaining SQL scripts for creation of Database Objects using Red Gate’s Source Control.
• Created Database maintenance plans and performed DBCC Database Integrity Checks.
• Configured Report Server (SSRS) and scheduled SSIS packages with alert notifications.
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Used log shipping for synchronization of databases between Primary and Standby servers.
• Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Worked on database design for Query optimization, performance tuning and Indexing.
• Extensive testing on the Performance of the Stored Procedures, Functions, T-SQL queries.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation to ensure optimal DB performance.
• Developed operational drill-down reports using SSRS and added report parameters.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to SQL Server instances for DEV, QA, Staging and Production environments.
• Provide 24x7 Production Database on-call support as needed.

Environment: SQL Profiler, SQL Server 2000/2005/2008/ R2,T-SQL, Business Intelligence (SSIS,SSRS) Excel, Windows 2008/2003 Server, Red Gate Source Control, Erwin 4.0, Lite Speed

Confidential, Hartford, CT

Jr. SQL Server Developer/DBA

Responsibilities:

• Installed, Configured, migrated SQL Server and DTS to SSIS (ETL) for enterprise servers, migrated logins with minimal downtimes.
• Scheduled jobs and monitored job failures to diagnose the problems.
• Hands on experience with backup and restoring databases for large OLTP systems
• Dealt with database and table privileges and permissions in SQL 2005/2000.
• Dropped and recreated the tables for the damaged databases to avoid data loss.
• Responsible for data portioning and disaster recovery plans in SQL 2005.
• Designed Physical and Logical Modeling using Erwin Case Tool.
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse, accounts, tables and Column Mapping, Data.
• Wrote T-SQL code for creating cursors and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed application Stored Procedures, SSIS packages, triggers, cursors, tables, and views

Environment: SQL SERVER 2000/2005, DTS, SSIS, SSRS, Erwin, Windows 2000/2003 Server.