Database Administrator Desk Specialist

John Bosco Gakumba

MS SQL Server Database Administrator

Texas, 77081 Cell: 832-***-**** Email: adsx8y@r.postjobfree.com Key Technologies High Availability Solution- Clustering, Always On, Log shipping TSQL SQL Server Configuration

Professional Summary:

SQL Database Administrator with over 7+ years of hands-on experience. 15 years+ Project management and networking development. Worked in a 24/7 Production and Development environment; providing Support in Database Design, Configuration, Monitoring, Tuning, Migration, Backup & Recovery, Security Administration, High Availability and Disaster Recovery Solutions and Fail over Clustering. Great Communication, Analytical and Organizational skills. An accomplished and highly qualified IT professional with diverse and extensive database administration experience. An energetic achiever capable of successfully managing multiple priorities as well as perform and deliver under pressure.

Education and Training

Bachelor of Science, and Processing Technology, College of Science and Technology, University of Rwanda

Diploma in Database Administration, Systems and Networking; Kyambogo University, Uganda

180+ hours training program in SQL Server 2016, SQL server 2017 Administration, SQL server 2019 Administration, TSQL Programming at KiawiTech Consulting LLC Certifications

MTA Database Fundamentals

Pursuing AWS solutions Architect

Pursuing Microsoft Certified Azure Database Administrator (AZ104) Recent Projects

Database migration to Microsoft Azure

Worked with Linked Servers on Oracle

SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation.

Applying windows and SQL Server patches on Production/Non Production Servers

Configured database backups and restoration, monitored and tuned database. Technical Skills:

7+ years of Administration SQL Server; Installation, Configuration, Active Directories and Setting of related server roles 2008,2014,2016,2017-2019

15 years+ Project management and conflict resolution

Performance Tuning & Monitoring using SQL Sentry One and other inbuilt tools.

SQL Standalone and cluster environments setup and installation

SQL Server Patching and Backup, Data Recovery and Migration

Working closely with developers, support, and QA teams to maintain all DB environments

- Performance tuning and Capacity planning, data integrity and security, recover corrupted data and eliminate data redundancy.

Verbal and written communication skills

John Bosco Gakumba

MS SQL Server Database Administrator

TX 77081 Cell: 832-***-**** Email: adsx8y@r.postjobfree.com

Key Technologies High Availability Solution- Clustering, Always On, Log shipping TSQL SQL Server Configuration

2

Detailed-oriented, results-driven, highly energetic and motivated.

Ability to communicate efficiently and effectively to technical and non-technical audiences.

Highly organized, detail oriented, extremely responsive and able to prioritize a large number of tasks.

Ability to provide guidance to team members to meet deadlines and objectives

Committed towards SDLC/Change Management Principles

Knowledge of data quality, data management and data testing strategies and practices.

Experienced with SQL installation on standalone and cluster servers across multi-subnet environments

Experience in the Scrum or other Agile framework

Works independently, with guidance in only the most complex situations

Able to work weekends as needed and an on-call rotation

Good time-management skills, flexibility and conflict resolution

Take initiative to solve complex problems; takes an outside perspective to identify innovative solutions Supporting capacity development for teammates, experiences and encourages collaboration Professional Experience:

Elite Cares – Irving – Tx January 2020 – Current

SQL Server Database Administrator

Manage SQL Server databases; Configure and maintain database servers and processes

Database refreshes from upper to lower environments

Monitor system's health, performance tuning and query optimization

Controlling and applying database access permissions, privileges and controls to maintain database security as per organizational standards.

Ensure high levels of performance, availability, sustainability, and security

Analyze, solve, and correct issues in real time

Monitoring MSSQL Servers for transaction latency, blocking and deadlock issues, and provide guidance in preventing/avoiding these issues to application development teams

Provide suggestions for solutions

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Provide 24x7 support for critical production systems

Perform scheduled maintenance and support release deployment activities after hours

Improved database performance by checking and fixing vulnerabilities on the database

Automation of processes to improve database performance

Resolving AG issues in an Always – On Availability

Resolving tickets on a day-to-day bases from the queue on Service Now on Non-Prod servers

Using a customized monitoring tool for database health checks and performance issues

Migration support; fulfilling DBA steps on playbook

Taking part in courses on AWS Cloud Technology for migration support

Rebuilt indexes at regular intervals per Microsoft recommendations for better performance John Bosco Gakumba

MS SQL Server Database Administrator

TX 77081 Cell: 832-***-**** Email: adsx8y@r.postjobfree.com

Key Technologies High Availability Solution- Clustering, Always On, Log shipping TSQL SQL Server Configuration

3

Nile Basin Discourse - Rwanda November,2009 – March,2019 SQL Server Database Administrator

Responsibilities:

SQL Database configuration, Active directory, Maintenance and Production support

Monitored several Servers for failed jobs and multiple performance issues

Worked with SQL Sentry one for monitoring and performance improvement in lower and upper environments

Performed daily Health Check-up of all Databases.

Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.

Developed and Implemented Disaster Recovery (DR) Plan.

Tested and Implemented different Physical and Logical Backup and Recovery methods and Point-in Time, Recovery.

Used Service Now for incident management, ticketing and issue tracking and resolution

Deployed Database Security Policy and Installation, using Passwords, Privileges and User Profiles.

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Rebuilt indexes at regular intervals per Microsoft recommendations for better performance

Used Activity Monitor, Database Tuning Advisor and SQL Profiler to optimize queries and enhance the performance of database servers

Nile Basin Discourse-Rwanda January,2006 – November,2009 IT Help Desk Specialist

Responsibilities:

Provided Service Desk support to end-users, both in the office and remotely. Assisted with hardware, software, and network issue

Monitor and respond quickly and effectively to requests received through the Service Desk ticket system (ServiceNow)

Provide day-to-day telephone support to the end-user community

Monitor and track existing incidents and service requests in ServiceNow. Prioritize tickets based on need and criticality

Support the service desk and deskside support leads by providing support for other activities outside of standard incident and service request handling

Support end-users with installation, configuration, and troubleshooting of hardware and software to ensure continued usability of equipment and software

Software and Image Management Systems (e.g. SCCM)

Technical knowledge of and experience with installing, upgrading, configuring and deploying end-user hardware

Setup, configure and maintain operation of all end-user IT equipment, including printers, computers, AV equipment, peripheral devices, mobile devices and tablets REFERENCES upon request

Contact this candidate