SUMMARY

• Over 8+ yearsof experience in Database Administration and Development for very large and complex databases related to Financial, Medical and Insurance etc.., in SQL Server 2012/2008R2/2008/2005/2000.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\internet environments.
• Experience in migrating SQL Server 2000 to 2005/2008/2008R2/2012.
• Experience in implementing Always On Availability Groups in SQL Server 2012.
• Expertise in Installing MSSQL 2012.
• Expert in RDBMS S/W installation, applying patches, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/08 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Handled up to 1.8 TB databases in Clustered environment wif good Physical storage configuration and Optimizing of SAN wif different Raid Levels.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Experience in configuring Replication and troubleshooting the issues wif transactional replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB wif considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer’ s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue.
• Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using Sql Mail.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Working knowledge of SOX Compliance for maintaining roles and responsibilities, data integrity and database management.
• Expert in raising the Service Requests and keep tracking of requests.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Maintaining the Service Level Agreements (SLA’s) according to the clients requirement.
• Very Strong Experience wifOLTPandOLAPEnvironment.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal wif Self-motivation.
• Experience in Dataguard Configuration, Implementing and Maintaining Standby Databases.
• Having good experience wif Dataguard and involved in solving trouble shooting issues.
• Involved in Cross platform migration and used ORACLE GOLDENGATE to transfer database from HP-UNIX to RHEL.
• Configured Extract and Replicate pumps for Golden gate replication in GOLDENGATE Environment and Involved in Troubleshooting issues.
• 24/7 on call production support.

TECHNICAL SKILLS

Operating Systems: Windows 2008 R2/2008/2003/XP/Vista/7, Unix (Sun Solar), Linux.

Databases: MS SQL Server 2012/2008 R2/2008/2005/2000, MS Office Access 97/2000/2003, Oracle.

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

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Data Modeling Tools: Erwin, Red gate, LiteSpeed, Foglight, Idera,Visio.

Languages: T-SQL, C/C++, C#, java script, Visual Studio 2012/2008R2/2008/2005/2003, ASP.NET, VB.Net

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

SQL SERVER DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000/2005/2008R2 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Worked on everyday tasks and tickets based on priority levels from TFS ticketing system and saved/ updated all scripts related to the tasks in TFS using visual studio 2010.
• Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/Active Cluster wif latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Worked in OLTP and OLAP environment dat includes Production (24x7), QA and development databases in SQL Server.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats. Involved in Change Data Capture process.
• Worked in resuming suspended availability database in Always On availability groups by using Powershell and TSQL in SQL Server 2012.
• Participated in the designing and development of software using agile development practices.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server wif the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Confidential, Alpharetta, GA

SQL Server DBA

Roles And Responsibilities:

• SQL Server 2012/2008R2/2005/2000 Database Administration.
• Migrated databases from SQL Server 2005 to SQL Server 2008R2 & to SQL Server 2012.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented and maintained Always ON new concept in SQL Server 2012.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2008R2.
• Worked on SQL Server 2012 Features.
• Worked on multiple Sybase servers using Unix Shell Scripting for database objects.
• Captured DDL changes using CDC (Change Data Capture) on Table and Database level. 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.
• Extensively used Repositories like Team Foundation Server (TFS).
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features like Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Migrated DTS packages to SSIS packages.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active passive cluster environment.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Did Performance Tuning of the Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups and Litespeed.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Routine Developer/DBA jobs like Backups and Restores
• Hands on experience in trouble shooting database issues.
• Performed all basic Database activities like moving databases between servers, copy databases etc
• Used Update statistics, database integrity check and Backup operations
• Used SQL server Reporting Services (SSRS) to create reports.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: Windows 2003, MS SQL Server 2012/2008R2/2005/2000, Oracle, .net, VB and ASP.

Confidential, Baltimore, MD

SQL Server DBA

Roles And Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2005/2008/2008R2 on Windows
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Configured the AWE and 3 GB switch for the 32 bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Used CDC (Change data capture), Table valued parameters and other new features in new applications.
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used litespeed backup wif MS SQL SERVER 2005.
• Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
• Good knowledge on new concepts of 2008 like PowerShell.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Re-factored and fine tuned the queries and stored procedures in T-Sql.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production server data base as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes wif different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SERVER 2000/2005/2008/R2, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008, IIS.

Confidential, NY

SQL Server DBA

Roles And Responsibilities:

• Database Administrator, Database Programming.
• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Designed and implemented Security policy for SQL Servers
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers
• Automated messaging services on server failures, for task completion and success.
• Using the Litespeed to take backups.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency wif DBCC at regular intervals
• Using log shipping for synchronization of database.
• Good experience in data modeling a metadata services.
• Expertise in SQL Server Analysis Services.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Expertise creating and supporting in OLAP Cubes
• To provide 24x7 production support for over 150 SQL Server databases on Clustered Servers wif sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Involved in Change Data Capture process.
• To provide direction and development DBA support to over 50 software developers located in various branches in US, Europe, and Asia.
• 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.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review wif client.
• To setup, implement, and maintain industry standards in database management.
• To maintain change control and release management process for all database objects like tables, views, procedures, and triggers.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.

Environment: SQL Server 2000 wif clustering, Sybase, T-SQL, LiteSpeed, Windows 2000, Oracle, VB and ASP.

Confidential

SQL Server DBA/Developer

Roles And Responsibilities:

• Involvement in the Design and Development of Database.
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance
• Monitoring Log shipping/Replication and trouble shooting of errors
• Security issues related to logins database users, and application roles and linked Servers.
• Performance Tuning of SQL 7.0
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Backup and Restoration of data/database.
• Involvement in Development and Implementation
• Designing the database
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Security issues related to logins database users and application roles and linked Servers.
• Timely completion of activities for database backup, restoration and health check of databases.
• Involved in trouble shooting and fine-tuning of databases
• Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases. Troubleshooting ODBC and OLEDB issues between the application and the server.
• Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL Server 7, SQL SERVER 2000, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.