SUMMARY

• 7+ years of experience in Microsoft SQL Server Database Installation, Configuration, Backup & Recovery, Administration, Maintenance and Performance Tuning in SQL Server 2005 - 2017 with Windows Server 2003 - 2012 platforms.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Excellent database administration skills in all areas including planning, implementing, configuring, troubleshooting, performance tuning, high availability and disaster recovery (HADR) solution.
• Experience in SQL Server Reporting Services Installation, Configuration and Maintenance
• Designed, developed and maintained databases including creation and maintenance of user security, managing users and their security privileges and accesses.
• Experienced in database upgrades, migration between different SQL server versions, applying hotfix and service packs.
• Worked with complex system stored procedures, triggers, cursors, views, tables and other SQL joins and statements for applications
• Experience on Creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Created Linked Servers between SQL Server 2008 & 2008 R2, also created SSIS package for data transfer between the two environments.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Apply various replication and High Availability and Disaster Recovery (HADR) models including log shipping, database mirroring, AlwaysOn Availability Group & Windows Failover Clustering.
• Expert in tuning database by choosing indexes and using Database engine tuning advisor and SQL Profiler.
• Expertness in trouble shooting database space issues, deadlocks, performance and blocking.
• Implemented isolation levels, concurrency effects and different levels of blockings for data integrity
• Experienced in SQL Server tools like Enterprise Manager and SQL Query Analyzer.
• Experienced in Monitoring and optimizing the performance of the database.
• Excellent communication, interpersonal skills, a solid team player.
• Highly self-motivated and adaptable to learning and understanding new technologies.
• Worked with project teams to plan integration and implementation strategies.
• 24 X 7 Production Database on Call Support.

PROFESSIONAL EXPERIENCE

SQL DBA

Confidential, Houston, Tx

Responsibilities:

• Installation, Upgrade, Configuration and Migration of SQL Server 2008 - 2016.
• Setting up the Transactional Replication in different SQL Server databases
• Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer Database Engine Tuning Advisor.
• Worked on Integration services for the purpose of Transforming data from the cubes and storing it into the data into the SQL Server tables.
• Created maintenance plans and jobs to achieve maximum performance.
• Developed SSIS packages and scheduling of the SQL agent jobs
• Expertise in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Responsible for data migration from Excel, Flat file, to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming and Loading of data using Microsoft SQL Server SSIS and DTS.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• Developed and documented backups, recovery strategies, disaster recovery mechanism and participated disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.
• Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, replication and performing backup and recovery databases, and implementing database modifications on production servers.
• Used System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries.
• Hand on experience in troubleshooting of all databases related issues.

Environment: SQL Server 2017, 2016, 2012, 2008, 2012 SQL, Server 2005 Enterprise, SSAS, SSIS, SSRS, Power BI, DBaas, Azure Data Studio, Windows Enterprise Server 2003, 2008 & 2012

SQL DBA

Confidential, Houston, Tx

Responsibilities:

• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Administrated and managed the SQL Server 2008 - 2016 production and Non-production servers.
• Experienced in creating SSIS packages using proper control and data flow elements.
• Export and import data from sources like flat files, row files using SQL Server Integration Services.
• Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
• Migrated SQL Server 2005 databases to SQL Server 2008R2 databases including SSIS packages.
• Implemented high availability on the various servers using Replication, Log-Shipping and Mirroring.
• Implemented and tested the point in time recovery of the production databases.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources like SQL Server using SSIS.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored Log shipping and Transactional Replication and troubleshooting of errors.

Environment: Windows 2000/2003, SQL Server 2012, 2008R2 and 2005, Windows Enterprise Server 2003, SSAS, SSIS, SSRS Microsoft Reporting Services.

SQL DBA

Confidential, Houston, TX

Responsibilities:

• Responsible for data migration from Excel & Flat file to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming and Loading of data using Microsoft SQL Server SSIS.
• Prepared, maintained and modified SQL server installation and configuration documents.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2008 data bases into SQL Server 2012.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Recovering the databases from backup in disasters.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Rebuilding the indexes at regular intervals for better performance.
• Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.
• Handled numerous change management requests on production servers.
• Worked on log shipping for synchronization of database.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005 - 2012, SQL Server 2000, Windows 2003/2000 - 2012 Server, T-SQL, SQL Query Analyzer, SQL Profiler.

SQL DBA

Confidential, New York

Responsibilities:

• Install, upgrade, configuration and migrate SQL Server in clustered and non-clustered production, dev and test environments.
• Relocation of Databases from one server to another server using attach and detach databases.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Designed and created databases, tables, views, store procedures and triggers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared folder.
• Designed and implemented comprehensive backup plan and disaster recovery strategies implemented and scheduled Replication process for updating our parallel servers.
• Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via Database Mail notifications, and a SQL Server failover system.
• Rebuilding the indexes at regular intervals for better performance
• Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Maintaining the database consistency with DBCC at regular intervals.
• 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.

Environment: SQL 2005 - 2008R2, Windows 2003/2000 Server, Query Analyzer, SQL Profiler and Index Tuning Wizard.