Work Experience
Developer | Database Administrator
Microsoft Dynamics2021 – Present
MEGASTAR TECHNICAL & CONSTRUCTION COMPANY - Port Harcout, Rivers State September 2021 to Present • Microsoft Dynamics Business Central Developer for a group of companies with four subsidiaries. • I customized and automated the following processes: Ø Payment Request Voucher Ø E-payment Ø Supply chain management Ø Financial management Ø Approval flows Ø Material Requisition Ø Purchase Order Ø Work Order Ø Reports Ø Automated email report using SSRS and SSIS Ø Power BI • Collaborate with business process leaders, users and Dynamics Partners to define, design, and implement dashboards and reports. • Troubleshooting, technical support, and system maintenance to include - Performing tuning, backup, session management, and query/schema optimizations. • Review and analyze data from multiple internal and external sources • Facilitate testing with users for ERP related enhancements and fixes • Develop reports and queries to present data to Line managers in a usable fashion. • Prepare system and business workflow documentation and diagrams to identify operations to be performed by system & personnel • Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000, 2005/2008/2012/2016 and 2019. Developed custom database objects, stored procedures, and delivered application support. • Experience in using SQL Server Profiler, Extended Event, Query Store, and Database tuning advisor, Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, and synchronization. • Solid experience in high availability SQL Server Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive). • Configured High Availability Solution- Clustering, Always-On, and Log Shipping • On-call 24/7 SQL Server Database Administration, Support and Monitoring for proactive problem resolution. • Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces. • Used SQL Server Transparent Data Encryption (TDE) to encrypt tables Tablespaces, also implemented "triple-A" (AAA) and database auditing policies. • Produced high-standard database solutions to meet stability, reliability and performance metrics. • Set up and controlled user profiles and access levels for each database segment to protect important data. • Created and implemented database designs and data models. • Created data integration pipeline to update data on the Data warehouse using ETL implementation. • Write, develop and deploy business reports using SQL Server Reporting Services (SSRS) across various databases and systems • Data Visualization with Power BI and SSRS report service. • Data analysis using Python to create a machine learning linear and non-linear model. • Monitoring and optimizing the performance of the database. • Developed reports and queries to present data to Line managers in a usable fashion.
Microsoft Dynamics 365 Developer | Database Administrator
UNITED BANK OF AFRICA PENSIONS CUSTODIAN LIMITED2021 – 2021
• I customized and automated the following processes: Ø Daily automated report through email for managers Ø Email notification to automate the manual process of sending a request Ø Reports on Sequel server reporting service Ø Benefit payment processes Ø Contribution and reconciliation Ø Power BI • Designed and developed a Data warehouse as a data source for the reporting platform (SSRS and Power BI). • Development of ETL pipeline to update data from the production environment to the Data warehouse. • Minimized downtime by optimizing and monitoring High Availability for SQL Server, applying Log Shipping, Traditional Failover Clustering, and Always On Cluster methods. • Maintained server and database security including database encryption (TDE), Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012. • Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, Setup Jobs, Maintenance plans for backups, rebuilding indexes, checking server health, alerts, notifications • Create and manage different types of Indexes (Cluster/Non-Cluster), and Constraints (Unique/Check). • Manual, Demand and setup jobs for Database Backup, and design backup strategy • Monitor Server Activity, Error Log, and space usage and solve problems as needed. • Implemented & managed database clustering, failover, and load balance technologies as per client requirements. • Strong working experience in creating, and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, and Triggers. • Data Modeling, developing E-R Diagram and SQL Server Data Diagram. • Working experience in Database Backup, Restore and Point-in-Time Recovery • Developed Different Maintenance Plans for database monitoring • Managed workload independently but collaborated with colleagues to complete larger-scale tasks in a distributed team environment. • Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
Database Administrator
Microsoft Dynamics2018 – 2021
• Provided Service Desk support to end-users, both in the office and remotely on any issue relating to the ERP application. • Monitor and respond quickly and effectively to requests received through the Help Desk ticket system. • Applied Service packs and security fixes for all SQL servers and provided database administration support. • Analyzing data using statistical techniques and providing reports. • Developing and implementing databases and data collection systems. • Acquiring data from primary and secondary sources and maintaining data systems. • Identifying, analyzing, and interpreting trends or patterns in complex data sets • 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 at a Tier II level - including, but not limited to: Network Connectivity, MS Office, Microsoft Outlook, tablet/smartphone support, Windows 7/10, 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 maintaining the operation of all end-user IT equipment, including printers, computers, AV equipment, peripheral devices, mobile devices and tablets • SQL Server Performance Dashboard Reports for Monitoring • Monitoring and maintaining computer systems and networks devices • Testing and evaluating new technology • Power BI implementation and training for the Management Staff • Requirement gathering and implementation of users' reporting needs. • User training and engagement in Business intelligence • Software manual and automation testing (Appium and Selenium) • Installation and Administration of Sophos Endpoint protection and Encryption on mobile devices (BYOD), computers and servers using Sophos Central Server (Web-Based) • Network Monitoring (Virtual Private Network), using Sophos XG Firewall for Remote Site to the Client workstation. • Microsoft Office 365 Administrator.
ICT Support
Lead Hardware Engineer
CLOUDSHOT TECHNOLOGY LTD2014 – 2016
Actively collaborating with a team of 11 members to increase the level of technological advancement in higher institutions through our practical engineering classes and technology club. Successfully trained 80 undergraduates.
Education
BSc. in Physics
WorldQuant University2021 – 2022
BSc. in Physics