Anthony Harper, Oracle Database Architect and PL/SQL Developer in Salt Lake City, United States
Anthony Harper

Oracle Database Architect and PL/SQL Developer in Salt Lake City, United States

Member since July 3, 2022
Anthony is a database designer and developer with 10+ years of experience in large Oracle PL/SQL implementations. He is proficient in Oracle database architecture, using PL/SQL programs to support application clients, ETL processes, and web services. Anthony is skilled in developing and optimizing tables, indexes, packages, triggers, views, procedures, and functions to keep business logic in the database. He is committed to mastering new functionality in the field to deliver the best solutions.
Anthony is now available for hire

Portfolio

  • Club 21
    Oracle SQL, Oracle PL/SQL, Oracle Cloud, ETL, Database Design...
  • Pearson
    Oracle Application Express (APEX), Oracle PL/SQL, Oracle SQL...
  • Comcast
    Oracle SQL, Oracle PL/SQL, Database Design, Documentation, OLTP...

Experience

  • Databases 15 years
  • Relational Database Design 10 years
  • Oracle PL/SQL Packages 10 years
  • SQL Views 10 years
  • Oracle Database 10 years
  • Oracle PL/SQL 10 years
  • Oracle SQL 10 years
  • Oracle Database Rollout Scripting 7 years

Location

Salt Lake City, United States

Availability

Part-time

Preferred Environment

Oracle Database, Oracle SQL Developer, Oracle PL/SQL, Oracle SQL, SQL, Databases, Oracle PL/SQL Packages

The most amazing...

...solution I've designed is to recreate the PL/SQL XML API and reflect table changes using XML for all database application interactions and code generators.

Employment

  • Oracle Consultant

    2022 - PRESENT
    Club 21
    • Developed a data warehouse for sales, advertising, and inventory data, while designing used external tables for data loading.
    • Deployed the data warehouse to the Oracle Cloud environment.
    • Prototyped an Oracle APEX reporting application to view data warehouse information.
    Technologies: Oracle SQL, Oracle PL/SQL, Oracle Cloud, ETL, Database Design, Data Warehouse Design, Analytic SQL, Relational Database Design, ETL Development, Oracle PL/SQL Packages, Oracle Application Express (APEX), SQL Views, SQL Stored Procedures, Data Modeling, HTML, Databases, Oracle Database, SQL, Database Schema Design, Data Warehousing, Data Analysis, Data Architecture
  • Oracle APEX Developer

    2009 - 2010
    Pearson
    • Developed APEX application to support online education content authoring while creating APEX pages with forms and reports for the system.
    • Managed rollouts between development, test, and production for Oracle codebase and APEX application.
    • Implemented PL/SQL packages to generate XML-based Excel spreadsheets for users to download, including custom XML formatting to create Excel output.
    • Assisted quality assurance staff with unit and coverage review tests.
    • Estimated project effort for new feature requests and system enhancements while creating proof of concept examples to assist with evaluating complex requirements.
    Technologies: Oracle Application Express (APEX), Oracle PL/SQL, Oracle SQL, PL/SQL Developer, Microsoft Excel, XML, JavaScript, Database Design, OLTP, Oracle PL/SQL Packages, SQL Views, SQL Stored Procedures, HTML, Databases, Oracle Database, SQL, Database Schema Design, Data Analysis
  • Database Architecture Consultant

    2008 - 2009
    Comcast
    • Adapted Oracle database table, complex view design, and performance for the video-on-demand system while integrating various enterprise data components into the design.
    • Researched and implemented advanced Oracle time zone conversion. features for geographically based menu items availability while deploying the database system nationally on a distributed server environment.
    • Implemented a benchmarking system to evaluate system performance through design iterations.
    • Exposed functionality to Java application clients using PL/SQL packages with stored procedures while assisting Java developers with unit testing.
    • Used Oracle object types to streamline complex views while integrating sys_context to create parameterized views for performance tuning.
    • Composed system documentation for database architecture.
    Technologies: Oracle SQL, Oracle PL/SQL, Database Design, Documentation, OLTP, Oracle Performance Tuning, Database Instrumentation, PL/SQL Developer, Oracle Database Rollout Scripting, Relational Database Design, SQL Views, Data Modeling, Databases, Oracle Database, SQL, Database Schema Design, Data Analysis, Data Architecture
  • Oracle Database Architect | Team Lead

    2004 - 2008
    Siemens Energy
    • Designed a powerplant inventory system with PL/SQL-based XML interface to expose all database functions as web services.
    • Completed PL/SQL API code generation to recreate the system while reflecting new tables, changing, and adding columns in schema tables.
    • Implemented parallel ETL processing using Oracle Advanced Queuing to optimize data transformation pipelines.
    • Integrated various data silos in the enterprise data landscape and worked directly with the architecture team to ensure new systems conformed to data standards. Diagrammed enterprise data structures in ERD design tools and PL/SQL Developer.
    • Scripted deployments to move Oracle codebase between development, test, QA, and production systems. Assisted Database Administration (DBA) staff in diagnosing and solving performance issues.
    • Supported .NET, Java, and web service applications with database functionality using PL/SQL, including engineering data warehouse, customer portal, document management, and powerplant inventory systems.
    • Implemented complete database instrumentation with error logging and trigger-based row-level change auditing.
    • Addressed all project planning and design aspects with end-users, project managers, and developers.
    • Performed technical interviews and screenings for Oracle developer candidates, assisted project managers with performance evaluations of team members, and mentored team members in Oracle technologies.
    • Conducted code reviews to discover potential performance bottlenecks and refactor PL/SQL code for effective maintainability and reuse.
    Technologies: Data Modeling, Oracle PL/SQL, Parallel Processing, Advanced Queuing, ETL Development, Database Migration, Analytic SQL, Database Instrumentation, Enterprise Data Landscape Integration, Team Mentoring, PL/SQL Code Generation, Data Structure Mapping, Oracle Performance Tuning, XML, Data Warehouse Design, OLTP, Oracle SQL, SQL, Oracle Database, Databases, SQL Stored Procedures, Database Triggers, SQL Views, Oracle PL/SQL Packages, Relational Database Design, Oracle Database Rollout Scripting, Oracle Database Triggers, Database Migration Scripting, PL/SQL Developer, Database Design, ETL, Writing & Editing, Documentation, Database Schema Design, Data Warehousing, Data Analysis, Data Architecture
  • Visual Basic | Oracle Developer

    2001 - 2004
    Bellsouth Communications Systems
    • Migrated Visual Basic 6 application to Visual Basic .NET framework and created wrappers for ADO data access to standardize and simplify stored procedure calls.
    • Created custom PL/SQL-based XML parser to optimize large data transactions performance with Visual Basic application and designed compression algorithm for XML messages.
    • Prototyped Oracle PL/SQL pricing engine to replace existing Forte pricing engine, demonstrating significant performance improvements.
    • Implemented an error logging system using autonomous transactions to assist support staff in working proactively with end-users problems.
    • Developed PL/SQL API for database interactions with Visual Basic sales quotes application while creating scripts to port database code between development, test, QA, and production systems.
    • Helped completely rewrite the Visual Basic 6 sales quotes application while developing PL/SQL API for all database interactions with the client application. Used stored procedures for DML operations and ref cursors to return data to the application.
    • Contributed to project design meetings for new features and wrote system functionality documentation.
    Technologies: Oracle SQL, Oracle PL/SQL, PL/SQL Developer, Visual Basic 6 (VB6), Visual Basic .NET (VB.NET), XML, SQL, Oracle Database, Databases, Data Modeling, SQL Stored Procedures, Database Triggers, SQL Views, Oracle PL/SQL Packages, ETL Development, Relational Database Design, Oracle Database Rollout Scripting, Oracle Database Triggers, Database Migration Scripting, Database Migration, Database Instrumentation, Team Mentoring, Oracle Performance Tuning, OLTP, Database Design, Writing & Editing, Documentation, Database Schema Design, Data Analysis, Data Architecture
  • Client Server Developer

    1999 - 2001
    ABC Distributing
    • Developed Visual Basic applications and databases for warehouse management, domestic shipping, and internet sales support.
    • Designed Oracle database to support collections department activity, including views and PL/SQL packages, while training end-users in writing Crystal Reports.
    • Implemented Oracle database with PL/SQL API to manage international shipping while working with project managers to clarify business requirements.
    • Supported existing Visual Basic 6 applications for the client-server department while fixing bugs and implementing new feature requests.
    • Revised barcode label printing application for RMA warehouse to optimize performance, saving thousands of labor hours annually by the management assessment.
    • Attended Oracle Corporation's advanced classes in PL/SQL.
    Technologies: Visual Basic 6 (VB6), Microsoft SQL Server, Oracle8i, Crystal Reports, Oracle PL/SQL, Database Design, OLTP, Oracle Database Triggers, Oracle Database Rollout Scripting, Relational Database Design, Oracle PL/SQL Packages, SQL Views, Database Triggers, SQL Stored Procedures, Data Modeling, Databases, Oracle Database, SQL, Oracle SQL, Database Schema Design, Data Analysis

Experience

  • Oracle Database Instrumentation and Logging System

    Developed a PL/SQL-based utility to add instrumentation to a database layer using autonomous transactions for error logging, process flow tracing, program access auditing, and process timing.

    The utility was implemented using Oracle object types to expose packaged methods. A simple object suitable for any PL/SQL package was used to support all logging, tracing, auditing, and timing methods without duplicating code or requiring recompilation to enable or disable logging features.

    Developers could freely add logging calls throughout the code to all exception handlers, with detailed instrumentation available to diagnose potential problems. The instrumentation could be easily turned off when the system ran as expected. The code allowed fine-grained control by initializing enabled logging methods on a package level via an environment table.

    Developing utilities over seven years of actual use in enterprise environments benefited technical support staff greatly by allowing them to monitor application problems before end users called in.

    The system was presented at the International Oracle Development Tools User Group seminar in 2007 and is still highly relevant today.

  • Quiz Author at Oracle Development Gym
    http://devgym.oracle.com

    The Oracle Development Gym's quiz competitions are a way for the developer community to test their knowledge of Oracle Database and get exposed to new features in the database and PL/SQL language. Thousands of developers interact with the Development Gym, and a steady group takes new quizzes regularly.

    After taking thousands of quizzes available at the Gym, I began to submit my own quizzes and was immediately asked to join the core team of dedicated quiz authors. I write quizzes in database design, SQL, and PL/SQL, and my quizzes are scheduled to appear in competitions every three weeks. My quizzes have been well received by the community, and the results have demonstrated that many of the areas I consider to be at the beginner level are actually advanced areas of expertise.

    Participating in this project as a regular quiz author allows me to contribute directly to the developer community. More than just testing knowledge of how Oracle works and new features, this project challenges me to illustrate the best practices for development in PL/SQL and Oracle SQL.

Skills

  • Languages

    SQL, HTML, XML
  • Paradigms

    Database Design, ETL
  • Storage

    Oracle SQL, Oracle PL/SQL, SQL Stored Procedures, Database Triggers, SQL Views, OLTP, Databases, PL/SQL Developer, Database Migration, Oracle SQL Developer, Oracle Cloud
  • Other

    Oracle PL/SQL Packages, Relational Database Design, Oracle Database Rollout Scripting, Oracle Database Triggers, Database Migration Scripting, Database Schema Design, Data Analysis, Data Architecture, Data Modeling, ETL Development, Parallel Processing, Advanced Queuing, Analytic SQL, Database Instrumentation, Enterprise Data Landscape Integration, Team Mentoring, PL/SQL Code Generation, Data Structure Mapping, Documentation, Public Speaking, Research, Writing & Editing, Oracle Object Types, Data Warehousing, Oracle Performance Tuning, Data Warehouse Design, University Teaching
  • Platforms

    Oracle Database
  • Tools

    Oracle Application Express (APEX), Crystal Reports

Education

  • Graduate Coursework in Philosophy
    1990 - 1992
    University of Oregon - Eugene, Oregon, USA
  • Bachelor's Degree in Philosophy
    1984 - 1990
    Willamette University - Salem, Oregon, USA

To view more profiles

Join Toptal
Share it with others