Experience

Audible Magic

• United States
• Information Services
• 1 - 100 Employee

• Sr. Software Engineer

  • Jan 2021 - Present



MediaNet

• United States
• Musicians
• 1 - 100 Employee

• Senior Oracle Database Engineer

  • May 2015 - Jan 2021



Bank of America

• United States
• Banking
• 700 & Above Employee

• Database Architecture and Development

  • Sep 2006 - Feb 2015

  • 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.



Fiserv ISS

• Financial Services
• 100 - 200 Employee

• Application Manager

  • 2003 - 2006

  • 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.



Soluxions, inc.

• Consultant

  • 1998 - 2003

  • 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. • 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.