Clearance Provided upon Request

30 years in Information Technology, which includes 10 years of software development, 17 year's database installation/implementation, 15 years experience implementing Oracle Databases 7.3 to 12c, and 8 years evaluating and implementing Information Assurance support to government related projects. 6 months experience with Oracle Identity Access Management IAM implementation and configuration over several different companies/projects.

Technical Skills

• Oracle Products: Relational Database Management Systems RDBMS 7.3 through 12c, Developer Suite, Enterprise Manager, Advanced Replication, Spatial, Database Vault, Real Application Cluster RAC and Oracle Structure Query Language SQL Developer, PostgreSQL 8.2 and 9.0.
• Operating Systems: Microsoft MS Windows: 98/NT/2000/XP/2003/2008/7 UNIX: Solaris 8/9/10 / TRU64 4.0F 5.1B, Red Hat/Fedora/Oracle Linux/CentOS.
• Languages: SQL, Oracle Procedural Language / Structured Query Language PL/SQL , Practical Extraction and Report Language PERL , MS Visual Basic for Applications VBA , Unix/Linux shell scripting.
• Databases: Oracle 7.3 through 12c, IBM DB2 6.1 7.1, MS SQL Server 4.2/7/2000/2005/2008 R2, Sybase 7/11, MS Access 2.0-2010, MySQL 4.0., MongoDB 3.0.1
• Management/Leadership Skills: System Architect, Agile Scrum Methodology
• Life Cycle Expertise: Troubleshooting, Code, Deploy, Test, Design, Development, Proposal.
• Specialty Skills: Database/System Security, Database Administration DBA , Data Manipulation/Cleansing, Database Development/Programming, and Data Migration.
• Communications: Oracle9i Application Server / Fusion Middleware / IAM.
• Other Products: Quest Toad

ORACLE CORPORATION COURSES

• Oracle9i DBA Fundamentals II, 07/04
• Oracle9i Database Security, 08/04
• Oracle9i Advanced Replication, 10/04
• Oracle Database 10g Administration Workshop 1, 10/05
• Oracle Database 10g Administration Workshop 2, 10/05
• Oracle Spatial 10g Fundamentals, 10/05

PROFESSIONAL Experience

Confidential

Job Title: Database Developer

• Support to Defense Treat Reduction Agency Bio Materials Information Program
• Work with current Prime Contractor to implement new environment based on MongoDB / JavaScript / Angular.js / Express.js / and Node.js.
• Implement a NoSQL database MongoDB from the current Oracle Database.

Confidential

Job Title: Database Engineer, Principal

• Responsible for the maintance of the Customer's University Theses repository Oracle database and support system.
• Responsible for the functionality of Theses to insure students were able to find theses through web pages.
• Analyzed database system to ensure that the Theses repository database and support system webpage meet all requirements.
• Used Oracle PL/SQL and UNIX shell scripts to address automating actions within the system and/or database. Such scripts were to validate information within the database and actions of the operating system. PL/SQL scripts were used to validate database data, such as duplicate data, invalid or misconfigured data. UNIX shell scripts were used to monitor system logs. Also wrote PL/SQL scripts to copy data between operating system environments. Wrote Java scripts which were wrapped within PL/SQL scripts to move data between Solaris and Windows environments.
• Involved in helping to investigate newer and more effective methods to meet the expanding technological goals and services in the Theses repository database and support system for the new system.
• Established security documents, in compliance with Intelligence Community Directive ICD 503.

Confidential

Job Title: Software Database Systems Engineer

• Support the development of system architectural product sets in support of critical customer transformational efforts, using the Agile Scrum approach.
• Created Architecture products will be documented using the DoD Architecture Framework DoDAF and the IBM Rational System Architecture SA tool across multiple time epochs.
• Provided expert guidance, relating to all Oracle products and what product was needed for what tasking.
• Work with the customer, through the National Geospatial-Intelligence Agency Software Asset Management Team to monitor the overall organizational software licenses and operation and maintenance support in order to address the Information Technology environment of the customer.

Confidential

Job Title: Senior Principal Database Design Analyst

• Analyze internal MS Access applications, relating to configurations, procedures, procedures, and problems to refine data for database management, in consideration of consolidation into organizations/common Oracle 11g database.
• Review designs and implements accurate, secure, efficient, logical and physical data bases and coordinates database development applying knowledge of database design standards and database management system.
• Implemented PL/SQL scripts to evaluate data and to load/update data within the database.
• Identify and resolve production and/or applications development problems related to the use of the database management system software or utilities. Review project request describing database user needs. Study existing data handling systems to evaluate effectiveness, and develops new systems to improve production or workflow as required, using the Agile Scrum approach.
• Maintained support of Oracle Database, in support of Oracle Critical Security Patches CPU releases and security alerts.

Confidential

Job Title: System Administrator/Database Administrator

• Monitored servers and workstations, and performed troubleshooting. Configured and maintained Cisco Internet Protocol Television IPTV servers, switches and routers. Monitored Seagate tape backups and performed network printer maintenance. Installed, configured, and supported Linux workstations, ACE/Keon network authentication/encryption servers, Blackberry devices, and more. Facilitated connectivity of SIPRNet and NIPRNet classified and unclassified networks . Installed, configured, and maintained Active Directory.
• Responsible for the support of the system security support and configurations, to include:
• Configuration of systems to meet Certification and Accreditation requirements on classified and
• unclassified networks, and configure IAM in support of C A.
• Support the Lightweight Directory Access Protocol, LDAP support across UNIX/Red Hat
• LINUX systems and implementation of Windows Active Directory AD across network.
• Applying system/software patches in support of OSs used.
• Providing programming and debugging support with PERL, OS Shell scripting Oracle database 11g SQL,
• PL/SQL scripts, Operating system base scripts and various other tools and languages to support Team functions/activities. Running comparison with PostgreSQL and Oracle Databases to evaluate specific needs.
• Established test areas to evaluate use of virtualized Windows workstation within a Linux workstation.

Confidential

Job Title: Oracle Database Administrator

• Maintain functionality of Oracle Database 11g and Application Server in support of the Contract Management System CMS Comprizon Suite Operations Support Team COST Operational/Training and Implementation environments.
• Established and maintained standard operations procedures and policies for installation/operation/maintenance of the Oracle products, which included PL/SQL and operating System scripts.
• Responsibility for maintaining and providing support to the operation of Oracle products and assist the Systems Administrator in functionality of the Oracle Database and Application Server, within the Operating System environments. Agile Scrum approach was used with incremental software development/changes was implemented.
• Configured, with Oracle replication, offsite databases, as temporary failover environments, in anticipation of Oracle Real Application Cluster RAC implementation of future environment.
• Backup System Administrator: Solaris UNIX.

Confidential

Job Title: Oracle Database Developer/Architect

• Move Oracle Database from a MS Windows operating system OS based single instance configuration with DataGuard for data protection/disaster recovery to a Sun Solaris OS based RAC/High Availability HA implementation.
• Provide capability to document current system/database configuration and scripted capability, to include database security issues/requirements, to load database as a structured/ consistent environment into a development/testing/production system.
• Having primary responsibility for implementation of Oracle 10g RAC configuration on a Sun Solaris 10 network, provide input to establishment of requirements for implementation/maintenance of to-be configuration. Collect configuration of as-is system to ensure operations from legacy platform and enhance the operations on the to-be system.
• Supported Oracle replication of current Oracle Databases at two 2 locations in support of failover requirements, until RAC environment is transitioned into production.

Confidential

Job Title: Database Engineer

• Have primary responsibility for the Oracle implementation and, to a limited degree, other RDBMS servers. Major technical duties include installation and upgrade of Oracle products and application system software, monitoring and tuning system performance, establishing user access controls, database security, defining new/modified database tables, and device configuration and planning. Also perform more complex analysis, programming, and implementation of scripts and programs needed in support of applications.
• Provide System Administration and security configuration of Solaris 8/9/10 and Windows XP/2000 and 2003 Server operating systems, in support of organization requirements in support of System Security Authorization Agreement SSAA .
• Providing programming and debugging support with PERL, OS Shell scripting Oracle database 11g SQL, PL/SQL scripts, Operating system base scripts and various other tools and languages to support Team functions/activities.

Confidential

Job Title: Principle Consultant

• Provided expertise in the use of Oracle products, to support customer needs and requirements. Additionally, provides industry-specific technology solutions and business applications implementation services that are designed to address the unique complexities of customers industries.
• Within the US Intelligence Community customer environment, provided the following support: Setup Oracle 10g Servers to support implementation of Oracle Spatial.
• Transported Spatial Data between Oracle Databases. Mapped spatial tablespace, table, and index layouts Configured table and spatial indexes.
• Published SDO GEOMETRY data into Spatial Data. Created PL/SQL scripts to validate data in spatial tables to verify structure and composition.
• Provided Security support to Oracle 10g products in support of system security configuration in support of Director of Central Intelligence Directives DCID 6/3 Protection Level PL 4 certification:
• Provided support to Oracle Team creating the Oracle DataVault predecessor of Oracle Database Vault Product for evaluations, and Certification and Accreditation for use within the Intelligence Community Defined and implemented Oracle Label Security OLS policies. Implemented table partitioning in support of data separation. Also configured IAM requirements.
• Validated configurations and setup of RAC instances in a Solaris environment. Provided and validated test plans. Worked with internal team members to validate a Train the Trainer presentation used to setup a RAC in a Linux environment. Through the use of Virtualbox software, the presentation allows the creation a single node RAC in a virtual Linux environment, resulting in comparison of experience to update/improve the presentation.
• Supported certification of Oracle Database Vault, to include:
• System security configuration, in support of DCID 6/3
• Mapping data in support of Oracle Label Security.

Confidential

Job Title: Database Engineer

• Design and development of Oracle SQL and PL/SQL scripts, PERL scripts and Operating System shell scripts to Extract Translate and Load ETL data from the Defense Security Service DSS Case Control Management System CCMS and Industrial Security System ISS databases for input into Joint Personnel Adjudication System JPAS
• Designed scripts based upon Oracle7 7.3.4.5 database. Performed system/script tuning to enhance the processing time from extract start to finish.
• Created Oracle9i rev2 instance and scripts in order to support a JPAS Changes Only extract. The data from a previous and current JPAS extract was loaded into the Oracle9i tables and compared record values and identify records that had not been sent to JPAS from DSS, or had been changed since last extraction.
• Design and development of Oracle SQL and PL/SQL scripts, PERL scripts and Operating System shell scripts as ETL scripts, which were used to extract data from the DSS ISS and Facility Database FDB
• ETL scripts were used to acquire data from Oracle7 7.3.4.5 and Oracle9i databases and populate into a separate Oracle9i instance for ingestion.
• Designed report, using Oracle 10g Developer Suite Report Builder to identify consistencies and differences in records for Industrial Security Facility records.

Confidential

Job Title: Database Administrator

• Developed and maintained databases to support a Web-Based Certification and Accreditation application:
• Designed database tables for Oracle8i, MS SQL Server version 7 and 2000, IBM DB2 version 6.1/7.1 and MYSQL 4.0.
• Created and supported a MS Access 2000 database, which was used by Security Engineers to load data from MS Excel 2000 spreadsheets.
• Created Visual Basic for Applications code, within the MS Access Database that would populate any and/or all the database systems with the current data.
• Created scripts, which would extract data from the different database version, to confirm the database dictionary for each database supported.