Bismark Nkansah

Project: WakeMed Raleigh Hospital, North Carolina, USA (Data Migration|Patching|Upgrade)

• Lead role for efforts that involve multi-terabyte data management / migrations
• Managed an inventory of 2500 line items to include servers, databases, and applications.
• Created project deliverables such as Migration, Rollback, Installation, and Test Plans
• Delivered status reports to stakeholders for budgeting and planning purposes.
• Planned, tested and implemented data migration from MySQL, Postgrel to SQL Server·
• Migrated VMs, SQL databases from On-Prem, AWS to Azure Cloud
• Performed Database Migration of SQL Server Databases to Microsoft Azure hosted DBs and Managed instances.
• Added functionality to existing applications using Java and SQL
• Performed Patching and Database upgrades and migration on multiple versions of SQL server to ensure instances are up to date with the latest security fixes from Microsoft
• Import of data from text files to SQL Server database using Bulk Insert
• Troubleshot complex database and system issues and closed 15-20 tickets a day
• Performed HL7 Integrations on third-party solutions (Epic, Meditech, Cerner, Omnicell)

Project: Nehemiah Manufacturing Company, Ohio (HADR/Backup/Restore)

• Created and support HA for tier 1 production servers using Always-On Availability groups and replication
• · Performed Log shipping, replication, mirroring and implemented as high availability techniques and setting up and automatic/forced fail over for production servers.
• Installed and configured SQL Server database in standalone/cluster environment with availability groups
• Installed, configured Microsoft SQL Server instances for high availability and disaster recovery on remote locations.
• Developed Oracle Database Backups & Recovery Strategies and created High Availability processes using Windows Clustering and Database Replication Technologies.
• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications
• Responsible for monitoring customer Facing databases and ensuring 24x7x365 uptime within our internal SLA of 99.99 with on call responsibility
• Troubleshoot any performance anomalies and respond to high priority issues
• Recommending and implementing data security by creating users and assigning permissions based on the minimum level of database access the user would need and with tools like Always
  Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure
  clients sensitive data.
• Performed administrative activities like Database Maintenance, Indexing Large Databases, Database Tuning, Query Optimization and Database Backup & Recovery.
• Developed and automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Develop and managed SLAs, including RTO & RPO, for all server instances (70+)

Project: Southern Kentucky Rehabilitation Hospital

• Provided day-to-day maintenance and administration of Microsoft SQL Server databases supporting client-facing and back-office production applications.
• Performed daily DBA management tasks including troubleshooting, Query Optimization and tuning, database monitoring and backup/recovery.
• Supervised daily DBA operations; implemented infrastructure and processes to support over 450 databases across enterprise.
• Created and installed ETL (Extract, Transform and Load) packages to complete different tasks using Azure Data Factory (ADF) and Microsoft Integrations Services (SSIS).
• Managed Servers and database level Security by implementing Triple As (AAA); Authentication, Authorization and Auditing. All Users are Authenticated through various security protocols.
• Created Partitioning to handle tables with over 400 million rows.
• Provided quick resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet deadline before SLA is due.
• Communicate with corporate customers via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software.
• Provided Microsoft SQL Server performance monitoring to establish baselines and adjust resources and/or database settings to achieve higher performance.
• Investigated and troubleshot complex system and software error codes (C++, Javascript) using Visual Studio and Powershell
• Provided 24x7 support for critical production database systems

• Troubleshooting and performance tuning stand-alone and clustered environments
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
• Review scripts submitted by the development team and working with other team like system analyst, developers, business analyst and project teams to perform the capacity planning required to create and maintain databases
• Installed multiple versions of SQL Server and performed regular updates and applied services packs
• Contributed to disaster recovery and business continuity plans and exercises
• Worked and assisted software application development groups to provide database setup, regularly refreshed on lower environments, configuration, optimization, and modification support
• Assisted in development, efficiency improvements and implementation of database policies and procedures for data security and integrity
• Leveraging the uses of in-built software in SSMS such as SQL Server profiler, Performance
  monitor, Extended Events, DMVs, Database Integrity checks to ensure database integrity,
  stability, and system availability and other Third-party software like IDERA and SolarWinds
  Database Performance Analyzer to monitor system health and security.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Developed custom database objects, stored procedures and delivered application support.
• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for projects
• implement targeted scheduled health-check reporting from Windows Server-level to provide additional monitoring of SQL Server availability.
• Installed and administered 3-Node Active/Active/Passive cluster on Microsoft Windows Server 2012.
• Handed all aspects of upgrading SQL server 2005 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Installed, configured and administered MS SQL Server on Windows servers and updated them with hot fixes and latest service packs.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition and windows 2008R2 SP2 enterprise editions.
• Created custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.
• Developed different applications using T-SQL and analyses functional requirements and developed software programs to specifications.
• Developed T-SQL Stored Procedures for maintaining data in existing systems and newly developed applications.
• Supported development effort by providing T-SQL statement tuning and optimizing data loading processes.
• Performed T-SQL data modifications to resolve issues and performed customer account maintenance.
• Performed HL7 and omnicell IV Robotic solution integrations
• Investigates complex software backend issues related to C++, .NET, Javascript and others
• Troubleshot complex issues in different databases such as Postgrel, MySQL and MsSql server
• Provided mentoring to less-experienced DBA and application support team members.
• Handled Primary DBA roles and responsibility for multiple applications.

• Worked on migrating SQL Server from SQL Server 2012 to SQL Server 2014/2016/19.
• Performed administrative activities like Database Maintenance, Indexing Large Databases, Database Tuning, Query Optimization Database Backup & Recovery.
• Developed and automated daily, weekly, and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA)
• Diagnosed and solved complex database issues
• Monitored database performance, implement changes and apply new patches and versions when required
• Performed tests and evaluations regularly to ensure data security, privacy and integrity
• Provided proactive and reactive data management support and training to users
• Provided technical support and troubleshooting assistance to application development teams and other third-party software providers utilizing SQL Server platform
• Implemented and support Administration tasks such as backup and recovery procedures, database utilities, and database log shipping technologies for both PROD and NON-PROD environments
• Provided 24x7 support for critical production database systems.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Tested programs and databases to identify issues and make necessary modifications.
• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Worked on linked server to run distributed queries between SQL server and Oracle databases
• Evaluation of customer deployments of PostgreSQL and recommendations on how to improve them
• Guided customers in the development of custom PostgreSQL-based applications
• Tuning of SQL statements, optimize stored procedures, analyze query plans, write advanced PL/pgSQL
• Implement replication, High Availability and disaster recovery solutions with Postgres
• Implement solutions for backup/restore, management/monitoring and perform upgrades and patching
• Configured and Maintained Backup and Restore strategies on production server or development servers as per requirement.
• Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
• Designed and implemented T-SQL queries for reporting and complex solution development.

• Executed installations, Sql server 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 TSQL
• 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.
• Performed extraction, transformation and loading of data directly from different source systems such as Excel/Teradata/MSSQL, SAP, Oracle using CI /CD
• Performed Data Migration, import/export, remapping, and transformation of data. Migrate SQL-Server Databases to Microsoft Azure hosted DBs, Managed instances.
• Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
• Created and monitored performance metrics to keep databases functioning at optimal capacity.
• Performed Routine Postgres database and cluster wide maintenance activities like auto vaccum, vacuum/vacuum full, Analyze, re-indexing.
• PostgreSQL replication technologies, Streaming Replication, Logical Replication, log shipping from master to slave.
• PostgreSQL backup/restore logical and PITR. Installation/configuration of backup tool (pgbackrest).
• Installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL version 10, 11. and 12 community.
• Implement replication, High Availability and disaster recovery solutions with Postgres
• Implement solutions for backup/restore, management/monitoring and perform upgrades and patching.
• Monitored and optimized performance of SSIS and SQL Server Reporting Services (SSRS) jobs, troubleshooting issues, and maintaining documentation of ETL processes, data flows, data lineage and Crystal Reports

• 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

• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS and performed documentation for all kinds of reports and SSIS packages.
• Developed data standards, data exchange, XML data standard or data sharing model.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Worked with redirecting outputs into different formats including XML Files and various other data sources.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more. • Worked on XML Web Services Control Flow task to read from XML Source
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into the data warehouse.
• Created, maintained, and updated ETL packages loading from/to both OLTP and OLAP database tables.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control