SUMMARY

• Technically sophisticated, business - savvy professional and a team player who can undertake responsibilities beyond job titles, with 8+ years of experience as SQL DBA. Demonstrated ability in implementing technologies that decrease costs and improve performance.
• Expertise inDatabase Administration of verylarge and complex databasesinSQL Server 2014, 2012, 2008 R2, 2008andSQL Server 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.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability Disaster Recovery.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing HADR solutions like Replication, Log shipping, Clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Configured Transactional and Snapshot Replication
• Configured Synchronous and Asynchronous Mirroring for DR.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER of different Versions.
• Experience with Microsoft SQL Server Integration Services
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE).
• Good experience in Deploying SSIS packages in MS SQL Server 2008 and MS SQL Server 2012.
• 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.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Upgradation of SQL server versions and applying patches and hot fixes.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• 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.
• Troubleshooting the Disk failures in a Cluster Environment.
• Experience working in both OLTP and OLAP environments.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Used Index tuning izard and rebuilding indexes for faster Query Performance.
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Configured the DB SMTP mail for the notification purposes.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good experience in Data modelling (Conceptual) and Meta Data services.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• 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 comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Experience in using DMV, DBCC and dynamic management functions.
• Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Experience working with change control process.
• Responsible for validating and editing change control or change requests to ensure compliance including verification checks and fallback procedures.
• Having experience in monitoring server health using SCOM.
• Strong ability in Scheduling and deploying reports on Report manager
• Experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and Drilldown Reports in multiple formats using multi - dimensional objects.
• 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 using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Good understanding of different RAID levels implementation.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/ 2003/20 R2, UNIX (Sun Solar), LINUX

RDBMS: MS-SQL Server 7.0/ 2000/2005/2008, 2012

ETL Tools: MS SSIS.

Third party Tools: Erwin, Visio, Red gate, Lite Speed, Tivoli TSM

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers.
• Migrations of SQL server from one version of SQL server to another.
• Implemented side by side and Inplace Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups.
• Building SQL 2008R2 cluster environments on VMware/ Physical environments.
• Applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping.
• Fix the Cluster and Replication issues on sql 2005/2008R2/2012 servers with in very strong SLA’s.
• Usage of new compression Techniques in SQL Server 2008(R2) for backup and restore jobs.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Performed Administrative tasks in SQL Server using PowerShell.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Experience working with change control process.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Worked Extensively on Remedy application Database server tuning.
• Configured Transactional replication on migrated server.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Experience in SQL Server Reporting Services (SSRS).
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, MS SCCOM, Tivoli TSM

Confidential, Columbus, OH

Sr. SQL Server DBA

Responsibilities:

• Setup Always-On High availability on 2012 SQL Servers.
• Migrating SQL server from 2008R2 to 2012 on standalone and cluster environment.
• Resolve locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Use log shipping for synchronization of database.
• Fixed high Memory utilization issues.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Build two-node/Multi-node cluster on physical/Virtual environments.
• Refresh non-prod environments with production.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Restore Development and Staging databases from production backups as per the requirement.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Managed SQL Server using PowerShell.
• Involved in Change Data Capture process.
• Setup SQL Auditing to capture data changes.
• Performance Tuning & Establishing integrated change control.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Documented and Created SLAs (Service Level Agreement) for the server availability in case of disaster.
• Configure Transparent Data Encryption (TDE) on Financial Applications.
• 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 with client.
• Used Rational Clear case and AccuRev for change management in the SDLC cycle.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security on SQL Servers databases.
• 24*7 On-Call Support.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, WINOWS SERVER NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Olympia, WA

SQL Server DBA

Responsibilities:

• Manage 210+ Database Servers between the Development, Quality Assurance, User Acceptance and Disaster Recovery Environments
• Migrated and Troubleshooting of Upgrades issues like SQL Server in Microsoft Windows Server 2003 R2 Enterprise Edition.
• Built Disaster recovery environment as replica to the Production servers and Created Custom Log-Shipping to manage and Support Disaster Recovery and Production Support restores
• Administration and Troubleshooting of Log Shipping
• Written stored procedures, cursors, user defined functions and tuning and optimizing Queries in SQL Server
• Extensive testing on the performance of the Stored Procedures.
• Enhanced the coding guidelines document for SQL developers
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitored the SQL Server Jobs, database size, disk space in SQL Server.
• Developing Backup & Disaster Recovery strategies and implementing on all production servers.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Monitor all DDL changes in production environment
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Configured Email notifications thru SMTP to get Alerts and diagnose the performance counters.
• Used Dynamic Management Views (DMV) and Functions for monitoring the performance of the server
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Experience in ETL process by extracting the data from XML, Flat Files and loading to the Reporting DB based on the Business requirements
• Controlled and Coordinated the installations ( Security Patches, Service packs ) and evaluated the performance before Pre-deployment
• Migrated DTS packages to SSIS Packages using DTSX change tool
• Performed SQL Server 2008 Compression Backup and Data Compression
• Perform the Node Injection to upgrade the Hardware on Cluster Servers.
• Used Visual Source Safe and Team foundation servers to maintain version control Mechanisms.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Perform capacity planning and offer both long and short term solutions to controlling and managing database growth and space management
• Develop and implement backup and recovery strategies using both native SQL and third party technologies like Lite Speed 4.8 and 5.0.
• Rebuilding the online indexes at regular intervals for better performance
• Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003, Erwin, DTSX change, SSMS, DTS, SQL profiler, VSS 6.0 C, HP SAN, Team Foundation Server, Lite speed 4.8, 5.0

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Configure Transactional and Snapshot replication on SQL 2008R2 Servers
• Install SQL server 2008R2 servers on Physical/virtual servers and apply Service packs where needed.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Performed Full and Differential backup with bulk-logged recovery models.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Wizard (DTA)
• Used Joins, correlated and correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, trigger and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.

Environment: T-SQL, MS SQL SERVER 2005/2008R2, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• 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, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: T-SQL, MS SQL SERVER 2000/2005/2008 R2, Windows Server NT/2003/2008R2, SSIS.