Overview
Work History
Education
Personal Information
Technical Experience
Current Projects
Timeline
Generic

Joseph Malekela

Powell,OH

Overview

7
7
years of professional experience

Work History

MS SQL Server DBA

HighRoad Technologies, Inc
01.2019 - Current
  • Installing and Maintaining SQL Server database systems which include but not limited to ensuring successful backups, resolving systems issues, opening cases with vendors to resolve issues, monitoring success and failures of automated jobs, monitor system availability, updating systems documentation and database recovery
  • Resolved and responded to all database access and performance issues
  • Configured High Availability Solutions- Always ON Cluster, Traditional Failover Clustering and Log Shipping
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor-(DTA) for performance
  • Upgrading SQL Server by reviewing, planning, testing, and installing database security patches and service packs
  • Design, documented and promoted security best practices, policies, standards
  • Working with development and system teams to perform application monitoring
  • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications
  • Setting up Transparent Data Encryption-TDE, Dynamic Data Masking-DDM, and Always encrypted
  • Configuring and monitoring HA and DR Solutions, Availability group, Log Shipping, Replication, Failover Clustering.

SQL Server Administrator

MidPoint Integration, LLC
09.2017 - 01.2019
  • Performed daily aspects of MS SQL database administration such as Installations, configuration, upgrade, security, user management and logins, performance tuning and monitoring database availability, backup and restore, trouble shooting and problem resolution
  • Work with the development team to resolve bug-fixes and assist in relevant testing through various environments
  • Provide solutions for database issues including capacity, redundancy, replication, and performance
  • Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc
  • As requirement on SQL Server Environments
  • Planning and implementation of Database backup/restore and disaster recovery
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor-(DTA) for performance
  • Configured and supported replication and log shipping in both SQL 2016 and 2019
  • Automation of DBA Tasks and monitoring using both SQL inbuilt tools and third-party tools
  • Respond promptly to user complaints regarding access to database
  • Perform automated Jobs to run and resolve database issues.

Education

Bachelor of Science: - Applied Management – Small Business

Franklin University
01.2013

Personal Information

Title: SQL Server DBA

Technical Experience

  • Responsible for daily maintenance of large environment comprising of over 120 servers, 400+ Instances and 550+ databases.
  • Enhanced databases performance implemented recovery procedures and achieved 99.9% up time on all SQL Servers.
  • Increased efficiency 25% by providing optimum database performance with efficient backup and restore processes.
  • Strong experience with SQL Server 2016 through 2019 administration standalone and cluster environment.
  • Configured and supported replication (Snapshot/Transactional/Merge) and log Shipping in both SQL 2016 through 2019 Servers.
  • High Availability Solutions Clustering, Always On, Database Mirroring and Log Shipping.
  • Exposure in Red Gate, Idera monitoring tools.
  • Query Store import/Export Wizard, SSMS, SQL Server Profiler, Extended events, and Tuning Advisor tools.
  • Interacts with clients, application team and project managers to design, implement and support solutions to meet clients’ needs.

Current Projects

  • Upgrading from SQL Server 2008 to SQL Server 2019
  • Setting HD and DR Solutions (Always on, replication and database log shipping)
  • Windows patching
  • Database migration
  • Responding to ticket queue (Refreshing databases, creating logins and users)

Timeline

MS SQL Server DBA

HighRoad Technologies, Inc
01.2019 - Current

SQL Server Administrator

MidPoint Integration, LLC
09.2017 - 01.2019

Bachelor of Science: - Applied Management – Small Business

Franklin University

Similar Profiles

CREATE PROFILE
Joseph Malekela