SUMMARY

• 8+ Years of IT experience in SQL Server Administration, Development, and Database Design using MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 environments.
• Experience in installing MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 and updating with hot fix and service packs.
• Expertise in installing and configuring sql server 2012 Always on availability groups on windows server 2008R2/2012.
• Hands on experience with High Availability & Disaster Recovery Solutions - Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Extensively worked on Active-Active and Active-Passive two node Clustering and three node clustering (Active-Active-passive).
• Implemented Side-by-Side and In - Place Migration of MS SQL SERVER .Experience in migration of sql server 2008 databases to sql server 2012.
• Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.
• Configured the AWE and /3 GB switch for the 32 bit 2000/2005 server.
• Good Experience and knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios
• Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/O, Memory bottlenecks.
• Extensively used repositories like Team Foundation Server (TFS)
• Experience in configuring Data Quality Services,(DQS), Master Data Services (MDS) and IIS.
• Very Extensively used the native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuningwizard, database tuning advisor for performance analysis
• Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
• Implemented Change data capture(CDC)
• Handled Large Databases in Clustered environment using Physical Storage Configuration and SAN Optimization with different RAID Levels .
• Experience on Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, DTS, BCP, BULK INSERT etc.
• Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Good at SQL Server 2008 new concepts like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE),
• Good knowledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
• Used Basic power shell scripts .
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
• Knowledge on developing and deploying OLAP cubes through SSAS.
• Experience on installing and configuring SSRS on windows environment; also know the process of generating different types of reports.
• Hands on experience in working with System Center Operations Manager (SCOM) and Ignite Used third party tools like Lite speed, Red gate, idera diagnostic manager,splunk dashboard, splunkFog light, Used pragmatic workbench.
• Ability to work independently as well as in a team
• Experience in production support, 24 X 7 on call.

PROFESSIONAL EXPERIENCE

Confidential, Bakersfield, CA

SQL Server DBA

Responsibilities:

• Installation and configuration/Maintenance of SQL Server R2/2008/2005 in all Environments
• Configured and maintained Transactional Replication
• Configured Sql server 2012 Always on availability groups with one secondary replica on windows server 2008R2/2012 .
• Applying sql server patches on all the sql servers
• Database migration from sql server 2008r2 to sql server 2012.
• Worked and involved on database pre-deployment and deployment DBA activities on production servers
• Updating the SQL service account passwords prior to expiry on all the servers as per the audit requirement .
• Monitoring all the SQL server alerts like disk space issues and SQL job failures and fixing the issues .
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
• Database Security Maintenance
• Installed sql server 2014 on test servers for testing purpose .
• Created Linked servers accordingly in between the different servers based on the requirement.
• Worked on troubleshooting long running queries, blocking issues and temp db issues
• Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis. Monitoring Event Viewer, SQL Error logs for errors.
• Involved in Capacity Planning and adding new storage space as needed
• Responsible for monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases.
• Configured Report Server Using Report configuration manager in SQL server 2008R2
• Used IDERA & splunk monitoring tool and upgraded IDERA Diagnostics Manager to the latest version
• Documenting all the issues encountered and all the important activities accomplished in the environment.
• Used Remedy ticketing tool in Resolving database related incidents and requests, resolving incidents within defined SLA's and respond to database related alerts escalations.
• Worked on call 24/7 Support on weekly basis.

Confidential, Richmond,VA

SQL Server DBA

Responsibilities:

• Installation and configuration/Maintenance of SQL Server R2 in newly configured standalone and Cluster Environments
• Configured Sql server 2012 Always on availability groups with one secondary replica on windows server 2008R2/2012, Worked on Always on proof of concept performed various failover test cases.
• Implemented and managed the clustering environment like Active/Passive .
• Worked on side by side migration, migrated sql server 2008r2 databases and ETL packages to sql server 2012 using team foundation server .
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring
• Implemented and maintained Replication (Transactional, Snapshot) .
• Worked on Team foundation server(TFS), created team projects and builds to deploy databases, ETL Packages, sql jobs.
• Worked on rebuilding sql server due to unexpected crash by Rebuilding Master Database in SQL Server as a part of recovery process and also worked on moving system databases from existing drive to new drive as per the requirement.
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, Check DB and Update Statistics. Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
• Created proxy accounts to lock down the permissions to the users were the ssis packages runs under the proxy account
• Installed and configured master data services(MDS),IIS,SQL Server Data Quality Services (DQS)in sql server 2012.
• Created new new integration service catalog (ssisdb) used for monitoring and managing SSIS projects
• Involved in Capacity Planning and adding new storage space as needed
• Worked on purge process as a part of database maintenance.
• Implemented CDC (Change data capature)
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Worked on tuning sql queries by adding the missing indexes
• Pro-actively monitoringand managingSQL Serverperformance like disk space issues, Log file full and backup failures .
• Used native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuning wizard, database tuning advisor for performance analaysis to optimize queries and enhance the performance of database servers.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Worked on tools like Idera diagnostic manager, pragmatic works doc xpress .
• Worked on call 24/7 Support on weekly basis.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2008R2/2012 Server,, Scom, Idera, pragmatic works doc xpress, web server IIS 7, vmware vsphere client.

Confidential, COLUMBUS, OHIO

Production DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008R2/2012 in newly configured standalone and Cluster Environments
• Managed and Administrated theSQL Server 2012/2008R 2/2008/2005/2000 production and Non-production servers for different applications.
• Implemented & managed clustering, failover as per client requirement Active/Passive & executed of any upgrade such as ServicePack, in Active/Passive clustering and Active/Active/passive clustering.
• Complete production database support for the applications in production, QA and test Servers in dedicated and shared environments.
• Involved in migration of SQL Server 2005 databases to SQL Server 2008R2 databases and sql server 2008r2 databases to sql server 2012
• Implemented database mirroring and logshipping for few applications as a part of disaster recovery plan.
• Validating applications before going to live from preprod stage to production .
• Performing Database Maintenance activities such as Backup, Restore and Optimization, Performed Database Restores/Refresh from Production to QA/TEST /DEV serevrs .
• Worked on very large and complex databases around 1.9TB .
• 24/7 on call support for all applications with severity ranging from level 1 to 3
• Maintaining High Availability of Production environments
• Extensively worked on Dynamic Management Views (DMV’s) and DynamicManagement Functions (DMF’s).
• Responsible for capacity planning, estimating database growth and disk space management performed installations & performance tuning,, and implement database security for multiple instances of development, QA, and production SQL Servers databases.
• Creating Logins and Roles with appropriate permissions
• Resolve issues in SSIS Packages and DTS package .
• Used third part tool like Litespeed and monitoring tool like Ignite for sql server performance issues .

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2003/2008R2 Server,OEM and Lite speed,IGNITE,Lumigent, Red gate .

Confidential, DESMOINES, IOWA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008/2008 R2on Test, Development and Production Environments.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases
• Implemented Database Mirroring, Transactional Replication and Cluster Active-passive as a part of DR plan.
• Performed SQL Server service pack up gradation and Release to Production.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Usage of new compression Techniques in SQL Server 2008/2008(R2) for backup and restore jobs.
• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
• Configured and deployed SSIS Packages from Test to Production Environments
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Create stored procedures, Functions,Indexes,Tables,views and other T-SQL code for applications following T-SQL code standards.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Involved in Capacity Planning, Database Normalization and De-normalization process, monitoringand managingSQL Serverperformance like disk space issues, Log file full and backup failures.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
• Handled lot of production issues like data correction and resolves error handling
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics worked on large databases in OLTP environment, Managing the San backups.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Implementing Change management processes to prevent production disruptions and outages.

Environment: Microsoft Windows 2008 Server, MS SQL Server 2005/2008/2008 R2/2012, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, SSIS, ASP.NET, Litespeed, MS- Excel, MS-DOS. Share point, SCOM, idera and VERITAS Net Backup.

Confidential

SQL Developer/DBA

Responsibilities:

• Installation and maintenance of SQL Server installations..
• Configuring and monitoring Log Shipping for few databases in the enterprise.
• Configuring and maintaining multiple replications for reporting.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Developed and deployed OLAP cubes for reporting purpose using SSAS
• Involved in creating Stored Procedures, views, tables, constrains.
• Involved in logical & physical design, development and testing of the system
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application
• Involved in logical & physical design, development and testing of the system
• Dropped and recreated the indexes on tables for performance improvements.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application
• All regular SQL DBA tasks.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, Microsoft Visio 2003, and Microsoft Reporting Service, Excel, Crystal reports,, SQL Enterprise Manager, VB.NET .