SUMMARY

• 7 years of experience as a SQLServer DBA and administrating/managing SQL 2008R2/2005/2000 versions on both standalone and clustered environments.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Experience in managing MS SQL Server on Windows 2003 and 2008 Servers.
• Expertise in upgrading (In - place Upgrades) and migrating databases from MS SQL Server and SQL Server .
• Experience with multi server administration.
• Implemented Database Mirroring configuration with Witness server to provide automatic failover.
• Implemented log shipping technology on standalone servers for getting reports on SQL Server 2005 and 2000
• Implemented different types of Replication models like Transactional and Snapshot.
• Expert in designing and implementing Backup and Recovery Strategies
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Hands on experience in migrating/rewriting the DTS packages (SQL 2000) to SSIS (2005/2008)
• Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
• Used DMVs, DMFs and Extended Events to monitoring and troubleshooting performance issues.
• Experienced in developing stored procedures, functions, triggers using T-SQL
• Very good experience in using Quest LiteSpeed and Idera SQLSafe to backup and restore the SQL databases.
• Hands on experience in reviewing the work orders by check-in/check-out using Team Foundation Server.
• Implemented proactive monitoring scripts for production databases.
• Worked on BMC Remedy and HP RMS ticketing system software’s to track if any problem occurs in the environment.
• Worked in production support role to provide 24/7 on-call support.
• Conversant with all phases of Software Development Life Cycle (SDLC).
• Flexible and enthusiastic team player with excellent communication and leadership skills.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, Visual Basic, Java, VB Script

RDBMS: MS SQL Server 2008/2005/2000 and MySQL.

Web Servers: IIS, Weblogic

Version Control Tools: Visual Source Safe, TFS 2008/2010.

Operating Systems: Windows 2008, 2003, 2000, /98/XP/7 and Linux

Backup and Restore Tools: Idera SQLSafe v2.5, Quest Litespeed v5.0, v6.5 and IBM Tivoli Storage Manager.

PROFESSIONAL EXPERIENCE

Confidential, Westchester, IL

SQL Server DBA

Responsibilities:

• Administrating more than 120 (Production and Non-production servers) both physical and virtual machines which runs SQL server 2005 SP3/2008 R2 SP1 versions.
• Installing Microsoft SQL Server 2005 and 2008 R2 on New Production and Test servers with latest Security updates involving Service Packs and Security patches as they are released.
• Involved in the SQL Migration Process (both in-place and side-by-side) with respective teams for upgrading SQL servers from 2005 SP3 version to 2008 R2 SP1 version.
• Upgrading/Rewriting the SSIS packages from SQL 2005 to SQL 2008 R2 version servers.
• Implemented and maintained Failover clustering (Active/Passive node) and Replication (Snapshot and Transactional, Transactional with Updateable) as databases high availability solution.
• Managing our DR environment with comprehensive restore plan meeting to our SLA
• Involved in DR-Drill test to make sure to meet the RPOs and RTOs specified to the applications in case of disaster.
• Enabled Resource Governor to manage SQL Server 2008 database workload and evaluating critical system resource consumption
• Research on Extended Events subjects to monitor the CPU consumption and Deadlock info on the servers with disabling the trace flags.
• Getting out the data from XML target file using XQuery for deadlock nodes.
• Supporting one of the major application team in column level encryption release using SMK, certificates and symmetric keys.
• Documenting the procedure(SOP) to create and manage these Encryption keys for future deployment
• Applying data fixes based upon the incident request by App team members.
• Auditing the DML changes in a tables with CDC feature and monitoring them using DMV s.
• Developed and deployed SSRS reports for in house monitoring to audit the performance stats.
• Rebuilding the indexes at regular intervals for better performance and monitoring these jobs on weekly basis.
• Monitoring the unused indexes in the databases using Catalog Views and DMV’s and dropping them.
• Archiving/purging the data in the tables using TSQL and executing as a job.
• Used Windows Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Reviewing cluster event logs using Failover cluster Manager in case of failover following with verifying SQL health and submitting RCA to Operations team.
• Reviewing the release code in TFS before deploying into Production. Recommending the developers to make the changes as per coding standards.
• Troubleshooting various SQL Server 2005 and 2008 R2 Database connectivity issues from the web applications.
• Managing the Quest Litespeed v5.0/v6.5, used for backup and restore procedures.
• Designed and implemented comprehensive Backup plan and rewriting the code to use SQL Native commands for SQL Server 2008 R2 versions
• Monitoring Double-take console to check the status of mirroring/replication of backup files cross the network
• Reviewing DBA Daily status report to troubleshoot the low disk space, consistency checks, server configuration and DB growth in proactive and submitting to Manager.
• Participated in Primary On-Call rotation, responsible for the prod releases, supporting app teams in case of assistance, applying patches, server verification and monitoring maintenance jobs
• Responded to issues that have been escalated with Change Control Processes and adherence to standards and documentation.

Environment: SQL Server 2005SP3/2008R2 SP1, ADO.Net, Windows Server2003/2008 Enterprise /Standard Edition, SSIS,SSRS, Visual Studio 2008/2010, Quest LiteSpeed Backup, Double-Take, Windows 2007R2 Communicator, BMC Ticketing System

Confidential, Oakbrook, IL

SQL Server DBA

Responsibilities:

• Upgraded SQL 2005 Server to SQL 2008 (In place and Side-by-Side) server for high volume processing databases.
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Design and Implemented Disaster Recovery Procedures.
• Implemented High Performance Database mirroring on medium scale SQL 2005 database servers.
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Designed the best back up strategy on the mission critical running application on databases considering our business requirements
• Used Idera SQl Safe tool for compressing the backups in order to perform efficiently and reduce the space.
• Reviewing the Design Document provided by the onshore/offshore development teams for future enhancements upon the requirements.
• Performing Performance tuning using Data Tuning Advisor, SQL profiler and Windows Performance monitor.
• Maintain database including consistency checks, and index defragmentation using DBCC and DMV s respectively
• Responsible for applying service packs and hotfixes
• Migrating SQL 2000 DTS packages to SSIS packages using Migration wizard and deploying into Production
• Responsible for environment refresh procedure from prod to test, stage and dev environments which happens periodically.
• Used SQL Litespeed on Production servers to increase space and time efficiency.
• Used Idera SQLSafe tool for performance monitoring, backup and recovery, security and auditing
• Proactive monitoring for 24*7 servers.
• Worked with adhoc queries to analyze and explore server data information.

Environment: MS SQL Server /2000, Visual Studio 2010/2005, Visual Source Safe, IIS, SQL Lite Speed, Idera, CMDB, Windows Server 2008/2003

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Installation and Configuration of SQL Server 2000/2005/2008 .
• Migration of SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Configured transactional replication between OLTP server and report server.
• Installed and configured SQL Server 2008 clustering on Windows Server 2008.Performed various disaster scenarios and also documented the recovery steps.
• Designed and implemented new integrated security schemas for improved security of the environment.
• Creating and maintaining database maintenance plans.
• Conducted database Performance monitoring and tuning.
• Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Authored T-SQL scripts for data partitioning, Error handling through TRY-CATCH statement, and Common Table Expression (CTE).
• Used Windows Performance monitor and SQL Profiler to optimize queries, resolve dead lock issues and enhance the performance of database servers.
• Successfully monitor SQL Server log shipping and support and perform proactive steps.
• Worked with BMC service desk express suite for ticketing.
• Extensively documented all the databases, database objects, jobs and the changes made to the database.
• Creating Database Maintenance Plan for database Integrity Checks, Update Database Statistics and Re-indexing
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Created and managed active directory for access control.
• Resolved issues related to query optimization, database optimization and index tuning
• Provided 24/7 on-call support on rotation basis for production support.
• Used extended stores procedures for creating alerts for critical production jobs.

Environment: Microsoft Windows Server /64 bit, Windows Server 2008, Microsoft SQL Server 2000/2005/2008 , Dell power edge

Confidential, Groton, CT

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005 in production and development environment.
• Upgraded SQL Server 2000 to SQL server 2005 in 32 and 64 bit clustered and non-clustered environment.
• Active involvement in installing and managing multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
• Successfully implemented database mirroring with high availability mode in SQL Server 2005.
• Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Expert in working with change management and change control procedure.
• Create and maintain various databases for Production, Development and Testing using SQL Server 2005. Planning the location of data, index, and Transaction log files on the disk.
• Solved issues related to server performance and disk space
• Monitoring and troubleshooting performance during peak periods with concurrent connections.
• Support Development team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Creating users and assigning permissions.
• Creating back up strategies and scheduling them for execution.

Environment: Microsoft Windows Server bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and Microsoft Visual Studio, Performance Monitor, Profiler and DTA.

Confidential, Dayton, OH

SQL Server DBA

Responsibilities:

• Installation and Configuration of SQL Server 2005
• Create Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Implement Capacity Planning based on the daily report looking over high volume of activity on servers
• Implement database standards and naming convention for the database objects
• Implement Transactional Replication for Sales Application
• Create Document for Transactional Replication and production change requests.
• Manage replication and database modifications for replicated objects
• Connecting Oracle servers to SQL server using linked servers.
• Design, document and implement SSIS packages and stored procedures.
• Test and implement SQL Server 2005 SP2 to the existing SQL Server infrastructure.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Create Linked Servers and migrate data from Oracle, DB2 to SQL Server 2005
• Implement process and/or manage transfers of data between external data structures (e.g. flat files, Excel files) and existing databases.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler
• Develop and implement backup and recovery strategies involving complete database backup/restore, transaction log backup/restore
• Monitor daily SQL jobs, event logs, error logs and performance of the database.
• Investigate and resolve SQL process issues using various SQL commands.

Environment: Microsoft Windows Server 2003, MS SQL Server 2000, MS SQL Server 2005, Litespeed, Event Viewer, SQL Profiler, T-SQL.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000/2005
• Developed various database objects like Tables, Triggers, Views and Stored Procedures by using T-SQL.
• Responsible for transferring of the databases and database objects from Development to Production Server DTS.
• Prepared Estimates for Database, table size growth.
• Responsible for MS SQL Server 2005, configuration, tuning and provide 24X7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Additionally, designed and implemented a disaster recovery system.
• Created the logical and physical data modeling using Erwin tool.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performance Tuning on live databases. This includes scanning for performance bottlenecks and troubleshoots them in order to provide the best service with the Servers.
• Developed database monitoring and tuning strategies and also Tuned Complex SQL Queries.
• Configured Log shipping from one production server to the reporting server.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Importing and Exporting of the Database using DTS utility.

Environment: MS SQL Server 2000/2005 Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Quest Litespeed,T-SQL