PROFESSIONAL SUMMARY:

• 12+ years of IT experience in SQL Server Database Administration, Design System Analysis, Testing, Development and Support of MS SQL server 2014/2012/2008 R 2/ 2008/2005/2000 in PRODUCTION, DEVELOPMENT, QA and UAT Environments.
• Experience in database administration and development activities like Installation, Configuration, Database design and development, Backup and Recovery, Performance tuning and Query Optimization, Data Transformation Services, Database Security and Patching SQL server.
• Hands on experience in SQL Server SSIS package designing, deployment and scheduling. Extensive knowledge of Relational Database Management Systems (RDBMS).
• Expert in Implementing High Availability Solutions for MS SQL Server Environments. Including SQL Server 2012 Always On High Availability.
• Expert in working with VLDB 3 TB database in production, development and Test environment and 40 TB Very large environments.
• Expert in Upgrade server from MS SQL Server 2008R2/2008R2/2005 to MS SQL Server 2012 and Patched SQL server and Expert in handling OLTP and OLAP environment in 24/7 and on call basis
• Planned and Implemented MS SQL Server Clustered Environments in Confidential / Passive and Confidential / Confidential
• Implemented Disaster Recovery Solutions by configuring SQL Server in Log Shipping and Mirrored Environments.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Business Intelligence development studio (BIDS), and Database Engine Tuning Advisor.
• Managed MS SQL Servers in Virtual Environments using VMWARE. Expert in writing TSQL, Stored procedures, Views, Triggers and Functions.
• Expert skills in Performance Tuning SQL Servers for Index Fragmentation, Query Plans and Deadlocks
• Experience in working high transacted OLTP systems. Experience in providing 24 x 7 production support. Experience in implementing different types of Replication like Snapshot and Transactional.
• Successfully tested and implemented Log Shipping Technique used for hot backup solution for MS SQL Server 2008R2/2008 databases.
• Configured and managing SQL server 2012 transactional replication and automated transactional replication.
• Created backup strategies as per RTO/RPO business need.
• Developed and documented disaster recovery plans and backup and recovery strategies for production environment.
• Extensive experience in SQL Server development, stored procedures, User defined functions, Triggers, Views, Indexes, data integrity. Worked with Problem Ticket (PTs)/Work request (WRs) for prod and lower environment issue and change request (CRs)/Work Order (WOs) for Prod deployment.

TECHNICAL SKILLS:

Key Skills: Windows Server 2 R2, Windows Server 2003, MS SQL Server 2012/2008 R 2/ 2008/2005/2000 , Enterprise Manager, Query Analyzer, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, SQL, PL/SQL, Sybase, Visual Studio 2008/2005, T - SQL, ERWIN, Database Modeling, Microsoft VISIO, SQL Lite speed, IDERA, VMware, TSRM, Alloy and Aldon Ticketing System, Orion, Pac2000 ticketing system.

EMPLOYMENT HISTORY:

Confidential

SQL Server DBA, Woodlawn, MD

Responsibilities:

• Expert in Installing and configuring SQL server 2014 Enterprise/Stranded version and applied services pack 1.
• Expert in SQL Server migration from lower version to upper version (SQL Server 2008R2 to SQL server 2014)
• Implemented SQL Server 2014 Always on High Availability in Windows server bit environment.
• Expert in building SQL Server Confidential /passive node cluster in 2014 for high availability.
• Expert in Configuring and managing SQL server transactional replication and Snapshot replication.
• Expert in troubleshooting SQL server Replication issues, latency issues, and dependency issues.
• Working and managing multiple SQL server migration projects.
• Created backup strategies as per RTO/RPO business need.
• Implemented Ola Hallengren’s Industries best SQL server maintenance plan and created schedule for all environment.
• Expert in using Foglight and spotlight monitoring tools for databases and servers health checks.
• Expert in troubleshooting slow running query tuning using SQL Server tuning advisor and SQL server Profiler, execution plan, DMVs.
• Implemented SQL server 2014 always on for HA/DR in production environment.
• Worked crossly with application team during production deployment.

Confidential

SQL server DBA, Columbia MD

Responsibilities:

• Installed and configured SQL server 2014/2012 Enterprise and standard version and applied services pack 3.
• Managing and supporting multiple applications and Primary DBAs for 9 applications in Prod/Prod Stage/ UAT/SIT/Dev and QA environment.
• Expert in SQL Server up gradation and migration from lower version to upper version (SQL Server 2008R2 to SQL server 2012.
• Installed and configured SQL server 2012 Always on High Availability in Prod to BCP for disaster recovery and high Availability solution in 64 bit environment.
• Involved in SQL Server 2012 environment tech refresh.
• Expert in Supporting and monitoring more than 1500 Databases in Prod/UAT/SIT/Dev and QA environment.
• Installed and Created SQL Server 2012 cluster Confidential /passive node in Production.
• Configured and managing SQL server 2012 transactional replication and automated transactional replication.
• Expert in setup 2.5 TB database transactional replication for reporting server, Using Backup and restore method.
• Expert in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.
• Involved in SQL performance Tuning, identifying locking and blocking issues using spotlight.
• Expert in database sizing and capacity planning for production servers.
• Expert in creating backup strategies for Production environment and Database backup and recovery.
• Expert in Prod to BCP semi-yearly and quarterly exercise.
• Implemented Ola Hallengren’s Industries best SQL server maintenance plan and created schedule for all environment.
• Expert in using Foglight and spotlight monitoring tools.
• Expert in implementing database Log Shipping/Mirroring between primary to Secondary servers.
• Involved in SQL slow running query tuning using SQL Server tuning advisor and SQL server Profiler.
• Worked with Problem Ticket (PTs)/Work request (WRs) for prod and lower environment issue Resolve and change request (CRs)/Work Order (WOs) for Prod deployment.
• Expert working with Application team and Dev. Team, Resolve SQL server Database issue within service level agreement (SLA).
• On call Production supports.

Environment: MS SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, Replication, Sybase, Migration, OLAP, OLTP, Pac2000 Ticketing System, Spot Light, Fog Light, SQL Lite speed console, SQL sentry.

Confidential

SQL Server DBA, Richmond, VA

Responsibilities:

• Installed and configured SQL Server 200R2/2012 Enterprise and standard edition in the production/Development and test environment and applied latest service packs and security fix servers.
• Expert in working with VLDB 3 TB database in production, development and Test environment and 40 TB Very large environments.
• Expert in daily development to Test and Weekly Test to Production deployment using MS-Visual Source Safe and SQL compare 8.0.
• Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.
• Implemented SQL Server 2012 Always On High Availability in Windows server bit environment.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Identifying blocking issues with automated SQL agent job.
• Implemented and monitoring Transactional replication in Test and production environment
• Implemented automation for daily database refresh job in Production, development and Test environment.
• Automated and scheduled backup using Sybase utilities and UNIX shell scripts.
• Expert in performing multiple SSIS packages migration from SQL server 2005 to SQL server 2008R2.
• Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• Expert in database sizing and capacity planning for production servers.
• Expert in creating the standard documents for DBAs purpose.
• Database and Transaction log backups and restoration, backup strategies, scheduling the backups. Backing up system and user databases and restoring them whenever necessary.
• Created the backup schedule for production, test and development servers.

Environment: MS SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, Replication, Sybase, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System, MS-Visual Source Safe, SQL Lite speed console, SQL sentry Spotlight.

Confidential

SQL Server DBA, Bradenton, FL

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 Enterprise and standard edition in the production environment. And applied service packs and security fix for all servers.
• Successfully migrated from SQL Server 2000/ /2008R2 on Developing/Testing/ production Environment.
• Actively involved in data warehousing of the Sybase database onto SQL SERVER 2008.
• Monitoring 1600 Production server using CMS, working with offshore and onshore SQL DBA team.
• Expert in Recover database from Suspect/Emergency mode using DBCC command, repair/rebuild user database and rebuild master using command prompt.
• Troubleshoot SQL server performance issue using DMS’s in Production Environment.
• Involved in the configuration and maintenance Confidential /PASSIVE Cluster Environments for the production servers
• Expert in implementing database mirroring between Primary server and Mirror Server as a DR policy.
• Expert in implementing and monitored transactional replication.
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• Configured and maintained Log shipping architecture to provide backup server solution for environments.
• Reduced the dead locks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.
• Troubleshoot and Resolved issued problems with the production server via the ticketing Aldon system
• Expert in automating SQL server using SQL server Severity in Prod., Development. Also automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and rebuild indexing.
• Provided dedicated supports for SQL Server production server 24/7 shifts.
• Created the backup and restore strategy for 2.2 TB in production and development environment.
• Expert in creating the standard documents for Disaster recovery testing and implemented them.

Environment: MS SQL Server 2008 R 2/ 2008/2005/2000 , SSIS, SSRS, Replication, Migration, OLAP, OLTP, Aldon Ticketing System, Orion.

Confidential

SQL Server DBA, Jacksonville FL

Responsibilities:

• Installed SQL Server 2012/2008 R2 and SQL Server 2005 on windows 2012/2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Upgraded server from MS SQL Server 2008R2/2008R2/2005 to MS SQL Server 2012 and Patched SQL server.
• Working with 24x7 Production support and On-Call rotation.
• Implemented Failover clustering for Confidential / Confidential and Confidential /Passive SQL Server 64 bit environment
• Managed SQL Servers in 32/64 bit Clustered environments and Implemented Database Mirroring on SQL Server 2012/2008 environments.
• Implemented snapshot replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication and implemented different types of Replication like Snapshot and Transactional.
• Installed, configured and maintained MS SQL Fail over clustering and configure SQL Server 2012 AlwaysOn High Availability to provide server high availability solution for different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Responsible for upgrades i.e. SQL server 2005 Service Pack, SQL Safe Backup tools and SQL Diagnostic Manager.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Worked with developers to do the database schema changes and database restore request.
• 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 2012/2008 R 2/ 2008/2005/2000 , SSIS, SSRS, Replication, Migration, OLAP, OLTP, ITSM Ticketing System, Double-Take Recover Now 5.3, Erwin 7.1 and Microsoft Visio 2003.

Confidential

SQL Server DBA, San Jose, CA

Responsibilities:

• As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
• Managed All Production, Development and QA Environments running MS SQL Server 2008/2005.
• Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008.
• Involved in Performance Tuning on Production, Staging and Test Servers and Involved with maintenance of Confidential /PASSIVE Cluster in Production Environments
• Maintained various databases for Production and Testing using SQL Server 2008. Implemented Database mirroring for High Availability.
• Used All Fusion ERWIN to deploy any changes to the database and objects from test to production.
• Worked with SQL Server Profiler and Perfmon. Involved in Monitoring Performance of different production servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views and Stored Procedures.
• Expert in planning the location of data, index, and Transaction log files on the disk. Performance tuning, and Optimization of Stored Procedures and Queries.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2008.
• Managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment: Microsoft SQL Server 2008/2005/2000 , SSIS, SSRS, Windows 2008/2003 enterprise server, SQL Profiler, Idera SQL Diagnostic Manager, Performance Monitor.

Confidential

SQL Server DBA, San Jose, CA

Responsibilities:

• Responsible for Critical server support 120 servers out of which 90 servers are production servers, remaining test and development servers.
• Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL fail over clustering for mission critical servers
• Involved in monitoring the backup jobs and fixed the failed jobs. Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Designed the logical and physical database design for development projects using Erwin data modeling tool.
• Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Experienced in creating backup strategy for production, test and development servers.
• Involved in disaster recovery procedures and restore the production databases.
• Involved in database restore requests and refresh the database between productions, test servers.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.

Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems, SSIS, SSAS.

Confidential

SQL Server DBA/DEVELOPER, New York NY

Responsibilities:

• Involved in upgrading the instance of SQL Server 2000 to SQL Server 2005 in testing and production environment. Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and addressing database related issues.
• Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery. Implemented New Objects according to the Business requirements.
• Create and Modify Stored Procedures, According to the business. Fine Tuning of Stored Procedures and SQL Queries.
• Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Configured Log shipping from one production server to the reporting server. Implemented built in log shipping with SQL Server 2000 for disaster recovery server. Creating the Packages for running the jobs automatically good in Implementing SQL Server security and process control.
• Creating users and assigning permissions in the DEV box. Creating back up strategies and scheduling them for execution.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance tuning for source databases.

Environment: Microsoft SQL Server 2005/2000, DB2, Windows 2003 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports, Business Intelligence Development Studio.