AFOLABI KEMBI

**** ***** **** *****, ***** Mountain, GA. 30058

adxqs4@r.postjobfree.com

773-***-****

SUMMARY

Data Architect transforming complex business problems in the technology sector into focused, data-backed solutions and driving down costs, elevating reporting capabilities and improving decision-making processes. Offer more than 17 years of DBA & Data Architect experience with expertise in cloud data migration, database consolidation, data transformation, and streaming, Data warehouse, Data Lake, Databricks, disaster recovery, management of database security, high availability solutions. Experience in designing innovative business solutions for public & private sector clients with exceptionally large and complex MS SQL Server, Oracle, PostgreSQL RDBMS, Microsoft Azure, Teradata, JavaScript, Python, AWS, SAP HANA.

TECHNICAL SKILLS

Experience in developing business solutions for enterprise projects and strong knowledge of project implementation methodologies.

Familiar with cloud technologies (Azure & AWS), Azure DevOps, Terraform & GitHub Pipelines for deployment solutions & cloud infrastructure management.

Experience with performance optimization, large data volume architecture and design, relational and columnar databases, operations, data extracts, data refreshes and workflows.

Skilled in Azure/AWS cloud computing, information management, application development, and virtualization.

Assists technical teams on various technical aspects of the Azure cloud program on Cloud Design/Build/Run/Transformation/Transition/Migration to validate and preview infrastructure changes before application of the plan.

Experience in Azure and Azure Data ecosystem, working with Azure Data Factory, Snowflake, Azure Data Lake, & Databricks.

Experienced in designing and implementing Relational, Non-Relational databases, Data Integration & Transformation patterns.

Experienced in Amazon EC2, Babelfish for Aurora PostgreSQL, setting up instances and setting up Security groups and setting up databases in AWS services using S3 bucket and configuring instance backups.

Demonstrated ability to architect and deliver scalable enterprise solutions combining various Azure services (Azure Data Factory, Stream Analytics, Azure Synapse Analytics, Databricks & Azure Data Lake).

Experience with Python scripting and TSQL scripting for data manipulation.

Implemented the new SQL Server 2012/2016/2019, Azure SQL instances mechanisms like data compression, online indexing, contained databases, security principles and AAG.

Experience Develop, evaluate, disseminate, and integrate new standards, specifications, and technologies into existing processes and methodologies.

Experience with development process lifecycle in an Agile methodology environment.

Experience with SharePoint integration with SQL Server Reporting Services and Power-BI in providing data integration, data crawling, and report design to enable business decision- making.

Experience in Database modeling using data modeling tools (Erwin).

Experience in design, deploy, and operate high availability, cost-effectiveness, and secure applications on both Azure & AWS platforms.

Experience in building and migrating applications, software, and services on the Azure & AWS platforms.

Knowledge of Apache Pig and related technologies to develop, operate, and optimize the massive data flows going into the Hadoop system Big Data platform.

Experience with implementation of disaster recovery (DR) and strategy planning.

Created Linked Servers linking SQL Server, SAP HANA, Azure & Oracle and created SSIS packages for data transfer.

PROFESSIONAL EXPERIENCE

Humana

DEC 2021 – Present Data Architect

Working with stakeholders across organizations to evaluate cloud systems and identify appropriate solutions from a technical perspective, including design, planning, integration, maintenance and support of cloud architecture.

Assisted in building and architecting systems using Azure Databricks, Azure Synapse, Azure Datalake, Azure Hyperscale Database, Python, Pipelines, SQL and other cloud related technologies like Ispirer.

Responsible for developing blueprints for all data repositories, evaluating hardware and software platforms, and integrating systems.

Support the use of data-driven insights to help our clients achieve outcomes and goals whilst respecting security requirements.

Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics.

Responsible for the migration of On-Prem SQL Server to Azure database for PostgreSQL using Azure Data Factory and Ispirer (third party tool) for the conversion of the business logic that resides on triggers and stored procedures.

Part of a team with strong technical skills assisting in translating business needs into long-term solutions.

Defines, designs and builds dimensional and cloud database schemas.

Evaluates reusability of current data for separate analyses by conducting data sheering to rid the system of old, unused or duplicate data.

Reviews object and data models and the metadata repository to structure the data for better management and quicker access.

Makes decisions on moderately complex to complex issues regarding technical approach for project components, and work is performed without direction.

Exercises considerable latitude in determining objectives and approaches to assignments.

Gwinnett County Government

OCT 2019 – DEC 2021 Solution Architect

Migrated databases, applications, accounts, and platforms when necessary and feasible. Manage SQL Server and Oracle databases on-premises and in the cloud.

Designed and tweaked global Azure/AWS infrastructure, including nodes in multiple regions and sub-regions by working to design automation solutions for Azure environments.

Conducting current state assessment of infrastructure framework to identify gaps and recommend solutions by leveraging assessment results to enhance existing framework and designed strategic solution for owners, stakeholders, and users.

Installation, configuration, migration, and update of SQL Server Instances for On-Prem & Azure Platform.

Leveraged information server, including data profiling, data quality, ETL, and metadata by designing and architecting enterprise data integration solutions.

Advice company on the importance of using state-of-the art technology end-to-end; from ETL & data pipelines, to analysis, algorithms, and visualization.

Designed and developed ETL pipelines with Python code to extend classes of operator objects techniques that supported highly varied (structured, semi-structured, and unstructured) with near real-time data processing and delivery.

Led in deploying data encryption solution for both disk and database encryption for MS SQL and Oracle databases with the client's technology (Vormetric) and help with the deployment of the encryption agents on the company's PCI environments within Azure SQL Database.

Designed an effective monitoring of critical SQL Server installations using Spotlight for SQL Server Enterprise & CloudWatch.

Experience with Vormetric Transparent Encryption to protect data on-premises, across multiple clouds and within big data, and container environments.

Assisted partners develop their Data Platform and Analytics practices on SQL Server, Azure and AWS, including delivering offers to the market based on professional services, managed services and/or IP.

Ability to understand Migration requirements and bridge the gaps.

Experience in AWS Platform as a Service (PaaS) and Infrastructure as a Service (IaaS).

Experienced in DR setup - replication, mirroring, and AlwaysOn with FCI and AG.

Implemented replication within the data warehouse management solutions with the use Data Lake.

Act as a liaison for third party applications and coordinated meetings to resolve issues on time.

Designed ETL architecture and developed capacity-planning and trending-data warehousing solution.

DUKE ENERGY

AUG 2018 – AUG 2019 Data Architect

Worked closely with business stakeholders and the software development team to understand their needs and construct efficient and scalable data models to achieve goals.

Participated in an Agile development process for on-going projects or ad-hoc requests.

Worked with the business team to gather and document business requirements for Meter Data Management (MDM) projects.

Responsible for validating billing metering data collected for the cloud-based service offerings.

Analyzed data to validate data accuracy from AMI meters in a timely manner.

Created logical and physical data models using Model Mart of ERWIN for effective model management and produced Entity Relationship Diagrams to document designs.

Constructed DDL scripts in T-SQL and SAP HANA to deploy database changes to the various Dev/Test/QA/Prod environments.

Managed data structures, data ingestion into the databases, and performance management and database tuning.

Designed VLDB (Very large databases) using design methodologies like STAR Schema, Snowflake Schema.

Helped partners develop their Data Platform and Analytics practices on SQL and AWS EC2, including delivering offers to the market based on professional services, managed services and/or IP.

Analyzed existing data models, processes, and architecture to make recommendations for improvement.

Implemented big data systems in cloud environments and created security and Encryption Systems for big data.

Designed and developed standalone data migration applications to retrieve and populate data from Azure Table / BLOB storage to on premise SQL Server instances.

Implementation experience with Data Lakes, Databricks, Snowflake and Business Intelligence tools in Azure.

Worked collaboratively to plan and deploy new Hadoop environments and expand existing clusters.

Established foundational procedures, guidelines, and standards for Data Modeling, Data Processing, Data Visualization, and Analytics.

Installed, configured, administered, monitored Azure, IAAS and PAAS, Azure AD.

Worked in an Agile software development framework with DevOps tools such as JIRA, SVN, and Bitbucket.

Worked with Data Scientist to provides reliable, secure data transfer from end-point devices back to enterprise applications and databases.

IBM INTERNATIONAL / INFINITE CONSULTANTS Enterprise Data Architect

FEB 2016 – JUN 2018

Worked with Clients and business teams on SQL Database Design and Construction, Database Consolidation, High Availability and Data Quality Assessments.

Worked with internal teams to create the migration process of legacy systems to the AWS cloud.

Developed client-supplied data with internally developed tools used to assess data and build requisite SQL databases.

Designed, migrated applications, accounts, tweaked global AWS infrastructure.

Investigated and resolved SQL escalated situations according to department processes.

Created SSIS packages using best practices from scratch to perform ETL process and load the data into destination tables.

Gained understanding of tools commercial and proprietary tools, such as Power BI, Tableau, Erwin and other applications.

Responsible for identifying root cause of SQL Server data quality issues and complete complex data investigations.

Performed normalization of database to reduce redundancy and achieve maximum system performance.

Worked with cross functional teams to develop mutually beneficial solutions and constantly provide input to clients & management team(s) based on technical experience and industry knowledge.

Acted as Team Lead for the Data Expansion Project, which increased the geographical footprint of the company's product offering by 10%.

Participated in requirements meetings and data mapping sessions to understand business needs.

COCA-COLA COMPANY Lead Data-Platform Architect

MAR 2013 – DEC 2015

Designed a scalable/sustainable data model that will address current and future database needs (flexibility), driving maximum business value.

Strong knowledge of SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, T-SQL, functions, tables, views, triggers, indexes, constraints) of SQL Server versions of 2000, 2005, 2008, 2012, and 2014 Microsoft Azure.

Implemented AlwaysOn availability group with one primary replica/node/server and up to four secondary replicas to have synchronous commit.

Implemented the new SQL Server 2012 and 2014 mechanisms like data compressions, online indexing, Contained Databases, and security principles.

Installed and administered Four-Node cluster Active/Passive on Microsoft Windows Server 2012/2014 Enterprise Edition on SAN environment.

Managed two Database Analysts and mentored, determined workload/tasks.

Managed day-to-day database operations and team for production databases and projects which includes database administration, planning, design, build/delivery, deployment, monitoring, standards, compliance, etc.

Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.

Migrated SSIS packages from SQL Server 2008 R2 to SSDT 2012/2014

Effectively managed DBAs and Data Analysts supporting Microsoft SQL Server environments.

Designing and deploying scalable, available, and fault tolerant systems on AWS-EC2.

Experience with developing and maintaining applications written for Amazon Simple Storage Service, Amazon Simple Notification Service, and AWS_EC2 CloudFormation.

Provides ongoing sizing estimates and supporting recommendations to manage large data volumes.

Optimized the previously existing jobs, stored procedures, and views to improve readability and speed in Teradata.

Provides estimates and support to the Sr. Project Manager and development team.

Provides security design recommendations including servers, data, report, and role-based security.

Created ETL architecture and provided strategy related to data scrubbing, data consolidation, and data quality.

Managed all database upgrades and migration projects across enterprise systems latest versions.

Partnering with the BI Solutions Architect to understand the BI roadmap and provide recommendations of opportunities.

Created several data source/target mappings, TD scripts for the ETL process models to load data.

Implementing HA and disaster recovery (DR) solution to reduce unplanned downtime.

Builds, leads, supports, maintains, and develops the architecture and development team.

Participated in the migration plan for ongoing data warehouse development by evaluating SQL Server 2008/2012.

PRATT INDUSTRIES INC Lead SQL Database Administrator

OCT 2012 – MARCH 2013

Responsible for the administration of development and production servers running SQL Server 2008R2 and MySQL databases, including creation of indexes, tables, stored procedures, security policies.

Ensured SQL Server replication and mirrored databases were operating as planned within AWS EC2 Cloud environments.

Identifying appropriate use of AWS architectural best practices and selecting the appropriate AWS service based on data compute, database, and security requirements.

Creating stored procedures and functions which enable cutting process time down and fine-tuning ad-hoc processes of hours down to minutes by scripting SQL code to eliminate manual work.

Configured and maintained MSSQL 2008/2008R2/2012 database servers for maximum resources usage.

Ran Profiler to support application and database developers to improve the database applications.

Developed reports based on well-defined requirements using complex stored procedures and packages to derive the data extracted for analysis within data warehouse.

Responsible for assisting application development team to streamline and optimize queries to adhere to best practices and deliver better performance.

Responsible for routine maintenance such as backups, recoveries, patches, upgrades, and performance monitoring.

HOME DEPOT SQL Database Administrator

JAN 2012 – OCT 2012

Managed on-going integration of data from native systems into SQL Server 2008 data warehouse and ensuring existing warehouse data supports evolving needs.

Developing ETL scripts and internal data feeds to warehouse using SQL Server 2008, Microsoft Access, and Excel.

Developing, maintaining, and auditing native scripts and macros in native systems to support ongoing data extracts and system validations.

Responsible for implementation and release of database changes as submitted by the development team.

Ensuring quality assurance of data and structure including hygiene/data integrity related activities, periodic data and process audits, and ongoing database statistics.

Managing proper encryption of external data feeds, layouts, and working with outside vendors.

Responsible for database Backup strategies with best recovery models in case of disaster.

Installed and configured SharePoint (Foundations 2010) to integrate with SQL Server 2008 Reporting Services.

Developing and maintaining ETL scripts for efficiently loading and extracting data from the production environment to test environment, when necessary, with the use of SSIS and Log Shipping.

Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability by working as part of the team to provide 7x24 support when required.

ACS TRANSPORT SOLUTION SQL Database Administrator

MAR 2010 – DEC 2011

Responsible for the deployment and migration of SQL Server 2000 and 2005 to 2008R2 with the use of DTS, SSIS, BCP.

Rewrote and tuned poorly written SQL queries with unnecessarily complicated joins, too much normalization, excess usage of cursors and temporary tables for better performance with the use of OLTP tool (DTA, SQL Monitor, Red gate Tools) to write smaller normalized tables and minimum number of required indexes.

Configured Peer-Peer Replication for OLTP databases to OLAP warehouses to help provide real-time reports.

Responsible for troubleshooting performance, disaster recovery in the event of a site outage, or network issue.

Performing backups of all SQL servers 2000/2005/2008 daily and weekly using native Microsoft tools, Quest Lite Speed, and Symantec Backup Exec 2010 for Windows to provide integrated deduplication, restore features, disaster recovery, and backup protection for Microsoft Exchange, SharePoint Services, SQL and Windows workstations.

Periodically performing database reorganization and rebuilding on all the indexes on all the tables in all SQL Server databases.

Administering and managing SQL Server clustered environments to reduce downtime in failover situations and to boost high availability solutions.

Implemented and configured Log shipping to provide high-latency redundant storage between the active server database logs and restored standby server.

Developing and maintaining ETL scripts for efficiently loading and extracting data from the database when necessary.

PEER 1 HOSTING INC. Database Administrator

JAN 2008 – FEB 2010.

Migrated Oracle, PostgreSQL, and MySQL databases to SQL Server 2005/2008 using SSIS, DTS, EMS Studio Manager, SQL Loader, and Data Pump.

Responsible for assigning users to databases and determining the proper security level for each user. Also responsible within each database, assigning permissions to the various database objects such as tables, views, and stored procedures.

Participated in the data warehousing of major deployment and migration projects.

Coordinated physical changes and performance monitoring of two replicated production servers, one development server and one reporting server, all Microsoft SQL Server 2005/2008.

Used SAN solutions to provide fail-safe disaster recovery processes, reliable storage, server building blocks and automated management via policy-based solutions.

Helped developers with fine-tuning queries, assigned proper indexes, and aided developers in the creation of triggers and stored procedures.

Rewrote and fine-tuned long running SQL queries to cut execution time, ease database load and improve scalability.

Implemented and configured Database Mirroring to duplicate mission-critical databases across servers in a high safety synchronous operating mode.

Established naming conventions and standards for the SQL Server and databases and made sure that everyone stuck to them.

EDUCATION

Lagos State University, Lagos State, Nigeria – Applied Chemistry (B.SC)

Chicago State University Chicago, IL – Computer Science

CERTIFICATIONS

MS Certified Azure Database Administrator

AWS Certified Solutions Architect-Associate-C02

MCITP: SQL 2008 Database Administration

OCP: Oracle 10g/11g Certified Professional

Professional Association for SQL Server (PASS)

Contact this candidate