SUMMARY:

Sr. Database Management Engineer, Sr. Oracle Application DBA, Sr. Oracle Developer, Oracle Application DBA, Oracle DBA, Oracle Sr. Developer, Data Architect.

TECHNICAL SKILLS:

• Oracle 12c
• Oracle 11i
• Oracle 10g
• Oracle 9i
• GoldenGate
• RAC
• RMAN
• Oracle Enterprise Manager (OEM)
• Oracle 8.9i
• Data Modeling
• Database Design
• Designing RDBMS from Logical to building the Physical
• Toad
• PL/SQL
• PL/SQL Developer
• SQL
• SQL Programming
• Sq lDeveloper
• Visual Basic.Net
• Visual Basic
• Microsoft Office XP
• Microsoft Office Excel
• Microsoft Access
• Tuxedo
• MQ Series
• C
• PRO*C
• C++
• HTML
• Java J2EE.

PROFESSIONAL EXPERIENCE:

Confidential, O'Fallon, IL

Sr. Database Management Engineer

Responsibilities:

• Responsibilities include the design, implementation & maintenance of clustered database systems using Golden Gate, RAC, RMAN and PLSQL code development and scripting for Gates Military TRANSCOM System for Scott Airforce Base. Investigated source systems to locate & understand existing data.
• Troubleshooting for data & Production/Staging database issues. Performed Oracle Quarterly Critical Patching (CPU) for Solaris, Linux and Windows Systems.
• Created documents & coordinated script deployments with Data Operations & Enterprise DBA team.
• Monitored & maintained the integrity of database system - Test & Development. Assisted developers in resolving their production issues, performed application code reviews.
• Set standards, procedures & policies for the movement for database development source code to production.
• Responsibilities include the design, implementation & maintenance of multiple databases systems.
• Performed database refreshes for test and development databases.
• Performed Exports and Imports. Monitored and resolved Golden gate issues.
• Responsible for achieving results, overcoming obstacles & resolving production issues in a timely manner. Thorough understanding of the software lifecycle & relevant software methodologies used in software development. Developed Oracle PL/SQL stored procedures, functions, packages, triggers, mergers & database scripts. Developed Oracle Data Definition Language (DDL) & Data Manipulation Language (DML) scripts. Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance. Created new database structures & database objects. Modified existing databases structures & database objects. Self-starter: ability to work independently.

Confidential, St. Louis, MO

Sr. Oracle Application DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases systems for the Multiple Large Financial Corporations
• Performed database refreshes for test and development databases.
• Performed Exports and Imports.
• Responsible for achieving results, overcoming obstacles & resolving production issues in a timely manner. Thorough understanding of the software lifecycle & relevant software methodologies used in software development. Developed Oracle PL/SQL stored procedures, functions, packages, triggers, mergers & database scripts. Developed Oracle Data Definition Language (DDL) & Data Manipulation Language (DML) scripts. Analyzed tables, tablespaces, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance.
• Created new database structures & database objects. Modified existing databases structures & database objects.
• Responsibilities include the design, implementation & maintenance of multiple databases and PLSQL code development for Financial Service Systems.
• Investigated source systems to locate & understand existing systems. Troubleshooting for data & Production/Staging database issues.
• Created documents & coordinated script deployments with Data Operations & Enterprise DBA team.
• Monitored & maintained the integrity of database system - Test & Development.
• Set standards, procedures & policies for the movement for database development source code to production.
• Self-starter: ability to work independently.

Confidential, O'Fallon, IL

Oracle Application DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases and PLSQL code development for ISDDC Military TRANSCOM System for Scott Airforce Base.
• Investigated source systems to locate & understand existing data.
• Troubleshooting for data & Production/Staging database issues.
• Performed Oracle Quarterly Critical Patching (CPU) for Solaris, Linux and Windows Systems.
• Created documents & coordinated script deployments with Data Operations & Enterprise DBA team.
• Monitored & maintained the integrity of database system
• Test & Development.
• Assisted developers in resolving their production issues, performed application code reviews. Set standards, procedures & policies for the movement for database development source code to production.
• Responsibilities include the design, implementation & maintenance of multiple databases systems.
• Performed database refreshes for test and development databases.
• Performed Exports and Imports. Responsible for achieving results, overcoming obstacles & resolving production issues in a timely manner.
• Thorough understanding of the software lifecycle & relevant software methodologies used in software development.
• Developed Oracle PL/SQL stored procedures, functions, packages, triggers, mergers & database scripts.
• Developed Oracle Data Definition Language (DDL) & Data Manipulation Language (DML) scripts.
• Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance.
• Created new database structures & database objects. Modified existing databases structures & database objects. Self-starter: ability to work independently.

Confidential, O'Fallon, IL

Oracle Application DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases (12) and PLSQL code development for IBS Military TRANSCOM System for Scott Airforce Base.
• Investigated source systems to locate & understand existing data.
• Troubleshooting for data & Production database issues that were backlogged. Created documents & coordinated script deployments with Data Operations & Enterprise DBA team.
• Monitored & maintained the integrity of database. Performed Oracle Quarterly Critical Patching (CPU) for Solaris, Linux and Windows Systems. Assisted developers in resolving their production issues, performed application code reviews.
• Set standards, procedures & policies for the movement for database development source code to production.
• Responsibilities include the design, implementation & maintenance of multiple databases systems.
• Performed database refreshes for staging, test and development databases. Exports and Imports.
• Responsible for achieving results, overcoming obstacles & resolving production issues in a timely manner. Thorough understanding of the software lifecycle & relevant software methodologies used in software development.
• Developed Oracle PL/SQL stored procedures, functions, packages, triggers, mergers & database scripts.
• Developed Data Definition Language (DDL) & Data Manipulation Language(DML) scripts.
• Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance. Created new database structures & database objects.
• Modified existing databases structures & database objects. Self-starter: ability to work independently.

Confidential, St. Louis, MO

Oracle Application DBA

Responsibilities:

• Responsibilities include the design, implementation, PLSQL code development of New Legal Auditing Data System.
• Designing database to align with development & business goals & objectives.
• Developed Oracle PL/SQL stored Packages, Procedures, Functions, Triggers & database scripts.
• Investigated source systems to locate & understand existing data.
• Created new database structures & database objects.
• Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance.
• Modified existing databases structures & database objects.
• Investigated and Resolved the existing Data Warehouse encountering problems due to lack of database maintenance.
• Support and maintenance of Existing Production Database Systems and data warehouse.

Confidential, Charlotte, NC

Oracle Application DBA /Sr. Developer

Responsibilities:

• Solid knowledge of relational database. Proven knowledge & experience in designing database schemas to align with development & business goals & objectives.
• Responsibilities include the design, implementation, PLSQL code development of New Federal Auditing Mortgage System for CFO Technical Risk.
• Developed Oracle PL/SQL stored Packages, Procedures, Functions, Triggers & database scripts.
• Created Oracle Data Definition Language (DDL) scripts & Data Manipulation Language (DML) scripts. Investigated source systems to locate & understand existing data.
• Created & coordinated script deployments with Data Operations & Enterprise DBA team. Created new database structures & database objects when necessary. Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance. Modified existing databases structures & database objects.

Confidential, Creve Coeur, MO

Oracle Application DBA

Responsibilities:

• Solid background in Oracle Relational Database Management Systems. Responsibilities include the design, implementation & maintenance of production multiple databases (4) and PLSQL code development for Apex Seed & Trait System.
• This system is totally rebuilt every year. Rebuilt the Apex ST System for year 2012 and prepped the databases for the next year 2013 system.
• Developed Oracle PL/SQL stored procedures, functions, packages, triggers & database scripts.
• Developed Oracle Data Definition Language (DDL) & Data Manipulation Language (DML) scripts.
• Investigated source systems to locate & understand existing data. Troubleshooting for data & database issues and Tuned Java Queries.
• Created documents & coordinated script deployments with Data Operations & Enterprise DBA team. Solid knowledge of relational database.
• Proven knowledge & experience in designing database schemas to align with development & business goals & objectives.
• Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance.
• Created new database structures & database objects.
• Modified existing databases structures & database objects. Self-starter ability to work independently.

Confidential, Maryland Heights, MO

Oracle Application Database Administrator

Responsibilities:

• Eleven plus years of Oracle PL/SQL Development with Oracle 7, 8, 9i, 10g, 11g.
• Five plus years experience with Oracle Database Administration, Design, Implementation & Maintenance with Oracle 11g, 10g & 9i managing mid-sized to large-scale production databases.
• Solid background in Oracle Relational Database Management Systems (RDBMS) from Designing Logical to Physical with normalization to fourth and third normal form.
• Data Modeling, Cardinality, Relational Database Management Systems.
• Monitored & maintained the integrity of database, assisting developers in resolving their production issues.
• Set standards, procedures & policies for the movement for database development source code to production.
• Responsibilities include the design, implementation & maintenance of production multiple databases.
• Performed database refreshes for test and development databases, Exports and Imports.
• Responsible for achieving results, overcoming obstacles & resolving production issues in a timely manner.
• Thorough understanding of the software lifecycle & relevant software methodologies used in software development.
• Developed Oracle PL/SQL stored procedures, functions, packages, triggers, mergers & database scripts.
• Developed Oracle Data Definition Language ( DDL ) & Data Manipulation Language( DML ) scripts.
• Investigated source systems to locate & understand existing data.
• Created documents & coordinated script deployments with Data Operations & Enterprise DBA team.
• Adhered to PL/SQL coding standards as defined for by Security Audit Requests. Troubleshooting for data & database issues. Implemented upgrades & patches for various software applications residing on databases. Solid knowledge of relational database.
• Proven knowledge & experience in designing database schemas to align with development & business goals & objectives.
• Experience in implementing database backup & recovery strategies & procedures. Analyzed tables, schemas, rebuilt indexes & tables, triggers, constraints, tuning database configurations for optimal performance. Detail oriented in all aspects of the job.
• Able to work with minimum supervision & with limited review of work required.
• Created new database structures & database objects.
• Modified existing databases structures & database objects. Provided 24-hour on-call support for all Oracle systems. Monitored databases for compliance with internal standards.
• Created all Oracle company Schemas and user IDs, establishing profiles, password expirations, tablespaces, & granting roles & privileges specific to their job titles.
• Monitored database table spaces, indexes, segments.
• Developed an ID Match system from design, build, testing to implementation and maintained this system.
• Created scripts to produce the Monthly Security Officer Reports, Quarterly Security Officer Reports & also a Document that lists all of the Valid Exception & Invalid Exceptions for the Security Officer's Reports.
• Maintained employee termination lists for removal of terminate employee ID from the database. Self-starter ability to work independently.
• Solaris, AIX, Hyperion, Unix, Linux, Windows 2000 Windows XP, MS Project, Excel, Serena Repository, Oracle 11gR2, Oracle 10g, Oracle 9i, TOAD DBA, Oracle OEM, PLSQL Developer, MasterTax, Chesapeak, UPCS, Reconnect UAR.

Confidential, Arnold, MO

Senior Oracle Developer

Responsibilities:

• Oracle Senior Developer and technical trouble shooter for an arms company.
• Redesigned & developed a process to upload to US. Customs for Duty Drawback. PL/SQL Developer: developed process to calculate Duty Drawback from U.S. Customs.
• Developed Oracle application/forms to allow for the manipulation of grants, privileges and roles on database tables. Installation and configuration of desktops; ghosting, images.
• Maintained daily backup recovery Tivoli tape system.
• Trouble shooter for desktops, windows and applications configuration, Eltron UPC label printer, HP office printers, flatbed scanners.
• Windows XP, Windows 2000, Unix, PL/SQL Developer, Oracle 9i, Oracle10, Oracle Database Processes Development.

Confidential, St. Louis, MO

Senior Oracle Developer

Responsibilities:

• Senior Oracle Developer for a diversified supplier of high tech, integrated military electronics, support equipment, and logistics services.
• Successfully reverse-engineered the logical database model for Primavera software to redesign an interface to Primavera Project Manager.
• Full Software Development Life Cycle (SDLC) including redesigned, reversed engineered database model, developed processes, coded, unit tested, integration tested, software integration, software deployment and software maintenance for interface to Primavera Program Manager and various Oracle payroll processes. Development using Oracle advance PL/SQL packages with stored procedures, functions, triggers and SQL scripts to facilitate the Primavera interface.
• Developed DOS and Linux scripts.
• Cleansed Primavera database to eliminate data anomalies and redundancies, then back loaded 3 years of data into Primavera Program Manager Database.
• Participated in the review of business and functional requirements and determined primary functions of projects with Financial Dept.
• Consulted with Business Owners on projects. Worked closely with users in identifying functional requirements. Evaluated business requests to determine feasibility, to define alternatives and recommend optimal solutions.
• Designed and implemented Oracle Relational Database Management Systems (RDBMS) from Designing Logical to Physical with normalization to fourth and third normal form. Design & Data Modeling, Relational Database Management Systems consisting of over 200 tables.
• Responsibilities include the design, implementation & maintenance of production multiple databases. Wrote scripts to aid in setup of Backup and Recovery, the setup of databases for MIS development and test environments.
• Weekly setup Oracle databases for development and testing environments. Provided maintenance of databases for development, testing environments and Primavera database.
• Setup DBMS job queue. Created Database Links, synonyms, roles, grants, table creations, truncations, packages, stored procedures, functions, triggers.
• Prepared documentation of business, technical presentations and user manual.
• Documented and coordinated changes and enhancements of development products. Also assisted fellow programmers in Visual Basic application unit testing and integration testing. Oracle 8, Oracle 9i, Advanced PL/SQL packages, store procedures, functions, Windows 2000, Windows NT, Linux,

Confidential, Chesterfield, MO

Oracle Developer / Programmer Analyst

Responsibilities:

• Oracle Developer I / Programmer Analyst for a top telecommunications software company.
• C, Pro C and C++ programming applications on HP/SUN Unix and Windows NT operating system.
• Developed, programmed, coded and tested client/server, N-tiered Process Layer Modules with services calling Data Layers with embedded Oracle SQL queries.
• Modifications, revisions, enhancements, testing, and documentation.
• Ensured development objectives were accomplished, user testing was performed. Participated in the review of business and functional requirements to determine the primary functions of the project. Documented and provided changes and enhancements of development of product.
• Prepared documentation of data definitions, data flowcharts, modules flowcharts.
• Used Tuxedo, TOAD and MQ messaging series. Updated and created new Data Dictionaries and user documentation for development, ensuring naming standards and data import verification. Modified C and Pro C applications with embedded PL/SQL for Sprint PCS wireless customer service projects. Customization of Sprint PCS software packages for wireless Customer Service Plans.
• Assisted in maintaining Sprint Oracle Replication Database.
• Reformatted data for data replication Warehouse Object Data Layer (ODL). Created Oracle stored procedures, functions, complex joins, sub queries, functions, triggers, tables, views, constraints, primary keys, candidate keys, secondary keys, foreign keys and constraints for interfaces, reports, forms and graphical user interfaces.
• Created new Order Management modules for wire line services using C, C++ and Pro C for Century Tel Company. Developed C, C++ and Pro C application modules with embedded Oracle PL/SQL and SQL queries. UNIX, Windows NT, C, C++, Pro C, Oracle 8, PL/SQL, SQL Plus, SQL, Tuxedo, MQ Messaging Series and Toad.