Anthony Harper, Developer in Salt Lake City, United States
Anthony is available for hire
Hire Anthony

Anthony Harper

Verified Expert  in Engineering

Oracle Database Architect and PL/SQL Developer

Salt Lake City, United States

Toptal member since July 3, 2022

Bio

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.

Portfolio

Self-employed
Oracle SQL, Oracle Development, Oracle Development, ETL, Database Design...
Pearson
Oracle Application Express (APEX), Oracle Development, Oracle SQL, SQL, XML...
Comcast
Oracle SQL, Oracle Development, Database Design, Documentation, Database...

Experience

Availability

Part-time

Preferred Environment

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

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.

Work Experience

Oracle Consultant

2021 - 2022
Self-employed
  • 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 Application Express (APEX) reporting application to view data warehouse information.
Technologies: Oracle SQL, Oracle Development, Oracle Development, ETL, Database Design, Data Warehouse, Analytics Development, Relational Database Design, ETL Development, Oracle Application Express (APEX), SQL Views, SQL, Data Modeling, HTML, Database, Oracle Database, SQL, Database Schema Design, Data Warehouse, 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 Development, Oracle SQL, SQL, XML, Database Design, Database, SQL Views, SQL, HTML, Database, 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 Development, Database Design, Documentation, Database, Oracle Development, SQL, Scripting, Relational Database Design, SQL Views, Data Modeling, Database, 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 Development, Processing, Oracle Advanced Queuing (AQ), ETL Development, Database Migration, Analytics Development, Enterprise Development, Data Integration, Team Mentoring, PL/SQL, Data Structures, Oracle Development, XML, Data Warehouse, Database, Oracle SQL, SQL, Oracle Database, Database, SQL, Database Triggers, SQL Views, Relational Database Design, Scripting, Triggers, Database Scripting, SQL, Database Design, ETL, Writing & Editing, Documentation, Database Schema Design, Data Warehouse, 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 Development, SQL, XML, SQL, Oracle Database, Database, Data Modeling, SQL, Database Triggers, SQL Views, ETL Development, Relational Database Design, Scripting, Triggers, Database Scripting, Database Migration, Team Mentoring, Oracle Development, Database, 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: Crystal Reports, Oracle Development, Database Design, Database, Triggers, Scripting, Relational Database Design, SQL Views, Database Triggers, SQL, Data Modeling, Database, Oracle Database, SQL, Oracle SQL, Database Schema Design, Data Analysis

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.
1990 - 1992

Graduate Coursework in Philosophy

University of Oregon - Eugene, Oregon, USA

1984 - 1990

Bachelor's Degree in Philosophy

Willamette University - Salem, Oregon, USA

Tools

Oracle Application Express (APEX), Crystal Reports

Languages

SQL, Processing, HTML, XML

Paradigms

Database Design, ETL

Storage

Oracle SQL, Oracle Development, SQL, Database Triggers, SQL Views, Database, Database Scripting, Database, SQL, Database Migration, PL/SQL, Data Integration, Oracle Development, Oracle Development

Platforms

Oracle Database

Other

Relational Database Design, Database Schema Design, Data Analysis, Data Architecture, Scripting, Triggers, Data Modeling, ETL Development, Oracle Advanced Queuing (AQ), Enterprise Development, Team Mentoring, Data Structures, Documentation, Public Speaking, Research, Writing & Editing, Object Types, Data Warehouse, Analytics Development, Oracle Development, Data Warehouse, University Teaching

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring