SUMMARY:

• 9+ years of Database Administration and Development experience on MS SQL Server 2000/2005/2008/2008 R2/2012/2014 in OLTP and OLAP environments.
• Experience installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014; updating with hot fix and service packs.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non-prod environments.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012, 2012 to 2014.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVS, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization.
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• 3.6 years of experience in Migration Databases from Physical Servers to AWS
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Handling OS, Disk and Memory configurations.
• Experience in SQL Upgrades SQL 2000 to 2005, SQL 2005 to 2008/2008R2, SQL 2008 to 2012
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
• Expertise in analyzing execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in using DMV and DBCC commands for various performance issues.
• Extensively used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transactions, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience working on Hyper-V and VMware environments. Created Veeam backups of the same.
• Experience working with Change control process/Change management
• Strong experience in mentoring junior team members, documentation and 24/7 on call production support

TECHNICAL SKILLS:

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

Operating Systems: Windows 2000/2003/2008/2008 R2/2012/2012 R2/XP/VISTA/7, Sun Solaris 9,VMware ESX servers, Linux

Databases: MS SQL Server 2000/2005/2008/ 2008R2/2012/2014, Oracle 10g/11g, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer, Toad 8.0 version

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

Data Modeling Tools: Erwin

Other Tools: Lite Speed, Red gate, Fog light, Spot light,SQL Sentry

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, CA

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl, PowerShell

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008 R2/2012/2014 on Production and Non-Prod environments.
• Migrated SQL Servers from Virtual to physical environments for performance improvement
• Upgrading SQL server 2005/2008R2 to 2008R2 /2012 and applying Service packs wherever needed.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Configured Transactional replication from multiple publishers to one subscriber.
• Configured Metadata repository and worked on application metadata for database correlation
• Creating and Maintaining Database Maintenance Plans.
• Performed database refreshes from prod to non-prod environments
• 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
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
• Used DBCC and DMV commands for day-to-day troubleshooting tasks.
• Created Security Baselines to enforce Server Hardening and SOX compliance
• Optimized the database server usingDMV’s and DMF’sand performed acode reviewandtuningfor the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Implemented Transperant Data Encryption for sensitive application databases
• Experience with Powershell and VBscripting environment.
• Disaster Recovery Planning, Testing and analyzing, preparing continuous updates of documentation.
• Mentoring junior team members and creating documents on daily basis.

Confidential, Maryland

SQL Server DBA

Environment: SQL Server 2000/2005/2008 R2/2012, Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio,Powershell.

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2/2012 on Prod and Non-Prod environments.
• Configured HADR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments.
• Worked on side-by-side migrations of SQL Server.
• Applied service packs as a part of standardization project.
• Implemented SQL server auditing to collect data for Quarterly audits.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Refresh non-prod environments with production data on regular basis.
• Migrated SQL databases to AWS on Amazon RDS in Development and production
• Provided RAID level suggestion for data files, log files and tempdb drives
• Reorganizing or Rebuilding Indexes based on the Index fragmentation
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.

Confidential, NY

SQL Server DBA

Environment: SQL Server 2000/2005/2008, T-SQL, Excel, Windows 2003/2008 Server

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases
• Setting up and Monitoring Clustering, transactional replication, Database mirroring on Production environments.
• Migrated DTS packages into
• packages.
• Handled up to 2 TB Sized databases in clustered and stand-alone environment
• Configured Transactional replication on migrated server.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Experience working with MS SCOM and MS SCCM.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Worked on TDE to protect column level data
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, Plano, TX

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003 servers, .NET, MS Access.

Responsibilities:

• Installing, configuring, tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server 2000 to 2005 and 2008
• Used TDE to encrypt and harden financial application databases.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designedandimplemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003

Responsibilities

• Installation and configuration of MS SQL Server 2005/2000
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using Erwin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.