Overview
Technical skills
Timeline
Administered and optimized Oracle databases in enterprise production environments to ensure high availability, reliability, security, and data integrity. Automated database operations such as monitoring and backup/recovery using SQL, PL/SQL, and Bash scripts. Supported database migrations and upgrades with an emphasis on minimizing downtime and resolving complex SQL and performance issues with development teams.
Designed and delivered end-to-end database migration processes from MySQL to Oracle 11g. Built automated extraction, transformation, validation, reconciliation, and integrity-checking workflows using SQL, PL/SQL, SQL*Loader, Data Pump, and scripting. Coordinated with cross-functional teams on mapping, testing, and troubleshooting to achieve accurate and reliable migration outcomes.
Designed relational data models and enterprise data warehouse solutions using Oracle tooling to support analytics and reporting needs. Developed and maintained ETL workflows using Oracle Warehouse Builder for transforming data feeding MicroStrategy reporting. Administered Oracle and SQL Server databases and supported development-to-production database changes and migrations.
