CV/Resume for contract work long or short term

Robert P. Lockard
+1.571.276.4790
rob (at) oraclewizard (dot) com
NOTE: Please put CONTRACT WORK in the subject line. I get somewhere 
around 500 emails a day, this will help my filters.

Professional Awards and Recognition:

  • Oracle ACE Director
  • Winner of the 2015 Oracle Developers Choice Award for Database Design for my work in Database Security.

Availability: I can be at your location within a couple days after contract is finalized.

Available Location, I am available to work at your location anywhere in the world. There are a couple exceptions to international locations, based on my safety.

Rate, My rate varies based on length of contract and location.

Summary: Over 30 years experience in Oracle technologies with a specialty in Oracle Database Security. Successfully designed, implemented and maintained highly complex information systems for customers ranging from Financial Crimes Enforcement Network (FinCEN) to Maryland Department of Transportation. My work for FinCEN ensured the secure transmission and processing of sensitive financial information sent from banks, casinos, and other financial institutions. For Maryland Department of Transportation (MDOT) designed using big data analytics to detect Chameleon Carriers (unsafe trucking companies) so they can be taken off the road. Securing MDOT data, encrypting data at rest and in motion, implementing secure coding standards and modernizing their information systems.

Application Security Retrofit. Evaluate and retrofit your database application(s) to a secure architecture that would save money over a complete redesign. This will improve your security posture and I frequently find places where we can optimize performance of your systems.

Application Design and Development. I can come in and design a secure database system that is secure, fast, accurate and stable.

Oracle Database Security Evaluations: Evaluate the security on your Oracle database system, recommend changes. My approach to your database security is holistic, so you know we are covering what needs to be done.

Oracle Database Security Audits: Before going live, you should do an audit of your implantation. I am available and capable of doing a security audit of your system.

SKILLS:

Oracle RDBMS (6 - 12.2) Expert


Oracle Forms Expert

Oracle Reports  Expert

Oracle Data Guard Expert

Oracle SQL Developer Expert

Oracle RMAN Expert

Oracle APEX Proficient

Oracle Virtual Box Proficient

IBM Connect Direct with Secure+ 3.8 – 4.1. Proficient

Oracle ASM Proficient

Oracle Exadata Proficient

Oracle SQL Developer Data Modeler  Proficient

Oracle Weblogic Proficient

Oracle RAC  Proficient

OPERATING SYSTEMS:

Windows Advanced

Solaris Advanced

HP/UX Advanced

AIX Advanced

Linux Advanced

 

LANGUAGES and SCRIPTING:

SQL Expert

PL/SQL Expert

korn Advanced

bash Advanced

Python Proficient

C Proficient

EXPERIENCE

4/1996 – Present Oraclewizard, Inc. Principle

Clients include. Maryland Department of Transportation, FBI,  FDIC, Department of Treasury, Treasury Communication Systems, Financial Crimes Enforcement Network (FinCEN), US Army Logistics, AT&T, Northrop Grumman, Naval Communications Command, US Navy Office of Chief Information Officer, Naval Aviation, EarthTech, Inc., Deloitte Consulting LLC, and Defense Cyber Crimes Center.

Public speaking at Worldwide Oracle User Group and technical events on Database Security and Secure Coding.

Lead Developer / DBA for custom financial application that collects and distributes fees, and issues credentials from trucking companies. Upgrade Oracle 10.2 -> Oracle 12.2. Develop advanced analytics application to detect chameleon trucking companies.

Lead Oracle database consolidation 11.2.0.3  twenty single instance Oracle 11.2.0.3 database to Oracle 12.1.0.2 RAC multitenant (PDB).  DBA lead for twelve database administrators (Oracle, SQL Server, DB2).  Manage Remedy ticket distribution. Prepare and present operational reports for FDIC management.  Plan, schedule and manage database maintenance activities (patching, upgrades)  Transition all contract activities to Deloitte.

Lead Database Administrator and Lead Database Application Developer. Design application to distribute cyber attack and malware data to the national Cyber Centers.  Features include, cell level security using Attribute Based Access Control and APIs to extract data from the database.  Train developers in database application profiling.  The uses case for this project lead to a hybridized approach using both NoSQL and Postgressql RDBMS to account for both unstructured data and structured data. Perform DISA STIG vulnerability remediation to Postgressql.

Lead design and development of FinCEN Banking Secrecy Act E-Filing (EFL) system using Oracle Designer/2000,  and Oracle Database 7.2.  Migrated BSA EFL over the years from 7.2 to Oracle 11.2.0.4. Lead Oracle DBA BSA EFL.  Perform DISA STIG vulnerability remediation, apply CPU and PSU patches.

Tier 3 support of 150,000 plus external users and several hundred internal users of FinCEN applications and data. Provide analytical support (data mining / analytics) of FinCEN data spanning multiple diverse environments to external law enforcement and intelligence agencies.

Setup, tune and operational maintenance of two node Oracle RAC and  physical standby databases for  FinCEN Basic Query (BQ) database.  Lead Oracle DBA BQ

Managed migration Internal Revenue Service historical Suspicious Activity Reports and Currency Transaction Report data to the new FinCEN System of Record (SOR).  Lead Oracle DBA FinCEN.  

Research and document best practices, and standardized practices for complex Oracle environments including database setup, maintenance, and database security.

Moved FinCEN from a silo environment (separate servers for applications) to a private cloud hosted at BPD data centers in Parkersburg, WVA and Kansas City, Kansas.

Setup and maintain IBM Connect Direct with Secure+ along with FTP over VPN tunnel connections to multiple Financial Institutions and external US Government agencies. Tier 3 support for secure data transmission FinCEN to / from Financial Institutions, and external US Government agencies.

Upgrade Oracle 7.3 to Oracle 8.1.x. Upgrade Oracle 8.1 to. Oracle 9.2.x.  Upgrade Oracle 9.2.x to Oracle 10.2.x. Upgrade Oracle 10.2.x to 11.2.x. Administer multiple Oracle 7 – 11G instances. Design and implement Oracle disaster recovery plan using physical standby databases. Maintain Oracle backups using RMAN, develop and monitor cron jobs. Write korn shell scripts for backup, recovery and tuning.

Present and Provide CIO US Department of Treasury and CIO Federal Aviation Administration standardized lock down procedures for Oracle Database products.

Develop and implement Oracle database security standards.  Perform audits of Oracle database events and configurations. Implementation of Row Level Security (Virtual Private Databases), Oracle Database Vault, Oracle Advanced Security, Fine Grained Auditing.

Develop time keeping and project accounting database using Oracle 11G, and Oracle Developer Suite 10G.  

Responsible for designing, developing and coding of the GCSS project. Use Oracle Designer/2000 to design and develop user interface. One hundred percent generate front-end application of Oracle Forms.  Design and develop Enterprise Risk Management / Operational Risk Management system.

Multiple highly focused projects for various customers:

Database, and application tuning.  

Database Administration

Oracle Database security audits.

Application retrofits to improve security.

EDUCATION

03/2015 Oracle Exadata Administration Workshop 

12/2012 Oracle High Availability

01/2012 Chris Date SQL and Relational Theory through Method-R

10/2009 Oracle Database: 11g Security

06/2008 Oracle Developer 10g

01/2008 Oracle Enterprise Manager Grid Control 10g

09/2006 Oracle HTML DB / APEX

05/2005 Oracle Workflow

03/1999 Oracle Developer/2000

01/2001 Oracle Data warehouse Design

03/1995 Oracle Designer/2000

01/1995 Oracle Database Logical Design, Physical Design, Generation

12/1994 Oracle Consulting Skills

04/1994 Oracle DBA I and II, Oracle performance tuning

02/1994 Oracle DBA

01/1993 Oracle Master Developer Forms 3.0

1984 – 1986  Germanna Community College Computer Science

1989 – 1990 Mary Washington College Computer Science, Math, Physics

1990 - 1992  George Mason University Computer Science, Math, Physics

1993 - 1995  The American University Computer Science

Current and Past Customers include:

Financial Crimes Enforcement Network. http://www.fincen.gov

Defense Cyber Crimes Center http://www.dc3.mil/

Maryland Department of Transportation http://www.mdot.maryland.gov/

Federal Bureau of Investigation http://www.fbi.gov

US Department of Treasury https://www.treasury.gov/Pages/default.aspx

Welcome to oraclewizard