It Administrator Customer Service

Jose Wube

Microsoft Certified DBA

NW, Washington, DC 248-***-**** ********@*****.***

OBJECTIVE

I am seeking a SQL server DBA position with new challenges and opportunities using MS SQL server 2008/2012/2014/2016/2017 and 2019. Hands on experienced in MS SQL Server Installations, Configurations, Patching, Performance Tuning, Backup and Recovery, Query Optimization, SQL Clustering and Replications and Always On, Security of database Servers. Worked independently as well as in team-oriented environments. Establishing guidelines for a defined database architecture and database builds. Experience in supporting huge SQL Server databases trouble-shooting problems.

PROFILE SUMMARY

Talented Microsoft Certified DBA with 6+ years of experience in SQL Server Database Administration, System Analysis, Design, Development, Security and Support of SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008,2005.

Install and configure SQL Server on production and non - production environments.

Upgrading SQL Server 2008 to 2012/2014/2016/2017/2019 using Data Migration Assistant (DMA) using side by side approach and applying service packs and hot fixes.

Experience in Database Backup, Restoration, and Recovery, Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans. Working on Security (Create Logins, Users and Roles).

Experience in Performance Tuning (Server level and Query level) and trouble shooting. Database consistency checks and troubleshooting using DBCC, DMVs, Trace Flags and wait stats.

Skilled in Production, Test, Development, Replication & Cluster Server Environments.

Experienced in implementing and monitoring different types of High Availability & Disaster Recovery (HA/DR) scenarios like Always On Availability Groups, Failover Clustering, Database Mirroring, Replication and Log Shipping.

Team player, Dedicative, attention to detail, strong analytical and problem-solving skills, and excellent customer service orientation.

Daily checking the tickets assigned and resolve them depends on the Priority levels within the SLA.

Providing 24x7 technical database support for SQL Database system

ACHIEVEMENTS

Created system architecture and design documentation for several systems that details the complete picture of different components including web, app, and database servers as well as how clients/users access the systems

Analyzed, documented, planned, and implemented SQL Server backup and disaster recovery strategies to meet RTO.

Successfully analyzed, documented, planned, and upgraded 2008/2008R2/2012 servers to SQL Server 2014/2016/2017/2019 as part of a major upgrade and migration projects.

Applied the latest SQL Server patching policies.

Tackled lingering production server issues by driving the re-architecture of application and database servers’ separation, load balancing and by mitigating a single point of failure.

Gathered the necessary documents for successful DB audits and made the required ratification of gaps as.

EDUCATION AND CERTIFICATION

Bachelor Degree Adamma University, Ethiopia

DATES FROM 2008– 2012

Microsoft certified IT Professional MCIP/ MICROSOFT, 2019

SKILLS

Strong analytical and problem-solving skills with ability to research and articulate alternative solutions

Expert knowledge and strong experience in database administration in SQL Server 2019/ 2017/ 2016/2014/2012/2008R2/2008.

Enriched experience in capacity planning & proactively monitoring

Knowledgeable in high availability solutions such as Log shipping, Mirroring, Replication, Clustering, Always On Failover Clustering Instance and Always On Availability Group.

Working knowledge of PowerShell script automation.

Strong knowledge of T-SQL scripts, and ETL

Strong knowledge of Database Security, AD, logins, user access, roles …etc.

Experienced on SQL Server Performance Tuning, Query Optimization.

Detail oriented and highly organized.

Experienced with third-Party tools including Red Gate SQL Backup, Sentry One, IDERA SQL Diagnostic Manager, Solar Winds and Ola Hallengren Database Maintenance scripts,

OS: Windows 2003/2008/R2/2012 R2/2016, SAN, VMware.

WORK EXEPRIENCE

Mid-Level DBA Pharmacy Quality Solutions

OCTOBER 2017 – Present

RESPONSIBILITIES

Installed, configured, and managed SQL Server 2012, 2014, 2016 and 2017 optimally in development, test, and production environments.

Developed and documented standards, policies, procedures and key performance metrics that support the continued improvement of the IT environments.

Worked closely with scrum masters, application developers, and system administrators for QC and production deployment in an agile environment.

Reviewed database deployment codes and roll back plans.

Created, configured and managed Very Large Databases (VLDB) optimally including multiple 3 TB+ databases with high resource and high availability requirements. Ranging from small departmental systems to large scale and global mission critical SAP SQL Server implementations.

Designed, executed, and maintained database backup and disaster recovery strategies using Ola Hallengren script for mission critical databases. Used maintenance plan occasionally.

Conducted database disaster and recovery drills.

Respond and closed DBA tickets, alerts, notifications and emails.

Responsible for updating and maintaining SQL Server inventory.

Monitored 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.

Generated and sent daily critical status reports.

Installed, configured, and deployed reports using SSRS.

Configured Disaster Recovery solution with Transaction Replication from Distribution Server with multiple updatable subscriptions.

Configured and maintained Log Shipping as part of a disaster recovery and high availability solution.

Successfully upgraded database servers from SQL Server 2008/2008/R2 /2012 to SQL Server 2014/2016/2017/2019.

Configured Log shipping for Reporting web server utilization.

Managed user access and permissions to enforce company and government compliance standards.

Created automation of day to day operations, critical SQL server alerts and repetitive tasks.

Performed periodic database maintenance including database consistency checks, index maintenance (rebuild or reorganize), statistics update, deadlock monitoring, long running jobs monitoring, monitored error logs…and the likes.

Troubleshooting performance issues using Database Engine Tuning Advisor (in staging and dev environment).

Conducted 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.

Worked with development teams to review code Implementation as per the best practice standards for stored procedures, triggers, views, SQL functions, bulk transaction …etc.

Worked with in house developers and outside venders to support developments in all environments (Dev, QC, Prod).

Strong knowledge on the design and implementation of Always On high availability and disaster recovery solutions on MS SQL Server 2012, 2014, 2016 and 2017.

Worked on troubleshooting steps and documentation per system to be followed by DBA Team.

Worked and resolved day to day operational, bug/defect tickets/tasks.

Troubleshoot and provide resolutions to critical database and server problems.

Worked on weekends, holidays and off hours when on call or reserve.

Environment: Microsoft SQL Server 2017/2016/2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2012R2\2016\2008R2, Clustering, Always On, Log shipping, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio, Database upgrade advisor and now Microsoft data migration assistant

Junior Level DBA Glatfelter

August2014 – October 2016

RESPONSIBILITIES

Installed, configured, and managed SQL Server 2008 and 2012 in different environments.

Monitored database backup and DB maintenance jobs like DBCC Checks, index maintenance, statistics update, error log recycling …etc.

Performed restores of databases for development environment and production point-in-time recovery during disaster.

Generated and sent daily critical status reports.

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).

Analyzing long running-slow queries.

Worked as a custodian of SQL Server inventory. 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 etc.

Generate traces.

Analyze execution plans, deadlocks and deadlock graphs and resolve issues.

Worked with developers to optimize the codes.

Wrote t-SQL, store procedures, triggers, and functions.

Created, modified and managed tables, index, constraints, views, stored procedures, triggers.

Export & Import data from flat files, excel, and Access to/from SQL Server Database using SSIS.

Environment: MS SQL Server 2016/2014/2012/2008R2/2008/2005, T-SQL, SQL Profiler, Log Shipping, Mirroring, Clustering, Windows Server 2003/2008/2012.

DISCLOSURE: Available upon request. I can work for any employer in the US, I do not require any sponsorship.

Contact this candidate