SUMMARY

• 8+ years of professional experience with Database Administration and Development for very large and complex databases in SQL Server 2012/2008 R 2/ 2008/2005/2000 .
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience in installing MS SQL Server 2012/2008 R 2/ 2008/2005/2000 and updating with hot fix and service packs.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Configured Sql server 2012 Always on availability groups on windows 2008R2/2012
• Extensively worked on Active - Active and Active-Passive two node Clustering and three node clustering (Active-Active-passive).
• Implemented Side-by-Side and In - Place Migration of MS SQL SERVER 2000/ .Experience in migration of sql server 2008 databases to sql server 2012.
• Auditing of database for user transactions, login and database action and in removing orphaned users.
• Configured the AWE and /3 GB switch for the 32 bit 2000/2005 server.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and Powershell scripting other SQL joins and query writing using T- SQL statements and user defined functions (UDF),In-depth noledge of T-SQL (DDL, DML, DCL)
• Good at SQL Server 2008 new concepts like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
• Experience in implementing SQL Server security models to prevent unauthorized access which Includes windows/mixed authentication, database permissions, roles, securable and principles. Experience in Creating Linked servers.
• Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency TEMPEffects, detect CPU, I/O, Memory bottlenecks.
• Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
• Experience in Performance Tuning, Query Optimization, Data Integrity, Client/Server Connectivity Database health Check, DMV’S and DMF’S.
• Very Extensively used the native tools like SQL Server Profiler, Performance Monitor, Activity Monitor,, database tuning advisor for performance analysis
• Good Experience in Backing up using Native Backup Compression, restoring the database manually and also by scheduling the jobs and Maintenance Plans. Proficient with Database Recovery models.
• Experience in using the Stored procedures, INFORMATION SCHEMA, System views and in-built Global variables for the instant analysis.
• Good noledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, TEMPeffective querying and Business Analysis Requirements.
• Good noledge of Data modeling including Physical and logical data modeling using ERWIN, VISIO.
• Experience in configuring IIS and XML.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Extensively used repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience with Microsoft SQL server Integration Services(SSIS) or any comparable ETL tool and Reporting tool with SQL server Reporting Services (SSRS) using Business Intelligence Development Studio (BIDS).
• Hands on experience in working with System Center Operations Manager (SCOM) and Ignite.
• Used third party tools like Litespeed, Red gate, idera and diagnostic manager, Veritas net backup.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Good Knowledge on oracle.
• Derived and documented the Root cause analysis for production issues
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script, Powershell scripting.

Operating Systems: Windows 95/2000/2003/2008/2012/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2008/2005/2000

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Litespeed

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008R2/2012 in newly configured standalone and Cluster Environments
• Managed and Administrated theSQL Server 2012/2008R 2/ 2008/2005/2000 production and Non-production servers for different applications.
• Installed sql server 2012 on windows 2008r2/2012 and configured Always on availability groups with a secondary replica in a synchronous mode allows automatic failover with zero data loss.
• Implemented & managed clustering, failover as per client requirement Active/Passive & executed of any upgrade such as ServicePack, in Active/Passive clustering and Active/Active/passives clustering.
• Involved in migration of SQL Server 2005 databases to SQL Server 2008R2 databases and sql server 2008r2 databases to sql server 2012
• Implemented database mirroring and logshipping for few applications as a part of disaster recovery plan.
• Performing Database Maintenance activities such as Backup, Restore and Optimization, Performed Database Restores/Refresh from Production to QA/TEST /DEV servers.
• Worked on very large and complex databases around 2TB .
• 24/7 on call support for all applications.
• Maintaining SQL Server performance using Spotlight and SCOM tools.
• Extensively worked on Dynamic Management Views (DMV’s) and DynamicManagement Functions (DMF’s).
• Responsible for capacity planning, estimating database growth and disk space management
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Performed installations & performance tuning, and implement database security for multiple instances of development, QA, and production SQL Servers databases.
• Creating Logins and Roles with appropriate permissions
• Resolve issues in SSIS Packages and DTS package.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2003/2008R2 and 2012 Servers

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Installed and Upgraded from Sql Server 2005 to Sql server 2008 & 2008R2 on Various Production Servers R2 and upgraded to their respective Service Packs.
• Implemented Sql Data Compression Using Sql server 2008 For Compressing Data and Log Files, Back Up Level.
• Installed SQL Server 2008 R2 Failover cluster.
• Implemented and setup database mirroring and replication as a part of disaster recovery solution.
• Migrating Databases from Sql server 2005 to Sql server 2008/R2.
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements.
• Created Table Valued Parameters of a table value data type and be able to pass dis variable into a stored procedure.
• Involved In Database Design, Normalization, Indexing.
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through Try-Catch, Common Table Expression (CTE), Ranking Functions.
• Designed and Developed Various Reports Like Adhoc, Matrix and Tabular Using SSRS
• Involved in maintaining Sharepoint Server to host web sites dat access shared workspaces, information stores and documents and WSS Content database restores.
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Developed Drill down, Static and interactive reports in SSRS.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup, and created alerts for error reporting.
• Solving Tickets on Daily Basis for Production Issues.
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Compared Database Objects using Red gate Tool for schema Changes, Data changes during Up gradation Process from Development to Production Servers and Sql lite Speed for Monitoring.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Checking Database Health by using DBCC Commands.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2003/2008R2 Server

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008/2008 R2on Test, Development and Production Environments.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases
• Implemented Database Mirroring, Transactional Replication and Cluster Active-passive as a part of DR plan.
• Performed SQL Server service pack up gradation and Release to Production.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors..
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Usage of new compression Techniques in SQL Server 2008/2008(R2) for backup and restore jobs.
• Involved in Index Analysis and Performance Tuning, Tune slow running queries using SQL Server Profiler.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Create and manage databases across Development and Production instances using SQL Server Management Studio. Creating and Maintaining Database Maintenance Plans
• Involved in Capacity Planning, Database Normalization and De-normalization process, monitoringand managingSQL Serverperformance like disk space issues, Log file full and backup failures.
• Implementing Change management processes to prevent production disruptions and outages.
• Used idera and diagnostic manager
• Worked on call 24/7 Support on weekly basis.

Environment: Microsoft Windows 2008 Server, MS SQL Server 2005/2008/2008 R2/2012, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, SSIS, ASP.NET, Litespeed, MS- Excel, MS-DOS. Share point, SCOM, idera and VERITAS Net Backup.

Confidential, Cincinnati, Ohio

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2000), SQL Server Enterprise Manager (2008R2) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process.
• Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, Data partitioning, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Worked on enhancing the application specific data sources and added new fields according to the requirement.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Configured more TEMPthan 2 GB ram on 32 bit Environment.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Removed excess indexing by using the index include clause.
• Created the documentation for issue diagnostics reports.
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• Managed capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows bit, DTS, SSIS, Profiler, Litespeed.

Confidential, WI

SQL Server DBA

Responsibilities:

• Worked on Administration, Database Design, and Performance Analysis on very large transactional production databases.
• Installed and configured SQL Server 2005/2008 on new servers with service packs.
• Extensively work on Snapshot and Transactional Replication.
• Work on 32 bit, x64 bit and i64 clustered and standalone server environments.
• Configured data files, log files and tempdb as per RAID features and Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Involved in ETL process under development, testing and production support environments.
• Extensively work on database partitioning for better performance in SQL Server 2005.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL.
• Implement data availability solutions like Replication, Log shipping and Database Snapshot.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Create and modify Stored Procedures and Functions to generate reports.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server, SQL Server
• Designed a report on the monitoring of SQL Server Performance. dis report gives a detail report to the management on the Performance of the server. Installed couple of SQL Server 2005/2008 on cluster environment.
• Hands on experience with the third party tools (Erwin, Fog Light, VERITAS)
• Implement and manage the clustering environment like Active/Passive and Active / Active
• Use log shipping for synchronization of database.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Troubleshoot and fine-tune databases for performance and concurrency.

Environment: MS SQL Server 2008, Windows 2003/2007, SQL, MS Access, Erwin.

Confidential, Mount Laurel, NJ

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000 to SQL server 2005 and 2008.
• Migrated Databases from SQL Server 2000 to SQL server 2005.
• Created and maintained Database mirroring with automatic failover, Metro Mirroring (SAN Mirroring) and Resilient infrastructure as a High availability
• Worked with the table partitioning (Sql Server) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked on server extensions installation under IIS (Internet Information service).
• Worked with Transparent Data Encryption, table compression, database compression and merge statements using SQL server.
• Used Policy Based Administration feature (SQL Server) and Worked with SCOM Monitoring
• Created Table Valued Parameters (SQL Server) of a table value data type and be able to pass dis variable into a stored procedure.
• Rendered Reports to Microsoft Word using SQL Server.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Worked in Active-Passive and Active-Active Cluster environment as a High availability solution and Performed Backup/Restore to server (Tape) and Disk
• Tuning queries which are running slow using Profiler and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in configuring Tempdb and Designing the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures and Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning and preparing documentation for the Disaster Recovery plan and designing Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Responsible for DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, SSIS, SSRS, T-SQL,, IIS 6.0, Erwin data modeler r7.0, MS Visio 11.0, Windows Server

Confidential 

SQL server DBA/Developer

Responsibilities:

• 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 dat better result in efficient SQL statements processing.
• Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.
• 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 2005(Enterprise Manager, DTS, IIS(Internet Information Service) Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2003 Advanced Server.