Raymond I Aigbogun

Midland, TX

413-***-****)

ad40eo@r.postjobfree.com

Technical Skills

Database Platforms: Microsoft SQL Server 2008, 2012, 2014, 2016, 2019, MySQL, PostgreSQL, Azure SQL

Database Management: Installation, Configuration, Upgrades, Migrations, Performance Tuning, Patching

Database Security: Availability, Backup, Restore Solutions, Clustering Concepts, Process Automation

Monitoring Tools: Query Store, Import/Export Wizard, SQL Profiler, Extended Events, Red-Gate, SolarWinds SQL Sentry (DPA)

SQL Server Components: SQL Database Engine, Integration Services (SSIS), Reporting Services (SSRS)

Replication Models: Snapshot, Transactional, Merge

Performance Tuning: Index Management, Integrity Checks, Database Clustering.

High-availability and Disaster Recovery: SQL Server, Dynamic Data Masking, Encryption

ETL Tools: Database Development, Data Warehousing, System Architecture, Query

Optimization

Data Security: HIPAA Data Privacy Laws and Practices

Azure data factory: Data Integration, Data orchestration, connectivity, Data transformation, Data monitoring and management

EDUCATION/ TRAINING AND CERTIFICATES

Microsoft Azure Fundamentals (AZ-900)

Associate of Science, Renewable energy

Delaware Tech.

Bachelor of Science, Electrical/Electronic Engineering

University of Benin, Benin City, Nigeria

PROFESSIONAL EXPERIENCE

Kraft Heinz Dover, Delaware

Database Engineer July 2020- Present

Manage and maintain multiple databases, ensuring high availability, security, and performance.

Plan and execute SQL Server installations, configurations, upgrades, and migrations across various environments.

Conduct performance tuning to optimize database and query performance, enhancing overall system efficiency.

Implement backup and restore strategies, clustering concepts, and process automation for seamless operations.

Utilize monitoring tools like Query Store, SQL Profiler, and Extended Events to ensure environment health and resource management.

Administer replication models, manage index structures, perform integrity checks, and troubleshoot database clustering implementations.

Implement high-availability and disaster recovery options for SQL Server, ensuring mission-critical data remains secure.

Led migrating on-premises data integration processes to Azure Data Factory, improving scalability, reliability, and cost-efficiency.

Developed and maintained data integration workflows using Azure Data Factory's graphical interface and ARM templates, ensuring adherence to best practices and architectural standards.

Implemented monitoring and alerting mechanisms to proactively monitor data pipeline execution, track data lineage, and troubleshoot errors and failures in real-time.

Collaborated with data architects and business stakeholders to define data integration requirements, design scalable data architectures, and implement data governance policies.

Designed and implemented end-to-end data integration solutions using Azure Data Factory to ingest, transform, and load data from various sources into Azure SQL Database and Azure Synapse Analytics.

Orchestrated complex data workflows and pipelines to automate data processing tasks and streamline data movement between on-premises systems and cloud-based data stores.

Implemented data transformation activities using Azure Data Factory's mapping data flows and executed stored procedures to perform complex data transformations and calculations.

Integrated Azure Data Factory with Azure Data Lake Storage Gen2 and Azure Blob Storage to store and process large volumes of semi-structured and unstructured data for analytics and reporting purposes.

Collaborated with cross-functional teams to gather requirements, design data models, and develop data pipelines that meet business needs and ensure data quality and integrity.

Conducted performance tuning and optimization of data pipelines to improve throughput, reduce latency, and optimize resource utilization.

SLB

Database Administrator Dec 2017 – June 2020

Performed thorough database troubleshooting to resolve diverse client issues, encompassing connectivity, performance monitoring, maintenance, query tuning, and performance optimization.

Collaborated closely with application/system administrators and third-party vendors, ensuring seamless coordination of activities and swift resolution of development and maintenance challenges.

Successfully executed migration projects, upgrading SQL Server 2012/2014/2016 from legacy SQL Server 2008/2005 versions. Additionally, orchestrated on-premises SQL database and resource migration to Microsoft Azure Cloud Services.

Expertly installed, upgraded, and configured SQL Server 2012 with the latest service packs, meticulously managing test and production environments.

Provided comprehensive support throughout all stages of database implementation and database-related deployments, ensuring smooth operations and efficient issue resolution.

Implemented robust SQL Server Security Privileged Access Management procedures and effective database security strategies to enhance security for users and applications.

Leveraged advanced tools such as SQL Server Profiler, Extended Events, Query Store, and Database Engine Tuning Advisor (DTA) for precise performance tuning, optimizing database efficiency and response times.

Conducted meticulous SQL query tuning, diligently optimizing database performance and maintaining indexes for optimal operation.

Implemented a comprehensive database backup plan and disaster recovery procedure, safeguarding critical data against potential loss due to various failure scenarios.

Participated in on-call rotation, ensuring continuous support and availability for database-related emergencies or urgent requests.

Contact this candidate