Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Bismark Nkansah

Lenexa,Kansas

Summary

Experienced and committed PostgreSQL | SQL Server| Azure Database Professional with about 7-8 years proven track record in overseeing multiple servers within complex, multi-instance setups. Proficient in installation, configuration, tuning, troubleshooting, active maintenance, and backups/restores and providing comprehensive support for SQL Server versions 2008/2012/2014/2016/2017/2019/2022. Strongly possess a robust analytical mindset, coupled with solid business acumen, and a flexible approach to assimilating new responsibilities, tasks, applications, and environments, and have continuously demonstrated a proactive and results-oriented attitude with outstanding interpersonal and communication skills. As a versatile professional keen on continual learning and expanding expertise in the dynamic realm of Database administration, and seeking to leverage knowledge acquired and skills in any SQL Server Database Administrator position

Overview

11
11
years of professional experience

Work History

Senior SQL Server/Azure Database Administrator

QuiverData Solution Inc
06.2021 - Current
  • Produced high-standard database solutions to meet stability, reliability and performance metrics.
  • Administered SQL Server databases in production environments, ranging from 2012 to 2019 versions. Install and configure SQL Server database in standalone/cluster environment with availability groups.
  • Set up and controlled user profiles and access levels for each database segment to protect essential data, Creating, granting and monitoring user access rights and privileges through roles and profiles.
  • Extensive Monitoring of SQL Server with Third Party Tools like IDERA, REDGATE, Solarwinds
  • Involved in Administering servers by creating User logins with appropriate roles, logins, monitoring user accounts, creation of groups, granting privileges to users and groups.
  • Configured SQL Server 2016 Always On Availability Groups. Involved in Analyzing and Upgrading SQL Server 2008 to SQL Server 2016.
  • Performed Database Migration of SQL Server Databases to Microsoft Azure hosted DBs and Managed instances.
  • Comprehensive knowledge of SQL Server deployment, migration, patching, troubleshooting, optimization, maintenance (modelling High-Availability (HA) and Disaster Recovery (DR)).
  • Worked in of team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team
  • Configured High Availability Solution- Clustering, Always-On, Database Mirroring and Log Shipping.
  • Manage database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent.
  • Involved in planning, setup and implementation of new servers across entire enterprise.
  • Migrate VMs , SQL databases from On-Prem, AWS to Azure Cloud
  • Create and install ETL (Extract, Transform and Load) packages to complete different tasks using Azure Data Factory (ADF) and Microsoft Integrations Services (SSIS).
  • Migrate SQL-Server Databases to Microsoft Azure hosted DBs, Managed instances.
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Managed database security and users in Active Directory, ensure Database Integrity and setup maintenance plans via SQL Agent.
  • Managed Servers and database level Security by implementing Triple As (AAA); Authentication, Authorization and Auditing. All Users are Authenticated through various security protocols.
  • Creates Partitioning to handle tables with over 400 million rows
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet deadline before SLA is due
  • Experience in Agile projects with solid foundation in Software Development Lifecycle (SDLC)

Services Specialist | SQL Server DBA

Omnicell Corporation
02.2022 - 08.2022
  • On-call 24/7 SQL Server Production Database Administration, Support and Monitoring for proactive problem resolution. Involved in planning, setup and implementation of new servers across entire enterprise.
  • Minimized downtime by optimizing and monitoring High Availability for SQL Server, applying Database Mirroring, Log Shipping, Traditional Failover Clustering, and Always-On Cluster methods.
  • Performance monitoring and SQL Profiler to optimize queries and enhance database and server performance.
  • Provide DBA support and technical expertise for multiple applications in development, test and production SQL Server 2016,2017 environment.
  • Responsible for working on 2008, 2012, 2014 and 2016 versions of SQL involved in building out new secondary data center servers by configuring SQL 2008/2012/2016 with DR strategy.
  • Performed Log shipping, replication, mirroring and implemented as high availability techniques and setting up and automatic/forced fail over for production servers.
  • Auditing of database for Logins, Users transactions, and database activities and resolving orphan users.
  • Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and types of locks being held; avoid keeping transactions open for long durations, breaking large transactions to smaller ones.
  • Scheduling and monitoring SQL agent jobs. Designed and developed script to refresh selective data from production to development, and implementing to support business needs and deadlines.
  • Work with Server/SAN team to diagnose IO latency occurring with several VM’s, configured HADR techniques such as log shipping and Always-on.
  • Reorganized index, rebuilt index and updated Statistics for faster performance using index tuning wizard.

System Admin | Consultant

Cerner Corporation
03.2019 - 02.2021
  • Worked on migrating SQL Server from SQL Server 2012 to SQL Server 2014/2016.
  • Design and implement appropriate database maintenance for database systems (Index maintenance, update statistics, Backup strategies).
  • Work with application teams on tuning queries which causes extended blocking, deadlock and locking.
  • Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification and indexing using control-M agent and SQL server agent.
  • Developed complex T-SQL script and stored procedure to improve performance, preserve referential integrity and provide application functionality.
  • Worked on linked server to run distributed queries between SQL server and Oracle databases.
  • Periodically apply required service packs and cumulative updates on database servers.
  • Configured Transparent Data Encryption (TDE) and backup/restore strategies on encrypted databases.
  • Followed standard practices for migrating changes to test and production environments.
  • Developed custom database objects, stored procedures and delivered application support.
  • Created and updated database designs and data models.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Built databases and table structures for web applications.
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
  • Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
  • Implemented BI solution framework for business intelligence projects.
  • Diagnosed and solved complex database issues.
  • Installs, patches, upgrades, and troubleshoots database platforms.
  • Supported clients with business analysis, documentation, and data modeling.
  • Liaised with customers, management, and sales team to better understand customer needs and recommend appropriate solutions.

PostgreSQL | SQL Server DBA

Kiawitech Solutions LLC
05.2017 - 02.2019
  • Executed installations, upgrades, and patching, as well as managed backup and recovery, performance tuning, security, monitoring, and configuration tasks.
  • 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.
  • Developed and maintained comprehensive documentation related to database administration, including configuration, troubleshooting, and HADR solution procedures.
  • Established, implemented, and managed data replication, clustering, and failover mechanisms to ensure high availability data redundancy.
  • Diagnosed and solved complex database issues.
  • Designed, developed, and implemented Extract, Transform, Load (ETL) processes using SQL
  • Server Integration Services (SSIS), creating packages to import and export data from various sources and destinations using Data Migration Assistant (DMA) software, and other tools.
  • Provided support to clients for performance issues using SQL Profiler and Database Tuning Advisor for Indexes.
  • Monitored and optimized performance of SSIS and SQL Server Reporting Services (SSRS)
  • jobs, troubleshooting issues, and maintaining documentation of ETL processes, data flows, and data lineage.
  • Designed and developed various analytical reports from various data sources by merging data on single worksheet in Tableau Desktop.
  • Performed Data Migration, import/export, remapping and transformation of data. Migrate SQL-Server Databases to Microsoft Azure hosted DBs, Managed instances.
  • Analyzed and executed database change requests and enhancement.
  • Interacted with organizations and database administrators to find organization’s requirements and data realties.
  • Performed extraction, transformation and loading of data directly from different source systems such as Excel/Teradata/MSSQL, SAP, Oracle using CI /CD
  • Maintained Computer systems with all updates and upgrades
  • Analyzed data and explained to management.
  • Participated in on-call support rotation and provide non-standard work hour support
  • Employs general SQL, Microsoft T-SQL, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing
  • Designs, develops and implements database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications. Communicates with IT management, and peers regarding database solutions and potential enhancements

System Admin | Kitchen Assistant

Sodexo Corporation, Park University
11.2016 - 05.2018
  • Worked with Chef and Cafeteria manager to design and perform food prep.
  • Followed proper handling and sanitation procedures to comply with food safety standards and protocols.
  • Assigned to maintain computer systems with all updates and upgrades in our offices.
  • Analyzed data and explained to management using Charts via PowerBi
  • Executed installations, upgrades, and patching, as well as managed backup and recovery,
  • performance tuning, security, monitoring, and configuration tasks.
  • Created Reports to retrieve data using code objects like functions and T-SQL
  • Performed Data Migration, import/export, remapping, and transformation of data.

Associate System Admin. (National Service)

Barclays Bank Ltd
09.2012 - 06.2014
  • Created and updated databases, tables, stored procedures, triggers, functions, and views
  • Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments
  • Prepared documentation for disaster recovery plan
  • Involved in installing failover clustering on multiple nodes
  • Implemented database mirroring and log shipping
  • Planned backup strategies, scheduled backups, and performed restore operations
  • Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits
  • Worked on creating, reorganizing, and rebuilding indexes
  • Worked on database space management, performance monitoring, and alert management
  • Planned location of files and increased size and number of files
  • Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning
  • Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks
  • Transferred data between several servers using BCP and DTS
  • Generated reports extensively using SSRS
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet deadline before SLA is due.

Education

Master of Science - Management Information Systems | HMA

Park University
Kansas City, MO
11.2018

Bachelor of Arts - Geography

University of Ghana
Accra Ghana
05.2012

Skills

  • Installed SQL in standalone/Clustered
  • Database migration to Microsoft Azure
  • Log Shipping, Always-On High Availability
  • Traditional Failover, Mirroring, Replication
  • Performance Monitoring & Tuning
  • Data Modeling & application Design
  • Azure, Network, Storage & Disaster Recovery
  • Managed Instances, elastic pools, Azure VMs
  • Managed Azure compute and services
  • On-call 24/7 rotation, Production Support
  • ETL with Pentaho data Integration, SSIS
  • ETL/ Data Engineering Tools: Azure Synapse, Azure Data factory, Blob Storage, CI/CD Pipeline, Kafka, PySpark, Airflow, Databricks, Snowflake
  • Azure DevOP
  • Manage Azure Active Directory
  • Database Mirroring
  • Database Optimization
  • Microsoft Visual C#NET
  • Oracle Application Server
  • End-User Training
  • Microsoft PowerShell
  • Python
  • Software Development Lifecycle (SDLC)
  • Agile/Scrum Master

Accomplishments

  • Automated processes to reduce workflow by creating maintainance plan that runs daily to reorganize, rebuild and update statistics, Backup, and Cleanup task in my environment.
  • Migrated SQL Databases from On-prem to AZURE, configure Geo-replication for High availability, Manage database on Elastic pools and Manage instances
  • Setup and Manage Always-ON High Availability for HA/DR; High availability and Disaster Recovery. Setup and manage Log shipping to automate and Synchronize Backups and restore to a Secondary servers for Disaster recovery as an addition security for Mission Critical databases In our environment.
  • Create Data Models for new and modernized legacy Databases, implement database design following best recommendations to maximize performance and reduce data redundancy and inconsistencies. In doing so, I understand the need for a Business requirement document that outlines the business needs from the conceptual to the logical, and a good strategy for the physical model and design like normalization in OLTP vs OLAP.
  • Maintain Database Security and Consistency in Sql Server Databases by Running database validation Checks and database consistency checks to proactively resolve data corruption and Inconsistencies

Timeline

Services Specialist | SQL Server DBA

Omnicell Corporation
02.2022 - 08.2022

Senior SQL Server/Azure Database Administrator

QuiverData Solution Inc
06.2021 - Current

System Admin | Consultant

Cerner Corporation
03.2019 - 02.2021

PostgreSQL | SQL Server DBA

Kiawitech Solutions LLC
05.2017 - 02.2019

System Admin | Kitchen Assistant

Sodexo Corporation, Park University
11.2016 - 05.2018

Associate System Admin. (National Service)

Barclays Bank Ltd
09.2012 - 06.2014

Master of Science - Management Information Systems | HMA

Park University

Bachelor of Arts - Geography

University of Ghana

Similar Profiles

CREATE PROFILE
Bismark Nkansah