SUMMARY

• Microsoft SQL Server DBA with 9+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server in Production, Testing, and Development Environments.
• Extensively involved in planning and configuring Disaster Recovery and High Availability Solution like Log Shipping, Database Mirroring, Clustering and Always On.
• Highly skilled in Administrative duties like Installation, Implementation, Configuration and Maintenance. Efficient in Managing, Monitoring, Performance Tuning and Query Optimizing.

TECHNICAL SKILLS:

RDBMS Tools: Microsoft SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005

Backup Restore Tools: Idera SQL Safe, Redgate, Litespeed, Symantec Backup Exec, DPA

Operating Systems: Windows 2016, 2012R2, 2012, 2008R2

Languages: T - SQL, PL\SQL, VB Scripting

Other Tools: SSMS, SSRS, SSIS, SSDT, Idera Diagnostic Manager, SQL Profiler, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Florida

SR. MS SQL SERVER DBA

Responsibilities:

• Upgraded Servers from SQL server 2014 to SQL server 2016 and installed service pack
• Installed and Configured the SQL server cluster/standby with AlwaysOn feature for VAST.
• Installed, Configured and Maintained SQL Server 2012 Cluster Setup for PMG.
• Used Idera SQL Safe for Backup and Restore databases.
• Troubleshooting Issues related to Transactional Replication for RD&E by using Replication Monitor.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Created maintenance reports, jobs, and alerts.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers.
• Designing and developing the Stored Procedures to process the rules coded in the business logic table Using T-SQL.
• Created Triggers for Auditing the Data and System changes and also prevent Ad-hoc and restricted changes to the system Using T-SQL.
• Extensively Worked on SSRS, SSIS, and SSAS.
• Created Distributed Partition view by using Linked Server for business logic Using T-SQL.
• Worked on SQL Server Clusters Active - Passive on mission critical Health applications.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements Using T-SQL.
• Creating SSIS Package to Extract, Transform and Load data into database.
• Deployed SSIS Package to MSDB as well as File System depending on requirement.
• Scheduled SSIS package to run as a Job.
• Writing complex T-SQL Statement and complex join Queries.
• Worked extensively in developing and implementing Crystal reports.
• Built and deployed integrated reports using SSRS.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Write SQL views against source tables in Oracle with business rules applied.
• Created permanent tables, temporary tables and table variables.
• Responsible for handling in high available clusters such as fail over clusters

Environment: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016, Windows 2000/03/08/12 R2, JIRA, SQL Profiler, Perfmon, Idera SQL Safe.

Confidential, Pleasanton, CA

Sr. MS SQL SERVER DBA

Responsibilities:

• Upgraded Servers from SQL server 2008 to SQL server 2012 and installed service pack
• Installed and configured SQL server 2008 and administered.
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Responsible for maintaining all database environments- Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Experience in handling the situations in change control process.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements Using T-SQL.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements
• Created SQL queries using T-SQL for business requirement.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Experienced working on SQL COMPARE tool to compare the structures between databases in order to synch them
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers.
• Installing SQL Server 2008 in windows Cluster environment.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly, and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Involved in migrating database from oracle 11g to SQL server 2008.
• Develop Ad-hoc and Customized Reports using SSIS.
• Actively involved in data warehousing of the Sybase database onto SQL SERVER 2008.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Write SQL views against source tables in Oracle with business rules applied.
• Created permanent tables, temporary tables and table variables.
• Responsible for handling in high available clusters such as fail over clusters.
• Conducted design reviews with users/team for development and production strategies.
• Capacity planning, maintaining run book documentation on all the servers in word, pdf and excel formats.
• Involved in handling onsite-offshore model.
• On call 24/7 supports to databases on weekly rotation. Involved in 24x7 on call support.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012, Windows 2000/2003/2008 R2, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring.

Confidential, MN

MS SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Configured and maintained database mirroring and Log shipping for high availability.
• Implemented different types of Replication Models like Snapshot, Transactional and Merge.
• Extensively worked on Dynamic Management Views (DMV's).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• 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.
• Migrated SQL Server 2000 to SQL Server 2005\2008 and SQL Server 2005 to SQL Server 2008.
• Applied SQL Server service packs and Cumulative updates based on the errors and flaws that are found in the application.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008 environments.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• 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 tools like Veritas NetBackup, LITESPEED and Sandpiper.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008, IIS 6.0, VERITAS Net Backup, TSQL, VB.NET, Sandpiper, IBM TSM, Litespeed, SQL Job Manager, BMC Patrol.

Confidential, Southfield, MI

MS SQL SERVER DBA

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 2008 environments.
• Involved in Migration from SQL 2005 to SQL 2008.
• Managing server logins, database users and permissions.
• Created Clustered Indexes and Non-Clustered Indexes 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 2008.
• 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 login 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
• Involved in coding complex stored procedures and debugging for optimum performance
• 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 2005/2008, Windows 2005/2008, Siebel, IIS 6.0, Data Warehousing, SQL SAFE, TSQL, VB.NET, Snap Manager, SQL Job Manager.