SUMMARY

• A Microsoft Certified SQL Server Lead DBA with 10 years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server R / 2000 in Development, Test and Production Environments on various business domains like Banking, Energy, Insurance, Telecom, Marketing and Manufacturing.
• Expert in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading, Patching and Migrating SQL Server 2014/2012/ 2008 R 2/ 2008/ 2005/ 2000 on various windows platforms on Clustered and Standby Environments including SSIS, SSRS and SSAS.
• Experience in implementing high availability solutions like SQL Server Always ON, Log shipping, Clustering, Mirroring using different modes and Replication.
• Solid Hands on experience in upgrades/migrations of SQL 2000 to SQL 2005, 2005 to SQL 2008 R2, SQL 2000/2005/2008 R2 to SQL 2012 and 2014 and applying Service Packs, extensive experiences in migrating and new installations of SQL Server on Hyper - V & VMWARE environments.
• Expert in designing infrastructure for SQL Server and Disaster Recovery (DR) and High Availability (HA) strategies across Data Centers.
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like VERITAS NetBackup, RedGate, TSM and LITESPEED.
• Excellent understanding on SQL Server security model, Roles, Users and permissions and Active Directory.
• Excellent back end skills in developing SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, user defined data types and functions and experience in PowerShell.
• Expert in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC.
• Used SQL Profiler, Extended Events, Database Tuning Advisor, Execution Plan, Performance Monitor and DMV/DMF/DBCC Commands to fix multiple performance issues.
• Experience in working with developers providing best practices, tuning queries & deploying SSIS packages.
• Experience capacity planning, maintenance planning, Backup, Restore, Table level Compression, Partition, Database mail and Data Archiving.
• Created complex SSIS Packages for application data migration and transformation.
• Experience in creating and deploying reports using SSRS and generating reports from Oracle\DB2 environments.
• Experience in SSAS administration cube backup, migration processing and security.
• Created linked servers between Oracle\DB2 and MS SQL Server and also deployed SSIS packages for data transfer.
• Provided 24/7 support in monitoring, troubleshooting, optimizating and tuning of SQL Server environments and Good hands on performance and tuning issues and developing and implementing emergency fixes, resolving database problems.
• Experience in migrating Sybase 12.5 and Oracle database to SQL Server using SQL Server Migration Assistant (SSMA).
• Excellent communication skills and ability to develop solutions for client needs using agile and waterfall methodologies, has the ability to work in a fast paced environment, good team player and can work independently.

TECHNICAL SKILLS

Languages/Technologies: C, C++, DDL, DML, T-SQL.

Software Concepts: Object Oriented Analysis and Design, Relational Database Design

Databases: SQL Server 2014/2012/2008 r 2/2008/2005/2000 and MS-ACCESS.

Tools: Used: SQL DB Access, SQL Profiler, Query Analyzer, Performance Moni-tor, Backup Utility, TDP/TSM, Lite Speed, Red Gate, Fog Lite, Quest Spotlight Diagnostic Server, Crystal Reports, SSRS, Various Change/Incident/Problem management tools.

ETL Tools: SSIS, DTS, Bulk Insert, BCP, Strong knowledge on SSAS

OPERATING SYSTEMS: Unix, Windows 2012/2008R 2/20008/2003/2000

PROFESSIONAL EXPERIENCE

Confidential, Cranston, RI

Lead SQL DBA

Responsibilities:

• Working as a lead support DBA by managing 150+ production servers.
• Build, configured and administered Stand Alone and Cluster SQL Server 2008 R2, 2012 and 2014.
• Upgrade/Migrating SQL 2008 R2 to SQL 2012/2014, SQL 2005 to SQL 2008 R2, SQL Server 2000 to SQL Server 2005.
• Involved in Capacity management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.
• Implemented high availability strategies like Always ON, Database Mirroring, Clustering, Log Shipping and Replication.
• Managed Cluster environment in both Active/Active and Active/Passive.
• Performed routine maintenance activity, Performance tuning and query optimization.
• Implemented Secure Operation like backup policy, Strong Passwords, Cross database ownership changing, disabling XP CMDSHELL etc.
• Automated database refresh from Production to Development for testing.
• Involved in performance tuning with stored procedure and T-SQL having high response time.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Applied patches and hot fixes.
• Written Scripts using DMVIEWS in SQL Server for troubleshooting indexes, performance tuning and instance health check activities.
• Documenting the standard procedures on regular basis.
• Responsible for query optimization using SQL tools such as SQL Profiler and Index tuning wizard.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring DB Servers, Instances and Clusters with custom scripts\ jobs.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles
• Automated operational reports using PowerShell and SQL Server jobs.
• Worked on SSRS installation, configuration and creation of reports.

Environment: SQL Server 2000/2005/2008 R2/2012/2104, PerfMon, Failover Cluster Manager, DTS/SSIS, SSRS, SQL Profiler, Extended Events, SQL Tuning Advisor, SQL IO bench mark, Foglight, LiteSpeed, ITSM, SCOM, PowerShell.

Confidential, Minneapolis, MN

Senior SQL DBA

Responsibilities:

• Working closely with different teams at client location to gather and understand the database requirement, setting up of new databases in both development and production environments and coordinating with the clients for enhancements.
• Build, configured and administered Stand Alone and Cluster SQL Server 2005, 2008 R2 and SQL 2012.
• Upgrade/Migrating SQL 2008 R2 to SQL 2012, SQL 2005 to SQL 2008 R2, SQL Server 2000 to SQL Server 2005.
• Involved in Capacity management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.
• Implemented high availability strategies like Always ON, Database Mirroring, Clustering, Replication and Log shipping.
• Managed Cluster environment in both Active/Active and Active/Passive.
• Implemented Secure Operation like backup policy, Strong Passwords, Cross database ownership changing, disabling XP CMDSHELL etc.
• Configured Security at AD group and SQL Server level by creating Principals (logins) and mapping Users to Roles. (Securables and Permissions).
• Maintaining SQL SOX database instances to abide with UA6 & UA7 Policies. Co-coordinating with IBM to keep Instances/databases GSD331 Compliance.
• Backup and restoring databases from Production to Development for testing.
• Review the logical\physical design in Sybase power designer tool and generate the database objects script.
• Writing SQLCMD scripts for capturing daily operational metrics like backup failures, SQL Job failures, SQL Availability groups running on secondary instance, SQL Cluster resources running on secondary node etc.
• Involved in performance tuning with stored procedure and T-SQL having high response time.
• Designed SQL Jobs to capture index usage, duplicate indexes, fragmentation etc. to periodically monitor the performance of the application databases.
• Written Scripts using DMVIEWS in SQL Server for troubleshooting indexes, performance tuning and instance health check activities.
• Troubleshooting Blockings & Dead Lock issues in SQL Server.
• Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and Index tuning wizard.
• Monitoring DB Servers, Instances and Clusters using SCOM.
• Automated operational jobs using PowerShell and SQL Server jobs.
• Used DB Artisan extensively managing DB objects of Sybase ASE 12.5 until 2012.

Environment: SQL Server 2000/2005/2008 R2/2012, PerfMon, Failover Cluster Manager, DTS/SSIS, SSRS, SQL Profiler, SQL Tuning Advisor, SQL IO bench mark, Quest Spotlight Diagnostic, DB Artisan, Service Now, SCOM, PowerShell.

Confidential

SQL DBA

Responsibilities:

• Installed and administered SQL Server 2000/2005 and created databases.
• Migrating SQL Server 2000 to SQL Server 2005.
• Used Microsoft SQL Server 2005 Upgrade Advisor to analyze our current SQL Server 2000 installation before doing migration.
• Created Login accounts and database user accounts. Managed database security using groups and roles.
• Created database Objects and managed the permission access on the objects with necessary security.
• Performed database Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up system databases.
• Estimated the space and did the Capacity Planning on Tables. Managed the Database size of more than 800GB.
• Automated consistency check of the database (DBCC) for SQL Server
• Analyzed & Fine-tuned the SQL Server performance at regular intervals.
• Extensively used BCP Utility/Import and Export to load the database from text files received from different applications.
• Created the necessary indexes to improve the query performance.
• Restoring Production Databases to Development Servers on regular basis.
• Maintaining databases by following best practices and documenting all the processes involved in maintaining the database for future references.
• Coordinating in reviewing the application scripts and implementing in UAT & production environments.
• Load data using Bulk Insert and DTS Import/Export Wizards.
• Tuned T-SQL queries using Execution Plans for better performance.

Environment: SQL Server 2000/2005. PerfMon, Cluster Admin, DTS, SQL Profiler, SQL Tuning Advisor, Manage Now (Change/Incident management tools).

Confidential

SQL Developer / DBA

Responsibilities:

• Developed database objects like Tables, views, stored procedures, indexes etc.
• Wrote various stored procedures for the purpose of application development.
• Wrote SQL Scripts to select the data from the source.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Maintaining the jobs schedules during the night for the Backup of Databases.
• Scheduled the Full, Differential and Transactional log backups for the user created and system databases
• Check the SQL logs for errors and monitoring the disk spaces.
• Supported 24 X 7 production environments.

Environment: MS SQL Server 2005 and 2000, SSAS, SSIS, Informatica, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, Erwin, SharePoint Moss Server.