SUMMARY

• 7+ years of experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with Healthcare, Department, Insurance and Retail Management Domains.
• 24/7 on Call Support for Production Databases.
• Experience and good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL …
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Failover) and Non - Clustered Environments.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and to troubleshoot SQL Server related CPU, memory, Disk I/O, and other resource contention.
• Experience in solving Database issues with Index fragmentation, DBCCchecks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in Monitoring Databases for Deadlock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Experience in T-SQL Development skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.
• Windows Server Failover Clustering and Availability Groups
• SQL Server Failover Cluster Instances (FCIs) and Availability Groups
• Restrictions on Using the WSFC Failover Cluster Manager with Availability Groups

TECHNICAL SKILLS

Operating Systems: Windows 2008 Server, Windows 95 98 XP NT

Databases: MS SQL Server 10.0 7.0 20 2016

Languages: T-SQL, PL SQL, C, C#, VS 12, ASP.net

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS)

ETL Tools: SSIS, SSRS, SSAS, Informatica.

Reporting Tools: MS Reporting Services, SAS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import Export Wizard

Database Modeling Other Tools: SQL Compare, SQL Trace

Other Tools: SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, NC

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2014, 2016 on Test, Development and Production Environments
• Worked with SQL Server 2014 side by side upgrade from SQL server 2012
• Database Performance Tuning, Database Memory, I/O Tuning. Plan for Performance in Database Design, Indexes tuning and Design Adviser Configurations parameter tuning. Table and index maintenance, Data base reorganization
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation
• Implemented Database Mirroring and Transactional Replication as a part of DR plan
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS
• Expertise in SQL server Reporting Services(SSRS)
• Implemented the SQL Server 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, SQLCMD and dedicated admin connection
• Worked in Active passive cluster environment
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
• Creating Logins and Roles with appropriate permissions
• Creating and Maintaining Database Maintenance Plans
• Experience in designing, developing and maintenance of databases in MS Access
• Migrated from SQL 2012 to SQL 2014 and SQL .
• Installed, upgraded and configured SQL Server 2012, 2014 server.
• Worked on incidents and notification mails from footprints tool based on Priority of issue.
• 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
• Performed data partitioning for efficient management of database tables and indexes
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks
• Managed Disk space, memory and User connections
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity
• Rebuilding the indexes at regular intervals for better performance
• Monitored and modified Performance using execution plans and Index tuning
• Performance testing on stored procedures, indexes, and triggers
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Experience in using ERWIN tool for Entity Relationship diagrams
• Checking Database Health by using DBCC Commands and DMVS
• Resolving Performance Tuning issues of the Stored Procedures (sp)
• Hands on experience in trouble shooting database issues
• Update statistics, database integrity check and Backup operations

Environment: SQL R, T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, LiteSpeed, MOM, NETIQ, HP SM7, Red Gate, Citrix, Oracle, OEM, ASM.

Confidential, Denver, CO

SQL Server Developer/DBA

Responsibilities:

• Installed, Configured and administration of SQL Server 2005, 2008, 2008R2, 2012.
• Scaling and configuring the new server builds.
• Installed and configured Clustered environment
• Commitment to SLA based on ticketing system where responding time with 15 minutes to production and 45 minutes to other environments.
• Successfully migrated SQL 2005 to SQL R2 and SQL 2008 to SQL 2012
• Tested and applied latest service packs on SQL 2008 R2 2012
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy
• Configuring and Troubleshooting Transactional Replication
• Implemented and maintained AlwaysOn Availability Groups as High Availability and Disaster Recovery solution on SQL Server 2012
• Install and configuring Report Servers and designing SSIS packages for refresh the report databases over nightly
• Extensively configured Log Shipping and addressing issues with it during day and on-call.
• Create, deploy, configure and monitor complex ETL SSIS packages
• Experience with performing DR tests periodically for mission critical application.
• Automated daily Database Refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000, 2005, 2008, 2008R2 and 2012 versions
• Created DDL triggers for auditing any DDL change in SQL 2008 R2.
• Implemented Data Partitioning to improve the performance of large table, reduces contention and increases availability of data
• Developed and implemented customized maintenance plans to meet the needs and keep up to date with the glitches and fixes for performances issues.
• Document custom database installation procedures, security standards based on environment and SLA and keep update the inventory of servers periodically.
• Involved in Change Management, Problem management activities using BMC Remedy tool before implementing database changes in production.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM 2012.
• Monitoring servers by checking Error Logs and Windows Logs
• Created the custom backup and restore strategy for production, development and test environments.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards
• Determined hardware and software requirements for SQL Server version 2005 and R2.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.

  24-hour On-call support during off-hours on rotation basis

Environment: Windows 2008 R2, SQL R2 2012, T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, LiteSpeed, MOM, NETIQ, HP SM7, Red Gate, Citrix, Oracle, OEM, ASM.

Confidential, St. Paul, MN

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Developed logical design and physical design.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• 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.
• Fine tuning of database objects and server.
• Worked with SQL Server 2005 side by side upgrade from sql server 2000.
• Expertise in setting up and troubleshooting Database mirroring.
• Daily routine Developer/DBAtasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Created Documentation for steps to be taken while upgrading the SQL server 2000 to SQL server 2005.
• 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.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: SQL Server 2005, 2008, 2008R2, T-SQL, Excel, Advanced Windows 2000 Server, Visual Source Safe 6.0 Version Control Management), TFS (Team Foundation Server), 2003/2005.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per sec, Memory involved in performance monitoring of Memory, Processor, and Disk I/O.

Environment: SQL Server 2000, Windows NT 2003, VERITAS Net Backup and Crystal Reports.

Confidential, Madison, WI

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2000/2005 on Windows 2000 environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
• Configured and managed merge replication database articles.
• Developed DTS packages to transfer data from heterogeneous data sources and different files like Flat Files, Spread Sheets to SQL Server.
• Data migration (import & export - BCP) from Text files to SQL Server 2000/7.0.
• Created Triggers to enforce data and referential integrity.
• Designed and developed Stored Procedures, functions and DTS packages and error handling using T-SQL for SQL Server 2000.
• Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
• Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
• Implemented and maintained industry standards in database management.
• Monitored SQL server performance using profiler, Index tuning advisor for query tuning, stored procs.
• Maintained the database consistency with DBCC commands at regular intervals.
• Ensuring that the backups are running fine for various databases on different servers.
• Dropped and recreated the indexes on tables for performance improvements.

Environment: SQL Server 2000/2005, Oracle 8i, Informatica, Ms-Access, Windows 2000, Linux, C++, T-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS.

Confidential

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
• Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases on a clustered environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Administrator tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed to speed up backup operations.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• 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.

Environment: Windows 2003, MS SQL Server 2000/2005, T-SQL, Visual Studio.Net 2003, SQL Loader, Lite Speed, MS Access, DTS, SSIS, SSAS, SSRS, SQL Profiler.