Support Engineer

Clearance Provided upon Request

Professional Summary:

I am a Sr. Oracle Database Engineer with more than 23 years of Oracle experience with a background as a DBA and DB Developer. I have more than 23 years of professional Oracle DBA experience and at least 10 years of PL/SQL Database Development experience. I am very confident developing in PL/SQL. I also have a strong background Perl and Shell scripting. I am familiar with ColdFusion but it has been some time since I have worked with it. I am very open to learning new technologies and contributing on the project. And I enjoy working with new technologies and actually have a 12c Oracle on Linux 7 system configured in my home lab with which I have been working. I am familiar with Data Guard and RAC; and have used them for at least a year. I have strength in Security related activities within several operating systems, to include Windows, Solaris, Linux. Additionally, I work with Windows SQL Server and Oracle environments. I have more than 23 years of Oracle Database Development experience and have recent exposure to NoSQL databases as well.

30+ years in Information Technology, which includes 10+ years of software development, 25+ year’s database installation/implementation, 23+ years of experience implementing Oracle Databases 7.3 to 12c, and 8+ years evaluating and implementing Information Assurance support to government related projects. I have supported Unix/Linux environments, in support of site activities: Solaris 8-10/Linux 4-7

6-months experience with Oracle Identity Access Management (IAM) implementation and configuration over several different companies/projects.

Technical Competencies:

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.

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

Professional Experience:

International Computing Systems, Fort Belvoir, VA

July 2016 – March 2017

Oracle Database Administrator

Meeting enterprise requirements by planning and developing database structure; developing database utilization policies, procedures, security, backup and recovery.

Confirms database requirements by conferring with clients; studying operations and objectives; integrating enterprise requirements; applying database concepts and functional capabilities/

Maintains design structure by developing implementation of SQL standards and guidelines.

Complements platform upgrades and migrations by issuing instructions; monitoring performance; coordination actions.

Maintains data integrity by establishing standards; monitoring performance.

Maintains database performance by developing tuning methodologies.

Provides information by collecting, analyzing, and summarizing database performance and trends

TEKsystems, Washington, DC

February 2016 – March 2016

Oracle Database Administrator

Maintaining, planning, developing, consolidating, managing and administering, and enhancing database applications in Oracle;

Analyzing database requirements;

Designing/redesigning database structures;

Implementing new/redesigned database structures;

Integrating database structures with EPA OIG’s system architecture;

Testing and debugging database structures;

Documenting databases;

Establishing procedures on DB backups, migration, recovery, patches and upgrades;

Implementing data access and security controls commensurate with system requirements.

TEKsystems, Quantico, VA

June 2015 – July 2015

Intelligence Custodian

Ensure the Supply Chain Risk Management (SCRM) data set is maintained and sustained.

Provide continued support to identify, evaluate, and develop emergent technologies and capabilities into the current system creating an ever evolving web-based enterprise.

Provide technical support integrating system security parameters, PKI and other advanced authentications means onto the DoD US enterprise for the SCRM data set

Masy Group, Fort Belvoir, VA

October 2014 – February 2015

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.

ManTech International, Inc., Joint Base Anacostia-Bolling, Washington, DC

August 2012 – May 2014

Database Engineer, Principal

Responsible for the maintenance 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. 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.

Provided admin support to Solaris 9 and Tomcat 3 to maintain site Oracle database front end.

Worked with customer to address a new environment. Provided presentations on Oracle 11c, Oracle RAC supported with Oracle GoldenGate to provide Real-Time Data Integration and Heterogeneous Database Replication.

Aspiration Software, LLC, Chantilly, VA

March 2011 – August 2012

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.

Worked with Senior Government personnel to address acquiring Linux (RHEL Family) to address costs and patching support.

BAE Systems, Newington, VA

July 2010 – March 2011

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.

NJVC LLC, Newington, VA

April 2009 – June 2010

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

Provided system administration for Windows workstations and UNIX/Red Hat Linux systems for configuration and maintenance.

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.

RAC Management Services, Washington, DC

January 2008 – March 2009

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.

PRO-telligent, LLC, Washington, DC

September 2007 – January 2008

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.

SkillStorm Government Integrated Solutions, Newington, VA

February 2006 – September 2007

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.

Oracle Corporation, Reston, VA

June 2004 – February 2006

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 customer’s 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.

Supported training environment (RHEL/Oracle Linux 4).

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.

Titan Corporation, Severn, MD

July 2001 – June 2004

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 the Sybase database - 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.

Xacta Corporation, Ashburn, VA

October 2000 – July 2001

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.

Corbett Technologies, Inc.

November 1999 – October 2000

Senior Information Security Engineer

Development of System Security Authorization Agreements (SSAA):

Reviewed system configurations, connectivity, applications, and security posture.

Wrote SSAAs to support the certification and accreditation of the systems.

Science Application International Corporation

April 1998 –October 1999

Software Engineer

Provided support to Oracle8/8i database projects.

Tasks included creation of database table structures, triggers, sequence numbers, and report formats using Oracle PL/SQL.

Performed a wide variety of assignments concentrating on the software development phase in order to extend the overall technical proficiency and knowledge of the system.

Assisted the INFOSEC software engineers and users with a wide variety of questions and problems.

Troubleshot and diagnosed failures to determine causes.

Developed and maintained complex INFOSEC utilities and diagnostic software.

Performed analysis, architectural design and development, testing, and debugging of INFOSEC software.

Electronic Data Systems

January 1989 – April 1998

Engineer Advanced Systems

Performed a wide variety of assignments, typically concentrating on specific phases of programming that related to database management systems (DBMS) support and DBMS connectivity within a particular system, while expanding overall technical proficiency and knowledge of the system.

DBMSs supported include Oracle 8i, MS SQL Server, Sybase SQL Server 11, MS Access, MS FoxPro, Borland dBASE, and Computer Associates/Nantucket Clipper.

Supported the Defense Information System Agency (DISA) Global Command and Control System (GCCS) INFOSEC Team’s Security Testing and Evaluation of GCCS, version 3.0, with emphasis on the security of the DBMS and DBMS applications.

Developed and wrote a technical report with the GCCS INFOSEC Information System Security Engineering (ISSE) team, in conjunction with the DISA GCCS Engineering Office, that described the target security architecture of the Joint Operations Planning and Execution System (JOPES) Oracle DBMS.

Provided complex analysis, design, development, security implementation, testing, and debugging of DBMSs.

Assisted a diverse population of microcomputer users with a wide variety of questions and problems.

oThe number of users for the supported database projects ranged in size from five to 150 users. Database applications included systems, which collected, processed and reported on the following activities or areas of interest:

oPreliminary Disaster Recovery, Human Resources, Budget, Personnel Skills, Patient Scheduling and Movement, Equipment Order Management, Status Reporting, Work Progress Reporting, and Data Comparison.

oThis support to the various systems included software development, testing support, security access, maintenance of the systems, and troubleshooting and diagnosis for cause determination.

Provided complex analysis, design, development, security implementation, testing, and debugging of COBOL and IBM Financial Control Language (FCL) based financial system applications.

oThese applications ran on Mainframe systems and IBM 4700 Financial Controllers Servers and Workstations.

oProvided troubleshooting and diagnosed failures to determine causes.

Education:

AA, Chemical Engineering and Political Science, Phoenix College, Phoenix, AZ, 1974

Trainings:

Oracle9i DBA Fundamentals II, July 2004

Oracle9i Database Security, August 2004

Oracle9i Advanced Replication, October 2004

Oracle Database 10g Administration Workshop 1, October 2005

Oracle Database 10g Administration Workshop 2, October 2005

Oracle Spatial 10g Fundamentals, October 2005

IBM Server, 04/95

Microsoft Access, 2.0, Intermediate Programming, 03/95

Microsoft Access, 2.0, Advanced Programming, 03/95

National Cryptologic School, National Info Sec Course, 09/94

Database Modeling, 06/93

UNIX Systems Administration, 04/93

UNIX Shell programming, 02/93

Contact this candidate