RONALD T. RAIGRODSKI

**** ******** *****, *****

Baltimore, Maryland 21209

410-***-**** (H) 301-***-**** (W) 443-***-**** (Cell)

Email: ac4ckb@r.postjobfree.com

Education University of Maryland, Baltimore County – B.S. Computer Science (1983-1986)

Security

clearances TS (SCI eligible - adjudicated at DHS/Coast Guard, January 2014)

Work 11/2017 – Present: Software Developer/Administrator: Engility Corporation

experience Oracle Database Developer on United States Army Contract

Providing database and IA support for the SATCOM Army contract.

1/2017 – 11/2017: Senior Database Developer/Administrator: ManTech

MS SQL Server Database Administrator on United States Army Contract

Providing database support for all IA activities on my current Army contract. Responsible for resolving vulnerabilities issue that are associated with MS SQL Server.

Assisting on completing open checklist database items that arose from scanning systems ManTech is supporting for U.S. Army

7/2016 – 1/2017: Senior Database Developer: Insight Global

Oracle Database Developer on United States Army Contract

Using Oracle PL/SQL to modify and enhance the current EKMS application. After analyzing the requirements, I used PL/SQL to modify database packages and procedures as needed. Developed enhancements using the SCRUM/AGILE methodology.

After reviewing requirements, coded various PL/SQL procedures, functions and packages. Changed queries using PL/SQL that were working incorrectly and/or running slow.

Enhancements and modifications were completed on time during our two week sprint cycle. Code was unit tested and peer reviewed before getting checked into CM.

I used SQL Navigator as the development in an Oracle 11G environment. I used PVCS for checking code in to CM and used MERANT Tracker to document changes made to the system

6/2015 – 7/2016: Senior Principal Analyst, Systems: General Dynamics Information Technology

Senior Application Developer on CMS/DECC Contract (No Clearance Required)

Designed and Developed enhancements to current Oracle application by creating SQL scripts and modifying PL/SQL Packages using AGILE/SCRUM methodology.

Changes were made to the current Oracle 11G database using the SQL Developer tool.

Created DDL scripts to install various code and data changes for our Sprint items.

6/2013 – 6/2015: Senior Principal Analyst, Systems: General Dynamics Information Technology

Oracle and MS SQL Server Database Developer on United States Coast Guard Contract (DHS)

Improved system performance significantly by modifying PL/SQL packages and procedures to eliminate the use a large table and its indexes.

I used TOAD and Oracle Developer tools to code changes in our Oracle 11G Database.

Analyzed the Coast Guard’s Maritime Global Awareness Network (MAGNET). Identified many significant data issues with MAGNET’s search capability. Researched PL/SQL database packages and documented methods to improve the system’s data integrity

Completed data extracts for Coast Guard users using TOAD, PL/SQL and MS SQL Server.

I coded various procedures and triggers using MS SQL Server T-SQL to load various data files into the Oracle 11G Database.

11/00 –5/2013: Senior Software Engineer: Science Applications International Corp

Database Developer/Administrator on Department of Defense Contract (4/2011–5/2013)

Created a data warehouse by writing stored procedures written in PL/SQL to extract data from division’s legacy system into a new Oracle data warehouse

Developed modern user interface using ColdFusion to access data warehouse and Adobe Flash/Flex to present results of user queries

Supported both Oracle and MS SQL Server databases

Ensured that jobs and backups ran successfully and data were properly loaded

Database Developer/Modeler DM Team for a Department of Defense Contract (6/2009–4/2011)

As a database engineer, I created SQL scripts in a Sybase environment running on Sybase IQ server in order to support the development of data warehouse

As a data modeler, I analyzed several data sources to create Entity Relationship Diagrams as well as logical and dimensional data models using Power Designer

Generated SQL scripts/queries to ensure data were being stored correctly in the warehouse

Database Developer/Administrator (8/2008–5/2009)

Provided database and software support on a DOD contract

Helped maintain the proper functioning of various Oracle 10.2 Databases

Created several new Oracle DBs to support the agency’s mission

Developed new SQL scripts to support the cleanup of data and new prototypes

Modified PL/SQL programs to support the database statistics report used by several users

Completed modifications to PL/SQL programs and functions to improve system performance, support a prototype application, and add auditing of long-running queries.

Utilized TOAD, SQL Developer, and Oracle Enterprise Manager to assist daily activities

Database Developer and Software Engineering Team Lead (11/2000 – 6/2006)

Supported and assisted the DSS project with both software and database development

Developed PL/SQL code and database SQL scripts against the Production Oracle database

Created SQL scripts for complicated queries involving multiple tables for extracting data from the Case Control Management System (CCMS) to the Joint Personnel Adjudication system

Designed database tables used in the extraction of data from CCMS

Developed AD-HOC scripts for several different Data Manipulation functions, including reports and data extract requests from other agencies against a DOD Oracle database

As a team lead, I was responsible for software issues regarding the Workflow part of CCMS:

Software enhancements to improve system performance

Modifications to add functionality and to fix problems with the CCMS application

Reverse engineering the scoping subsystem of CCMS

Utilized the following technologies: PL/SQL, Oracle Forms 4.5, Visual Basic, UNIX, Unified Modeling Language (UML), and Rational tools (i.e., CLEARQUEST, Rational Rose) and Visual SourceSafe.

Supported the move of the data retention activities to Boyers, Pa. by developing new SQL scripts, modifying PL/SQL and Visual Basic programs, providing Oracle DBA support and providing documentation and training to the staff at the facility in Boyers.

3/00 – 11/00: Senior Software Engineer: General Research Corporation International (GRCI)

Maintained and developed code for the Defense Security Service (DSS) - Case Control Management System (CCMS) using Oracle Forms and PL/SQL

Responsible for back-end enhancements and screen modifications (used Oracle Forms V4.5)

Developed PL/SQL procedures in development of new fingerprint program for DSS

2/97 – 3/00: Senior Software Engineer: Ryland Corporation

Developed and maintained database applications using Progress, Oracle, and Microsoft Access to support several applications within the Mortgage Operations of Ryland Corporation.

As a member of the development team, assisted in creating a new loan origination system using Progress User Language. In addition, developed SQL scripts for a new data warehouse and modified the MS Access Forms using Microsoft’s VB for applications.

Formal –Oracle Database Administration I &II (2007-2008)

training –Implementing MS SQL Server Database (2009)

–Data Modeling with Power Designer (2011)

certifications CompTIA Security+ (2017)

computer

proficiency Software:

Application Packages: Adobe Flash/Flex, MS Access, Oracle Enterprise Manager, Oracle Forms, Oracle Reports, Toad, SQL*Plus, Rational Rose, Rational CLEARQUEST, Visual SourceSafe, Erwin

Databases: Oracle, MS SQL Server, Sybase, Progress, Model 204, Microsoft Access

Programming Languages: PL/SQL, ColdFusion, SQL, Transact SQL, Visual Basic

Contact this candidate