PROFESSIONAL SUMMARY:

• Having 11.5+ years of total experience in Microsoft SQL Server - Database Administration, System Analysis, Data modeling, Database design and Support of MS SQL Servers 2012/2008 R 2/2005/2000/7.0 in Production, QA, Testing and Cluster Server Environments.
• Experience playing as an Onsite coordinator role, understanding client business/requirement, communicate well between client and offshore, ensure quality deliverables with zero defects, estimate effort and manage escalations.
• Extensively worked with clients across wide range of industrial domains: Manufacturing & Logistics, Insurance, Banking, Entertainment, Retail and BPO.
• Worked in Offshore, Onsite, Follow the Sun global support models.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008 R2/2005/2000 versions.
• Solid experience inHigh Availabilityand Disaster Recovery (HADR) solutions usingAlways-on Availablity group,SQL Server clustering, Database mirroring, Replication Models(Snapshot /Transactional) and Logshipping
• Experience inDisaster Recovery Planning, Execution and Testing at remote side.
• Expert in implementing SQL Server Database security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Hands on experience in Database Backup/Restore and setup the best backup schedule plan according to client requirement.
• Experience in using SSIS(SQL Server Integration Services)for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer.
• Very good knowledge in SSRS (SQL Server Reporting Services) configuration, migration and report development.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Extensive working experience in database migration between sql servers, fix orphan users and troubleshooting.
• Working experience in Database and SQL Servers Consolidation to reduce costs for maintenance, space, licenses and easy maintenance of backup/restore, security, upgrade.
• Expertise in Query Tuning - Analysis of Index, Fragmentation, Statistics, Execution plan, Blocking and Deadlocks.
• Expertise in Performance Tuning - SQL Profiler, Activity Monitor, Performance Tuning, Database Tuning Advisor (DTA), Dynamic Management Views (DMVs), DBCC commands, System Stored Procedures.
• Working knowledge in Database Mail configuration and set email notification for scheduled jobs, packages.
• Experience in upgrading SQL Server versions with a proper roll back plan in case of failure.
• Proficiency in T-Sql programming using DDL, DML, DCL, TCL writing complex queries involving multiple tables, joins and stored procedures.
• Hands on experience in Transactional Log-shipping configuration, monitoring and troubleshooting.
• Experience in FILESTREAM for the storage and management of unstructured BLOB data.
• Created SQL Server Auditing to track and log events that occur on the Database Engine.
• Implemented the advanced SQL features like online indexing, online restore, Database Snapshot, Database compressed backup.
• Involved in Change and Release management processes for database changes and sql server upgrades using ticketing tools like BMC Remedy, TrackIt, HP Service Manager.
• Perform day-to-day activities related to administration and maintenance of database systems.
• Maintain documentation related todatabaseplatforms, guidelines, methods and standards using Microsoft Visio and other tools.

TECHNICAL SKILLS:

SQL Server Versions: MS SQL Server 7.0/ 2000/2005/2008 R2/2012

Operating Systems: Windows 2000/2003/2008 R2 Servers, Windows 98/XP/NT/7/8, Linux

SQL Server Tools: Management Studio, Business Intelligence Development StudioEnterprise Manager, Query Analyzer, Profiler, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS).

Report Tools: Sql Server Reporting Services, Seagate Crystal Report 8.0.

Backup Tools: Native Backup Utility, SQL LiteSpeed, IBM Tivoli Storage Manager.

Monitoring Tools: SQL Sentry, Spotlight. Foglight, Performance Monitor

Ticketing Tools: Request Tracker, BMC Remedy, JIRA, HP Service Manager.

Windows Tools: Device Manager, Event Viewer, Performance Monitor, Cluster AdminFailover Cluster Manager, Device Manager, Command Prompt.

Network Topologies: TCP/IP, FTP, SMTP.

Programming: Visual Basic 6, ASP 3.0, HTML & SQL

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer/SQL Database Administrator

Responsibilities:

• Migrate databases from SQL Server 2000/ R2/2012 version.
• Analyze and understand the project lifecycle and modules involved in the SQL Server Migration. Plan and execute the SQL upgrade on DEV, QA, UAT, PP and PROD environments.
• Analyze the SQL Upgrade Advisor report ran against on older SQL Server versions.
• Remediate/rewrite backward compatibility features such as breaking, behavioral, discontinued and deprecated changes in the new SQL server versions.
• Converted non-ANSI joins into ANSI joins standard.
• Run SQL Profiler to trace stored procedures hampering performance.
• Lead a team of seven members for SQL Migration and meet the client for requirement gathering, status updates, etc.
• Coordinate with Windows and Network support team for new SQL Server builds.
• Managed offshore SQL team of size eight and coordinate with stakeholders, development team.
• Maintain documents, standards, guidelines and methods

Environment: MS SQL Server 2000/2005/2008 R2/2012, Windows 2000/2003 serversPerforce.

Confidential

SQL Database Administrator

Responsibilities:

• Handled over 150 SQL servers of 2000/2005/2008 R2/2012 versions and over 3000 databases.
• Apply database standards and policies on all SQL servers.
• Audit SQL Servers and databases to adhere regulatory guidelines.
• Performed/Enabled Transparent Data Encryption (TDE) on databases to encrypt the sensitive data and protect encryption keys with a prevents anyone without the keys from using the data.
• Conducted performance test on very large databases with TDE enabled.
• Configured Secure Socket Layer (SSL) on all sql servers to protect sensitive data from man-in-the-middle attack when the data is in the network transit.
• Developed SSIS packages to generate audit reports to check the standards on all sql servers.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively worked on SQL Server Reporting Services (SSRS) installation, configuration and report designs.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• Importing & Exporting Data using DTS, Queries and packages.
• Database auditing.
• Monitor and troubleshoot sql job failures.

Environment: MS SQL Server 2005/2008 R2/2012, Windows 2000/2003 serversMS Visio 2003.

Confidential

SQL Database Administrator

Responsibilities:

• L1 and Follow the Sun Support in Production, non-production environments.
• Monitor SQL alerts for server outage, blocking processes, slow performance, long running queries, backup failures, etc
• SQL server installation and apply post installation configuration.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively worked on SQL Server Reporting Services (SSRS) installation, configuration and report designs.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process using import/export utility and SSIS packages.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup on Autosys,
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Database auditing.
• Monitor and troubleshoot sql job failures.

Environment: MS SQL Server 2005/2008 R2, Windows 2000/2003 serversMS Visio 2003.

Confidential, Atlanta-Georgia

SQL Database Administrator

Responsibilities:

• SQL server installation and configuration.
• Support in Production, Development environments.
• SQL Server Monitoring, Troubleshooting and Tuning.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Experience in Document Filestream management.
• Experience in Monitoring tools like SQL Sentry and Spotlight.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process using import/export utility and SSIS packages.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts
• Database auditing.
• Monitor and troubleshoot sql job failures.

Environment: MS SQL Server 2000/2005/2008 R2/2012, Windows 2000/2003 serversMS Visio 2003.

Confidential, New York city, New York

SQL Database Administrator and Onsite Coordinator

Responsibilities:

• SQL server installation and configuration.
• Support in Production, Development environments.
• Set-up Disaster recovery planning and testing.
• SQL Server Monitoring, Troubleshooting and Tuning.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Apply SQL patches.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process using import/export utility and SSIS packages.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts
• Database auditing.
• Monitor and troubleshoot sql job failures.

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003 servers, MS Visio 2003.

Confidential, Salem, Virginia

SQL Database Administrator and Onsite Coordinator

Responsibilities:

• SQL server installation and configuration.
• Support in Production, Development, QA and Testing environments.
• SQL Server Monitoring, Troubleshooting and Tuning.
• Database Mail configuration and set email notification
• Capacity planning
• Apply SQL patches.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts
• Database auditing.
• Monitor and troubleshoot sql job failures.

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003 servers, MS Visio 2003.

Confidential, St. Paul, Minnesota

SQL Database Administrator

Responsibilities:

• SQL server installation and configuration.
• Support in Production, Development, QA and Testing environments.
• SQL Server Monitoring, Troubleshooting and Tuning.
• Apply SQL patches.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process.
• Database Mail configuration and set email notification
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts
• Database auditing.
• Monitor and troubleshoot sql job failures.
• Handled UNIX batch jobs for data load.

Environment: MS SQL Server 2000/2005/2008, UNIX jobs.

Confidential, NYC, NY

SQL Database Administrator

Responsibilities:

• SQL server installation and configuration (Stand-alone and Clustered).
• Support in Production, Development, QA and Testing environments.
• SQL Server Monitoring, Troubleshooting and Tuning.
• Apply SQL patches.
• Database Replication configuration, monitoring and troubleshooting.
• Transactional Log-shipping configuration, monitoring and troubleshooting.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Experience in IBM Tivoli Storage Manager.
• Database restoration and fix orphan users if any.
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts
• Database auditing.
• Monitor and troubleshoot sql job failures.
• Handled UNIX batch jobs for data load.

Environment: MS SQL Server 2000/2005, IBM Tivoli Storage Manager.

Confidential

SQL Database Administrator

Responsibilities:

• SQL server installation and configuration.
• Database Replication configuration, monitoring and troubleshooting.
• System study and Development.
• Database Design for various applications.
• Transactional Log-shipping configuration, monitoring and troubleshooting.
• Performance Tuning & Query Optimization.
• ETL process
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Restore data from backups
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts.
• Provided 24/7 support.

Environment: MS SQL Server 2000/2005, Crystal Report 8.0.

Confidential

SQL Developer/SQL Database Administrator

Responsibilities:

• System study and Development.
• SQL server installation and configuration.
• Database Design for various applications.
• Performance Tuning & Query Optimization.
• ETL process.
• Importing & Exporting Data using DTS, Queries and packages.
• Database backup setup.
• Restore data from backups
• Refresh production database copy and restore user privileges.
• Managing Security-authentication, Logins, Permissions and Alerts

Environment: MS SQL Server 2000, Crystal Report 8.0, ASP 3.0.