Sql Developer Oracle Database

Steven R. Meyer

Gilroy, CA • 669-***-**** • *********@*****.*** • linkedin.com/in/steven-r-meyer

Senior Database Developer

PL/SQL Programming Database Design Performance Enhancement US Citizen Public Trust Clearance

Seasoned and loyal PL/SQL & SQL Developer with extensive contract experience and expertise in using Oracle, SQL, and PL/SQL to optimize SQL queries and build database solutions that meet business goals. Highly adaptable analyst proficient in Oracle Database Design, Implementation and Maintenance. Track record of success in building and deploying systems that improve quality and efficiency. Proven ability to enhance database performance and efficiency, collaborate on transitioning applications, and align end-user needs to launch long-term resolutions. Adept at rewriting SQL code to reduce elapsed times and streamline data processes, as well as creating reports, procedures, and functions to ensure seamless data flow for various projects.

Core Expertise

Specialties: Database/Web Design Stored Procedures Data Warehousing Transaction Processing Report Creation Performance Tuning/Enhancement Relational Database Management System Database Solution/Schema/Maintenance

Technical Tools: PL/SQL Development Tools (Oracle, AllRound Automation, Toad) SQL Query Optimization Oracle Database (versions 6 through 21c, Exadata) ETL CSS SQL*Plus HTML JavaScript Triggers SVN Git Stash XML

Professional Experience

PL/SQL and SQL Developer US Air Force – Remote Nov 2021 – Jun 2025

»Collaborated on transitioning Comprehensive Engine Management System (CEMS) application from COBOL to Oracle PL/SQL with ODS CEMS/GIMMS team.

»Utilized AllRound Automations’ PL/SQL Developer, Atlassian Jira, and Microsoft Teams for development.

»Assisted in maintaining Amazon AWS database and resolving bugs and enhancing features.

SQL Developer KAISER PERMANENTE – Pleasanton, CA Sep 2021 – Nov 2021

»Maintained SQL Scripts for Export, Transform, and Load processes between databases.

»Enhanced SQL query performance, achieving 98% improvement for specific reports.

»Optimized data transfer processes; collaborated with team to ensure efficient data flow and accuracy.

Oracle Database Developer AIG – Remote Jun 2021 – Jul 2021

»Developed and implemented Oracle databases; optimized database performance; conducted troubleshooting to promptly resolve issues with efficient solutions, enhancing overall system functionality.

»Prioritized database performance and stability, contributing to success of database operations.

Oracle Database Developer BANK OF THE WEST – Remote Aug 2020 – Feb 2021

»Built reports on data, program and structure variances between environments; wrote scripts to update environments.

»Employed FORALL and SAVE EXCEPTIONS for error handling; used SQL and PL/SQL to validate that BotW’s custom tables and columns successfully migrated to updated database, ensure all data is updated when new/changed rows are found.

Oracle Database Developer MORSE CLOUD CONSULTING – Remote Feb 2020 – Aug 2020

»Investigated indexes and alternative methods to drive performance enhancement and PL/SQL performance optimization.

»Tuned performance of SQL and PL/SQL objects; analyzed SQL statements within procedures for procedural efficiency.

Senior Software Architect WAGEWORKS – San Mateo, CA Dec 2018 – Feb 2020

»Led performance tuning for Oracle database programs/storage elements, deploying updates for live database software.

»Verified/tested New Edition before opening to all users; Provided SQL & PL/SQL support for various projects and POCs.

»Partnered with Architecture Team on Proof-of-Concept projects and established architecture guidelines.

Discoverant Developer GILEAD SCIENCES – Foster City, CA Aug 2018 – Dec 2018

»Built Discoverant Hierarchy and controls for drug testing to support efficient drug development/management operations.

»Documented processes to ensure compliance with Gilead standards; setup control processes in proprietary application.

Database Performance Analyst KAISER PERMANENTE – Pleasanton, CA Mar 2018 – Jul 2018

»Tuned performance of SQL exported from Teradata to Exadata; enhanced performance of SQL code for running reports and batch processes; improved efficiency of database operations through performance analysis and optimization.

»Rewrote SQL code to improve performance of Data Warehouse database on Exadata, reducing elapsed times by 90+%.

Database Engineer DEFENSE MANPOWER DATA CENTER (DMDC) – Seaside, CA Nov 2017 – Jan 2018

»Ran canned scripts and transferred data to MS (Excel, Access, PPT), assisting DMDC’s DoD employees and dependents.

»Used programming skills to improve database reporting; enhanced efficiency by streamlining data processing workflows.

Senior Database Engineer WELLS FARGO – Fremont, CA Jun 2017 – Sep 2017

»Built and provided SQL and PL/SQL code for Data Quality project within Data Warehouse; utilized Oracle PL/SQL stored procedures, SQL Developer, and SVN for development/source control, ensuring successful global financial operations.

Database Engineer GOOGLE – Mountain View, CA Sep 2016 – Nov 2016

»Developed SQL and Workflow designs for Reporting project using Google-SQL, Google platform, and related tools.

»Utilized Google proprietary tools for coding, testing, and deployment; provided SQL code to validate data in reports.

»Managed code with Google proprietary source control; supported Reporting project with SQL and workflow design.

Senior Database Engineer WELLS FARGO – Fremont, CA Mar 2016 – Sep 2016

»Built database design and installed SQL and PL/SQL programming/code for Guarantor/Guarantee enhancement project.

»Created Oracle PL/SQL stored procedures, functions, views, and materialized views; optimized CreditView application.

Senior Database Engineer FEDERAL RESERVE BANK – San Francisco, CA Sep 2015 – Feb 2016

»Provided SQL assistance to generate test data for testing performance of FedCash application and other systems.

»Utilized Oracle PL/SQL blocks, SQL queries, and DML statements for database ops and key financial services applications.

»Leveraged SVN and Document Sharing platform FedShare; utilized Development Tools for database development tasks.

Additional Experience

Senior Database Engineer WELLS FARGO – Fremont, CA

Implemented means for reports from Data Warehouse to Oracle. Added constraints, indexes and created views. Enhanced performance of online reports by 90% to 99%. Utilized Oracle PL/SQL stored procedures, Views, PL/SQL Developer and SVN.

Senior Database Designer/Developer AERIS COMMUNICATIONS – San Jose, CA

Aided online reports/OLTP and batch processes to enhance performance and deliver new functionality. Optimized ETL process for incoming data, improving throughput capacity 75+% and enhancing data integration. Mentored junior engineers.

Senior Database Engineer WELLS FARGO – San Francisco, CA

Developed Wells Fargo YOM application (ACARS), enhancing on-line reports and batch processes. Analyzed needs, data and code to meet client needs and improve performance. Supported OLTP and batch processing for database operations.

Senior Database Engineer I&J SOLUTIONS – Sunnyvale, CA

Led Premium Billing product and its performances, improving monthly billing performance 75% and Delinquencies module 90+%. Led Data Implementation and Control for ETL processes, optimizing database interfaces for web/batch processes.

Senior Database Engineer SNOCAP – San Francisco, CA

Led design and software support for MyStore app. Built database design and PL/SQL APIs for customer-facing and internal sites. Enhanced web app response time 100% by building Oracle instance for load during SNOCAP’s music track imports.

Senior Database Engineer SLAC (Stanford Linear Accelerator Center) NATIONAL LABORATORY – Menlo Park, CA

Contributed to several medium- to large-scale database-driven web systems supporting high-energy physics experiments, including BaBar Experiment (global collaboration of 500+ physicists). Built/led Oracle database applications for institutional data, reducing data errors and streamlining reports. Integrated databases to enable users to track modules/trouble tickets.

Education & Professional Development

Computer Science Studies DE ANZA/FOOTHILL COLLEGE Clearance: Public Trust

Contact this candidate