TECHNICAL SKILLS:

• AWS Cloud, RDS, EC2, S3,Oracle 18, Oracle 12.2c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle Enterprise Manager (OEM), Data Modeling
• Database Design, Designing RDBMS from Logical to building the Physical, Toad, PL/SQL, PL/SQL Developer, SQL, SQL Programming, Toad, Erwin, SQL Developer
• Linux RedHat 7.5, Unix, 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

Sr. Oracle Development DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases systems. Building new databases on the AWS Cloud RDS and Linux Redhat platforms EC2. Setup of the configuration of Linux Redhat. Installed Oracle Software and created new databases. Created all database objects, datafiles, tablespaces, schemas ensuring database interface is setup correctly.
• Performed database refreshes for test and development databases. Performed DataPumps, Exports and Imports. Monitored and resolved Production, Test and Development database 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. Investigated source systems to locate & understand existing data. Troubleshooting for data & Production/Staging database issues. Created documents & coordinated script deployments with Production Data Operations & 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. 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

Sr. Oracle Development DBA

Responsibilities:

• Development and scripting for DISA GLOBAL Defense Information System Agency at 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. Reversed engineered current failing network monitoring systems and design, created new system for network router hardware monitoring. Created documents & coordinated script deployments with Production 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, vercoming 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

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. Performed STIG analysis and modifications to bring database system inline with policy. Self-starter: ability to work independently.

Confidential,St. Louis, MO

Sr. Oracle Development DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases systems for the Multiple Large Financial Corporations ( Confidential, Chase, UMB, etc.). 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. Advanced database development experience (Oracle SQL/PLSQL). Hands-on data architecture, design and development. Practical creation and implementation of data models.
• Familiar with database management programs (TOAD, SQL Developer, PL/SQL Developer). Advanced knowledge of Oracle database architecture. Overview of object oriented programming in Oracle database. Designed, coded, tested, debugged, and documented complex database programs to ensure that data processing production systems to meet user needs.
• Troubleshoot and resolved complex production issues. Designed relational database models for small and large scale applications. Provided data analysis and validation. Identified performance issues on production and testing systems. SQL Tuning and Optimization of newly develop and existing PLSQL applications.
• Interacted with internal and external clients to understand requirements, explain issues and prioritize work. Designed, implemented & maintained multiple databases and PLSQL code development for Financial Service Systems. Investigated source systems to locate & understand existing systems.
• Troubleshooting for data & Production/Staging/Test/Development 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 Development DBA

Responsibilities:

• Responsibilities include the DOD design, implementation & maintenance of multiple databases and PLSQL code development for ISDDC System for United States Military TRANSCOM System at 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 Development DBA

Responsibilities:

• Responsibilities include the design, implementation & maintenance of multiple databases and PLSQL code development for SDDC 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 Development 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.Signature contractor

Confidential,Charlotte, NC

Oracle Development DBA /Sr. Developer

Responsibilities:

• 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 Development DBA

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. Created new database structures & database objects. Modified existing databases structures & database objects. Advanced database development experience (Oracle SQL/PLSQL). Hands-on data architecture, design and development. Practical creation and implementation of data models. Familiar with database management programs (TOAD, SQL Developer, PL/SQL Developer).
• Advanced knowledge of Oracle database architecture. Overview of object oriented programming in Oracle database. Designed, coded, tested, debugged, and documented complex database programs to ensure that data processing production systems to meet user needs. Troubleshoot and resolved complex production issues.
• Designed relational models for small and large scale applications. Provided data analysis and validation. Identified performance issues on production and testing systems. SQL Tuning and Optimization of newly develop and existing PLSQL applications. Interacted with internal and external clients to understand requirements, explain issues and prioritize work.
• Designed, implemented & maintained multiple databases and PLSQL code development for Financial Service Systems. Investigated source systems to locate & understand existing systems.
• Troubleshooting for data & Production/Staging/Test/Development 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.

Environment: 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.

Environment: Windows XP, Windows 2000, Unix, PL/SQL Developer, Oracle 9i, Oracle10, Oracle Database

Confidential,St. Louis, MO

Senior Oracle Developer

Responsibilities:

• Senior Oracle Developer for a diversified supplier of high tech, integrated military Confidential, 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.

Environment: 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.

Environment: 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

Confidential,St. Louis, MO

Programmer Analyst

Responsibilities:

• Programmer Analyst Internship: Full Software Development Life Cycle (SDLC) including redesigned, developed, coded, unit tested, integration tested, software integration, software deployment and software maintenance for an interactive accounting, payroll and inventory database system.
• Application module development consisted of top-down design, abstract data types and encapsulation, using the C language.
• Developed new Visual Basic application that calculated the necessary supplies, costs and checked against existing inventory, by scrolling pen base device along blueprint layouts to determine customer cost estimate, company cost and inventory backlog.
• Software maintenance of existing Visual Basic applications and ACCESS database.
• Created macros for queries, forms, reports & Graphical User Interface (GUI).

Environment: Windows 95/98, C, Visual Basic, Access, Macros and Visual Basic GUI Development.