SUMMARY

• Sr. Oracle developer experienced in Oracle development tools and technologies related to PL/SQL development, application UI design, Oracle schema/application modeling, and Oracle Forms/Reports
• Demonstrates experience in application design, data modeling, writing and tuning SQL, coding Oracle packages used with .Net and Java applications, database server migrations, UNIX scripting, and Oracle database administration
• Sr. Oracle DBA experienced in managing Oracle database environments both in development and in production systems running on AIX, Linux, Solaris, and Windows platforms
• Has experience in working with Oracle products, including database and development tools for 18 years

TECHNICAL SKILLS

• Oracle Database 8i, 9i, 10g, 11g, 12c (AIX, Solaris, Linux, Windows)
• Unix shell scripting, ETL scripting using SQL and PL/SQL
• Oracle Developer Forms - Fusion Middleware / Oracle Reports version 6i, 10g, 11g
• Oracle SQL Plus, PL/SQL, RMAN, Oracle Grid Control, OEM, Data Guard, TDE
• Oracle server builds for production & development implementations
• Database related third-party products: T.O.A.D.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Oracle Developer

Responsibilities:

• Develop and support Oracle schema modeling, PL/SQL procedure development for Data Quality Portal/Rave Systems, Managed Accounts support and other enterprise support functions
• Developed and maintain an application in support for extracting Rave audits in XML format and populating a data warehouse for a .Net application
• Developed data model, views, object types, packages, and reports
• Developed packages used by the application in support for API functionality
• Developed and maintain an application in support for account management for Windows and Oracle database accounts
• Create Linux shell scripts for environment support functions and programs
• Recommend and demonstrate SQL tuning and application query tuning techniques against Oracle database

Confidential, Washington, DC

Oracle Database Engineer

Responsibilities:

• Support FAA NISC III contract application with regards to Oracle database development, server architecture, and application interactions with the database.
• Support and implement PL/SQL development
• Oracle technology support lead for development team and FAA contract partners
• Application schema development & data warehouse modeler
• Implemented a database migration from 10g (10.2.0.4) to 11g (11.2.0.3)
• Implemented Oracle BI Discoverer 11g using Weblogic Server and Oracle Virtual Private Database (Fine Grained Access Control)
• Designed a data warehouse schema and ETL using SQL, PL/SQL for contract reporting needs
• Application support for production processes
• Support developers with SQL construction and tuning
• Provides guidance on implementation for backup and recovery procedures

Oracle Database Administrator

Confidential, Arlington, VA

Responsibilities:

• Coordinate project deployments related to Oracle Database Server, Oracle Application Server and Oracle Portal technologies
• Install, configure and maintain Oracle Database Server, Oracle Application Server, OID, and Oracle Portal systems
• Oracle database/OAS/OID/Portal systems integrity checks & process support
• Perform Oracle service backups and establish recovery procedures.
• Extensive knowledge of the Oracle Grid Control & (OEM) software to monitor instances and scheduled various database and application jobs across multiple database servers.
• Oversight and management of Oracle environments running AIX, Solaris, Linux, and Windows platforms.
• Support PL/SQL, Java, and Portal developers in achieving their deliverables
• Participate in Architectural Control Board meetings for environment capacity planning.
• Create Unix shell scripts as needed for environment support functions

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured and maintained Oracle development & production database services.
• Extensive knowledge of the Oracle Management Server (OEM) software to monitor instances and scheduled various database and application jobs across multiple database servers.
• Supported system developers with designing, tuning and deploying schemas.
• Supported system developers with Oracle Forms, Oracle Reports and PL SQL.
• Created and maintained (SQL Plus and/or RMAN) cold backup, hot backup and full export routines for database recovery.
• Created installation and operational checklists as required.
• Maintained database environments on Windows, Linux and UNIX

Senior Systems Developer

Confidential, NC

Responsibilities:

• Develop web enabled/client server Oracle applications using Oracle Forms, Oracle Reports and PL/SQL.
• Performed project manager responsibilities for production rollout and upgrades.
• Designed Oracle application data and security models.
• Designed Oracle database schema objects such as tables, indexes, synonyms, database links, packages, procedures, and views.
• Provided technical support for other development groups as required.

Oracle Application Developer

Confidential, NC

Responsibilities:

• Developed web enabled/client server Oracle applications using Oracle Forms and Reports.
• Create Oracle database objects such as tables, table indexes, synonyms, database links, procedures, and views.
• Provided technical support for other PPD Oracle applications as required.

Confidential

Data Warehouse Developer

Responsibilities:

• Write Oracle PLSQL code in stored procedures or external scripts as needed that will be used for reporting needs and populating data warehouses.
• Create Oracle database objects such as tables, table indexes, synonyms, database links, procedures, and views that will support data warehouse and reporting efforts.
• Submit database schema enhancements as needed to improve database content and database design.
• Created SQL and PL/SQL for ETL data warehouse needs
• Responsible for developing and documenting reports for use in production, sales, and finance. Determined current reporting data elements and formats by interviewing end users.