CV/Resume for contract work long or short term

Robert P. Lockard
robert.lockard (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.


  • Pro Oracle Database 12c Security. Publisher APRESS. 2015
  • Oracle Database Application Security: With Oracle Internet Directory, Oracle Access Manager, and Oracle Identity Manager. APRESS 2019

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.

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

Summary: Over 35 years experience in IT 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. We 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.


Oracle RDBMS (6 - 19c) 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


Windows Advanced
Solaris Advanced
HP/UX Advanced
AIX Advanced
Linux Advanced



SQL Expert
PL/SQL Expert
korn Advanced
bash Advanced
Python Proficient
C Proficient


4/1996 – Present Oraclewizard, Inc. Principal

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.

Access and made recommendations for the secure interoperability of justice sector systems for the country of Moldova.

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  twenty single instance Oracle database to Oracle 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 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.


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.

Defense Cyber Crimes Center

Maryland Department of Transportation

Federal Bureau of Investigation

US Department of Treasury

Welcome to oraclewizard