Sql Server Database Administrator

AFOLABI KEMBI

**** ***** **** *****, #**** Stone Mountain, GA. 30058

********@*******.*** 773-***-****.

SUMMARY

Database Administrator with over 17 years of experience in database administration and development. Proven expertise in cloud data migration, database consolidation, data transformation, and streaming. Skilled in designing innovative business solutions for large and complex MS SQL Server, Oracle, PostgreSQL, DB2, MySQL, Microsoft Azure, AWS, Teradata, JavaScript, Python, Snowflake, and SAP HANA.

TECHNICAL SKILLS

Proficient in implementing project methodologies effectively.

Extensive experience utilizing cloud technologies, particularly Azure and AWS, coupled with mastery in Azure DevOps, Terraform, and GitHub Pipelines.

Skilled in optimizing performance, designing architectures for large data volumes, and ensuring efficient database performance.

Comprehensive understanding of Azure/AWS cloud computing, encompassing information management, application development, and virtualization.

Hands-on proficiency with Azure Data Factory, Snowflake, Azure Synapse, Azure Database Hyperscale, Azure Data Lake, Azure Cosmos DB, Amazon Redshift, and Azure Databricks.

Expertise in managing both relational and non-relational databases, adept at implementing data integration and transformation strategies.

Experience with database replication technologies such as transactional replication, merge replication, and peer-to-peer replication.

Familiarity with Amazon EC2, Babelfish for Aurora PostgreSQL, S3 bucket management, and instance backups.

Demonstrated success in developing scalable enterprise solutions leveraging Azure & AWS services.

Proficient in Python, PowerShell, and TSQL scripting for data manipulation and automation tasks.

In-depth knowledge of SQL Server versions 2005 through 2022 and Azure SQL instances, including data compression, online indexing, contained databases, and security protocols like MSSQL Server AAG.

Experienced in Agile methodology environments, ensuring adaptability and efficiency in project execution.

Capable of integrating SharePoint with SQL Server Reporting Services and Power BI for comprehensive reporting solutions.

Skilled in database modeling utilizing tools such as Erwin, ensuring efficient database structures.

Proven ability to develop automated solutions for streamlining Data Governance processes.

Familiarity with Apache Pig and related technologies for Big Data platforms, enabling effective handling of large datasets.

PROFESSIONAL EXPERIENCE

Humana (DEC 2021 – Present)

Database Architect

Conduct thorough evaluations of cloud systems, offering expert insights and delivering technical solutions tailored to the organization's needs.

Develop detailed blueprints for data repositories and integrated systems, ensuring a strategic and cohesive approach to data management.

Implement a robust Data Governance framework, establishing guidelines and protocols for effective data management and compliance.

Design and meticulously maintain schematics, layouts, and architectures for data warehouses, optimizing data storage and retrieval processes.

Successfully migrated 40+ On-Prem SQL Server databases to Azure database for PostgreSQL, Azure SQL DB, Azure Hyperscale DB, Azure Databricks, Azure Synapse, & Snowflake, facilitating a seamless transition to cloud-based solutions.

Conducted capacity planning assessments to determine resource requirements and scalability options for Azure SQL Database deployments.

Utilize Terraform to deploy Azure Databricks, implementing efficient ETL logic for streamlined data processing.

Skillfully ingest data into Azure services using Azure Databricks, ensuring optimal efficiency and data integration.

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

Led the migration of on-premises SQL Server databases to Azure SQL Database while implementing Azure SQL Database features like elastic pools, geo-replication, and automated backups to optimize performance, availability, and disaster recovery.

Implement DR setup – MSSQL Server Replication, Mirroring, & MSSQL Server AlwaysOn AG with FCI.

Evaluate the reusability of healthcare data and conduct thorough data sheering to enhance data quality and efficiency.

Review and optimize object and data models, enhancing overall data management and system performance.

Demonstrate the ability to make decisions on complex technical issues independently, showcasing a high level of technical expertise and problem-solving capability.

Gwinnett County Government (OCT 2019 – DEC 2021)

Database Architect

Collaborate with development teams to design and optimize database schemas, stored procedures, and queries.

Orchestrated seamless migrations of databases and applications onto Azure platforms, ensuring a smooth transition to cloud-based solutions.

Architected and fine-tuned the global infrastructure on both Azure and AWS, optimizing performance and scalability.

Conducted comprehensive assessments of existing infrastructure, offering strategic recommendations for enhancement and efficiency.

Installed, configured, and executed the migration of SQL Server Instances for both On-Premises and Azure Services, ensuring consistent and reliable performance across environments.

Designed and implemented ETL pipelines using Python for Azure Data Warehouse, streamlining data processing and integration workflows.

Established robust data classification and security standards to safeguard sensitive information and ensure compliance.

Enhanced data security posture by implementing encryption and masking techniques, ensuring compliance with GDPR and industry-specific regulations to enhance data protection and privacy measures.

Implemented proactive monitoring for critical SQL Server installations utilizing tools such as Spotlight and CloudWatch, ensuring optimal performance and identifying potential issues.

Collaborated with partners to develop robust Data Platform and Analytics practices, providing valuable insights and expertise.

Engineered Disaster Recovery (DR) setups, replication, mirroring, and AlwaysOn Availability configurations, enhancing data availability and resilience.

Collaborated with cross-functional teams to design and implement database schemas, stored procedures, and SQL scripts to support application development efforts.

DUKE ENERGY (AUG 2018 – AUG 2019)

Database Architect

Collaborated closely with business stakeholders and the software development team in gathering requirements and building efficient data models.

Participated in Agile development for ongoing projects and aligned with evolving business needs.

Documented business requirements for Meter Data Management (MDM) projects.

Validated billing metering data for cloud-based service offerings, ensuring precision and reliability.

Conducted thorough data analysis from Advanced Metering Infrastructure (AMI) meters to verify accuracy.

Created logical and physical data models using ERWIN's Model Mart, demonstrating proficiency in data modeling tools.

Constructed DDL scripts in T-SQL and SAP HANA for database changes across various environments, ensuring consistency and efficiency.

Managed data structures, oversaw data ingestion processes, and conducted performance tuning to optimize database functionality.

Designed Very Large Databases (VLDB) using STAR Schema and Snowflake Schema methodologies, promoting efficient data storage and retrieval.

Assisted partners in developing Data Platform and Analytics practices on SQL and AWS EC2, contributing valuable insights.

Analyzed existing data models, processes, and architecture for continuous improvement, ensuring adaptability to changing business requirements.

Implemented big data systems in cloud environments and developed robust security and encryption systems.

Demonstrated expertise in Data Lakes, Databricks, Snowflake, and Business Intelligence tools within the Azure ecosystem.

Prepare and present reports on database performance, security, and capacity to management and stakeholders.

Established foundational procedures, guidelines, and standards for Data Modeling, Processing, Visualization, and Analytics, ensuring consistency across projects.

Worked within an Agile software development framework using DevOps tools such as JIRA, SVN, and Bitbucket, promoting efficient collaboration.

IBM INTERNATIONAL (FEB 2016 – JUN 2018)

Data Architect

Collaborated with clients and business teams to oversee SQL Database Design, Construction, Database Consolidation, High Availability, and Data Quality Assessments.

Contributed to internal teams during the migration of legacy systems to the AWS cloud.

Utilized internally developed tools to process client-supplied data, assess data quality, and construct necessary SQL databases.

Designed, migrated applications, and optimized the global AWS infrastructure.

Investigated and resolved escalated SQL situations in accordance with departmental processes.

Developed SSIS packages following best practices for efficient ETL processes.

Identified the root cause of SQL Server data quality issues and conducted intricate data investigations.

Executed database normalization to minimize redundancy and enhance overall system performance.

Led the Data Expansion Project as Team Lead, expanding the company's product offering geographical footprint by 10%.

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

Analyzed and resolved SQL Server data quality issues, identifying root causes, and conducting complex data investigations.

Executed database normalization to minimize redundancy and enhance overall system performance.

Collaborated with cross-functional teams to devise mutually beneficial solutions, consistently offering valuable input to clients and management based on technical expertise and industry insights.

Led the Data Expansion Project as Team Lead, successfully expanding the company's product offering's geographical footprint by 10%.

Engaged in requirements meetings and data mapping sessions to comprehend and address business needs.

COCA COLA COMPANY (MAR 2013 – DEC 2015)

Lead Data-Platform Architect

Formulated a scalable and sustainable data model to cater to current and future database requirements, emphasizing flexibility and driving maximum business value.

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

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

Oversaw day-to-day database operations and led project teams, encompassing tasks such as database administration, planning, design, build/delivery, deployment, monitoring, standards, and compliance.

Successfully migrated SSIS packages from SQL Server 2008 R2 to SSDT 2012/2014.

Designed and deployed scalable, available, and fault-tolerant systems on AWS-EC2.

Developed and maintained applications tailored for Amazon S3, Amazon Simple Notification Service, and AWS_EC2 CloudFormation.

Played a key role in the migration plan for the ongoing data warehouse development, evaluating SQL Server 2008/2012.

Implemented database security measures, including user access controls, encryption, and auditing mechanisms, to protect sensitive data.

Created ETL architecture, devising strategies for data scrubbing, data consolidation, and data quality enhancement.

Oversaw database upgrades and migration projects for the latest versions across enterprise systems.

Collaborated with the BI Solutions Architect to comprehend the BI roadmap and offered recommendations for potential opportunities.

Developed multiple data source/target mappings and TD scripts for ETL process models, ensuring efficient data loading.

Implemented High Availability (HA) and disaster recovery (DR) solutions to minimize unplanned downtime.

Led and supported the architecture and development team, playing a key role in building, maintaining, and developing systems.

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

EDUCATION

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

Chicago State University Chicago, IL – Computer Science (B.SC)

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