Resume

Sign in

Oracle Database Administrator/SQL-PL/SQL Developer

Location:
St. Louis, MO
Posted:
January 14, 2020

Contact this candidate

Resume:

Stephen Snyder, Ph.D.

Database Administrator – PL/SQL Developer

Stephen Snyder SDS Consulting

adba2s@r.postjobfree.com 314-***-****/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.

Expeience 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.

• 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 Administrator – PL/SQL Developer

Stephen Snyder SDS Consulting

adba2s@r.postjobfree.com 314-***-****/314-***-**** TECHNICAL SKILLS

Software and Programming Languages:

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

Unix shell scripts

Ingres

Administration/Application Tools:

SQL*Plus SQL*Loader

SQL*Net Enterprise Manager

Hardware and Operating Systems:

Windows Multi processor Intel systems

Unix: Sun, AIX systems

Technical Capabilities:

Oracle Tuning

SGA I/O

Indexes Query structure

Application Flow SQL*Net

Implementation of table partitioning Implementation and tuning or parallel query option 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 configuration & management

Programming/Scripting

Unix & o/s batch scripting PL/SQL package creation & maintenance PRO*C & PRO*Fortran VB.net programming

Oracle Forms and Reports

Stephen Snyder, Ph.D.

Database Administrator – PL/SQL Developer

Stephen Snyder SDS Consulting

adba2s@r.postjobfree.com 314-***-****/314-***-**** EMPLOYMENT EXPERIENCE

SDS Consulting: 2002-present

Principal Consultant - Support clients on contract or as needed basis Client Projects

Willert Home Products 2002-present

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. The application integrates access to Oracle and Ingres databases allowing users to adjust, manage, and report on data integrity and the load process.

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

Stephen Snyder, Ph.D.

Database Administrator – PL/SQL Developer

Stephen Snyder SDS Consulting

adba2s@r.postjobfree.com 314-***-****/314-***-**** EMPLOYMENT EXPERIENCE

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

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 Fulbright Scholar – 2018

Stephen Snyder's academic webpage

Stephen Snyder, Ph.D.

Database Administrator – PL/SQL Developer

Stephen Snyder SDS Consulting

adba2s@r.postjobfree.com 314-***-****/314-***-**** EDUCATION

B.S., Computer Science - Philosophy, Manchester University M.A. Program, Philosophy/Frankfurt University

Ph.D., Philosophy, Saint Louis University

REFERENCES

Jim Schoendienst, Willert Home Products 314-***-**** Glenn Hoorman, Ludus,LLC 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