SUMMARY:

• Over 8 years of strong professional experience in SQL Server 2008 R2/2008/2005/2000 as Database Administrator and Developer.
• Highly experienced in installing, configuring and administering SQL Server 2008 R2/2008/2005/2000.
• Upgraded and migrated several servers and databases from SQL Server 2000 to SQL Server 2008/2005, SQL Server 2005 to SQL Server 2008 R2/2008.
• 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Good Knowledge in implementing in different Replication Models Snapshot, Merge and Transactional with different topologies.
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
• Extensive experience with backup and Restore methodologies using Native and third party tools LITE SPEED, NetBackup, and Red Gate .
• Highly experienced with Business Intelligence in MS SQL Server 2005/2008 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in migrating servers using in place and side by side upgrade.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
• Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
• Experienced in Extraction, Transformation and Loading ETL process using DTS, SSIS.
• Created Linked Servers for OLEDB Data Source and Native Data Sources.
• Experience in developing management reports using SSRS and Crystal Reports.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Very good knowledge of PCI/SOX regulations and documenting audit procedures.
• Developed Dash Board Reports on COGNOS 8.4 report studio
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008/2008 R2.
• Good knowledge with features of Sql server 2008 like Spatial, CDC, Encryption and File stream Data functionality.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
• Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Good working knowledge in .Net Frameswork2.0/3.0/3.5,VB.Net,C , ASP.Net, ADO.Net, XML and Web Services.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.
• Microsoft Certified IT Professional: Database Administrator.

TECHNICAL SKILLS:

EXPERIENCE:

Confidential

Role: SQL Server DBA

Confidential is the State regulatory authority for the insurance industry in Confidential.This project is mainly to provide 24x7 production support, setup and support new 4 node cluster environment for SQL Server, migration of existing SQL Server instances from 2005 to 2008 R2, respond and resolve trouble tickets assigned.

Responsibilities:

• Installed and configured SQL Server 2008 R2 on WINDOWS 2008 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on 4 node cluster setup with SQL Server 2008 r2 on Windows Server 2008 r2 in active-active configuration.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Supported production servers in Fail over cluster environment.
• Created and designed data models using Erwin data modeling tool.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application effectively distribute database administration activities, such as full database backup and database defragmentation during non-peak hours.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.
• Created SSIS Packages to Extract, Transform and Load ETL consolidated data from different sources into Data Warehouse.

Environment: Windows Server 2003, Windows Server2008 and 2008 R2, SQL Server 2012/2008 R2/2008/2005, SSRS, SSIS, Internet Information Server 6.0,7.0, JavaScript, CSS, HTML, Microsoft CRM 4.0, .Net Framework 3.5,4.0, VB.Net, C , ASP.Net, ADO.Net, Quest LITE Speed.

Confidential

Role: SQL Server DBA

Confidential is one of the oldest financial institutions and a leading global financial services firm which operates in more than 60 countries, have more than Confidential employees and also serve millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients.This project is to provide 24x7 production support, optimize application database performance, deploy and maintain SSRS reports with share point integration and native mode.

Responsibilities:

• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest Lite Speed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running database consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS in SharePoint integration and native mode.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005/2008/2008 r2, Windows Enterprises 2003/2008 servers, IIS Web server, Toad for SQL Server, LiteSpeed, JavaScript, CSS,HTML, Microsoft CRM, SSIS, SSRS,VERITAS NetBackup,ERWIN,C ,VB.Net, ASP.Net.

Confidential

Role: SQL Server DBA

Confidential is a Fortune Global 500 and Fortune 500 company whose subsidiaries provide insurance, investment management, and other financial products and services to both retail and institutional customers throughout the United States and in over 30 other countries.This project is to do in place and side by side upgrades from SQL 2000 to 2005, migrate DTS to SSIS packages, implementing high availability solutions using replication and log shipping.

Responsibilities:

• Installed SQL Server 2005 and maintained 50 servers.
• Upgraded the servers from SQL 2000 TO SQL 2005.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
• Performed Backup/Restore by using VERITAS Net Backup.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check at regular Intervals.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.

Environment: SQL server 2005,SQL Server 2000 Enterprise Edition, MS Reporting Server 2000 , Windows 2000/2003 Server, IIS 5.0, VERITAS NetBackup,VB.Net.

Confidential

Role: SQL Developer/DBA

Confidential consulting is one of the fastest growing Software solution companies in Confidential with its services in offsite and onsite in US, Singapore and Australia.

Responsibilities:

• Installed and configured SQL Server 2005 on Windows Servers. Applied patches and service packs to keep the database at current patch level.
• Created and maintained database objects like tables, indexes, stored procedures, functions, views, triggers so on.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Provided Initial Analysis and Planning for database structure under the guidance of Data Architect.
• Tuned the SQL queries using SQL profiler.
• Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
• Created SSIS Packages to ETL Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Used SQLCMD utility in command prompt to access SQL Server.
• Created Partition View by using Linked Server for Business Requirement.
• Implementation of data transfer through DTS/SSIS and setting guidelines to automate recovery scenarios.

Environment: SQL Server 2000/2005 Standard and Enterprise Editions, MS Reporting Service 2000, ODBC, VBScript, Windows 2000/2003 Server, IIS 5.0.

Confidential

Role: SQL Developer/DBA

Confidential is one of the India's leading healthcare operations and information technology providers. Confidential is comprised of more than 3,000 global healthcare experts who work with the nation's leading healthcare organizations to develop custom, world-class IT-based solutions that extend health care business capabilities and increase their financial strength.

Responsibilities:

• Involved in creating and designing of data models, logical and physical models of database using Erwin data modeling tool.
• Created scripts using VBScript and stored procedures to push the log files to a different location/file.
• Created the Packages for running the jobs automatically for backup and data transfer.
• Developed DTS packages to Massage the data and put into others tables, which are used for reporting.
• Created and maintained database objects like tables, triggers, Functions and stored procedures.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
• Implemented log shipping with SQL Server 2000 for standby server.
• Involved in tuning of applications and databases by analyzing and resolving long running queries, locks, index usage, Statistics, counters, logs, execution plans and query costs.

Environment: MS SQL Server 2000, MS Access, Erwin, SQL Query Analyzer, Visual Basic 6.0 and ASP.