• Performance enhancement of existing Oracle 19c PL/SQL solutions in support of high-volume energy pricing.

• Agile Scrum team member supporting PL/SQL based APIs for web services and end user applications.• Implemented PL/SQL to support ETL of high-volume transactional databases into star schema dimensional model data warehouse.• Architected PL/SQL solution for music content royalty payments based on millions of streams/downloads and complex publisher and label deal contracts.• Piloted AWS RDS Oracle solution loading SQS queued Apache Parquet files via Lambda Python function.• Created periodic aggregate and detailed reporting for both internal and external stakeholders implemented via Oracle PL/SQL file I/0 and Microsoft SSRS.

• Architected high TPS and large data volume Oracle RAC database utilizing partitioning to stage data for movement to enterprise data warehouse. Implemented advanced indexing and PL/SQL to achieve service level requirements.• Created reusable nonpublic personal information encryption PL/SQL package implemented in various databases. Documented interfaces and implementation for use throughout the organization.• Extensive query tuning of Hibernate J2EE service-based queries. Used Oracle Enterprise Manager to monitor volume testing and identify high resource queries and work with J2EE team to optimize SQL or replace with PL/SQL solution.• Performed development Oracle database administration support. Task included storage management, SGA tuning, instance monitoring, and cloning of development databases.• Prototyped Oracle Stream (GoldenGate) replication process replicating multiple databases to one operational data store. Prototype technologies included Oracle Advance Queues, LogMiner, Oracle Data pump, and Oracle log archiving.

• Oracle database development team manager supervising a team of ten developers and report writers. Responsibilities included database programming for .Net and Java application developers, schema/table maintenance, package/procedure development, and Korn/C shell scripting and job automation. • Performed technical lead role for large financial data integration project. Responsibilities included coordination with offshore development, testing, and system configuration personnel. Project tasks included employing the Pervasive Cosmos ETL tool to migrate financial trading system data into Itanium Redhat LINUX Oracle 9i RAC system.• Designed and coded MS SQL Server to Oracle 9i data replication process via the Oracle Transparent Gateway. The record reservation procedure guarantees exclusive record access allowing simultaneous processing.• Designed and coded Oracle packages and procedure to calculate financial account real time balances based on historical positions and pending transactions. Implemented Oracle PL/SQL tables to increase performance over standard queries and materialized views by decreasing large table scans.

• Administered Oracle databases on Windows NT platform for remote clients. Duties included backup, recovery, security, SGA and query tuning, database schema design and sizing. Utilized Oracle Trace, TKPROF, and Explain Plan for tuning of existing Oracle application• Provided MS SQL Server DBA services to remote clients. Responsible for development, backup, recovery, and data archiving strategies.