Resume

Sign in

Oracle Developer

Location:
Suwanee, GA
Salary:
105000.00
Posted:
January 12, 2020

Contact this candidate

Resume:

Tony Daniel Reeves

**** ********** ******

Suwanee, GA 30024

CELL: 678-***-****

EDUCATION

Georgia State University, Atlanta, GA

Bachelor of Business Administration, Finance /Computer Information Systems

Montgomery College, Montgomery, MD

Java Programming Language: Montgomery College, winter 1999;

Advance Java Programming Language: Montgomery College, fall 1999

Unix/Linux: Montgomery College,

Certification:

Oracle Certified Associate (OCA) Database Administration: June 2003

Oracle Certified Professional (OCP) ) Database Administration: December 2003

Oracle Database Administration Training:

Data Modeling: Oracle Corp, Tyson, VA August 1997;

DBA II: Oracle Corp, Portland, OR. December 1995;

ENTERPRISE DBA PART 1A: Architecture and Administration: Oracle Corp, Jan 2001;

ENTERPRISE DBA PART 1B: Backup and Recovery: Oracle Corp, Jan 2001;

ENTERPRISE DBA PART 2: Performance and Tuning: Oracle Corp, Feb 2001;

ENTERPRISE DBA PART 3: Networking Administration: Oracle Corp, Feb 2001;

DISTRIBUTED SYSTEMS PART1: Distributed Database Implementation: Oracle Corp, Dec 2001;

DISTRIBUTED SYSTEMS PART2: Advance Distributed Database Implementation: Oracle Corp, Dec 2001;

Oracle 9i Database Administration Fundamentals II: Oracle Corp, May 2002;

Oracle 9i Database Administration Fundamentals I: Oracle Corp, May 2002;

Oracle 9i Performance Tuning: Oracle Corp, May 2002;

Oracle 9i Real Application Clusters: Oracle Corp, April 2004;

Oracle 9i Oracle Security: Oracle Corp, June 2004

Oracle Developer Training:

Introduction to ORACLE for Programmers: Oracle Corp, Atlanta, Georgia. October 1988;

Developer 2000 Forms 4.5: Oracle Corp, Portland, OR. December 1995;

Oracle 9i SQL Introduction: Oracle Corp, Bethesda, Maryland May 2002;

Oracle Java Training:

Object-Oriented Analysis and Design using Unified Modeling Language: Oracle Corp, MD May 1999;

Java Programming for Oracle Developers: Oracle Corp, Bethesda, MD May 1999;

Java Programming Language: Montgomery College, winter 1999;

Oracle Application Server: Develop Web-Based Applications with Java, Oracle Corp, MD July 1999; Develop Database Applications with Java, Oracle Corp, MD July 1999;

Advance Java Programming Language: Montgomery College, fall 1999;

Oracle Case Training:

Designer 2000 System Modeling and Tools: Oracle Corp, Denver, CO. June 1996;

Designer 2000 Build Database Objects: Oracle Corp, San Francisco, CA. June 1996;

Designer 2000 Building Database Applications: Oracle Corp, Bethesda, MD September 1996;

Oracle Webserver System Administration: Oracle Corp, Bethesda, MD April 1997;

Oracle Webserver Develop Advanced Web Applications: Oracle Corp, Bethesda, MD April 1997;

Designer 2000 Developing Web Applications: Oracle Corp, Tysons, VA April 1997;

RedHat LINUX Training:

Course 133: Linux Administration: RedHat, Washington D.C. May 2003

Professional MS SQL Server Database Administration Training and Performance Tuning.

SUMMARY

Oracle Developer & DBA with extensive software development experience supporting analysis, design, build, testing, implementation, installation, and configuration of Oracle RDBMS systems

Extensive experience coding in PL/SQL, Stored procedures and function using advanced features; current releases of Oracle RDBMS supported are 9.2.0.6, 10.2.0.4, 11gR2 and 12c.

Extensive experience providing Oracle DBA support to development, QA and production environment; Database Administrator responsibilities includes installation, upgrade, patch, migration and conversion. Possess strong database and application-side performance tuning skills.

Some development experience supporting n MS SQL Server 2005, 2008 and 2012.

Experience as data modeler conducting analysis and design to flush data model requirements through the conceptual, logical and physical database design phase to support scalable systems.

Experience with supporting functional requirements, CRUD/IRUN, data dictionary, and performance tuning of Oracle (SQL) relational database applications on Windows, UNIX, Linux environments

Experience leveraging Oracle Designer, Erwin and PowerDesigner to create conceptual, logical and physical database designs for OLTP/OLAP application.

Experience using Toad, Oracle Developer, RMAN, Export/Import, DataPump, Oracle RDBMS versions 5 through 12c, Pro*C, Java, C/C++, Oracle Web Server, Oracle Enterprise Manager, AWR, RDS, S3 – preparing for AWS Certified Solutions Architect – Associate 2019.

PROFESSIONAL EXPERIENCE

APPSYS/SWIFT, MANASSIS, VA September 2019 – Current

Oracle Developer

Contractor to SWIFT Message Service Store and Forward. Supported the fall back plan for RMA. Supported Oracle partitioning. Supporting enhancements to message retrieval for protocol level 3 and higher. Support the analysis of obsolete code from table columns to api layer.

MERIDIAN STAFFING SERVICES/DUKE ENERGY, Charlotte, NC November 2018 – May 2019

Oracle Developer

Contractor to Duke Energy supporting iTOA TEAM for Carolina. Supported the validation scripting for table row counts and business rule to identify defect using PL/SQL. Supported the Oracle Common Code initiative for Mid-West, Florida and Carolina Oracle production system. Developed reporting structure that accommodate and show comparison between three schemas simultaneous and highlight difference in table row counts and object lists across schema boundary.

Extensive coding in PL/SQL, Stored procedures and function using advanced features, current releases of Oracle RDBMS supported using 12.2.0.1.0.

ROSE INTERNATIONAL/UPS, Alpharetta, GA May 2018 – September 2018

Oracle Developer & DBA

Contractor to UPS Supply Chain Solution supporting FGV. Supported 315, SM220, CM236 and CM237 data loads using PL/SQL. Supported WSGL PL/SQL Packages when contract terminated.

Extensive coding in PL/SQL, Stored procedures and function using advanced features, current releases of Oracle RDBMS supported using 12.0.1 and 12.0.2.

VEREDUS CORPORATION/GTRI, Atlanta, GA Jun 2015 – May 2018

Oracle Developer & DBA

W2 employee contractor of Veredus serving GTRI as Database Engineer in the Cyber Technology and Information Security Lab (CTISL).

Responsible for writing SQL queries, performance tuning, coding packages, procedure and functions that support new features and/or bug fixes for multiple applications.

• Support DBA task by developing automated solutions and/or researching and utilizing existing Oracle tools that provide a solution once scripted.

• Evaluate code developed by other colleagues and communicate recommendations and potentially decline work.

Test creating an Oracle database using AWS RDS.

Heartland/Ovation Systems, Alpharetta, GA July 2014 – March 2015

Oracle Developer & DBA

Responsible for writing PL/SQL queries and stored procedures against production Oracle database environment in response to questions from internal business community and development team.

Support the role of Oracle DBA in 24X7 environment

Serve operations and development management team on application and database performance tuning matters.

Proto-type partitioning scenario against HOPS largest table of 60 Gig and tune all dependency related stored procedure queries.

As result of tuning analysis and findings on partitioning will help guide management to make more informed decisions regarding the proper use of Oracle

McKesson Corporation, Alpharetta, GA June 2011- April 2014

Oracle Developer/DBA

Responsible for providing Oracle PL/SQL development, Stored procedures, and DBA support to multiple scrum teams on HzERM project

Conduct data analysis of HzERM database structures and develop data integrity clean-up scripts intended for deployment at customer sites.

Utilize Erwin to review HzERM database design of bed management and other functional areas.

Provide on-call support on-rotation and supported Oracle database cloning and upgrade request.

Supported daily database build process and upgrade/patch process internally using Oracle PL/SQL and shell scripts.

MS SQL Server 2005, 2008 and 2012/Engineer 2.5 years

Supported SQL Engineer role on Paragon project. As SQL Engineer I coded database-side using T-SQL to create API layer for the .net and PowerBuilder Web and client-side Hospital systems.

Supported Rules Engine project which is a customized rules-based product required to support government mandated initiative to facilitate meaningful use throughout patient care process, while utilizing customized rules stored within a BizTalk database.

Developed SQL Audit approach for Auditing PHI data using Broker Service External Activator to propagate messages from a generic trigger that adapts to any table and ETL stored procedures dynamically interact to changing message propagated by table events.

Participant at Microsoft Performance Tuning LAB in Charlotte NC for Rules Engine and Audit PHI DATA.

Ericsson, Duluth, GA March 2011- June 2011

Oracle DBA/Database Developer/ Modeler

Provide Oracle DBA/development support for multiple scrum teams at Ericsson, coding in PL/SQL and performing stored procedures.

Support the design, build and unit test phases of AMS REORG and CONVERTDB utility to facilitate and resolve emergency scenarios that occurred on production AMS servers.

Both, AMS REORG and CONVERT DB was coded utilizing a combination of shell scripting and PL/SQL language to extend functional life of black box systems that supported movie-on-demand services.

Provide emergency production support to Ericsson most valued customers like Comcast and Verizon. Support application and database tuning of AMS for production customers and development.

VCG, Roswell, GA Dec 2005-Feb 2011

ORACLE Developer/DBA/ Modeler

Oracle PL/SQL developer, DBA and data Modeler for VCG StaffSuite product

Support rapid-iterative development environment, support QA deployment and provide database production support

Support and maintained server-side PL/SQL coding of Vertex, GL packages, GL Predictability, Eligibility, Nightly Processes and Lockbox.

Maintain and develop database server-side installer software that is used to support New Install, Upgrade, and Patch process used for development, QA and customer production environments.

Develop database-side installer software and appropriate documentation used by VCG support team to upgrade and migrate StaffSuite customers from Oracle RDBMS 9i to 10g 10.2.0.28. Develop and document Oracle backup and recovery procedures leveraging Oracle Export/Import, Oracle Data Pump and RMAN in support of multiple Oracle homes.

Pursued best practices and guidelines to identify and improve StaffSuite performance. Significant performance improvements realized through a combination of tuning high cost SQL, re-normalization, indexing, code re-engineering, and proper Oracle database installation and configuration.

MS SQL Server/Engineer 2.5 years

Support conversion of Oracle PL/SQL to SQL Server T-SQL

Provide development support for SQL Server 2000/2005 and code control process for Pointwing.

Participant in loadrunner testing effort to performance tune database by identifying high cost SPROCS and tuning.

Identified duplicative SPROC calls generated by application during pre/post phase of update.

Refactored anonymous calls generated by application and converted to tuned sprocs based on dynamic SQL.

Support database-modeling task using Power Designer

Power Designer and utilized for generating DDL for physical database and generate application-side persistence layer.

DDL is generated for new install, upgrade and patch releases of StaffSuite. Both, DDL and data changes for StaffSuite is carefully managed under software control and well defined proven processes that guarantee consistent and accurate back-end deployment.

Support VCG support teams in troubleshooting Oracle database production issues and develop Hot Fixes.

Support physical database conversion of StaffSuite from Oracle to SQL Server 2005 and reverse engineering tasks

Custom Software Development, Inc (CSD) /Pentagon Feb 2006-Dec 2006

ORACLE PL/SQL Developer / DBA/Data Modeler

Provide part-time support as Oracle Database Administrator/Data Modeler to Lockheed Martin OASD (PA)

Custom Software Development/Lockheed Martin/Pentagon June 2005 - Dec 2005

Oracle Consultant

Supported Oracle database migration from Oracle 8i and 9i RDBMS servers operating on Solaris and Windows to Oracle 10g RDBMS release 2.

Maintain Oracle Forms/Reports applications that support operations for Pentagon Office of Public Affairs.

Custom Software Development/NEWGEN/ EDS, VA July 2004 - May 2005

Oracle Consultant

Provide support for EDS/VA My HealtheVet project as an Oracle Database Administrator/Data Modeler.

Supported 8 instances of Oracle 9i that serve development, system test and user acceptance and test environment.

Provided routine database maintenance responsibilities, installation, configuration and patching as required.

As database Developer/ modeler, produced logical and physical database design to support information requirements for My HealtheVet project.

Supported 100% of back-end development of API using PL/SQL, cron job initiated reporting and synchronization between Oracle and LDAP Directory Server. Facilitated data modeling and JAD sessions; provided estimates and supported design and build scripts.

Custom Software Development/ProObject/FDA DARRTS Dec 2003 - May 2004

Oracle Developer/ DBA

Database Engineer to produce conceptual, logical and physical database design to support information requirements for FDA DARRTS project through ProObject.

Nextel Aug 2003 - Nov 2003

Oracle Developer/ DBA

Provided Development /DBA/data modeling support to multiple projects associated with Telco Data Warehouse.

Utilized Oracle Designer to create conceptual, logical and physical database design for multiple data warehousing projects.

Engaged on sideline projects installing Oracle 8.1.7 and Oracle 9i RDBMS, Oracle Designer and Oracle Application Server on Windows and Red Hat Linux 2.1 AS.

Custom Software Development/USGS Aug 2002 - May 2003

Oracle Developer/ DBA

Support Oracle development using Oracle CASE technology and DBA support with USGS to support BASIS+ project.

Responsible for day-to-day operations related to achieving software maintenance deliverable goals and customer guidance. Hands-on experience with performance-tuning Application and Database, enhancing PL/SQL Web Modules to satisfy performance objectives, troubleshooting Application, Middle Tier and Database issues, streamline procedures to improve quality control and improve efficiency.

BASIS+ application is based on Oracle PL/SQL Web technology, generated using Oracle Designer, hosted via 9iAS and Oracle 8i RDBMS.

NFR March 2001 - May 2002

Oracle Database Consultant

Provide Oracle database development, DBA and database design support for NFR Security project.

Supported installation, configuration and maintenance of Oracle RDBMS version 8.1.7 and Oracle 9i AS operating on Red Hat Linux, Solaris and Windows 2000 Server.

Installed, configured, and maintained Oracle Designer 6i and Developer 6i tools utilized for analysis, design and build of Rosie, Vulnerability and NFRDB Enterprise system.

Sole responsibility for conceptual, logical and physical database design of Rosie, Vulnerability, and NFRDB Enterprise system.

Designed, built and hosted Rosie and Vulnerability web-enabled application; 100% generated applications using Designer 6i.

Created installation and tuning documentation for NFRDB Enterprise system. Supported typical Oracle DBA responsibilities.

RADOS, Inc. February 1999 - February 2000

Support to Nuclear Power customers

Supported Oracle RDBMS installation and configuration to four servers, two Reader servers, and client workstations

Supported installation, configuration of Oracle SQL Net and proprietary application software, and supported performance-tuning responsibilities of database and on-going support to RADOS.

AT&T 1999 – 2000

Oracle Database Consultant

Responsibilities involved analysis, design, and build utilizing Oracle Designer version 2.1.2.

Support conceptual, logical and physical database design requirements for Property Accountability.

Supported 100% generation method to generate client and server side build of Property Accountability utilizing Oracle Designer 6i.

Prior Experience on Request

UNISYS project February 1998 - June 1998

Designed and built an Oracle Web Server application "DLAMP"

Installed and configured development environment using Oracle RDBMS 7.3.2.3.1, Designer 2000 1.3.2 Database Repository, and Oracle Web Server 2.1 on Windows NT

Leveraged 100% generation from Oracle Designer 2000 tool

Supported role of Web Database Application Developer, and supported 100% of DBA responsibilities

Produced application and installation documentation, plus providing installation support of DLAMP for UNISYS customer

National Computer System, Englewood, Colorado June 1988 - August 1989

Support National Computer System in maintenance work on a Student Loan Portfolio System. Specialized in design, development, and maintenance using SQL*Forms, SQL*Plus, and SQL*Reports. The development platform was a 386 microcomputer operating under SCO Xenix System V and ORACLE RDBMS version 5

The Maxim Group, Rockville, MD July 1997 - February 1998

Assigned to provide full life-cycle development support for Data Tracking Services, Inc. Tasked to complete a two-to-four month project involving full life-cycle development utilizing Designer 2000 to build client server and Oracle Web Server 2.1 application to support business operations for a start-up company

Installed and configured development environment using Oracle RDBMS 7.3.2.3.1, Designer 2000 1.3.2 Database Repository, and Oracle Web Server 2.1 on Windows NT

Captured and documented requirements of two hundred entities and domains, one hundred plus business functions, and associated CRUD and IRUN during conceptual modeling

The Registry, Rockville, MD. November 1996 - July 1997

Support OAO development effort of the Fleet Logistics System (FLS) for US Coast Guard. Developed the quality assurance check list/guide to support OAO's effort to complete analysis

Developed Requirement Management System (RMS), which associates Designer 2000 Repository Objects and Properties to CASE Reports and CASE Tools, and their association to customer requirements like "Military Standard 498". RMS provided OAO a standard, a methodology, from which to approach analysis, design and build for FLS. In conjunction with OAO and SSI

Assisted with the development and documentation of OAO's methodology and approach using RMS, as proof of concept

Pacific Data Group, Portland, OR July 1996 – September 1996

Support application conversion from Access to Oracle for Wells Fargo Bank and affiliates. "NASCAR" system generated vendor route schedule, and instructs vendor on task to perform per stop

Installation, configuration and Database Administration task associated with Oracle 7.2.2.4 on Windows NT, plus installation and configuration of Designer/Developer 2000 tools for client workstation

Supported analysis, design and build, and produced and maintained conceptual, logical and physical models using Oracle Designer 2000

Responsible for conceptual, logical and physical database design, performance tuning and capacity planning estimates

Pacific Data Group, Portland, OR September 1994 - April 1996

Support Standard Insurance Company Retirement Investment Division on Oracle project to provide daily management of equity and guarantee funds a portfolio management system

Built Unitization Engine and Quarter Close System using Stored Objects (i.e. Oracle Procedures and Functions, SQL, PL SQL and Unix Script's)

Designed and generated Oracle reports to support auditing and customer financial statements using SQL Reportwriter 1.1.

Built debugging tools using Oracle Forms 4.5 and Oracle Reports 2.5. Supported system and integration testing

Development environment represents a mixture of host base and client server technology using MS Windows 3.1 and SoftTerm to interface with Sequent and Mainframe

Comsys, Idaho Falls, ID July 1994 – September 1994

Support Halliburton NUS on Oracle project developing of a Radiological Data Management System for the Nuclear Power Industry

Design and build of Signature Control Module and Permits Module

Comsys/American Management System May 1992 - June 1993

Support American Management System tasked with Oracle development project for the Saudi Air Defense Force Institute

Development of TARS "Training Assessment and Recording System" using SQL*Forms 3.0 and Oracle RDBMS Version 6

Supported unit test operations in Saudi Arabia.

Booz, Allen and Hamilton, Bethesda MD, October 1991 - April 1992

Support research funding project as Oracle DBA for Air Force International Research Institute of Technology.

Supported the recommendation of a single vendor technology platform versus high utilizing high maintenance cost utilization of continued use of Oracle on Wang technology platform.

Parsons Management Consultants, Washington DC, October 1990 - September 1991

Support a consortium of four construction manage entities involved in new construction at Dulles Airport and maintenance and renovation at National Dulles Airport. As Oracle DBA/Technical Lead/Forms and Report developer my involved included assembling software development team and supporting new software development to consolidate, control budget and costs.

Municipal Gas Authority, Marietta, GA October 1989 - October 1990

Support a new pilot project by developing the system process that support supply and collective purchase of natural gas as a State Municipality.

Supported the role of Oracle DBA and Forms/Report Developer for a project design and specifications from an unknown source.

CAD Information Systems Inc., Englewood, CO. September 1989 - October 1989

Support CAD Information System as Oracle DBA and Forms/Report Developer by converting a Manufacturer of Parts system to Oracle.

National Computer System, Englewood, Colorado June 1988 - August 1989

Support National Computer System conducting maintenance and new development on a Student Loan Portfolio System. Specialized in design, development, and maintenance using SQL*Forms, SQL*Plus, and SQL*Reports. The development platform was a 386 microcomputer operating under SCO Xenix System V and ORACLE RDBMS version 5

Previous Work History

Support US Sprint transition process to all-fiber network as DBA engineer.

Supported DaVox proprietary voice recognition software via testing.

Supported Scan Atlanta optical recognition and printing as C developer.



Contact this candidate