Summary
Overview
Work History
Education
Skills
Timeline
Generic

ALVIN NDIKEFOR

Summary

Innovative Database Architect with a solid background in designing, implementing, and maintaining complex database solutions. Possess strong skills in data modeling, system scalability, and ensuring data integrity across diverse platforms. Effective communicator and collaborator who has contributed to enhancing database performance and supporting business objectives through strategic planning and technology integration.

Overview

6
6
years of professional experience

Work History

Cloud Database Engineer

CALSAWS
08.2024 - Current
  • Provisioned, configured, and managed Azure SQL Databases for production and development environments.
  • Implemented geo-replication, failover groups, and automated backups for high availability and disaster recovery.
  • Monitored performance using Azure Monitor, Query Performance Insight, and SQL Analytics.
  • Applied role-based access control (RBAC) and Azure AD authentication for secure access to database resources.
  • Automated database deployment and updates using Azure DevOps pipelines and ARM templates/Bicep.
  • Optimized cost and performance by configuring elastic pools and scaling DTUs/vCores based on workload.
  • Migrated on-premises SQL Server databases to Azure SQL Database using Data Migration Assistant and Azure DMS.

Senior Cloud Database Architect

Lockheed Martin
12.2021 - Current
  • Performed Data visualization using PowerBI, Tableau, Quicksight and OpenSearch
  • Tunned slow running transaction and Data Warehouse reporting SQL queries.
  • Developed reusable terraform & CloudFormation templates to automate the creation of VPCs, EC2 instances, RDS databases, and other AWS resources, reducing provisioning time by 30%.
  • Designed the overall Virtual Cloud VPC environment including instances, subnets, availability zones.
  • Created AWS S3 lifecycle rules to manage the cost of our Cloud storage.
  • Implemented security of AWS accounts using AWS Organizations, Cloud Tower, IAM Users, groups & policies.
  • Configured AWS Kinesis Firehose to deliver real-time streaming data to AWS S3 for further analysis and storage.
  • Secured SQL Server instances through encryption, role-based security, and audit logging.
  • Created and maintained SSIS packages for ETL operations and data transformation.

Cloud Security Application Engineer

Judicial Information System, MD Courts
01.2020 - 12.2021
  • Built ETL pipeline with SQL Server Integration Services (SSIS).
  • Implemented role-based access controls (RBAC) to enforce least privilege principles, minimizing the attack surface and enhancing overall security posture.
  • Implemented Azure account governance with Azure management Groups, Azure Subscriptions, Azure Resource Groups &Azure Landing Zones.
  • Implemented Azure resource security with Azure Resource Locks, Azure tags, Azure Security Center, Azure Advisor, Azure Blueprints & Azure Policy.
  • Migrated on-premises virtual machines to Azure using Azure Migrate & Azure Site Recovery, achieving minimal downtime and cost savings of 30%.
  • Assessed and migrated on-premises databases to Azure SQL Database using Azure Database Migration Service (DMS) & Data Migration Assistant ensuring data consistency and improved performance.
  • Conducted web app assessments and migrated web applications to Azure App Service, optimizing performance and scalability.
  • Design Data warehouse environment using Star & snowflake schemas.
  • Created audit trail for SQL Server activities with IDERA SQL Compliance Manager.
  • Monitored SQL Server and PostgreSQL database performances with IDERA SQL Diagnostic Manager 11.1.0 and SQL Sentry one.
  • Developed and maintained Azure Security Policies and Procedures, providing clear guidance to the team and stakeholders on security best practices and standards.
  • Led the design and implementation of security controls for Azure cloud services, including Virtual Networks, Azure Active Directory, and Azure Storage, reducing the risk of unauthorized access and data breaches.

Education

Master of Science - Data Analytics

University of Maryland, Global Campus

Certification in Business Analytics - Graduate Level

University of Maryland, Global Campus

Bachelor of Arts - International Studies

University of California, Irvine

Skills

  • Azure SQL Databases
  • MS SQL Server
  • Azure VM
  • Azure Network
  • MySQL, Oracle, PostgreSQL
  • Azure Functions
  • AWS RDS
  • PowerShell
  • Terraform
  • Azure ARM
  • (RBAC) and Azure AD Data Modeling
  • Azure Data Factory
  • Data Warehousing
  • NoSQL Solutions
  • Azure Synapse Analytics
  • Amazon Redshift
  • DynamoDB
  • Data Processing
  • Data Analytics
  • Data Pipelines
  • AWS Kinesis Data Stream
  • Kinesis Firehose
  • AWS Lambda
  • AWS Glue
  • AWS Athena
  • AWS Quicksight
  • OpenSearch
  • AWS Account Security
  • AWS Resource Security
  • ETL pipeline development
  • AWS Security Lake Formation

Timeline

Cloud Database Engineer

CALSAWS
08.2024 - Current

Senior Cloud Database Architect

Lockheed Martin
12.2021 - Current

Cloud Security Application Engineer

Judicial Information System, MD Courts
01.2020 - 12.2021

Master of Science - Data Analytics

University of Maryland, Global Campus

Certification in Business Analytics - Graduate Level

University of Maryland, Global Campus

Bachelor of Arts - International Studies

University of California, Irvine

Similar Profiles

CREATE PROFILE
ALVIN NDIKEFOR