Summary
Overview
Work History
Education
Skills
Activities
Timeline
Generic

Enoch Osei

Riverside,MO

Summary

Dedicated and knowledgeable SQL Server Azure Database Administrator with experience in managing multiple servers in multi-instance environments, Installation, Configuration, tuning, providing support for SQL Server 2008/2012/2014/2016/2017/2019/2022; troubleshooting, active maintenance, and backups/restores. Seeking to leverage knowledge acquired and skills in SQL Server Database Administrator position. Strong analytical sense with sound business acumen and versatility in adapting to new roles, tasks, applications, and environments. Proactive and results oriented with excellent interpersonal and communication skills. Multi-talented professional eager to learn and continue to grow my knowledge in the Database environment.

Overview

9
9
years of professional experience

Work History

SQL Database Administrator

QuiverData Solutions Inc
04.2022 - Current
  • Install, Configure, tune, and provide support for SQL Server 2008/2012/2014/2016/2017/2019/2022
  • Creates logins, users, groups, roles, and databases for database reliability
  • Keep database systems and operations under control
  • Help with programme or database testing so that mistakes can be fixed, and necessary adjustments can be made
  • Manage Database Storage, Including file groups and file placement
  • Manage Azure computer and services
  • Determine the project's scope and constraints and coordinate database development as a member of a team
  • Migrate VMs, SQL Databases from On-Prem to AZURE
  • Create and install ETL (Extract, Transform and Load) packages to complete different tasks using Azure Data Factory (ADF) and Microsoft Integrations Services (SSIS)
  • Setup Notifications, Alerts, job steps with an automated response solution schedule using SQL Server Agent
  • Monitor SQL agent jobs and make sure all jobs run successfully
  • Prepare Reports on backup failures, job failures and disk space
  • Creates Maintenance Plan for Full Backup, Differential Backup and Transaction Log Backup
  • Compress backups to minimize the amount of space it takes on disk
  • Design, manage and implement disaster recovery plans (Data Refresh and Restore)
  • Use index tuning wizard to reorganize index, rebuild index and update Statistics for faster performance
  • Manages SQL Server databases and configure failover cluster
  • Installs, patches, upgrades, and troubleshoots database platforms
  • Monitor Connections, locks and Database Performance using the Performance Dashboard
  • Performs migration of Data from SQL Server 2016 to SQL Server 2019
  • Creates Partitioning to handle tables with over 400 million rows
  • Response to assigned tickets
  • Performs root cause analysis to prevent future occurrence
  • Develop and maintain ETL processes using SQL agent jobs
  • Stored Procedure development
  • System Administration, creating users and group users
  • Develop and install Windows Operating Systems jobs using PowerShell to execute various database tasks such as executing importing and exporting schemas across multiple database instances.

SQL Database Administrator

Engaged Technologies
12.2018 - 03.2022
  • Installed, Configured, tuned, and provided support for SQL Server 2012/2014
  • Create database identifiers and descriptions
  • Worked with a team of business analysts, application developers and data architects
  • Created databases and logins with permissions
  • Observe authorised protocols when altering databases
  • Evaluated and optimized SQL queries, Indexes and Triggers
  • Supervised SQL Server databases and configured failover cluster
  • Designed physical and logical data modelling design for development projects
  • Created reports per business requirements using SQL Server Reporting Services (SSRS) 2012/2014
  • Managed Database Storage, Including file groups and file placement
  • Help with the creation and management of databases
  • Setup Alerts and Notifications with an automated response to solution schedule using SQL Server Agent
  • Performed root cause analysis to avoid future occurrence
  • Monitored SQL agent jobs and made sure all jobs were running successfully
  • Prepared Reports on backup failures, job failures and disk space
  • Established guidelines for common data field structures in your documents
  • Performed Database backup for Production, Test and Development Servers and restored backups to make sure we have successful backups
  • Designed, managed and implemented disaster recovery plans
  • Reorganized index, rebuilt index and updated Statistics for faster performance using index tuning wizard
  • Responded to assigned tickets.

HIM Analyst/Data Analyst

Bridgepoint Hospital
12.2018 - 03.2019
  • Used data entry query tools to retrieve specific patient data for reporting and analysis
  • Administer training to users and technical personnel regarding the utilisation of decision support and query systems
  • Maintained data governance practices which involved setting standards for data entry, data validation and data quality
  • Analyzed health data to identify trends and patterns to improve patient care and operational efficiency
  • Collected data, identified issues, identified areas that can be improved, wrote reports, and presented them to the medical staff
  • Created an excel Spreadsheet to track monthly data on how many affidavits and patients records are completed and put in a pivot chart
  • Assisted and provided guidance to supporting clinical services to capture required medical information/data on patients for computer input
  • Assisted physicians and other hospital personnel in retrieval of patient data and chart completion
  • Analyzed health care metrics and provided reports to management on how workflows can be improved to increase efficiency and reduce costs
  • Maintained confidentiality of information pertaining to clients, physicians, patients, and employees
  • Prepared, managed, and retrieved patient charts and records for billing purposes
  • Collected and analyzed patient and institutional data from medical records.

SQL Database Administrator

Voltranex LLC
08.2015 - 12.2017
  • Adjust applications, database queries, system hardware, and operating system, as well as maintain data files and data element references, to maximise system response and resources
  • Created Reports to retrieve data using code objects like functions and T-SQL
  • Created and altered various database objects such as Tables, indexes, constraints, and views
  • Setup, Maintenance, and supported jobs in SQL Agent
  • Help with data conversion specifications, software installation, upgrades, and maintenance, as well as data accuracy verification
  • Diagnosed and solved complex database issues
  • Used database diagrams in SQL Server to establish relationships in various tables using the Primary and Foreign keys
  • Designed and developed various analytical reports from various data sources by merging data on a single worksheet in Tableau Desktop
  • Ensure the integrity, accessibility, overall security, and privileges of the database system
  • Performed Data Migration, import/export, remapping, and transformation of data
  • Analyzed and executed database change requests and enhancement
  • Performed integration and implementation of projects, database creations and table spaces
  • Worked with database sizing and capacity planning monitoring
  • Interacted with organizations and database administrators to find the organization's requirements and data realties
  • Performed extraction, transformation and loading of data directly from different source systems such as Excel/Teradata/MSSQL
  • Create, configure, and launch systems for data recovery
  • Used SSIS to validate and then move data across servers
  • Created SSRS Data Model projects using Microsoft Visual Studio
  • Maintained Computer systems with all updates and upgrades
  • Analyzed data and explained to management.

Education

Master of Science in Information Systems and Business Analytics -

Park University

Bachelor of Science in Computer Science and Technology -

Jiangxi Normal University
05.2015

Skills

  • Operating System: Windows 10, Windows 10 Pro, Windows 11
  • SQL Server Versions: MS SQL Server 2008/2012/2014/2016/2017/2019/2022
  • Management Systems: MS SQL
  • SQL Server Tools: SQL Server Management Studio, Performance Monitor, Activity Monitor, Index Tuning Wizard, Query Analyzer, Database Tuning Wizard, Replication, SQL Server Business Intelligence, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • Data Migration: Import/Export Wizard, to Microsoft Azure Azure Site/ Recovery (ASR), Azure DevOPS
  • Manage Azure computer and services
  • Optimization
  • Scrum Master
  • Server Configuration
  • Database Creation
  • Database Backup/Recovery
  • Microsoft SQL Server Disaster Recovery
  • Excellent T-SQL and Database Programing Skills
  • SQL Profiler
  • SQL failover Clustering
  • Patches
  • Upgrades
  • VM Clustering
  • SQL Jobs Automation
  • PowerShell
  • Managing, Trouble Shooting
  • Disk Partitioning and Table Partitioning
  • Ability to effectively multi-task
  • Well-organized and dependable with the flexibility to adapt to shifting priorities
  • Strong verbal and written communication skills
  • Strong Team-Oriented

Activities

  • American Health Information Management Association (AHIMA) member 8/2016- Present
  • Kansas City Heath Information Management Association (KCHIMA) 10/2021 - Present

Timeline

SQL Database Administrator

QuiverData Solutions Inc
04.2022 - Current

SQL Database Administrator

Engaged Technologies
12.2018 - 03.2022

HIM Analyst/Data Analyst

Bridgepoint Hospital
12.2018 - 03.2019

SQL Database Administrator

Voltranex LLC
08.2015 - 12.2017

Master of Science in Information Systems and Business Analytics -

Park University

Bachelor of Science in Computer Science and Technology -

Jiangxi Normal University

Similar Profiles

CREATE PROFILE
Enoch Osei