PROFESSIONAL SUMMARY:

• Total 16+ Years of IT experience and 10+ years as MS SQL Server DBA.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in providing Good production support for 24 x 7.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Capacity Planning.
• Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and standalone environment.
• Having very good experience as Lead role for onshore and offshore model.
• Automate export CSV file and send mail using Database mail using T - SQL.
• Experience working with MS SQL Server 2000, 2005, 2008, 2008 R2 and 2016 versions.
• Expertise in Migration and up gradation from lower version to higher versions like 2014/2016.
• Having very good expertise in windows batch and power shell scripts.
• Prepared templates for migration process for Non Production and Production environments.
• Expertise to enhance the SOP’s for Migration process checklist using SSMA
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL server 2005/2016.
• Implemented Database Mirroring as a High Availability Solution.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing RAID 1-5 & 10 technologies.
• Experience in creating packages, jobs, sending Alert using SQL Mail and Database mail.
• Creation and Maintenance of Databases, Creating Roles and managing user Permissions, resolving deadlocks
• Experience cloud AWS SQL Server installation, maintenance and configuration.
• Worked on SAN (VNX, EMC, IBM and HP Arrays) for SQL Server Databases and good understanding in capacity planning.
• Worked experience in HPSD, ITSM, VM Service Manager and ITG ticketing tools.
• Experience in Microsoft SQL Server CLUSTERING and experience in Tracing SQL Server events and SQL Profiler to McAfee monitor events in an instance of Microsoft SQL Server and AWS
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and related errors.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 CTP 2, MySQL, Oracle 10g and DB2 9.7

Languages: T -SQL, Visual Studio.

Scripting Languages: HTML, DHTML, JavaScript, VB script

Operating Systems: Windows Server 2000/2003/2008/2012, Windows NT 4.0, Windows XP.

Reporting: SSRS, Crystal Reports XI, Power BI

Tools: SSAS (MS SQL Analysis Services), SSIS, IIS, SQL Backup, Foglight, Symantec Net backup, Avamar, Commvault, Cherwell

Networking: TCP/IP, DNS, WINS, DHCP

Other Tools: Quality Center, MS Project, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Lead SQL Server DBA

Responsibilities:

• Work experience with Cherwell Service Management tool for tickets .
• Work experience handing with all government high security data.
• Hands on exposure in Column store indexes and In Memory OLTP.
• Hands on experience in PowerBI reports installation and configuration.
• Installation and configuration for high security servers like DHS, DOC and DCF agencies.
• Working with Microsoft SQL Server Always on, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server 2016.
• Work experience with WUG alerts to priorities alerts as per process.
• Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups using commvault Backup tool.
• Installing, configuration Commvault backup tool on servers and scheduling database backups .
• Working on database Storage migration from 4k block size to 64K block size on sql server 2016.
• Analyze performance statistics on the databases to provide feedback on database performance. This also includes performance tuning of database at a physical level, through file structure, index rebuilds and hardware modifications as well as at query and index level using tools such as profile, explain/execution plan.
• Having very good work experience in automated tool ivanti to schedule sql patching.
• Check the fragmentation and rebuild/ reorganize the indexes using Idera data tools.
• Having hands on experience in clustering and Always on SQL server 2012 and 2016.
• Check the current queue for requests and identify requests to be processed and work on the issue.
• Prepare the build release checklist for Non Production and Production environments.
• Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Working on missing indexes and fine tune the server to access the application Idera quickreindex.
• Check Performance counters on all production servers and verify that all counters are within the normal range. Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.

Environment: MS SQL Server 2012 Enterprise Edition and 2016, Windows Server 2012 and 2016, Commvault Backup, SSIS, SSRS, Idera and WUG Diagnostic tool.

Confidential, West Bend, WI

SQL DBA Lead (Project Lead)

Responsibilities:

• Design a procedure that continuously run on all PROD servers and notifies DBA team if any blockings, long running quires/transactions using Idera tool.
• Work experience on Wealth Management projects.
• Hands on experience in onshore and off shore model working as a lead role.
• Working with Microsoft SQL Server Always on, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
• Working exposure in columnstore index for dataware house environments
• Working as a lead to share work to offshore and conduct scrum call every day to know the status.
• Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups using Avamar Backup tool.
• Having very good experience on call dba 24/7 support.
• Working on database migration from SQL Server 2012 to SQL Server 2014.
• Implementing agile scrum for everyday stand up call.
• Having very good work experience in Virtual environment like VMWare.
• Check the fragmentation and rebuild/ reorganize the indexes using Idera data tools.
• Having hands on experience in clustering and Always on SQL server 2012 and 2014.
• Check the current queue for requests and identify requests to be processed and work on the issue.
• Prepare the build release checklist for Non Production and Production environments.
• Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
• Working on missing indexes and fine tune the server to access the application Idera quickreindex.
• Check Performance counters on all production servers and verify that all counters are within the normal range.
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.

Environment: MS SQL Server 2012 Enterprise Edition and 2014, Windows Server 2008 R2, SSIS, SSRS, Avamar Backup, Idera and Ignite Diagnostic tool.

Confidential, Tampa FL

Senior SQL Server DBA (Lead)

Responsibilities:

• Installation, Administration and Maintenance of SQL Server Instances.
• Regularly monitor and identify blocking issues. We can design a procedure that continuously run on all PROD servers and notifies DBA team if any blockings, long running quires/transactions
• Working with MS SQL Server Database Security and Auditing SQL server Systems.
• Working with Microsoft SQL Server Always on, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server
• Responsible for SQL Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Worked Migration and upgradation from SQL 2012 to SQL 2014
• Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Work experience in Virtual environment like VMWare.
• Check the fragmentation and rebuild/ reorganize the indexes. We can use a native procedure which takes care of the task.
• Installation and configuration in AWS cloud.
• Check the current queue for requests and identify requests to be processed and work on the issue.
• Prepare the build release checklist for Non Production and Production environments.
• Maintenance - Schedule an official maintenance, do all required health checks on all premium databases and servers using windows batch and power shell.
• Implementing TDE for few databases in Production Environment.
• Working on missing indexes and fine tune the server to access the application.
• Check Performance counters on all production servers and verify that all counters are within the normal range. We can design a SSRS metrics report to review the counters for every one hour.
• Responsible for the management of the database performance, backup, replication, capacity planning and giving guidance for the developers.
• Worked in Tracing SQL Server events and SQL Profiler and McAfee monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.

Environment: MS SQL Server 2012 Enterprise Edition and 2014 CTP2, Windows Server 2008 R2, SSRS, SSIS, Symantec Net Backup, SQL Profiler.

Confidential, Houston TX

Senior SQL Server DBA / Architect

Responsibilities:

• Working with MS SQL Server Database Security and Auditing SQL server Systems.
• Working with Microsoft SQL Server Mirroring, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
• Working on data integration (SSIS) with Data HUB team to prepare Data growth report.
• Responsible for Database & Log Backups, Restoration, Backup Strategies, Scheduling Backups.
• Manage Backup, Security, and Controls of databases using RMAN for Oracle.
• Manage Storage & IO performance issues related to SQL databases
• Prepare the build release checklist for Non Production and Production environments.
• Security - Remove unneeded logins and users for individuals that have left the organization, had a change in position, etc.
• Working on missing indexes and fine tune the server to access the application.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Using PowerShell creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Monitored performance and optimized SQL queries for maximum efficiency, worked with SQL Server 2008 R2 Service Broker Applications and hands on experience in Foglight.
• Implementing Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
• Responsible BMC utilities and the management of the database performance, backup, replication, capacity planning and giving guidance for the developers.
• Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity and automate db migration.
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases
• Moving data from production to archive: If your environment requires any specific DBA related data for a long time, plan for an archival procedure. We can achieve data from actual OLTP system to other dedicated DBA Server / Database

Environment: MS SQL Server 2008 R2 Enterprise Edition and 2014 CTP2, Windows Server 2008 R2, Oracle 10g, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler and Index Tuning Wizard.

Confidential, PA

Senior SQL Server DBA

Responsibilities:

• Worked with MS SQL Server Database Security, SSIS, Encryption Keys and Auditing SQL server Systems.
• Worked with Microsoft SQL Server CLUSTERING, Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
• Creation of schema objects, granting roles and privileges to the users, compilation of procedures.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups
• Expertise migration from SQL 2008 to SQL 2012 environment.
• Prepare the Migration checklist for Non Production and Production environments.
• Enhance the SOP’s as per new version development.
• Handling 1.2TB database size and average DB size more than 500GiB.
• Refreshed databases when necessary, worked in SQL Server Performance Tuning and Query Optimization.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitored performance and optimized SQL queries for maximum efficiency, worked with SQL Server 2005 Service Broker Applications
• Implementing Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
• Responsible for the management of the database performance, backup, replication, capacity planning and security.
• Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and added Indexes to improve performance on tables.
• Installing and configuring MS SQL Server 2005/2008 and 2012 (Personal, Standard and Developer Editions)
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity and guidance to developers.
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance of SQL Server
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases
• Deployed the generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008 R2 Enterprise Edition & 2012, Idera SQL Diagnostic manager, Windows Server 2003, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard.

Confidential, PA

Senior SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 in production and development environments.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database for Disaster Recovery.
• Creating back up strategies and scheduling them for execution.
• Performance Monitoring using SQL Profiler, Windows System Monitor, System Stored Procedures, Foglight and DBCC Commands.
• Migration experience from SQL 2005 to SQL 2008.
• Prepare the checklist and enhance the SOP’s for Migration Template.
• Managing average 500 GiB to 600 GiB database in Production and Stage servers.
• Monitored SQL server LOGS, Application logs and analyzed the logs.
• Wrote stored procedures, Triggers, Cursors to implement business logic.
• Monitoring disk space alerts and act as according to the space management.
• Implementing alerts for backup fail/success, disk space, agent jobs fail/success...etc.
• Implemented and documented proactive monitoring scripts for production databases
• Provided support for ETL developers in loading of client’s data into SQL Server using ETL tool.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Configured customized log shipping for SQL Server 2005 importing and exporting of the Database using DTS and BMC utility.
• Creating, maintaining the users, roles and granting privileges.

Environment: MS SQL Server 2005/2008 R2 Enterprise Edition, SSRS, SSIS, SSAS, MS Access, Import & Export Data, Windows 2003

Confidential, Tampa FL

SQL Server DBA

Responsibilities:

• Created and managed Schema object such as tables, views, indexes, procedures and triggers through Query Analyzer
• Created complex Stored Procedures, Functions and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Handling not more than 500 GiB in Production Environment.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Installed and configured SQL Server 2005 on Windows 2003 Servers, applied service packs and security fixes
• Worked with lead developers to help in their applications in terms of Data modeling and designing.
• Performed tuning of SQL statements and Stored Procedures
• Worked as a developer to tune the queries, run scripts and move the database from production to development servers.
• Managing SQLServers in development and production.
• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Created system procedures for database maintenance and monitoring them.
• Testing the application for deployment, Function and behavior testing.
• Backup and Recovery: Designing Backup/Restore Strategy. Setup backup and recovery scripts. Setup exports.
• Performance Tuning: Analyze, tuning and optimizing for SQL Server code by using performance and index tuning wizard.
• Up-gradation of SQL Servers database from version .
• Performed backups and restoration, developed backup strategies, scheduled transfer of backups and tested their viability.
• Database creation and location of database file
• Monitoring of SQL Server/NT performance/deadlock tracing

Environment: MS SQL Server 2000/2005, Windows NT, Crystal Report 8.5, Windows Server 2003.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created and managed Schema object such as tables, views, indexes, procedures and triggers through Query Analyzer
• Created complex Stored Procedures, Functions and other T-SQL code and SQL joins for applications.
• Working on Confidential banking project related servers.
• Responsibilities include tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Installing, Configuring and Maintaining SQL Server 2005 with latest Service Packs, Hot Fixes.
• Implement Log Shipping in SQL Server 2005 from primary server to Standby server.
• Worked with on-site personnel or internal project manager to review problems, define and test solutions, and developed Ad hoc Queries and reports for user management.
• Responsibilities include Upgrading for two applications from MS SQL Server 2000 to MS SQL Server 2005.
• Responsibilities include advising in Planning and designing the Logical and physical Data Modeling.
• Help the team to write and tuned Stored Procedures, Triggers, UDF, Queries.
• Extensively involved in documenting upgrading procedures and project plans from MS SQL Server 7.0 to MS SQL Server 2000.
• Performed Structural changes to Database like creating tables, adding columns accordingto business requirement.
• Monitored growth of data and managed space allocation accordingly.

Environment: MS SQL Server 2005 Enterprise Edition, SSRS, SSIS, TSQL, Windows Server 2003.

Confidential

Senior Software Engineer

Responsibilities:

• Managing of database objects Tables, Views, Indexes
• Installing and configuring of SQL Server2000 on Windows 2000/NT OS
• Involved in writing scripts for the clients requirements for reporting purposes.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Automatic generation of grouping attribute members.
• Defined Granularity with in a measure group and drill through actions.
• Implemented calculations to aggregate physical measures, defined the Browsing Prospective and Browsing Translations and responsible for Process Database Objects Security Role.
• Responsible for writing T-SQL code for creating cursor and handling the data validations and developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Implementing backups and restoring when necessary
• Deployed DTS Packages to transfer the Data between SQL Server database and Files
• Creation and management of database maintenance plan for various database consistency checks
• Used SQL profiler to monitor the Server performance, debug T-SQL and slow running queries
• Extensively used Joins and Sub Queries to simplify complex queries involving multiple tables

Environment: MS SQL Server 2000 Enterprise Edition, Oracle 7.1, Windows XP, .Net Framework 1.1, Windows Server 2000.