Stephen Snyder, Ph.D.
Database Engineer - Database Administrator - PL/SQL Tuner/Developer
adzmlq@r.postjobfree.com 314-***-****
SUMMARY
I have been working in the field of information technology for over 30 years. My specialty is 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 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.
• 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 adzmlq@r.postjobfree.com 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
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 PRO*C & PRO*Fortran SQL
PERL, Java VB.net programming
Stephen Snyder, Ph.D.
Database Engineer - Database Administrator - PL/SQL Tuner/Developer adzmlq@r.postjobfree.com 314-***-****
EMPLOYMENT EXPERIENCE
Wells Fargo: Jan 2023 – July 2023
Lead Software Engineer
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 with Public Trust Clearance (Contractor M9)
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
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
SDS Consulting: 2002-2020
Principal Consultant - 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.
Stephen Snyder, Ph.D.
Database Engineer - Database Administrator - PL/SQL Tuner/Developer adzmlq@r.postjobfree.com 314-***-****
EMPLOYMENT EXPERIENCE
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. 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
Stephen Snyder, Ph.D.
Database Engineer - Database Administrator - PL/SQL Tuner/Developer adzmlq@r.postjobfree.com 314-***-****
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-2019 Assistant Professor A full range of graduate and undergraduate courses: Fatih University, Istanbul Social and Political Philosophy: Johannes Guttenberg University, Germany Philosophy of Art, Ethics and Bioethics: Saint Louis University Aesthetics: Washington University; Hildesheim University, Germany; Bogazici University 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.