SUMMARY

• Over 7+ years of progressive experience in Database Administration and Development for verylarge and complex databases in SQL Server 2012/2008R 2/ 2008/2005/2000 on 32 bit and 64 bit environments.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensively worked on installing and configuring (32bit/64bit) different versions SQL Server 2000, 2005, 2008 R2 and 2012 updating with latest hot fixes and service packs.
• Configured and Maintained SQL Server Always On Failover Cluster for Active - Active and Active-Passive Clustering.
• Extensive Knowledge on SQL server Always on Availability Groups.
• Extensively worked on implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and mirroring on physical and virtual machines.
• Migrated SQL Server 2000/2005/2008 databases to SQL Server 2012.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes and table partitioning.
• Expertise in reading and understanding execution plan and fixing the query to execute with low cost using joins like merge, nested loops, hash join.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• Monitoring Event Viewer, SQL Error logs and Log file viewer for software and hardware related errors.
• Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Experience working with Data Compression techniques like Row Level and Page Level Compression and Database backup Compression in SQL 2008.
• Good at SQL Server 2008 R2 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), Change Data Capture.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection(DAC).
• Expertise in using Native tools like SQL Server Profiler, Database Tuning Advisor, Perfmon and third party tools like Lite Speed and Red gate.
• Handled up to 2.2 TB Size databases with clustered environment.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.
• Handling Memory configurations for SQL Server 2005 and 2008 on Windows 2003/2008.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Configured the AWE and 3 GB switch for the 32 bit 2005 server
• Experience in Troubleshooting and documenting root cause analysis.
• Thorough Understanding of different RAID levels implementation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MSSQL server by using BCP utility, DTS and SSIS services.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Dev Systems.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008 R 2/ 2008/2005/2000 .

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

Data Modeling Tools: Erwin, Red gate, Lite Speed, Idera, Visio.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP and SMTP.

Languages: T-SQL, C/C++, C#, Visual Studio2005/2003, VB.Net.

PROFESSIONAL EXPERIENCE

Confidential, Salem OR

SR: SQL SERVER DBA

Responsibilities:

• configured always On availability
• Installed and Configured MS SQL Server 2012, 2008/2008R2/2005.
• Experience on Working SQL SERVER 2012 always on environment.
• Used Erwin tool to create logical and physical model for database design
• Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
• Managing SQL server usingPowerShell scripts
• Used Database Consistency Checks - DBCC commands for database maintenance
• Prepared policy documents for Installation and Configuration of MS SQL Server 2008 R2/2012.
• Assisted in Tuning Procedural codes using Server Side Trace Queues.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Worked on installation of ESM MSSQL Server Module on Production and Non Production Servers
• Installed different Named SQL instance on one server for creating logical environment
• Implemented Database Mirroring and Transactional Replication as a part of DR plan
• Rebuilt indexes with different fill factors and update statistics manually
• Created Maintenance plan for regular database Full, Differential, and T-log backup.
• Planning and implementing the Snapshot and Transactional Replication of MS SQL Server Databases,
• Handled orphan users while moving databases
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
• Migrating the database from existing /2008 servers.
• Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Created Database project files in TFS and configured to Auto Publish Database changes in different environment
• Supported load and performance (L&P) testing and suggested design fixes
• Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Checking Database Health by using DBCC Commands and DMVS.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Installed and configured SSRS to create the reports according to client requirement

Environment: s: SQL Server 2005/2008/2008 R2, Windows 2000, 2003/2008, T-SQL, Sybase, SQL Lite Speed, SQL Spotlight and VSS, SSAS, SSRS, SSIS, ODBC, EXCEL 2007.

Confidential, OH

SR: SQL SERVER DBA

Responsibilities:

• 24 X 7 Production Database On Call Support.
• Remote Monitoring of SQL Server 2005/2008/2008 R2/2012
• Good expertise in migration of MS SQL Server 2005 to MS SQL Server 2008/2008R2,2012
• Configured database mail, Linked server and database mirroring as per the application requirement.
• Created Maintenance plan for regular database Full, Differential, and T-log backup.
• Planning and implementing the Snapshot and Transactional Replication of MS SQL Server Databases,
• Successfully configured/administered transactional replication using MS SQL Server 2000/ 2005/2008/2008 R2/2012.
• Successfully implemented High-Availability solution in MS SQL Server 2005/2008/2008 R2/2012
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Expert in creating the standard documents for Disaster recovery testing and implemented them.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Expertise in implementing Integrated Installation of SQL server 2008 failover cluster on two nodes and performed failover test to ensure automatic failover
• Production experience in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active,
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in Scheduling the SSIS packages to process the cubes.
• Involved in designing SSAS Cubes and Deploying Cubes on Production server
• Involved in designing in SSRS reports based OLAP and OLTP systems.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Manage and maintain database changes in Development, QA, Staging and Production
• Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool Performance. Counters and performance tuning.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Worked on Performance analysis and evaluation of queries and databases in slow running applications.
• Responsible for enhancing database objects including Tables, Indexes, and Stored Procedures and SQL jobs.
• Developed custom selection of reports ordering using SQL Server Reporting Services(SSRS)

Environment: s: SQL Server 2005/2008/2008 R2, Windows 2000, 2003/2008, T-SQL, Sybase, SQL Lite Speed, SQL Spotlight and VSS, SSAS, SSRS, SSIS, ODBC, EXCEL 2007.

Confidential, MI

SR: SQL SERVER DBA

Responsibilities:

• Implemented SQL Server 2008R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2012/2008R2 on Test, Development and Production Environments.
• Worked with SQL Server 2008 side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Moved SharePoint Content Databases from one Drive to another Drive.
• Fixed high Memory utilization issues.
• Installed Various Service packs for SQL Server 2008 and 2005.
• Migrated SQL Server 2005/2008/2008 R2 databases to 2012
• Having expertise Knowledge on SQL Server 2012 High availability concepts.
• Worked On SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Moved Temp db files from One Drive to another Drive.

Environment: Microsoft Windows 2003/2008/2008 R2 Server, Microsoft SQL Server 2008 R2, 2008/2005/2000 , IIS 7.5

Confidential, Austin, TX

SQL SERVER DBA

Responsibilities:

• Monitor and troubleshoot SSIS Jobs and other tools.
• Configured database mail, Linked server and database mirroring as per the application requirement.
• Created Maintenance plan for regular database Full, Differential, and T-log backup.
• Remote Monitoring of SQL Server 2005/2008
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• 24 X 7 Production Database On Call Support.
• Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in implementation of replications like Snapshot and Transactional.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Performed Database backups (operating system, flat file backups & export/import).
• Created the standard documents for Disaster recovery testing and implemented them.
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Configured Log shipping from one production server to the reporting server.
• Implemented built in log shipping with SQL Server 2000 for disaster recovery server.
• Creating the Packages for running the jobs automatically good in Implementing SQL Server security and process control.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Migrated existing Servers from SQL Server /2008R2.
• Migrated databases over 50 GB to 1TB from SQL server /2008R2 with minimum down time.
• Manage and maintain database changes in Development, QA, Staging and Production
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Replication and Log shipping for different Applications.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS),TOAD,, MS PowerPoint, MS Access 2003 & Windows Server 2003/2005/2008 , Oracle.

Confidential, Boston, MA

SQL Server DBA/Developer

Responsibilities:

• Prepared DFD & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse (Informatics) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Tune various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server dynamic configurationsforSSISpackages. Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for creating reports based on the requirements using SSRS.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, MS Visio 2008, SQL Profiler, Report Builder.

Confidential

SQL SERVER DBA

Responsibilities:

• Creating and maintaining various databases for Production, Development and Testing using SQL Server 2000.
• Installing SQL Server 2000 on the server and client machines, providing connections and managing databases.
• Planning and scheduling backups and developing recovery procedures.
• Migration of data across different databases and different servers.
• Creating procedures, functions, and triggers, handling database performance and tuning.
• SQL Server Installation, patch application, migration of databases.
• Creation of new databases, planning the location of data, index, and Transaction log files on disks.
• Setting up backups for the databases.
• Providing support to the Application developers on the application databases.
• Handled 24/7 Production Issues.

Environment: MS SQL Server 2000, Windows 2000 Advance Server, MS Office.

Confidential

SQL Server DBA

Responsibilities:

• Created and maintained Windows NT user profiles.
• Installed and configured MS SQL Server 2005 on Windows NT machines.
• Created and managed tables, functions, indexes using T-SQL in development and Production environment.
• Developed stored procedures, triggers and functions based on project requirements.
• Created all administration tasks of SQL Server and designed database.
• Designed report on the monitoring of SQL Server Performance using MS Access.
• Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
• Created automatically running stored procedures for day-end operation using SQL Server agent.
• Support and maintenance of existing code and analyzing the impact of changes in scripts and data model.

Environment: MS SQL Server 2005/2000, T-SQL, SQL Query Analyzer, Windows NT, Profiler, DTS, Microsoft Excel