PROFESSIONAL SUMMARY:

More than 25 years’ experience in the IT Industry with background in Health Care, Banking, Public Utilities, Automotive, and Gaming. Positions have included Oracle Database Development Manager, Oracle Database Administrator, Sr. Programmer Analyst, Project Lead, and Data Architect. Additional skills include team leadership, mentoring, resource acquisition and management.

TECHNICAL SKILLS SUMMARY:

Languages: Oracle PL/SQL, ANSI SQL, Microsoft T - SQL, Linux Bash Shell, AWK, Korn Shell, C#.NET, ASP.NET, JSON

Operating Systems: Red Hat Enterprise Linux Server release 5*, 6*, CentOS release 6.8, UNIX Sun/Solaris, AIX, Windows 10,7, XP Pro, Win2000, NT4, Windows9.x, MS DOS, IBM MVS, DOS/VSE

Development Tools: Oracle SQL Developer, PL/SQL Developer (All Around Automations), Toad 12. * DBA suite, SQL Navigator, MS SQL Management Studio, Visual Studio Pro 2005, 2003, SQL* Plus, SVN, PVCS Version Control, MS Visual Source Safe Version Control, AccuRev Source Control

Databases: Oracle18c, 11g - 7.3.4, SQL Server 2012,2008,2005,2000, MS Access

Database Tools: Edition Based Redefinition (EBR) 18c, Oracle Advanced Queuing (AQ), APEX Administration, ORDS Listener Administration, RMAN Backup, ASH, ADDM, AWR, Oracle Data Pump, Oracle OEM DB Console, legacy IMPORT/EXPORT, Oracle SQL Developer and Data Modeler, Toad DBA Suite

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Senior Oracle Database Administrator

Responsibilities:

• 1-way data replication using a publish / subscribe model
• A suite of event-based message broadcasts using JSON format
• An event-based batch job initiator used to handle ad hoc job requests
• Implemented as Oracle 18c SQL/JSON
• Oracle REST services via ORDS
• Extensive software development using ANSI SQL with PL/SQL stored procedures, packages; developed, tested, deployed custom Oracle database server utilities such as Oracle Listener “Keep Alive” process using Bash Shell, also developed a similar process for APEX ORDS Listener.
• Designed and Developed a custom job scheduling system using PL/SQL to leverage the Oracle DBMS SCHEDULER; designed, developed several custom LINUX Bash scripts leveraging the use of the AWK language. Reverse engineered Synkros database model using the Oracle Data Modeler.
• Administer APEX application deployments and the ORDS listener, perform troubleshooting of APEX InfoSynk Local application, created custom reporting features for InfoSynk Local by using BASH and AWK along with Oracle External Tables leveraging pre-processor .bash scripts to consume Linux Host OS level data used for database health monitoring.
• Perform Synkros Casino Management System 24 hour on call DBA/application support; also, provided DBA support for new customer implementations; application trouble ticket support.

Confidential, Las Vegas, NV

Oracle Web Developer

Responsibilities:

• Designed and implemented a customer reservation voucher redemption system using Oracle PL/SQL and JQUERY technology; Delivered high visibility “Methods of Payment” application for newly acquired Island One properties.

Confidential, Las Vegas, NV

Oracle PL/SQL Development Manager Developer/DBA

Responsibilities:

• Assumed dual role of PL/SQL Development manager and developer in March of 2008.
• Manage a development team of up to 5 database developers. Other tasks include
• Data Modeling and architectural design, managing project timelines, project sizing, project resource management, quality assurance/code reviews, developer candidate screening and interviews, establishing shop coding standards, deployment manager, participation in 7/24 incident manager on-call rotation.
• Perform data modeling using Oracle Data Modeler (ODM) 3.3., 3NF, conceptual and physical modeling for new projects , reverse engineering of existing data models into ODM projects.
• Creation and maintenance of database accounts in all test environments, assist DBA’s with query tuning, problem analysis and resolution , key resource in tuning effort using Toad SQL Benchmarking Tool.
• Key participant in design and development of database security model for Protected Cardholder Information (PCI).
• Developed a variety of custom database applications for Bank initiatives
• Design public facing Customer ESIGN Electronic Document tracking and notification System
• Redesign and performance scaling of new Customer Account Boarding Process
• Major redesign, tuning of Collections Agency Assignment Batch Processing.
• Proven record of with Query tuning, use of the Explain Plan, Debugger, and indexing strategies.
• Excellent knowledge of database definition language (DDL), triggers, stored procedures, data extract techniques, SQL Plus Scripting
• Effective in MS T-SQL design, development, debugging, use of MS SQL Management Studio

Confidential, Las Vegas, NV

.NET developer

Environment: Windows XP Pro, .NET 2.0

Tools: Visual Studio 2005, C#.Net, ASP.Net, PL/SQL Developer All Around Automations

Version Control: AccuRev, MS VSS

Reporting Tools: MS Reporting Services

SOA: .NET Web Services, .NET Remoting

Languages: C#.Net, ASP.NET, Oracle PL/SQL, T-SQL, JavaScript

Database: Oracle 11g, 10g, 9i, SQL Server 2008, 2005

Confidential, Las Vegas, NV

Consultant

Responsibilities:

• Developed several Window Forms based and Intranet based applications using C#.NET, ASP.NET, and Oracle9i; supported Confidential vendor supplied software package for the Engineering Services department.
• Extensive maintenance of Oracle9i triggers and PL/SQL stored procedures.

Environment: Windows XP Pro, IBM/AIX Risc6000

Tools: Visual Studio 2005, C#.Net, ASP.Net, Toad

Languages: C#.Net, ASP.NET, Oracle PL/SQL

Database: Oracle10G

Confidential, Las Vegas, NV

Senior Programmer/Analyst

Responsibilities:

• System Administrator for Crystal Enterprise XI implementation. Successfully lead a major software upgrade for SQL Server 2000 based Electronic Medical Records system, Touchworks.
• Perform Project Management for vendor supplied software.
• Developed Intranet based application for managing Smoking Cessation program using VB.NET and ASP.NET with SQL Server 2000.
• Performed routine maintenance of in house applications.

Environment: Windows XP Pro

Tools: Visual Studio 2003, ASP.Net, Sql Server 2000, Oracle 10g

Languages: Oracle PL/SQL, VB.Net, ASP.NET, T-SQL

Database: SQL Server 2000, Oracle10G

Confidential, San Diego, CA

Consultant

Responsibilities:

• Performed data trend analysis, ad-hoc reporting, file extracts, and external customer support using Oracle PL/SQL.
• Developed dynamic trend analysis report using Microsoft Data Access Pages

Environment: Sun/Sparc

Tools: PL/SQL Developer All Around Automations

Languages: Oracle PL/SQL

Database: Oracle8i, Oracle9i

Confidential, San Diego, CA

Software Engineer

Responsibilities:

• Designed and implemented high performance Oracle PL/SQL solutions for a high visibility, terabyte scale, mission critical corporate database system using bulk processing methods, native Dynamic SQL, Oracle External Tables, and Merge/Insert/Update SQL features; recurrent use of Oracle query tuning, TKPROF, and Explain Plan tools.
• Designed a variety of Batch processes using UNIX KORN shell.

Environment: Windows 2000, IBM Risc600

Tools: SQL Navigator 4.3, SQL* Plus, TOAD

Languages: Oracle PL/SQL, ANSI SQL, UNIX Korn Shell

Database: Oracle9i