SUMMARY

• Microsoft Certified SQL Server DBA with good experience in MS SQL SERVER 2012, 2008R 2/2008/2005/2000 Database Administration in Production, Test and Development environment.
• Expert in installation and configuration of MS SQL Server 2012, 2008, 2005 & 2000 in different 32/64 bit environments.
• Expertise in Installing and configuring SQL Server 2012/2008/2005 Active/Active and Active/Passive clusters on 32/64 bit Window Server 2003 and Window Server 2008;
• Expertise in migration of SQL Server 2000 to SQL Server 2005/2008,SQL Server 2005 to SQL Server 2008
• Implemented Database Mirroring in SQL server 2005 & 2008.
• Expert in developing and documenting the backup and disaster recovery plan.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008/2008 R2 databases.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server 2005 and 2008 in OLTP environments.
• Excellent skills in developing Backup & Recovery procedures and Database Security procedures to maintain Data Integrity.
• Expertise in deployment and scheduling of SSIS packages.
• Expertise in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S
• Expertise in monitoring the production server with native tools like SQL Profiler, Window System monitor.
• Expertise in identifying, troubleshooting issues and documenting root cause analysis.
• Experienced in configuring and managing Linked Server, Data transfer between SQL Server and other Databases
• Experience working in 24X7 production support for 2008R2, 2008, 2005 and 2000 SQL Server.
• Experience in working with quality assurance and version controlling tools
• Superior communication, presentation, documentation, analytical and problem solving skills.

TECHNICAL SKILLS

RDBMSMS: SQL Server 2012, 2008R2, 2008, 2005, 2000

Operating Systems: Windows server 2008/R2, 2003, Windows 2000, Windows NT 4.0, Windows 95/98/XP

SQL Server Tools: Management Studio, Business Intelligence management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor

Cluster Solution: Microsoft Windows Cluster

Languages: C, C++, T - SQL

Third Party Tools: Spotlight, SQL LiteSpeed, Idera s diagnostic manager

PROFESSIONAL EXPERIENCE

Confidential, Richfield, OH

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise/Standard edition in the Production/QA environment.
• Administered SQL Server Instances running on 2005/2008R2/2012 across DEV, QA and Production environments.
• Involved in the maintenance of high availability 5 - Node Active-Active Cluster Production environment.
• Worked on upgrading SQL server instances and applyingservice packs and hot fixes.
• Ensure company best practices for any and all SQL Server related items.
• Use RedGate Toolbelt for Database backups, Schema compare and Data compare.
• Implement, maintain and troubleshoot high availability solutions such as Transactional and Snapshot Replication and Database Mirroring.
• Implement and maintain SSIS, SSRS and SSAS as well as troubleshoot these services.
• Troubleshoot server and query performance using perfmon, DMV’s, Execution plan analysis, Quest Performance analysis, Quest Spotlight, Performance Dashboard, Data Collector, and Extended Events.
• Deploy any and all SQL Server related items like SQL Scripts, RDL report files and SSIS packages.
• Worked on automated solutions to manual deploy processes.

Environment: Windows server 2003/2008R2, MS SQL Server 2012/2008R2/2005, TFS 2008/2013RedGate Source Control, RedGate SQL Compare, TortoiseSVN, Quest Spotlight, PostGreSQL.

Confidential, Cincinnati, OH

SQL Server Database Adminstrator

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise/Standard edition in the production/DR/Test/Dev environment.
• Monitored the Daily Full Back-up and Transactional log backup jobs.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• 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.
• Implemented and maintain database security (create and maintain users and roles, assign privileges).
• Perform general technical trouble shooting and give consultation to development teams.
• Identified issues related to poor performance of complex SQL queries by analyzing missing indexes and unused indexes.
• Reduced the deadlocks 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 system BMC remedy.
• Involved in taking backups of database and restoring and validating them when needed.
• Experience in working in Change Data Capture (CDC) for auditing data objects in SQL Database.
• Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Monitoring the servers usingIdera Diagnostic Manager.
• Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment: Windows server 2003/2008/2008 R2, MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic Manager, BMC remedy

Confidential, Berkeley Heights, NJ

SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise edition in the production environment.
• Successfully migrated from SQL Server 2000/ /2008R2 on Developing/Testing/ production Environment.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003/2008 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Successfully implemented database mirroring between Primary server and Mirror Server as a DR policy.
• Successfully implemented and monitored transactional replication
• Reduced the deadlocks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Provided 24/7 dedicated production server supports.

Environment: Windows server 2003/2008/2008 R2, MS SQL Server 2012/2008R 2/2008/2005/2000 , Idera Diagnostic Manager, Quest foglight, BMC remedy

Confidential, Virginia Beach, VA

SQL Server Database Administrator

Responsibilities:

• Installed and configured Active/Passive Failover cluster as a high availability solution with SQL Server 2005/2008/2008 R2.
• Successfully upgraded SQL 2005 to SQL R2 and Facilitated SQL server 2005 and SQL 2008-R2 server migration.
• Setup and configured Log Shipping for the disaster recovery solution
• Implemented and maintained the snapshot replication in the environment
• Performed Full Backups, Differential Backups and Transactional Log Backup as a backup and restore strategy for the company environment on pre-determined timely basis
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Identified locking, blocking, dead locking issues and resource bottlenecks using idera so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Created maintenance plan for database consistency and optimization.
• Created snapshot of mirror database for reporting
• Provided 24 X 7 dedicated supports.

Environment: SQL Server 2005, SQL Server 2008, T-SQL, Windows Server 2003, Windows Server 2008

Confidential, Oaks, PA

SQL Server Database Administrator

Responsibilities:

• Responsible for configuration, Tuning of SQL Server 2005 and provided 24 X 7 dedicated support to all production and development servers
• Managed Login and User: adding logins, roles, groups to the Window Server and MS SQL Server and maintaining proper security procedures
• Involved in moving SSIS packages between various environments including Dev, QA, Staging and Production
• Involved with Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005 Databases and Servers.
• Responsible for migration of databases from one version to other versions and applying patches
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
• Assign permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
• Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Scheduled SSIS Packages and batch jobs through SQL Server Agent and through various Shell scripts and VB scripts to run on a regular basis.
• Documented disaster recovery plans and participated disaster recovery drills.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server

Environment: Windows Server 2003, SQL Server 2005/2000, Windows Performance Monitor, Idera Diagnostic Tools, Microsoft Visual Studio 2005

Confidential, Camphill, PA

SQL Server Database Administrator

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked with DTS to load text files to SQL Server.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
• Involved in writing queries and optimizing the performance of the queries.
• Helped the front end application developers with their queries.
• Working on different environments like development, staging, production
• Involved with optimization of Stored Procedures, Triggers, Views
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performed transformations and data flow tasks using VB scripts.
• Worked with Application development using Visual Basic.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, HTML 4.0, JavaScript, Access

Confidential

SQL Server Database Administrator/Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005.
• Implementing Load balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server error logs.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000, SQL Server 2005. T-SQL, Windows Server, HTML, VBScript, JavaScript, Access