*

Name: Afework

Skills: SQL SERVER DBA

Email:ac3esh@r.postjobfree.com

PROFESSIONAL SUMMARY

● Over 6 years of IT experience on Database Administration and Development for large and complex databases in SQL Server 2016,2014, 2012, 2008R2, 2008, 2005 and 2000.

● Extensive experience in Installation and Configuration of SQL Server 2016,2014, 2012, 2008R2, 2008, 2005 and 2000 service packs and hotfixes on standalone, Cluster Environment both in physical and virtualized servers.

● Experience in database migration and upgrade SQL Server 2000/2005/2008/2008R2/2012 to SQL Server 2005/2008/2008R2/2014/2016. Database migration to SQL Server from Oracle, MySQL, DB2, Microsoft Access using SSMA.

● Implementing data security and hardening (groups,roles, privileges, authentication, TDE and auditing)

● Excellent understanding of SQL Server architecture and Database storage structure. Ability to prepare and implement database standards and procedures across multiple environments.

● Experienced in writing T-SQL and PL\SQL queries, creating complex Stored Procedures, Functions and Triggers to perform administrative tasks and to carry out business requirements.

● Solid experience on Design, implement and manage different High Availability and Disaster Recovery Solutions Backup, restore, log shipping, Mirroring, Replication, failover Clustering and Alwayson.

● Experience in Maintenance tasks Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC check Data Integrity and, Update Statistics.

● Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.

● Monitoring and Troubleshooting SQL Server Performance using SQL Server native tools (Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs) and Third party tools (IDERA SQL Diagnostic Manager, SQL Sentry)

● Developing and Managing SSIS to populate the target database repositories from the source systems.Developing and managing reports using SQL Server Reporting Services (SSRS).

● Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels. Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills. 2

TECHNICAL SKILLS

Database Admin/ Development SQL Server 2016/2014/2012/2008/2008R2/2005/2000 Windows: Windows Server 2016/2012R2/2012/2008R2/2008/2003 Windows /XP/XP Professional/VISTA/7/8/10

SQL Tools SQL Server Management Studio (SSMS), SQL Server Configuration Manager

(SSCM), Microsoft SQL Server Migration Assistant (SSMA),Profiler, Query Execution Plan, Index and Database Tuning Advisor

ETL Tools Data Transformation Services (DTS), SQL Server Integration Services (SSIS). Reporting and Analysis Tools SQL Server Reporting Services (SSRS), Crystal Reports Data Modeling Toad Data Modeler, ERWin, Visio

Programming SQL, T-SQL, Stored Procedures, Trigger, Functions, HTML, JavaScript, ASP, ASP.net, Windows PowerShell Scripting

Hardware/Storage SAN, RAID, VPLEX XIO, Pure storage. Performance Tuning Tools Profiler, Query Execution Plan, Index and Database Tuning Advisor, Perfmon, Task manager, Windows Event, System Stored Procedures, DBCC, DMV and Third Party Tools (IDERA SQL Diagnostic Manager, SQL Sentry) Backup/Recovery SQL Server Native & Third Party Tools (Idera SQL Safe and Redgate SQL Backup Pro), litspeed backup

Server Virtualization Worked on migrating and managing database systems on Hyper-V and VMware virtual machines.

Education

● Bachelor's in Engineering @ 2008

Certification

● MCSA (Microsoft SQL Server Database Administration) 3

Citizenship: Permanent resident

References: Strong references available upon request PROFESSIONAL EXPERIENCE

Title: SQL Server DBA and Microsoft certified Engineer advisor (MCE) Client: Franklin County data center Columbus, OH

Duration: August 2017 – Present

Description:-

The Franklin County government structure includes 33 agencies, 42 independently elected officials, and 39 appointed boards, commissions, and committees. The Franklin County Commissioners manage a budget of more than $1 billion each year1. The Franklin County Data Center is a centralized information technology resource dedicated to serving over forty offices, agencies, and departments in Franklin County, Ohio.

Responsibilities:-

● Working extensive Installing, configuring, upgrading and managing SQL Server 2016/2012/2008R2 standalone and clustered on VMware Environment on Production, staging and development servers.

● Applied Service Pack (SP) and hotfixes (cumulative updates (CU) for Databases and Operating Systems.

● Design, implement and manage different High Availability and Disaster Recovery Solutions : o Installed, Configured and manage Database Mirroring o Configured Log Shipping as Standby database from Production database to Reporting database systems for reporting purposes.

o Configured and Maintained Replications.

o Installed, Configured and manage Failover Clustering o Installed, Configured and manage SQL Server AlwaysOn.

● Migrating database, linked server, logins server to server using T-SQL and wizard. 4

● Database migration to SQL Server from DB2, MySQL, Oracle using SSMA.

● Created Credential, proxy and Linked Servers between SQL Servers and other Heterogeneous environment (Azure and DB2)

● Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards. Wrote SQL, T-SQL, Stored Procedure, Functions, Triggers and views.

● Creating database encryption TDE and migrated to new servers using T SQL.

● Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.

● Performed acceptance testing to verify that database changes performed without adverse consequences.

● Estimated disk storage requirements for database software, database files & database administration needs.

● Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.

● Gave training to other DBAs how to monitor/Maintain SQL Server Alwayson Availability group.

● Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor and Sentry data management Third party tool .

● Supported cluster environment in Data center level. Two data centers with clustered.

● Database Monitoring/Performance Tuning: Tune poorly performing queries, did index and statistics related recommendations. Monitoring SQL server performance using profiler to find performance and deadlocks.

● Maintained all the maintenance jobs in all the servers.

● Configured and altered alert configuration settings for the jobs and issues. 5

● Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.

● Configured Linked server and Database Mail after migration.

● Extensively worked on Dynamic Management Views (DMV’s) to get the information about executed T- SQL statements.

● Backup/Recovery: Strong knowledge and working experience in designing, implement and manage Database Backup and Recovery solutions.

● Used DBCC to check database conditions, did indexes Reorganize/Rebuild and other database Maintenance tasks.

● Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints

(Unique/Check), Views, Developed Different Maintenance Plans for database monitoring

● Create and deploy different SSIS package to full fill ETL business requirements. Environment: SQL Server 2016/2012/2008R2; Enterprise Edition on Windows Server 2012R2/2008R2/2003. Title: SQL server DBA

Client: Nationwide, Columbus, OH

Duration: Oct 2014 – July 2017

Description:-

Nationwide Insurance, founded in 1926, is one of the nation’s oldest and most well-respected insurance agencies. A Fortune 100 company, Nationwide Insurance is recognized as one of the world’s largest financial and insurance services companies, with statutory assets reaching nearly $160 billion. Responsibilities:

● Installed and configured SQL Server 2016/2014/2012/2008 R2/2008 standalone, clustered and VMware 6

Environment on new Servers, and Installed service packs with latest hotfixes.

● Installed and configured SQL Server Data tools/BI tools

● Migrate and upgrade databases from SQL Server 2005/2008 to 2008R2, 2012/2014.

● Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.

● Fixing data issues and writing various T-SQL scripts and procedures for the migration process.

● Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks Data Integrity and, Update Statistics.

● Writing T-SQL, including complex stored procedures, tables join, functions, views and triggers.

● Implementing DMV’s, DMF’s, Triggers and Function.

● Create and maintain logins, users and manage security tasks like granting, deny and revoking.

● Implementing data security and hardening (groups, roles, privileges, authentication, TDE and auditing)

● Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.

● Assist in developing and implementing best practices for DR and Backups. Define and implement maintenance plans for the database systems. Test backups to ensure it meet the business’ Recovery Time Objectives (RTO).

● Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary. .

● Perform day to day and long term monitoring of system health as it relates to database usage and performance monitoring and troubleshoot SQL server performance, Identifying the CPU, I/O and memory bottlenecks, blocking and deadlocks using SQL Server Activity monitor/profiler/Perfmon task manager, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.

● Creation of SSIS packages for transferring data from various data sources like Oracle, MS Access, MS Excel and Text files. Implement SSIS packages to do the nightly refresh of data. 7

● High availability (HA) & Disaster recovery (DR) solutions Backup, restore, log shipping, DB Mirroring, Replication, failover Clustering and Alwayson.

● Troubleshooting SQL Server 2016/2014/2012 /2008 R2/2008 and 2005 Database connectivity issues from the web applications.

● 24 X 7 Production Database on Call Support

Environment: SQL Server 2016/2014/2012, 2008R2, 2008; Enterprise Edition on Windows Server 2012/2008R2/2003

Title: MS SQL server DBA

Client: Marriott International, Bethesda, MD

Duration: Apr 2011 – Sep 2014

Description:

Marriott is an international hotel and lodging company with nearly 4,400 properties in 85 countries worldwide. Marriott's roots can be traced back to 1927, with a root beer stand in Washington, DC and Alice S. and J. Willard Marriott, and today maintains revenues exceeding $14 billion. Responsibilities:

● Install, configure and maintain SQL Server 2005/2008 /2008R2/2012 standalone and clustered environment.

● Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.

● Monitoring and troubleshoot SQL server performance using Profiler, system procedures, DMV handling deadlocks, blockings, and fine tuning long running queries that better result in efficient SQL processing .

● Expert in using Native tools like SQL server profiler, Database Tuning Advisor, Perfmon Counters.

● Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

● Relocation of Databases from one server to another.

● Modified database Tables, Stored Procedures, Views, Triggers, User Defined Functions, as well as disk 8

configuration and storage allocation to support application enhancements.

● Created Clustered and Non-Clustered Indexes to improve data access performance.

● Routine DBA jobs like monitoring the data loading jobs/automation, Backups, disk space, database status, handling the maintenance jobs and checking the error logs.

● Configured Database Mail for sending failure job notification email messages from Jobs and Procedures

● ETL data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages.

● High Availability SQL Server solutions with SQL Server Failover Clustering, Alwayson (AG), Replication, Log shipping, and Database Mirroring.

● Created Maintenance Plans for Regular Backups, Indexes Rebuilding, and Data Purging Process as part of maintenance.

● Administered SQL Server Configuration settings to resolve various resource allocation, memory issues, setup ideal memory, and min/max server options.

● Designed and created databases, tables, views, store procedures and triggers.

● SQL development: write and troubleshoot SQL code and design (SPs, functions, tables, views, triggers, indexes, constraints).

Environment: MS SQL Server 2000/2005/2008/2008R2/2012 64 bit, Enterprise, Windows server 2003/2008/2012 64 bit, Enterprise Edition, Management Studio, BCP, Profiler, T-SQL and Performance Monitor.

Contact this candidate