SUMMARY

• 8+ years of Database Administration and Development experience on MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 in OLTP and OLAP environments on SSMS tool.
• Certified in Administering in Microsoft Sql Server 2012/2014 Databases
• Experience installing MS SQL SERVER 2005,2008,2008 R2,2012; updating with hot fix and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• 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.
• 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.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2016.
• 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.
• Expert in creating Views.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in RMAN, Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
• 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.
• 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.
• Experienced in migrating the data from ORACLE to SQL.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Customizing and generating multiple TFS reports to serve company needs.
• 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 and Redgate.
• Working on the performance with the tools IDERA and Sentryone.
• Auditing of database for users transactions, login and database action and removing orphan users
• Proficiency in writing Microsoft PowerShell scripts
• Executing the windows PowerShell scripts
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• 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 in creating SQL Server Reports using SSRS 2005 and 2008.
• Experience working on Hyper-V and VMware environments
• Experience working with Change control process/Change management
• Loaded Data into Oracle Tables usingSQL Loader
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Strong experience in mentoring junior team members, documentation and 24/7 on call production support
• 24*7 Production support experience

TECHNICAL SKILLS

• SQL Server 2008 R2/2005/2000
• Windows 2003/ 2008 Server
• C#.net
• VB and ASP.NET
• Lite Speed
• MS Visio
• Microsoft SQL server Visual Studio 2005/2008 R2

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

SQL Server DBA

Responsibilities:

• Installing, managing and troubleshooting SQL Server 2016, 2014, 2012, 2008R2, 2008.
• Performing Database optimization and performance tuning.
• Experience in configuring the disaster recovery and high availability.
• Experiencing on Log Shipping, Replication, FCI and Always on Configurations.
• Creating SQL jobs, indexes, store procedure and maintaining them.
• Migrating the database servers from 2008 to 2014 and 2008R2 to 2016.
• Working on monitoring tools like Idera, Sentry one for the performance of the databases and servers
• Working on Transactional Replication with multiple publisher to single subscriber and Single publisher to multiple Subscriber.
• Experience in developing T-SQL (DDL, DML, and DCL) statements
• Deploying the sql code according to the requirements of the business into the production.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Auditing of database for users transactions, login and database action and removing rphan users
• Configuring failover cluster instances with two nodes.
• Working on Change data capture(CDC) and Change Data Tracking(CDT) on the Replications servers. Worked on the ticketing tools Salesforce and service now.
• PerformedDatabase Integrity Checks, updated Database Statistics and performed Re-indexingthrough Maintenance Plan.
• Knowledge of SQL server Integration Services(SSIS)and Reporting Services(SSRS)Experience in building SSIS packages (.dtsx) involving ETL processextracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in providing goodproduction support for 24x7being on call system schedule vernight and weekends

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2005/2008(R 2)/ 2012/2014/2016 on Production and Non-Prod environments.
• The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, DE stuffing, Billing, vendor-managed inventory and warehouse management.
• Handled up to 2.5 TB size database in Active Passive clustered Environment.
• Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks.
• Configured Active- Active, Active- Passive clustering on physical and virtual environments.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Implemented Database Mirroring with high safety and high performance as a part of DR plan.
• Day-to-day activities like taking backup or schedule the backups daily for database and transaction log on disk and restore the databases.
• Created Logins for the users and manage their permissions.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Implemented partitioning on large table to get the performance.
• Resolve locking and blocking issues.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Performed Migrations for legacy database SQL Server migration from SQL 2000/2005 to SQL Server 2012/2014/2016 databases, after running the server side trace to know about the depreciation factors and announcements.
• Upgrades of SQL server 2005/2008R2 to 2008R2 / 2012/2014/2016 and apply Service packs wherever needed.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Creating and Maintaining Database Maintenance Plans.
• Guardium Tool for Auditing and security Purpose across the servers in the inventory.
• Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Configured Bi - directional transactional replication and have resolved many of the issues related to replication
• Created Numerous known error records to problem tickets
• Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way

Confidential, Charlotte, NC

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 R2/2012/2014, 2016 Windows 2003/2008R2/2012

Responsibilities:

• Expertise ininstallationandconfigurationof MS SQL Server 2016,2014,2012,2008R2 &2008in different32/64 bit environments.
• Experienced in Validation,Installing, configuring and maintaining multi node (2-node, 4-node) clusters runningSQL Server 2012, 2008R2/2008 inActive/Active, Active/Passive and Active/Passive mode.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Performed in configuring DR sites usingDatabase Mirroringtechnology on SQL server 2008R2/2008/2005with a witness serverorwithoutwitness serverto configure automatic failover.
• Expertise inimplementing Log Shippingas backup solution for MS SQL Server 2005/2008/2008 R2 databases.
• Experience inupgrading SQL serverand applying service pack and hot fixes.
• Expertise indatabase migrationfrom one SQL server version to other.
• Worked on the migration of data from DB2 to Sql server Databases.
• Experience inDatabase Backup, RestoreandDisaster Recovery proceduresand document disaster recovery drills.
• Performed timely refreshes on alwayson in the lower environment.
• Expert in working with third party backup tool likeSQL Lite speedto improve performance of backup and recovery.
• Highly Experienced inSQL Server performancetuning,query optimization,Database Maintenance plans, Database Consistency Checks usingDBCCand DMV’S
• Administering the MS SQL Server bycreating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts,creation of groups, granting the privileges to users and groups
• PerformedDatabase Integrity Checks, updated Database Statistics and performedRe-indexingthrough Maintenance Plan.
• Expertise in using tools likeSQL profiler, windows performance monitor and performance counter for monitoring and tuning MS SQL server performance,SCOM and OVPM.
• Highly experienced inimplementing Replication Modelssuch as Transactional and Snapshot in SQL Server
• Extensively used third party tools like Lite Speed..
• Expertise inidentifying, troubleshooting issuesanddocumentingroot cause analysis.
• Experience inconfiguringandmanaging Linked Server, Data transfer between SQL Server and other RDBMS.
• Knowledge of SQL server Integration Services(SSIS)and Reporting Services(SSRS)Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Excellentcommunicationandinterpersonal skill, have goodProblem Solving ability.

Confidential, Atlanta, GA

SQL Server DBA

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

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 improving performance.
• Upgrades of sql server 2005/2008R2 to 2008R2 /2012 and apply 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.
• Creating and Maintaining Database Maintenance Plans.
• Performed database refreshes from prod to non-prod environments
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process. Experience in C sharp.
• 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.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Proficiency in writing Microsoft PowerShell scripts.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Experience in implementing the new features of MS SQL Server 2008R2/2008 such asPolicy Based Management,Backup Compression andTransparent Data Encryption (TDE).
• Extensively used third party tools like Lite Speed, Fog light and Redgate.
• Experience in ETL process where we migrated the date from other platforms.
• Customizing and generating multiple TFS reports to server company needs.
• Loaded data into Oracle/PL SQL table using sql server
• Mentoring junior team members and creating documents on daily basis.
• 24* 7 on-call production support

Confidential, Austin, TX

SQL Server DBA/Developer

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

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 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.
• Engage with Users and Managers of company ERP system to gather and analyze data, and design and implement corporate reports
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Design and develop “canned” and ad-hoc reports for operations analysis using Crystal Reports and/or SSRS reporting environment and back-end MS SQL
• 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.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Provided RAID level suggestion or data files, log files and tempdb drives
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• 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.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Proficient in creating queries inTFSto validate results ofTFS reports.
• Expertise in usingTFSto open bugs, create tasks and user stories, initiate change requests.
• Providing 24*7 support

Confidential, Long Beach, CA

SQL Server DBA

Environment: SQL Server 2000/2005, 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 by In-place upgrade process and also used upgrade advisor tool in up gradation process.
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand-alone environment
• Configured Transactional replication on migrated server.
• Extensively worked on DMAN,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.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• 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 validation for the Application.
• Assist in capacity planning, space management and data maintenance activities for database system in DB2.
• Expertise in usingTFSto open bugs, create tasks and user stories, initiate change requests.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, NY

SQL Server DBA

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

Responsibilities:

• Installing and configuring and 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
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Restore Development and Staging databases from production backups as per the requirement.
• 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 2003/2000/7.0
• 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.
• 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.