SUMMARY

• Extensive experience developing and working with diverse collection of applications and around 8 years of professional experience as Microsoft SQL server database administration and developer.
• Extensive experience in maintaining Very large databases (VLDB) and highly transactive production servers in SQL Server 2012/2008R 2/2008/2005/2000 environments.
• Extensively Worked on SQL Clustered Instances in 2008 and Slip Stream installation for 2008R2.
• Experience in Migrating from SQL server 2000/ R2 and 2012 by using side - by-side upgrade process, and documented the Upgrade Process.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and Database Mirroring.
• Extensively worked on Backup compression and data compression in SQL Server 2008.
• Experience with Transparent Data Encryption (TDE)
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools.
• Experience configuring and working Microsoft SQL server 2008, Microsoft SQL Server 2005 on VMware Environment.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Expertise on physical storage SAN configuration on different RAID levels.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal, vertical partitioning and Setting up clustered Instances.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, DMF’s, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in designing, developing and maintenance of databases in MS Access.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing and Reporting Services (SSRS)
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Handful of Experience on SQL server 2008 new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Explicitly used third party tools like Lite speed, Fog light and Tivoli Storage Manager (TSM).
• Rebuilding indexes with different fill factors and updating statistics.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM 2012.
• Strong experience in mentoring and working with team, good communication skills documentation and 24 X 7 on Call Production Support.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import, DTS, Replication, SSIS, SSRS.

Databases: MS SQL Server 2012/2008R2/2008/2005,2000/7.0, Oracle

Languages: T-SQL, vb.net, ASP.NET, HTML, Visual studio2005/2003

Technologies: .NET FRAMEWORK, ASP.NET, MICROSOFT SHAREPOINT 2007

Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007,SSIS,SSRS,SCOM2007/2012,Tivoli TSM

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2/2012, Windows 95/98/XP/Vista/7.

Others: Microsoft office, Microsoft Project.

PROFESSIONAL EXPERIENCE

Confidential, MD

Responsibilities:

• SQL Server 2012/2008 R 2/2008/2005/2000 Database Administration.
• Migrated databases from SQL Server 2005 to SQL Server 2008R2 and 2012.
• Started building SQL Server 2012 environments.
• Installed and configured Clustered environment.
• Installed Service packs and Builds
• Setting up and Troubleshooting Replication.
• Working As Primary DBA for Multiple applications.
• Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
• Worked on Project for setting up DB mirroring and troubleshooting
• Successfully implemented the Capacity planning for different servers.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Install and configured SQL Server clustered databases.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Installed and Configured SSRS and Deploying SSIS packages.
• Performed BCP failover exercises for Log shipping and Mirroring.
• Performed data partitioning for efficient management of database tables and indexes.
• Maintaining the database consistency with DBCC at regular intervals
• Used 3rd party tools like Red Gate, Lite speed, Fog light and DB comparer.
• Monitoring servers by checking Error Logs and Windows Logs.
• Creating Logins and Roles with appropriate permissions.
• On call production support on rotation basis.

Environment: SQL Server 2008R2/2008/05, Windows 2008r2\2008, Windows 2005 Server, VB and ASP.NET, LiteSpeed, Fog light, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, DB Comparer.

Confidential, NJ

Responsibilities:

• SQL Server 2008 R 2/2008/2005/2000 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, Default trace, change data capture, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Working As Primary DBA for 50 Instances and 70 As Alternate DBA.
• Experience working with CRM Application issues.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005 and 2008 R2.
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Configured more than 2 GB ram on 32 bit Environment.
• Successfully implemented the Capacity planning for different servers.
• Migrated DTS packages to SSIS packages.
• Worked in Active passive and Active Active cluster environment
• Installed and Configured more than 50 Clustered SQL Instances
• Installed Service packs and Builds
• Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
• Worked on Project for setting up DB mirroring and troubleshooting
• Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting.
• Worked on Slip stream installations.
• Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
• Implementation of SQL failover cluster and setting up backup jobs and Checking Control M Jobs.
• Creating and Maintaining Database Maintenance Plans.
• Worked in migrating database to different collations. worked on TDE
• Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.
• Checking the performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.
• Monitoring servers by checking Error Logs and Windows Logs.
• Creating Logins and Roles with appropriate permissions.
• Installed and Configured SSRS and Deploying SSIS packages.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2008R2/2008/05/00, Windows 2008, Windows 2005 Server, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, FogLite and SCOM 2007.

Confidential, CO

Responsibilities:

• Installation and Maintenance of SQL Server 2008 on Test, Development and Production Environments.
• Worked with SQL Server 2005/08 side by side upgrade from SQL server 2000.
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Expertise in SQL server Reporting Services(SSRS)
• Implemented the new SQL Server 2008 concepts.
• Worked in Active passive cluster environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Successfully implemented the Capacity planning for different servers.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Performed data partitioning for efficient management of database tables and indexes.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Checking Database Health by using DBCC Commands and DMVS
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations

Environment: SQL Server 2008/05/00, Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, FogLite.

Confidential, NJ

SQL DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2005.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Dropped and recreated the indexes on tables for performance improvements.
• Experience in applying Service Packs at database and OS Level.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• Configured more than 2 GB ram on 32 bit Environment.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, T-SQL, Microsoft Reporting Service.

Confidential

SQL Developer /DBA

Responsibilities:

• Installed and configured SQL Server 2000.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000(Enterprise Manager, DTS, Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2000 Advanced Server.