SUMMARY

• Over 8 + years of experience in MS SQL Server as a Database Administrator in Development, Staging, Testing and Production environments.
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery and Running DBCC Commands.
• Experience in applying latest Service Packs and Rolling Patches and Upgrades for SQL Servers in Clustered (Failover) and Non - Clustered environments.
• Experience in Configuration and Maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2008/2005
• Installed and Configured SQL Server 2000, 2005, 2008, 2008 R2, 2012.
• Involved in Implementing of multiple multi-node clustered community environments, which supported multiple instances of SQL Server.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues with the same. Applied hot fixes and Service Packs in clustered environments.
• Configured Database Mirroring in High Performance and High Availability mode and troubleshoot issues with the same.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the associated problems.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects.
• Verifying and tuning stored procedures created by developers by using Execution Plans, SQL Server Profiler and Database Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in administrative activities comprising Database Health Check, Index Optimization (Rebuild and Reorganizing Indexes with different fill factors), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Security.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Worked closely with management, applications development Team, and users on database solutions to resolve business problems.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows Server 2003,DOS,Unix, Linux

Database: MS SQL Server 2000, 2005, 2008 R2, 2012, Oracle 9i\10G

Monitoring Tools: Fog Light, BMC

Ticketing Tools: Company Inbuilt Tools, Remedy

Other Tools: SQL Lite-speed, Import-Export, BCP, Bulk Insert, SQL CMD

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr SQL Server DBA

Responsibilities:

• Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
• SchedulingSSIS packagesby creating the corresponding job tasks for updating the synchronizing of data between two databases.
• Managing issues for database security, High Availability and implementing strategies accordingly.
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
• Build up SQL SERVER cluster and NON Cluster environments, performing post installand pre install steps.
• Daily administration, monitoring, and documentation of SQL Servers (2000\2005\2008\2008 R2).
• Monitoring replication and make correction actions in case of problems.
• Tuned querieswhich arerunning slowusing different Methods in terms ofevaluating joins, indexes, updating Statistics and code modifications.
• Monitored and tuned databasesto meet the performance and availability requirements of on-line systems and multiple applications.
• Closely working on Production issues and production deployment tasks
• Experience in Failover Clustering, DB Mirroring, Replication and Log shipping in (2000\2005\2008\2008 R2).
• Experience in security procedures, SQL Server security and auditing procedures.
• Leading database environment on SQL 2005/2008 with service pack upgrades and migrations to SQL 2005\2008\2008 R2.
• Align and set up database policy standards and security procedures for all servers globally.
• Implemented project timelines and standards for SQL Server builds capturing pre-build phase, implementation, production readiness and final rollouts which helped in streamlining the existing initiatives and in giving estimates from the database perspective to various internal customers.

Environment: SQL Server 2005, 2008 R2/2012, SSIS, Windows 2003/2008 Server, SQL Server Management Studio, SQL Server Agent, Red gate, Fog light, Light speed tools.

Confidential, Trumbull, CT

SQL Server DBA

Responsibilities:

• SQL Server related issues and escalations, globally responsible for escalations on critical issues in the database environment across different database areas like Performance tuning, Log shipping and day to day issues.
• Scheduling database backups using Lotus notes and TWS tools.
• Developed, modified, and optimized complex stored procedures, triggers, views to handle complex business rules, history data and audit analysis.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Leading database environment on SQL 2005/2008 with service pack upgrades and migrations to SQL 2005/2008.
• Expert inPerformance Tuningof theStored Procedures.
• Engaged in maintenance of 200+ Database servers with 400+ databases across US.
• Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
• Managing issues for database security, High Availability and implementing strategies accordingly.
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
• Daily administration, monitoring, and documentation of SQL Servers (2000/2005/2008/2008 R2).
• Monitoring replication and make correction actions in case of problems.
• Monitor jobs execution, and make correction actions when necessary.
• Deployment, configuration, troubleshooting and debugging of the application environments.

Environment: SQL Server 2005, 2008 R2/2012, SSIS, Windows 2003/2008 Server, SQL Server Management Studio, SQL Server Agent.

Confidential, Indianapolis

SQL Server Developer and DBA

Responsibilities:

• Involved in SourceData Analysis, and designing mappings for data extractionalso responsible forDesign and Development of SSIS Packagesto load the Data from various Databases and Files.
• Created complexstored Procedures, Triggers, Cursors, Tablesand other SQL Joins and Statements for Applications by using T-SQL.
• Created maintenance plans for Rebuild indexes, Check integrity, Update statistics and Shrink Database.
• Collaborated with web developers on the backend design and development to support the survey UI, IISand applications.
• Ensure queries are optimized, tables are correctly indexed and data is accurate.
• PerformedBackup/Restore to/fromLegato server(Tape) andDisk.
• Configuredand Monitoredtransactional replication.
• Developed, modified, and optimized complex stored procedures, triggers, views to handle complex business rules, history data and audit analysis.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Maintained the database consistency withDBCCutility at regular intervals.
• UsedDMV’sand Created indexes for faster Query Performance.
• Provided knowledge transfer to the company’sSQL programmers.
• Daily routine DBA tasks like handling user’spermissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: SQL Server 2005, 2008/2012, SSIS, Windows 2003/2008 Server, SQL Server Management Studio, Microsoft Reporting Service, SQL Server Agent.

Confidential

SQL Server DBA

Responsibilities:

• Installed and Upgradedfrom SQL server2005, 2008 and 2008 R2and Some servers upgrades Standard to Enterprise edition
• Migrated Databasesfrom SQL Server2000to SQL server2005 and 2008.
• Worked inActive-Passive, Active-Active Cluster and DB Mirroringenvironmentas a High availability solution.
• Performed DBA duties including:database backups, restores, performance tuning and capacity analysison databases on VMware.
• Collaborated with web developers on the backend design and development to support the Survey UI and Applications.
• Ensure queries areoptimized, tables are correctly indexed and data is accurate.
• Daily routine DBA tasks like handling user’spermissions andspace issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handledmonthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Successfully handledthePRODUAT, QA and DEV environmentservers, IISand database issues.
• Reviewed andoptimized SQL queries,stored procedures, views and triggersfrom other developers to achieve maximum efficiency and scalability.
• Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
• Experience inmigration of databases, weekend refreshes and solvingissues whiledoing the migrations, refreshes.
• Configuredand Monitored transactional replicationon QAservers.

Environment: MS SQL Server 2008 R2, 2008, 2005 and 2000, T-SQL, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, Windows 2003 and 2008 Servers.