SUMMARY

SQL Server DBA with more than Seven years of IT experience with various Industries as a SQL Server DBA in MS SQL SERVER in administration, analysis, design, development, testing, presentation and implementation experience using SQL Server 2008R2/2008/2005/2000.

• Good knowledge of Relational Database Management Systems (RDBMS).
• Good experience in installation, upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Expertise in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Integration Services, Database designing and Query optimization.
• Good working experience in maintaining SQL Server Active/Passive cluster environment.
• Experience in Migration from MS SQL Server 2005 to MS SQL Server 2008.
• Experience in implementing different types of Replication models like Snapshot and Transactional.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 databases.
• Experience in configuring and monitoring Database Mirroring.
• Experience in Installing and Configuring SQL Server on virtual machines (VMware).
• Experience in MS SQL Server 2000 and 2005 installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
• Experience in implementation of Policy Based Management.
• Extensive experience in Capacity planning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Knowledge on RAID 1-5 & 10 technologies.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience working in Production support including weekend and Change control support over nights.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Monitoring SQL Server job logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in DB.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

CERTIFICATE OF EXCELLENCE FROM MICROSOFT

• Designing, Optimizing and Implementing Databases with MS SQL Server 2008
• Microsoft SQL Server 2008 - Implementation and Maintenance

TECHNICAL SKILLS

:

T-SQL,C, C++, HTML, XML, html, Javascript, PHP

RDBMS

:

MS SQL Server 2008R2, 2008, 2005, 2000

SQL Server Tools

:

SSMS, SQL Server Profiler, SSIS, Query Analyzer, Performance Monitor, Enterprise Manager etc.

Version Control

:

Visual Source Safe 6.0

Operating
Systems

:

Windows Server 2008/2003, Windows 2000 Advanced Server, Windows NT 4.0 / 3.51, Windows 95/98/XP

Other Tools

:

IDERA Diagnostic Manager, SQL Light speed , ERWIN 4.0, Red Gate SQL belt, BMC Remedy Pac 2000 (for helpdesk tickets, change requests - CR, work order - WO, problem tickets -PO).

Hardware

:

PowerEdge 1900 Server, Dell PowerEdge 8450, IBM servers, HP servers

APPLICATION AREAS

• Installed, configured and maintained MS SQL Server 2008R2/2008/2005/2000 on Windows 2008/2003.
• Expertise in DTS, SSIS, SQL Server Reporting Services (SSRS).
• Expert in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
• Setting up Log-Shipping on MS SQL Server 2008 / 2005/2000.
• Implemented Log Shipping technique for DR solution for Microsoft SQL Server 2008R2/2008/2005/2000 also solved and automated manual log shipping issues.
• Database Mirroring.
• Database Replication.
• Configuring Cluster Server.
• Implemented & Configured cluster server in Active/Passive node.
• Database security & optimization.

PROFESSIONAL EXPERIENCE:

Confidential,New York July ’11 – till date
SQL SEVER DBA

Description: Confidential,is a leading global financial information and education company. Leading brands include Standard & Poor\'s Ratings Services, S&P Indices, S&P Capital IQ, McGraw-Hill Education, Platt’s energy information services and J.D. Power and Associates

Responsibilities:

• Installed and configured SQL Server 2008 Enterprise edition on Active/Passive Cluster environment.
• Successfully migrated from SQL Server 2005/2008 on Development and Testing Environment.
• Pre installation check before installing SQL Server 2008 that identified unsupported configurations.
• Created SSIS packages for the ETL the data from SQL Server 2005, flat files, Excel files.
• Implemented Resource Governor for one of the critical server for better performance.
• Applied Page and row compression to efficiently organize the space.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Implemented the Data Collector to capture the CPU, DISK, Memory counters.
• Implement table partitioning to improve performance and data management.
• Database and SQL Tuning to improve performance of loads.
• Reduced the dead locks by using the sql server profiler hence the performance of the query is tuned.
• Created automatically running stored procedures for day-end operation using SQL Server agent
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
• Creating logins and roles with the appropriate permissions.
• Monitoring & Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping in standby mode to support DR servers.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft Windows 2003 Server, Microsoft SQL Server 2005, 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services , Microsoft OFFICE 2007.

Confidential,Charlotte, NC May ’10 - June’ 11 SQL SERVER PRODUCTION DBA

Confidential,is an American multinational diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards. In 2011, Wells Fargo was the 23rd largest company in the United States. Wells Fargo is headquartered in San Francisco, California, but has major "hub quarters" in other cities throughout the country.

Responsibilities:

• Installed and administered SQL Server 2008 with Windows Server 2008.
• Applied latest service packs SQL Server 2005 Servers.
• Implemented Transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Designed logical and physical layers of the various databases.
• Optimized database performance and use of resources, including selecting optimal physical implementations of databases.
• Assisted management with database and resource capacity planning.
• Active involvement in installing and managing multiple two node failover cluster set up in Active- Passive environment as a ‘High Availability’ mechanism to avoid downtime.
• Implemented Log-shipping as a warm-standby solution for the critical databases.
• Expertise in data cleansing for various Data Source and loading them in to Destination Database as per the Business Requirement using SSIS various Components.
• Monitored user accounts, user permissions, database extents, table partitions and backup.
• Used SSIS to transfer data between SQL Serverand operation system files.
• Involved in creating Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Scheduled exporting of entire database to off-site repository.
• Worked in OLTP environments with web sphere as the application server, java code interacting with the oracle database server.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Performed database consistency checks.
• Backup scheduling and monitoring the job.
• Optimizing and fine-tuning the SQL servers.
• Involved in support, development, QA, knowledge transfer.
• Importing and exporting the data by using the DTS, BULK insert utility.

Environment: MS SQL Server 2008R2, MS SQL Server 2008, MS SQL Server 2005, MS SQL Server 2000, SYBASE, ORACLE, Windows 2008 Server Enterprise Edition, Windows 2003 Server Enterprise Edition, Windows 2000 Server, Linux, Unix,Visual studio .NET, Share point, Dell Power Edge 8450 , IBM servers, HP servers, BMC Remedy Pac 2000, SCOM.

Confidential,Boston, MA Nov ’09 - May ‘10
MS SQL SERVER DBA

Confidential,is a not-for-profit health care system that is committed to patient care, research, teaching, and service to the community locally and globally. Collaboration among our institutions and health care professionals is central to our efforts to advance our mission.
Founded in 1994 by Brigham and Women\'s Hospital and Massachusetts General Hospital, Partners HealthCare includes community and specialty hospitals, a physician network, community health centers, home care and other health-related entities. Partners HealthCare, a teaching affiliate of Harvard Medical School, is a national leader in biomedical research.

Responsibilities:

• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 25+ SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed SSIS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for the end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Reference Data across different Instances of the application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes. Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances with Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: SQL Server 2000/2005, Transactional-Sql, Visual studio.net, Windows 2000 data center/advance server, Crystal reports 8.0, dell power edge 6650, Third party tools (Idera diagnostic tools).

Confidential,INDIA June ’07 - Aug ‘09
SQL SEVER DBA/DEVELOPER

Description: Confidential,Training and Turnkey Services to its clients”, Trident is a dynamic and fast growing company. One of the largest IT companies in North India, with head office at Chandigarh and regional offices at Mumbai, Delhi, Ludhiana, Barnala and Seattle, USA, it offers wide range of solutions to clients ranging from big Corporates to Government Agencies and Banking to Export Houses.
The primary focus of this position was converting historical data files (mostly Excel, Tally accounting files, Access Database) into the data model of the database and assisting fellow database developers when needed.

Responsibilities:

• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Designing and validating the forms according to client requirement by using VB.
• Importing and Exporting of the Database using DTS utility.
• Creating, maintaining the users, roles and granting privileges.
• Security features were implemented for restricted set of users.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in PL/SQL.
• Planned, modified and resolved Chain-of-ownership problems in the server.
• Designed reports on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Writing stored procedure and SQL Queries.
• Fine tuning the Database Settings as well as the Server Settings.
• Developing customized applications based on customer requirements.
• Development of modules assigned.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Had good experience in 24/7 production support.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft SQL Server 2000, Microsoft SQL Server Data Transformation Services, Microsoft SQL Server Reporting Services.

Confidential,INDIA Aug’05 - May’07
SQL DBA/DEVELOPER

Description: Confidential,is one of India\'s leading providers of Business Process Outsourcing (BPO) servicesto the international markets. The core competency of IDS Infotech Ltd. is to facilitate Business Process Outsourcingwith successful process migration. IDS strengths lie in its multi-faceted approach to diverse services, both in the voice and non-voice domains. As a part of the project, the company wanted to improve its manageability and stability of its IT infrastructure, eliminate unnecessary complexity and costs and extend its internal systems for external access via the web.

Responsibilities:.

• Worked extensively as a DBA to create the databases for IDS Infotech. Also created monitoring jobs in these servers.
• Preparing and maintaining database for production and solving issues as and when needed.
• Creating database backup and transactional log backup plans and scheduling them as and when required. Also monitored these jobs on a daily basis.
• Managed manual Log shipping for the servers running on SQL Server 2000 by creating SQL scripts and configuring them in a job to run hourly, every day.
• Solved automated Log shipping failures & manual log shipping failures and other issues related to it.
• Worked extensively in creating the INTRANET server from scratch which is used for storing the employee information and the company information.
• Played the key role in configuring Transactional replication between Primary Server and three Read–Only (Subscribers) servers, with the separate Distributor server.
• Giving 24x7 ON Call support to the application team.
• Performed prime role in managing all the databases during peak holidays like Mother’s day, Valentine’s Day and Christmas.
• Developed workaround solutions for jobs that failed due to space constraints in Development servers and Archive servers.
• Also involved in creating the quarterly data required for Data Warehousing needs.
• Created logins as and when required for the application team and giving appropriate permissions to these Logins.
• Created logins as and when required for the application team and giving appropriate permissions to these Logins.
• Configured the latest version of DIAGNOSTIC MANAGER from Idera solutions for the monitoring of servers.
• Creating operators and alerts in getting notifications.
• Also worked extensively setting up all the servers in Diagnostic Manager, tweaking the settings for individual servers.
• Created and updated statistics on various tables as required by the query run by the application team.

Environment: MS Windows 2000 Server, SQL Server 2000 Enterprise Edition, Visual Studio 2002 , Microsoft Office Excel 2000, IIS 5.0 ,Visual Basic 7.0/6.5,Third party tools.