Robert P. Lockard +1.571.276.4790 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
LANGUAGES and SCRIPTING:
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 184.108.40.206 twenty single instance Oracle 220.127.116.11 database to Oracle 18.104.22.168 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 22.214.171.124. 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. 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