SUMMARY:

• MS SQL Server Database Administrator with Five+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.
• Experience in supporting and involvement in Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
• Provided 24/7 and On - call Support for PRODUCTION environment
• Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
• Experience in VMWARE and managing multiple SQL Server Instances on Physical and VMWARE
• Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE replication
• Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups
• Used third party tools like Redgate, SQL Litespeed and Commvault for Backups
• Used SPOTLIGHT and FOGLIGHT for Monitoring and Performance tuning
• Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2014/2012/2008 R2
• Experience in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD
• Extensive use of SQL Server DMV's for Performance Tuning.
• Experience in SSIS.
• Created basic and troubleshoot heavy duty SSIS packages and deployed the packages from development to different environments
• Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.
• Performed and involvement Capacity Planning and Logical/Physical database design.
• Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
• Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Experience in resolving Database Performance, Capacity and Distributed data issues.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.
• Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Big Data Hadoop concepts.
• Understand C,C++,C#,VB, JAVA languages and Networking concepts.

TECHNICAL SKILLS:

Databases: MS SQL server 2012/2008 R 2/2008/2005/2000

Operating Systems: Windows NT/98/2000/XP/Vista/2003, 2007, VMWare

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Other Tools: Redgate, Foglight, commvault, Litespeed, Legato Tap Backup.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers.

PROFESSIONAL EXPERIENCE:

Confidential, Bloomsburg, PA

SQL Server DBA/Production Support

Responsibilities:

• Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
• Migrated SQL Server from SQL Server 2000/ R2/2012/2014
• Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2014/2012/2008 R2
• Managed OLTP, DSS applications/databases in Physical and Virtual Environment
• Worked extensively on Virtual and VMware Environments.
• Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log Shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Heavy migration using SSIS, DTS and Data Integrator.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, LiteSpeed Backup, Foglight, Commvault, Legato backup system.

Confidential, Golden, CO

Application SQL Server DBA/Production Support

Responsibilities:

• Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
• Migrated SQL Server from SQL Server 2000/ R2/2012
• Worked primarily as a rotating PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2
• Worked extensively on Virtual and VMware Environments.
• Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Worked on setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database Replicatioin and Log Shipping for disaster recovery.
• Worked on PowerShell Scripting
• Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2 created database logical/physical modeling with ERWIN
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Heavy migration using SSIS, DTS and Data Integrator.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager

Confidential, Bloomsburg, PA

SQL Server DBA/Production Support

Responsibilities:

• Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
• Migrated SQL Server from SQL Server 2000/ R2/2012
• Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2
• Managed OLTP, DSS applications/databases in Physical and Virtual Environment
• Worked extensively on Virtual and VMware Environments.
• Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log Shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Heavy migration using SSIS, DTS and Data Integrator.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, LiteSpeed Backup, Foglight, Commvault, Legato backup system.

Confidential

MS SQL Server 2008/2005 DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining 253 SQL Servers out of which 120 servers are production servers in which 70 were mission critical and 50 were business critical servers, remaining test and development servers.
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh.
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Implemented SQL Server Mirroring on SQL 2008/2005 environments
• Created and involved in DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages in 2008 platform to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in setting up transactional replication in production environment.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server, Windows 2000/2003/2008 Server operating systems.