Akin Alawode

Oracle Database Analyst and Platform Architect with 12+ years of hands-on experience in database administration, DBMS design, production support, ETL processing, data modeling, data migration, data warehousing, and enterprise computing environments. Extensive experience supporting Oracle 19c, PL/SQL, SQL, KornShell and Unix/Linux scripting, data governance, schema analysis, performance tuning, monitoring, capacity planning, and technical documentation. Proven ability to review and document existing database structures and ETL workflows, define requirements with business and technical customers, design approved warehouse and integration changes, mentor application teams, and manage multiple project priorities through implementation and production support.

Experienced in creating reporting and visualization-ready datasets and operational dashboards using Oracle, Snowflake, OEM, AWR/ASH, and SQL-based analytics.

Manager, Oracle / Database Platform Architect - DIGIT KONSULT - Fort Myers, FL

(2024-07)

• Lead Oracle database analysis, DBMS design, cloud migration, data integration, automation, and production-support engagements across Oracle 19c and hybrid computing environments.
• Review current database structures, schemas, PL/SQL components, batch jobs, interfaces, and ETL processes; document the as-is environment, identify control or performance gaps, and recommend prioritized improvements.
• Work with customers, application teams, security, infrastructure, and business stakeholders to define data, ETL, reporting, migration, and warehouse requirements and translate them into technical designs and implementation plans.
• Design and implement approved changes to database schemas, data-movement workflows, validation controls, indexing, partitioning, storage, and operational procedures.
• Develop and support SQL, PL/SQL, KornShell, and Linux automation for data extraction, transformation, loading, reconciliation, deployment, monitoring, and database maintenance activities.
• Apply data-governance principles to metadata, lineage, access, data quality, change control, retention, auditability, and technical documentation.
• Mentor application and support staff on Oracle SQL/PL/SQL, ETL troubleshooting, data-warehouse techniques, performance diagnostics, deployment standards, and production-readiness practices.
• Manage day-to-day project activities, risks, priorities, deliverables, vendor coordination, and stakeholder communication to ensure milestones and deadlines are met.
• Perform Oracle 19c monitoring, SQL and database performance tuning, workload analysis, storage forecasting, and capacity planning using OEM, AWR/ASH, execution plans, and system metrics.
• Prepare technical procedures, architecture documents, data-flow diagrams, support runbooks, implementation plans, rollback plans, and knowledge-transfer materials.

Lead Oracle / Platform Architect - Chico's FAS Inc. - Fort Myers, FL

(2012-10 - 2024-07)

• Architected, administered, and supported enterprise Oracle databases, schemas, ETL interfaces, and data platforms for retail, e-commerce, inventory, order-management, fulfillment, and analytics workloads.
• Provided more than 8 years of hands-on ETL, data-modeling, data-migration, and data-warehouse support, including source-system analysis, source-to-target mapping, staging design, data transformation, reconciliation, and production validation.
• Administered Oracle 19c and earlier releases in RAC and Data Guard environments; managed CDB/PDB databases, ASM storage, backups, recovery, patching, security, availability, and lifecycle operations.
• Reviewed legacy schemas, stored procedures, PL/SQL packages, batch dependencies, KornShell scripts, file feeds, and ETL schedules to document current-state processing and identify modernization and optimization opportunities.
• Partnered with application owners and business customers to define new warehouse, reporting, interface, and data-integration requirements; converted approved requirements into schema, ETL, migration, and deployment designs.
• Designed and supported Oracle and Snowflake databases and schemas, including three years of Snowflake data-platform work and Oracle-to-Snowflake migration support for analytics-ready workloads.
• Built and maintained SQL, PL/SQL, KornShell/Shell, Python, and PowerShell utilities for ETL execution, environment refreshes, data validation, deployment, monitoring, backup, and operational support.
• Produced logical and physical data models, mapping documents, data dictionaries, lineage information, dependency inventories, technical procedures, troubleshooting guides, and production-support runbooks.
• Implemented data-governance and security practices including role-based access, TDE, auditing, data redaction, controlled change management, data-quality validation, and recoverability standards.
• Created operational reports and visualization-ready datasets for application, infrastructure, and leadership teams; used OEM, AWR/ASH, SQL analytics, trend reports, and KPI summaries to communicate performance and capacity findings.
• Performed routine and complex database tuning using execution plans, indexing, statistics, partitioning, SQL rewrites, optimizer analysis, memory/I/O review, and workload diagnostics; improved critical system performance by 35%.
• Conducted storage and workload capacity planning, forecasted growth, resolved production bottlenecks, coordinated releases, and led incident analysis and corrective-action implementation.
• Mentored DBAs, developers, and application-support personnel on SQL/PLSQL, ETL support, warehouse design, Oracle operations, data migration, performance tuning, and recovery procedures.
• Led database migrations, large environment refreshes, cloud/hybrid modernization, and cutovers with dependency analysis, testing, rollback planning, stakeholder communication, and post-implementation validation.

Senior Oracle Database Architect - Securus Technologies / STOP - Houston, TX

(2011-12 - 2012-09)

• Administered Oracle and MySQL databases supporting high-volume GPS monitoring, transactional processing, reporting, and public-safety applications in a 24x7 environment.
• Analyzed database schemas, ingestion workflows, PL/SQL code, SQL performance, batch processing, and reporting dependencies; documented findings and implemented tuning and reliability improvements.
• Configured Active Data Guard for reporting continuity and supported ETL/reporting workloads while isolating production transactional demand.
• Developed SQL, PL/SQL, and Unix/KornShell automation for database operations, VLDB backup/recovery, deployment, monitoring, data movement, and validation.
• Performed capacity analysis, performance tuning, incident resolution, and technical knowledge transfer for application and operations teams.

Lead Database Architect - Bank of America, Mortgage Division - Charlotte, NC

(2009-01 - 2011-12)

• Led and mentored a 20-member onshore/offshore DBA team supporting regulated, mission-critical Oracle database and data-processing environments.
• Managed Oracle RAC, Data Guard, GoldenGate, RMAN, patching, migrations, production support, performance tuning, monitoring, capacity planning, and recovery operations.
• Supported data-center migrations and database/data movement activities, including dependency analysis, migration planning, validation, reconciliation, rollback planning, and stakeholder reporting.
• Automated replication, backup, refresh, monitoring, and support processes with SQL, PL/SQL, KornShell, and Unix scripting.
• Authored operating procedures, implementation plans, support documentation, audit evidence, and knowledge-transfer materials.