SUMMARY

• 7+ years of experience in SQL Server 2017/2016/2014/2012/2008/2005 Database planning, implementing, Installing, configuring, Administering, troubleshooting, Performance tuning, Query Optimization, Backup/Restore, high availability and disaster recovery (HA/DR) solution to ensure maximum uptime.
• Skilled in Production, Test, Development, Replication & Cluster Server Environments.
• Experienced in implementing different types of High Availability & Disaster Recovery (HA/DR) scenarios like AlwaysOn Availability Groups, window Failover Clustering, Database Mirroring, Replication and Log Shipping.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event Viewer for performance analysis.
• Responsible for data migration from Excel, Flat file, Sybase, Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming and Loading (ETL) of data using Microsoft SQL Server SSIS and DTS.
• Worked on recently SQL Server 2016 migration from SQL Server 2008R2, 2012 and 2014.
• Ability to design high availability applications on cloud adhering to DR and availability best practices
• Team player, attention to detail, strong analytical and problem - solving skills.
• Experienced with third-Party tools including Erwin r7, BMC Remedy, Service Now, Idera, RedGate SQL Backup, and Ola Hallengren's Database Maintenance scripts.
• 24 X 7 Production Database on Call Support

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior SQL DBA

Responsibilities:

• Install, configure, and manage SQL Server 2017/2016/2014/2012/2008/2005 , Services packs and Hot fixes optimally in production, development and test environments.
• Designee, execute, and maintain database backup and disaster recovery strategies (by using Ola Hallengren script) to meet RTO for mission critical databases.
• Respond and close DBA tickets, alerts, notifications and emails.
• Monitor server activities, error logs, space usage, and troubleshooting failures or alert problems, and open trouble tickets if necessary, to work with engineers from other departments.
• Configure and management of high-performance production Clustered Sql Server database instances using Active - Passive nodes, and Active-Active nodes clustering.
• Handle all SQL administration related issues like Configuring and troubleshooting Always On, Replication, Mirroring, Clustering and Log shipping issues.
• Experience on design and implementation of AlwaysOn high availability and disaster recovery solutions on MS SQL Server 2017~2012.
• Configure Disaster Recovery solution with Transaction Replication from Distribution Server with multiple updatable subscriptions. analyze, document, plan, and upgrade 2008/2008R2 servers to SQL Server 2014/2016/2017 as part of a major upgrade and migration project.
• Create automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Perform periodic database maintenance including database consistency checks, index maintenance (rebuild or reorganize), statistics update, deadlock monitoring, long running jobs monitoring, monitored error logs.
• Troubleshooting performance issues using Database Engine Tuning Advisor (in staging and dev environment).
• Conduct baselining of SQL Servers to identify potential bottlenecks in reference to Memory, Disk I/O, CPU, database locks using SQL native tools & DMVs as well as third party tools.
• 24 X 7 Production Database on Call Support

Environment: Microsoft SQL Server 2017~2005 Enterprise and Standard Editions, Windows, 2016~2008R2,Clustering, Always On, Log shipping, replication, SSMS, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio, Database upgrade advisor and Microsoft data migration assistant, SAN, VMware, PowerShell, Tcp/Ip, Dns, Wins, Dhcp, Ftp, Snmp, Smtp, ADDS.

Confidential, Dallas, TX

SQL Server Database Administrator

Responsibilities:

• Installed, configured, and managed SQL Server 2008 and 2012.
• Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Monitored database backup and DB maintenance jobs like DBCC Checks, index maintenance, statistics update, error log recycling.
• Performed restores of databases for development environment and production point-in-time recovery during disaster.
• Monitored server activity, error log, space usage, and solving problem as needed.
• Installed and configured SQL Server database engine, reporting server, analysis sever and integration server.
• Configured and maintained Mirroring and Log Shipping as part of a high availability solution.
• Upgraded databases from SQL Server 2008 and 2012 in test and production environment.
• Applied SQL service pack, patching and security patches.
• Daily database performance monitoring and tuning by using activity monitor dynamic management views (DMVs).
• Responsible updating and maintain SQL server Inventory, keeping truck of versions, patches, application supported, support resources, License information’s, audit requirements, patch cycle, DR tier.
• Analyze execution plans, deadlocks and deadlock graphs and resolve issues.
• Created, modified and managed Databases, tables, index, constraints, views, stored procedures, triggers, functions.
• Export & Import data from flat files, excel, and Access to/from SQL Server Database using SSIS.

Environment: MS SQL Server 2012~2005, T-SQL, SQL Profiler, Log Shipping, Mirroring, Clustering, Replication, AlwaysOn Failover Clustering Instance and AlwaysOn Availability Group, Window Server 2016~2008 R2 and Active Directory.

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• Involved in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server.
• Provide technical guidance during all phases of development.
• Manage SQL Server that is running in a Hyper-V virtual machine.
• Skillful in allocating, planning future storage requirements for the database system.
• Developed data-conversion processes for customization, testing, and production.
• Automated and configured management tasks using PowerShell scripting language.
• Experienced in SQL scripts for creation and upgrade of databases, maintenance plans, user logins, database mail notifications, automation of network and server monitoring.
• Expert in performing routine maintenance on database instances including applying updates, patches, and hotfixes.
• Configured SQL server security with business requirement such as server logins, user account and passwords along with database object permissions.
• Manage complex stored procedures, functions, triggers, cursors, indexed views, tables, joins and other SQL statements.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Involved in database migration and server consolidation along with users and login.
• Participated in SQL Server upgrade from SQL server 2005 and 2008 to SQL Server 2012.
• Plan and implement backup and recovery strategies for large databases in Production and QA environments to ensure recoverability of the data warehouse.
• Ensure high availability by implementing failover clustering, Log Shipping, database mirroring or Always on Availability Group Configuration.
• Managed snapshot and transactional replication in between SQL server databases.
• Installed SQL Server Reporting Services (SSRS) to create a common report template and using SSRS data source connections inside the report.
• Configured SSIS packages to change the connection string and update the value of a variable to transform data as per Business Required Document.
• Responsible for data transformation from Excel, flat file to SQL server by using BCP and data transformation services DTS utilities.
• Resolve blockings, locks, deadlocks using Activity Monitor, DMV’s and SQL profiler.
• Update statistics using query analyzer, enterprise manager on the existing servers.
• Schedule and scripting DBCC commands to run daily and weekly basis in order to identify the health and performance of SQL server databases.
• Monitored SQL server logs to ensure whether the backup operations, batch commands and scripts have completed successfully.

Confidential, Ethiopia

Junior Database Administrator

Responsibilities:

• Administrated and managed the SQL Server 2008R2, 2005 production and Non-production servers.
• Experienced in creating SSIS packages using proper control and data flow elements.
• Export and import data from source like flat files, row files using DTS, 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 DTS to 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.
• 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.
• 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 server 2003 /R2, SQL Server 2005 and 2008R2, DTS,SSRS Microsoft Reporting Services.