Database Engineer Administration

Stephen Snyder, Ph.D.

Database Engineer - Database Administrator - PL/SQL Tuner/Developer

**************@*****.*** 314-***-****

SUMMARY

I have been working in the field of information technology for over 30 years. My specialty is SQL, PL/SQL and Oracle tuning. My skillset includes Oracle database administration, setup and maintenance of a broad range of instance configurations, performance tuning, database analysis, troubleshooting and data architecture. I have been responsible for the data architecture of several datamarts and authored extraction modules and conversion scripts for transactional database and data warehouse applications in diverse business environments. Using VB.net I have written several complex systems deigned for ETL maintenance of a sales datamart and hazardous material safety database. My training experience is in Oracle education, instructing Oracle database administration and introductory SQL and PL/SQL training.

Experience and skills:

• BA in Computer Science and a PhD in Philosophy

• Over 30 years of experience with extensive knowledge of Oracle databases and PL/SQL.

• Over 15 years of experience as an OraclePL/SQL developer/tuner.

• Over 10 years of experience in Data Warehousing and Business Intelligence architecture.

• Experience implementing, maintaining and tuning both transactional and dimensional databases. This includes VLDB support, tuning tables of over 40 billion rows.

• 15 years experience with entity relationship modeling, data design, and data structure maintenance.

• Proven track record in customer support, data recovery and system troubleshooting.

• Cloud migration experience.

• Analytic training in philosophy with superior problem resolution skills.

• A professor and published author with excellent verbal and written communication skills. Stephen Snyder, Ph.D.

Database Engineer - Database Administrator - PL/SQL Tuner/Developer **************@*****.*** 314-***-****

TECHNICAL SKILLS

Software and Programming Languages:

Oracle versions 5, 6, 7, 8, 9, 10, 11g, 12c, 19c Embedded SQL and OCI VB, VB.net/Visual Studio 2010, 2015 PL/SQL

Unix shell scripts SQL

Ingres

Administration/Application Tools:

SQL*Plus SQL*Loader

SQL*Net Foglight

SQL*Developer Enterprise Manager

PL/SQL Developer TOAD

Jenkins, TFS, git

Hardware and Operating Systems:

Windows Multi processor Intel systems

Unix: Sun, AIX systems Oracle Exadata

Linux Google Cloud Environment, AWS

Technical Capabilities:

Oracle Tuning

SGA I/O

Indexes Query structure

Application Flow SQL*Net

Implementation of table partitioning Implementation and tuning of parallel query option Advanced Exadata tuning on VLDB json tables

Database Administration

Database table/object design Agent configuration

Data warehouse design and implementation Backup & recovery Data integrity Remote database administration

Creation of database analysis tools Complex SQL scripts Database migration Custom database configuration

Standby database setup & management DBMS_SCHEDULER package Programming/Scripting

Unix & Linux o/s batch scripting PL/SQL package creation & maintenance C++, PRO*C SQL

PERL, Java VB & VB.net programming

Stephen Snyder, Ph.D.

Database Engineer - Database Administrator - PL/SQL Tuner/Developer **************@*****.*** 314-***-****

EMPLOYMENT EXPERIENCE

GovCIO – Veterans Administration Sep 2023-Jun 2024 Senior Database Developer (Public Trust Clearance)

Technical lead of development team responsible for maintaining and upgrading VA case management system.

Maintain and develop Pro*C modules used to interface distributed data sources managed by Tuxedo and the VA application.

Compile and distribute services to the lower environments.

Migrate case management application to AWS cloud server. Wells Fargo: Jan 2023-Jul 2023

Lead Software Engineer (Contractor S3)

Member of development team responsible for maintaining and upgrading securities performance system written in Oracle and executed from PERL scripts.

Convert PERL batch process to Java.

Troubleshoot Oracle errors in PERL load process.

Performance tuning on problem queries.

Extensive use of Oracle UDTs and member functions.

Develop parallel SQL load balancer using DBMS_SCHEDULER package and Java.

Agile Scrum

Accenture Federal Services/Department of Energy: 2021-2022 Oracle Database Developer/DBA (Contractor M9 Solutions Public Trust Clearance)

Member of development team responsible for maintaining and upgrading DOE planning/budgeting system.

Write new PL/SQL procedures and packages.

Troubleshoot Oracle errors; write alternate substring functions to handle CLOB type errors; SQL tuning.

Implement design improvements; developed standardized error handling.

Assist Database Administrator with maintenance tasks.

Agile Scrum/Kanban Board

Wells Fargo: 2020-2021

Lead Database Engineer – performance tuning specialist (Contractor Colabera)

Member of team responsible for resolving performance issues with brokerage data warehouse queries.

Troubleshoot and tune problem queries in VLDB test environment. Recommendations applied in production.

Evaluate and assess usefulness of features added in new Oracle releases.

Document tuning, data modeling and pl/sql standards for division WIKI.

Analyze dependencies in operational schema to make recommendations for how application schemas could be incorporation into micro services.

Agile/Kanban board

Stephen Snyder, Ph.D.

Database Engineer - Database Administrator - PL/SQL Tuner/Developer **************@*****.*** 314-***-****

EMPLOYMENT EXPERIENCE

SDS Consulting: 2002-2020

Principal Consultant – Self-Employed: Supported clients listed below on contract or as needed basis. Willert Home Products 2002-2020

Data warehouse design and implementation.

Oracle and Ingres Database maintenance, tuning and application support.

Data transformation tools created using PL/SQL packages and Ingres SQL/Report Writer.

Unix scripts created to manage database interface operations, backup, and error reporting.

Backup/recovery process developed and integrated into cron.

Design & implementation of VB.net-PL/SQL-Ingres SQL application used to ensure integrity of datamart. Frucon/Optimum Solutions 2004-2011

Troubleshoot/tune/maintain customized Oracle manufacturing application.

Maintenance, tuning, backup/recovery management of Oracle databases on multiple site locations. Pepsi Co, New Haven, MO 2002-2004

Data warehouse design and implementation. Oracle Database maintenance, tuning and application support.

Data transformation tools created in PL/SQL to extract and massage data from windows based distribution application.

Other clients: Appointlink, Lanter Logistics and Delivery, Host Analytics, Sentinel DBA Host Analytics: 2000-2002

Sr. Technical Analyst

Development of web-hosted data warehouse system.

Design of database schema and extract tools.

Design and tune views for use by web based business intelligence reporting system. Tapestry Computing/Braun Consulting: 1994-2000

Sr. Database Administrator/Trainer

On-line and on-site technical support

Transactional and business analysis database design and support

Database tuning and maintenance

Customized database configuration and installation

Oracle training:

Introduction to ORACLE

Introduction to PL/SQL

DBA I

DBA II

Cap Gemini America: 1989-1990

Technical Consultant

Oracle database administration.

SQL/OCI programming for graphical mapping system.

Conversion of Oracle precompiler code from DEC PRO*Fortran to OS/2 PRO*C for graphically driven marketing application. Authored interface module emulating Oracle OCI calls using IBM embedded SQL allowing the application to transparently switch database vendors. Stephen Snyder, Ph.D.

Database Engineer - Database Administrator - PL/SQL Tuner/Developer **************@*****.*** 314-***-****

EMPLOYMENT EXPERIENCE

Oracle Corporation: 1987-1989

Consultant

SQL & embedded SQL programming and system tuning

Oracle training

Database design

Forms programming

Qint Database: 1985-1987

Technical Support

Technical support for configuration and tuning of PC based RDBMS

Develop database utility tools.

Represent Qint in 1987 Database Derby

TRAINING EXPERIENCE

Responsible for development and instruction for a suite of ORACLE training courses: Introduction to ORACLE

Introduction to PL/SQL

DBA I

DBA II

Undergraduate teaching: 2005-2022 Assistant Professor A full range of graduate and undergraduate courses: Fatih University, Istanbul (Full-time 2007-2015) Social and Political Philosophy: Johannes Guttenberg University, Germany (Erasmus exchange) Philosophy of Art, Ethics and Bioethics: Saint Louis University (Adjunct) Aesthetics: Washington University; Hildesheim University, Germany; Bogazici University (Adjunct) Fulbright Scholar – 2018

Stephen Snyder's academic webpage

EDUCATION

B.S., Computer Science - Philosophy, Manchester University Ph.D., Philosophy, Saint Louis University

REFERENCES

Tom McGeehan, Panera 314-***-****

Jim Schoendienst, Willert Home Products 314-***-**** Glenn Hoorman, eAlliance 314-***-****

Jim Eberlin, TopOpps 314-***-****

BOOKS PUBLISHED

End-of-Art Philosophy in Hegel, Nietzsche and Danto. Palgrave Macmillan, 2018. New Perspectives on Distributive Justice: Deep Disagreements, Pluralism, and the Problem of Consensus, co- edited with Manuel Knoll and Nurdane Şimşek. De Gruyter Press, 2018.

Contact this candidate