Pl/Sql Developer/DBA

JIDEOFO AZINGE

*******@*******.***/763-***-****

Sr PL/SQL developer/Oracle DBA

PROFESSIONAL SUMMARY

As an Information Technology Professional with over 25 years of industry experience, and over 20 years using Oracle technologies, I have acquired experience in both spectrums of Database Administration, Data Analysis and Database Development, with skills ranging from advanced PL/SQL, performance tuning, backup and recovery strategies and high availability DBA duties etc.

Expert programming experience as an Oracle PL/SQL developer, System Analysis, Design, Development & Support of Oracle Database 20c, 19c, 12c, 11g, 10g, 9i, and 8i in Production, Staging, and Development environments.

Most recent skills have come in a more horizontal cloud centric architecture, to leverage on-premise skill with cloud integration.

Dedicated to providing leadership that will empower a prospective client with the resources required to encapsulate, enhance, and focus their business objective, by providing detailed analysis and technical information required to produce the most viable business solution.

Strong skills in Oracle server-side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming.

Experience in extracting, transforming, and loading (ETL) data from spreadsheets, database tables and other sources using INFORMATICA.

Excellent ability in writing specifications and gathering requirements from multiple user Data sources, like (ODS), Splunk logs, star and Snowflake data warehouse schemas that are then used to develop actionable reports. Oracle Forms, Oracle Reports and APEX GUI interfaces and the maintenance of other client documentation as needed.

Practical understanding of Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in the complete System Development Life Cycle.

Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces, and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & a full suite of Oracle Tools including development/customization of Oracle Developer (Reports & Forms) and Oracle discoverer.

Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiling and Oracle Code Coverage Utilities.

Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.

Experience in migrating and scaling MySQL databases from on-premises to AWS EC2; Cloned MySQL on-premises to AWS EC2 without affecting on-premises traffic.

Migrated on-premises Oracle database to an AWS Oracle RDS database and an Azure environment for (POC).

Experience with C, C++, Java, JavaScript, .net, SQL programming and Visual Basic programming.

Well-versed with Dockers, Kubernetes, OpenShift, Confluence and ServiceNow platforms.

Base knowledge in managing and manipulating geospatial data within ESRI GIS, including data import/export, spatial analysis, and cartography.

EDUCATION

BSB in Business Administration and Computer Science Information System, University of Minnesota, Minneapolis, MN. Jun 1989

Certificate in Computer Programming, Operations & Systems Analysis, Control Data Institute, Minneapolis, MN. Aug 1985

Associate Degree in Electronics, National Education Centre, Minneapolis, MN. Sep 1993

Certification in Web Development and Java programming and also, J2EE v/s .NET Architecture, North Hennepin Community College, Minneapolis, MN. Mar 2003

Certificate AWS Cloud Practitioner, Harker Heights, TX. Oct 2022

Additional Course Work

Oracle database certification classes, Two years of mechanical engineering course work, user psychology, math, physics, data communications, employee relations, team building, and theater arts, CI/SEC/CD tool set, AWS essentials certification. Kubernetes, Microservices.

TECHNICAL SKILLS

Software

ORACLE 20c, 19c, 12c, JIRA, Confluence, AWS S3, ORACLE 11g, Azure, ORACLE 10g.x ORACLE 9i.x, and 8i.x RDBMS, PL/SQL, ORACLE Forms/Reports Servers, Microsoft Transact SQL Server stored procedure, Apache Web and HTTPS Servers, ERWIN, Oracle 9iAS Application and (RAC) Real Application Cluster Servers, XML, XPath, Oracle Java API, C & C++, IBM DB2 SQL, Dreamweaver, XML Spy, Fortran, Pascal, JCL, XEDIT, IBM Assembler, Visual Basic, CI/CD tool set, MongoDB, Informatica, MySQL

Hardware

Eurocom servers, AWS global Cloud, DELL 2850 server, Compaq ProLiant (7000, 6000, and 5000) IBM 360/370, Sun Solaris, HP-UX 9000, Delta 5600, DELL Workstations, IBM COMPARTABLE PC’s, PS/2, Sun and Windows clusters, Smartcard readers, Bio-scan readers and card punch

Operating system

Win 10, Microsoft 2003/2000/NT, UNIX, Sun Solaris, LINUX, HP-UX 9000, AIX 5.2, OS/2, MS DOS, IBM OS/VS, MVS/DOS, VAX MVS, CYBER System, NOS (Network Operating System), AMDAHL/MVS

PROFESSIONAL EXPERIENCE

Free Lance Jan 2024 – Present

Sr. Oracle PL/SQL Developer/DBA

Responsibilities:

Ever since I returned from an emergency mandatory break, I have been in the open job market, engaging with viable job boards and head hunters to hopefully get back into the job market.

Attending Technology events, like Amazon Q.

TATA Consultancy services, Global Dec 2019 – Dec 2023

Oracle Specialist/Developer

Responsibilities:

As the harness for the next four bank projects. USBank, Citi Bank, and Bank of America.

USBank, Dallas Metropolitan Area, TX (Remote) May 2023 – Dec 2023

Oracle Specialist/Developer

Responsibilities:

Joined a dynamic agile Small Projects team (SMProj) as an Oracle specialist/developer. US Bank was in the process of finishing a data center migration, and in a process of moving to the cloud. I worked with the team to support an Apex 18.x.x GUI, ORDS 18.x.x, PL/SQL, and SQL environment that was the merging point to many independent data sources, audit reporting and many other integrated systems. We adopted a Kanban method in agile. We used JIRA to organize our development, deployment and Change environment and Confluence to document all effort and new Items relevant for a cloud migration. Note, Star and snowflake schema modeling were applied in this warehouse environment.

Optimized ETL performance by developing efficient PL/SQL scripts for data transformation, ensuring timely data processing, and loading into Oracle data warehouses.

Managed the entire data warehouse lifecycle, from schema design to ETL pipeline development, using OWB for seamless integration with Oracle databases.

Developed and implemented ETL processes using Oracle Data Integrator (ODI), optimizing data extraction, transformation, and loading from multiple data sources into Oracle and non-Oracle databases.

Environment: Oracle 19c, ODI, OWB, ETL, Apex 18.x, AWS Cloud Environment

Citi Bank, Irving Metropolitan Area, TX (Remote) Jan 2021 – Mar 2023

Oracle Specialist/Developer

Responsibilities:

Worked with the remediation team to support the CSI with another upgrade from Oracle 19c to 23c, and MongoDB from 4.4.11 to 5.0.12 in the next 18 months. Team ownership for this upgrade and product certification is being evaluated currently. Also, I am being exposed to various cloud migration tools, as Citi slowly migrates to the cloud. i.e., via OpenShift.

Participated in another dynamic agile EOVS (End of version Service) remediation team as an Oracle specialist/developer for multiple lines of business (LOBs)/CSI clients. Monitored PL/SQL jobs and queries running on a Snowflake schema, identifying, and resolving performance issues or errors. I worked with an Oracle remediation team to support CSIs with an upgrade from Oracle 11g to 19c in an OraaS cloud environment.

Environment: Oracle 11g, 12c, 19c / RHEL 6/7/8 Cloud OraaS 19c Environment

Bank of America, Dallas Metropolitan Area, TX (Remote) Jun 2020 – Dec 2020

Oracle PL/SQL Database Developer

Responsibilities:

Joined another dynamic agile Data Lake/Datamart development team as an Oracle developer for multiple lines of business (LOBs) clients. I worked on a UNIX reporting framework that consolidates various (LOBs) processing modules into a single database driven adaptive reporting framework. This involved shell scripting and PL/SQL modules.

Also worked on converting/combining various Datamart’s into a data lake, by moving reporting fact and dimension tables into the data lake.

Was deeply engaged in getting up to speed with the horizon SDM platform here at bank of America. As part of the CI/CD required implementation. We used Autosys to run jobs, and Git to access a bitbucket remote repository.

Environment: Oracle 12c, UNIX

Bank of America, Dallas Metropolitan Area, TX Dec 2019 – Jun 2020

Oracle PL/SQL Database Developer

Responsibilities:

Joined a multi train agile development team as an Oracle developer. I have been assigned to the Capture Ingestion and the Capture Discovery teams as one of the on-shore database developers to give round the clock database coverage on ongoing projects.

Collaborated with Java developers in integrating Java with Oracle stored procedures. Occasionally code additional modules or modify existing modules to meet the new requirements.

Deeply engaged in trying to get up to speed with the highly complex bulk ingestion and capture discovery process here at Bank of America. The agile tool of choice is JIRA. I am learning that too.

Environment: Oracle 11, UNIX

Phillips66 Corporation (ConocoPhillips), Bartlesville, OK Sep 2012 – Aug 2019

Responsibilities:

As the harness for the next three projects.

Analyst Logistics (FTE) May 2017 – Aug 2019

Responsibilities:

Joined the midstream support team, after core development for TRAC66 slowed down. I was part of the client support and application enhancement team, resolving client requests.

Worked with clients from various departments like Accounting, Provisioning, Commercial, field services etc. on requirements gathering to help define their needs.

Complied and analyzed data from multiple sources, Oracle database, SQL Server database, sometimes used SQL Loader to load CSV’s from Excel spreadsheets, proprietary vendor formatted satellite feeds and even whiteboard photos of hand illustrations, to quantitatively address user requirements.

Conducted agile team spikes to work through roadblocks, and sometimes to align with client needs. Created stories that addressed the work that was necessary to accomplish the tasks, and assigned to the various teams. We then worked the stories in two-week sprints via an Agile (Kanban) board process.

Wrote and documented technical specs that will be used by the various technical teams like .NET, Data Integration and field OPS teams. These included the required data sources and data flow diagrams with ERDs, templates, and collaboration points for front-end and back-end inputs and outputs, with specific user instructions.

Sometimes it was necessary to create new meta-data sources like rules for selecting types of crude oil, or when a particular tariff pricing is used.

When SQL queries were needed to integrate data from the multiple data sources, I wrote SQL code, procedures and even logical physical normalized data structures to facilitate any enhancements. Always with performance as a cornerstone.

All and any such enhancements flowed through our DEV/OPS environment, which was built using Visual Studio Team Server (VSTS) running a Git repository, with a build pipeline plugin to run Jenkins enabling the CI/CD environment.

I was excited when the company announced its cloud strategy, it gave me the opportunity to start looking into AWS technologies and I have started exploring how I can use cloud technology to accomplish some of the same on-prem deliverables.

The journey to the cloud has been very interesting. AWS cloud solution was the core cloud vendor. Most of our core systems have moved off prem. Though I was not directly involved with the move, I have learned so much about the process to the cloud and messaging systems.

Design (POC) and Implement cloud- based solutions using Azure Services such as App services, Functions, and logic Apps.

DBA Database support for critical business applications such as ESRI GIS, Google Glass, Oracle PeopleSoft, and CAD. These could help with "The right of way mapping" experimental project.

Environment: Oracle 11g R2 (RAC)/ 12c, SQL Server, Linux

Midstream Technical Architect (FTE) (Jan 2014 – May 2017)

Responsibilities:

The project took on a much larger scope, absorbing other smaller silo projects and adding more cross functionality that would automate and enhance various business processes. The project now has a more corporate enterprise integration focus.

I transitioned into the Full time Technical Architect position when my predecessor moved into a much broader position. The plan was to integrate the various silos of process and functionality across the corporate volumetric and reporting space under the umbrella now called Trac66, and also to design, develop and implement new processes and functionality where gaps may exist.

The core of the system was .Net and an Oracle back end. The team’s agile methodology enables us move at a very fast pace through iterations of timed sprints, and gave us the ability to adapt quickly to new and changing business requirements. The big challenges were working in a highly leveraged environment where other teams used the waterfall methodology. At first, we released on a quarterly bases, and we have had many major and minor releases without any major incidents to date.

Environment: Oracle 11g R2 (RAC)/ 12c, Linux, Windows

Sr Oracle Database Developer (Sep 2012 – Jan 2014)

Responsibilities:

Phillips66 embarked on an unprecedented large-scale software development project to revamp and replace aging software (VRS, EXSTARS etc.) in its corporate operations and accounting business units. These applications help manage various aspects of its Oil transportation organization. My wealth of experience in Oracle technologies and agile development life cycles was immediately valuable.

As one of the lead Oracle database developers, my tasks included working directly with the systems technical architect and the business (SMEs) on the design, development, and implementation of Oracle data structures in PL/SQL packages to provide data to the .NET and web services teams.

In this role, I also mentored other database and .NET developers on various technical issues and Oracle best practices. I also helped to keep them aligned with the business goals and direction.

The team relied on the tool (Rally dev for agile project management) for management and communication of such a large-scale project. It was possible to track tasks in real time, and liaison with other teams in concert. This made it possible have an in-depth knowledge of the entire Trac66 project. It also allowed us to track how the builds were progressing, and also to better coordinate module integration.

Environnent: Oracle 11g R2 (RAC)/ 12c, Linux, Windows

Target Corporation, Minneapolis, MN Apr 2011 – Sep 2012

Sr Oracle Database Admin

Responsibilities:

Part of a new team that will support, analyze, and enhance the current corporate security and compliance process for the Oracle environment. The initial process was developed at Target, due to the burden placed on the environment by the new customer data warehouse tracking software. Targets version of an inventory tracker or (SCM). It was a UNIX script that called multiple Oracle database PL/SQL procedures that populated an APEX repository. It was initially put in place to meet the basic requirements of the compliance environment for (SOX, PCI, GLBA and HIPPA). As the demands for higher standards and better compliance accountability grew, it became clear that an enterprise solution was needed. While the search for the better tool for the job was kicked off, my task was to help identify, standardize, and modularize the current process in a way that it could be exportable or at least ensure a seamless migration to the new enterprise tool.

This involved working with multiple teams at Target, as well as with federal and state compliance auditors, to define the standards and build controls that would help us achieve the corporate goals. There was also a proof-of-concept phase where we evaluated multiple tools. Imperva and Guardium were the two prominent appliance-based architecture tools in the market. Imperva was the preferred tool for various reasons. I worked with the service reps to set up controls for the Oracle side of the tool. We did pass a full audit for the first time in a while at the end of the project.

Environnent: Oracle 9i/10g/ 11g R2 (RAC), Linux, Solaris, AIX, Windows

ACB, Louisville, KY Sep 2010 – Nov 2010

Sr. Oracle Database Admin

Responsibilities:

Part of a three-month Oracle Developer project to implement a unique registration and tracking process for cancer research.

My Main task was to help implement a three level Oracle PL/SQL API that would interface with a C# front end. We used Steven Feuerstein’s TAPI generation environment to implement a three-level separation between the client and the underlining database.

There were several levels of biometrics design and implementations which presented all kinds of challenges. The language base went beyond PL/SQL. To activate modules, External Procedures, C/C++ DLL’s, Oracle OCI code skill set were tapped into.

Environnent: Oracle 11g R2 (RAC), Linux, PL/SQL, C, C++

Digi-Key Inc., Bloomington MN Dec 2009 – Jun 2010

Sr. Oracle Database Admin

Responsibilities:

Part of a six-month Oracle contract team via ConcordUSA brought in to assist Digi-key transition from a DEC: RDB/SQL Server environment to an Oracle centric environment.

My Main task was to build the initial data dictionary database that would then be transitioned into a more elaborate Data Warehouse environment.

I tapped into a wealth of skills ranging from requirements analysis to gather information from various silos of subject area experts, Physical and Logical Data modeling to tie all the disparate information into consumable relational model, ETL to find and load data into the model via SQL loader for CSV files, External Table loads, and PL/SQL code to provide an automated and repeatable process to transition data quickly.

We used Data pump (expdp/impdp) to create our dev/test environments. Other duties and assignments included upgrades from 10g/11g; installing 11g R2 (RAC) with ASM, and Installation of Oracles security wallet, Grid control, and other miscellaneous Oracle related research.

Environment: ORACLE 11g, / LINUX

NAU Metro (TeamUS Inc.), Maple Grove MN Dec 2008 – Mar 2009

Sr. Oracle Database Admin

Responsibilities:

Staff argumentation database administrator for production and development environment, to support a recently TeamUS installed oracle 11g, with RAC-to-RAC High Availability DataGuard physical standby implementation.

Though I was not part of the installation team, I was brought up to speed with the current configuration and played a key role in trouble shooting and resolving the apply side DataGuard Broker issue. Apparently, there was a rogue process that was manipulating millions of rows which was assumed to be a performance issue. It was later resolved to a corrupt ARC Log file shipped from the primary side.

Used Grid Control and database Control as some of the management tools used to trouble shoot the database and dataguard broker issues. I also used AWR in conjunction with Statspack to help identify issues. Note Oracle ASM was also fully implemented on this project.

Environment: Oracle 11g, Linux, Statspack

Skybridge (Archway Marketing), Minneapolis, MN Aug 2008 – Nov 2008

Sr. Oracle Database Admin / Lead Oracle Web App admin

Responsibilities:

Upgraded 8i oracle database to oracle 10g, and conversion of legacy applications.

Upgraded 6i forms and reports to 10g forms and report services.

Worked with the Mcgem development team, to reengineer key application interfaces to best harness the new (SOA) Service Oriented Architecture of the 10g forms and report services server.

Helped identify and clean up redundant and non-reusable code segments, making the environment more efficient and more adaptable to new business.

Performed code reviews, and evaluated the environment for a possible data ware house addition.

Environnent: Oracle 8i, 10g / HPUX, NT

Best Buy, South Richfield MN Jun 2008 – Jul 2008

Sr. Oracle Database Admin

Responsibilities:

Staff argumentation database admin for production & development environment; supported existing oracle 10g.

Worked with ORPOS developers to support their project deployment.

Worked with the Exclusive Brand Project team to create a new environment for a third-party vendor product installation. This would also help keep a closer track on inventory movements and warehouse restoking efforts. A quasi (SCM).

Used a load balanced Grid control server set up to Manage a RAC environment with over 200 instances, 50 database and 10 ASM instances to manage security and database performance tuning on 3 primary databases.

Environnent: ORACLE 8i, 10g / SUN Solaris, NT

State of Minnesota (MHFA), Minneapolis, MN Jul 2005 – Jan 2008

Sr. Oracle Database Admin/ PL/SQL developer

Responsibilities:

Lead database administrator for production and development environment, installed and configured oracle 8i/9i/10g, and worked with developers to resolve performance, client and server issues.

Performed capacity planning, server reassignment and detailed user application migration requirements gathering, in preparation for operating systems upgrade.

Designed and implemented a road map for migrating Oracle 8i to a new Oracle 10g platform, including migration of forms/reports 6i to Oracle 10g.

Implemented backup and recovery strategy using RMAN and VERITAS Backup Exec (MML).

Lead DBA for MHFA’s disaster recovery drill team, and participated in several mandatory off site total loss recovery projects.

Also provided miscellaneous support in performance tuning for Oracle PL/SQL, and provided Oracle database and technical support for the new flagship third party product (HDS) Housing Development Software. Was also Source Code management PVCS admin, Hummingbird BI Query Admin.

Was also part of the team that successfully implemented oracles Content Management System (CMS) in a 10g Oracle database environment:

Set up 10g grid control on the admin server to replace the 9i Enterprise manager used to manage multiple databases, after upgrading to a 10g environment. I also used the new Grid control to set up an oracle 10g primary and physical standby database using oracle’s ASM disk configuration, for a proof of concept application that would support a third party application.

Environment: Oracle 8i/9I/10g /NT, PL/SQL,

Medtox, St Louis Park, MN May 2005 – July 2005

SQL Server Database Admin/T-SQL Developer

Responsibilities:

Lead database admin and Transact SQL developer in the process to provide a paperless environment for medical insurance claims.

Provide insight into the effort it will take to convert core procedures to an Oracle PL/SQL environment in future expansion.

Environment: SQL Server /NT

Digital River, Eden Prairie, MN Mar 2005 – Apr 2005

Senior Database Developer

Responsibilities:

Performance tuned of a database driven webpage delivery system. A specific environment was observed to be much slower than usual, but was never consistent enough to identify. Was engaged to help narrow it down.

Environment: ORACLE 9i Solaris UNIX

Bankers Systems Inc (BSI), St. Cloud, MN Oct 2003 – Feb 2005

Senior Database Administrator

Responsibilities:

As a harness for the next two projects.

Senior Database Administrator (FTE) Jan 2004 – Feb 2005

Responsibilities:

Lead database administrator for production and development environment.

Implemented backup and recovery using RMAN and Tivoli Data Protect (TDP).

Capacity planning.

Conversion of oracle PL/SQL to T-SQL for a new client facing interface, and managing ad-hoc small projects in legacy systems conversion.

Environment: ORACLE 9i NT/AIX and SQL Server

Senior Oracle Database Developer Oct 2003 – Jan 2004

Responsibilities:

Part of the lead development team brought in to help implement an oracle solution at Bankers Systems. The sub system included a data driven document DATA WAREHOUSE (Expere). Initial data loads were from multiple data sources that included word documents, PDFs, ETLs from SAP, PeopleSoft and some proprietary document providers. There were also DTS transformations from Excel and SQL Server data sources.

With the enactment of the Patriot Act, a lot of institutions were looking towards bankers Systems for a viable dynamic document generation solution in compliance and money laundering. This could only be achieved by the integration of the OLTP document generation and the document content data warehouse, implementing the get descendant method with precedence (Ranking).

Task was to rewrite portions of the PL/SQL code that was part of a 24 step JAVA document assembly routine called the Micro Flow for better performance and to make better use of the strengths of Oracles 9i relational database infrastructure i.e. Materialized views, Oracle Collection (Nested Tables, Arrays) Merge (upsert).

Also enhanced the PL/SQL API’s to pass bigger payloads via oracle collections to JAVA front end service layer architecture (SLA). This eliminated SQL code silos in Java code, improved modular reusability and presented a more unified and transparent access to all company data across multiple platforms and databases.

Environment: ORACLE 9i NT/AIX, SQL Server, Java, PL/SQL, SAP, PeopleSoft, Excel

Startup Web Services Business, Plymouth, MN Sep 2002 – Oct 2003

Continued Education University of Minnesota Hospital Coding and Billing management Prerequisites

North Hennepin Tech Web Development

CES International, Plymouth, MN Jun 2001 – Jul 2002

Senior Software Engineer II

Project Lead database performance solutions

Responsibilities:

Re-architected the data flow environment to better use the strengths of the relational database infrastructure. There were too many nesting SQL statements and multiple single threaded calls to the database.

Participated in base product redesign that included an integrated reporting enterprise DATA WAREHOUSE on the back end.

Helped develop a middle tire data extraction routine (ETL) and database stored procedures that would be called from various applications i.e. the universe of a Business Objects front end, a mobile/wireless interface for field crews, and a web call entry interface that will be used for real time trouble reporting.

Designed and implemented a database foundation for a base product on Sun Solaris, HP-UX, and AIX, after analyzing the various in-house CES client’s data structure, made up of 10 major power company project databases.

Performance tuned each UNIX server for an Oracle database solution. Converted an 8i database to 9i, on a server with Sun Solaris hardware cluster and Oracle Real Application Cluster (RAC).

Installed 9iAS on another Sun box, to complete the deployment procedure for our high availability solutions. Performed benchmark testing and a full database and system wide performance testing on critical path modules.

Final automation was written in UNIX kron script to automate several procedures.

Environment: ORACLE 8i and 9i on HP, Sun, Linux, Aix

Rapid Application Deployment, St Louis Park, MN Jul 1999 - Apr 2001

Senior Technical Consultant

Responsibilities:

As a harness for the next five projects.

Senior Technical Consultant Sep 2000 – Apr 2001

Responsibilities:

Implemented and simulated all application and database client solutions for Oracle 8i and 9i.

As Oracle partners, performed beta testing of all Oracle products i.e. 11i financials and manufacturing, 9iAS, Oracle Clinical and Portals.

Also did a lot of legacy application conversion, and also migrations of Informix to Oracle and Sybase to Oracle.

Environment: Oracle 8i/9i, Sybase

Gage Marketing, Loretto, MN

Database solutions Architect Jun 2000 – Sep 2000

Part of a RAD project team that was reengineering a client/server application into nth Tire architecture.

Responsibilities:

Redesigned the infrastructure to enable nth Tier application processing.

Installed and tune an 8i Oracle database with caching. Installed and enabled Apache and HTTP servers with web caching.

Installed oracle forms and reports server, with client caching.

Assisted in the dataflow analysis, this helped determine modularity and the most efficient deployment solutions across all nth Tiers.

Also built PL/SQL packages to help consolidate data nesting in calls from Oracle forms. Created procedures and files to enabled web access security.

Environment: ORACLE Databases 8.1.6 on Win 2000/NT, HP-UX 9000

Gage Marketing Maple Plain, MN

Database solutions Architect Apr 2000 – Jun 2000

Part of a RAD project team to reduce the paper trail, redesign a manual reporting system that used magnetic tape transfers and a data entry process to consolidate reports, into a fully automated web enabled online reporting system.

Responsibilities:

Assisted in the dataflow analysis to determine the repeatable elements and the data structure that would best enhance output model.

Created PL/SQL procedures to find and pull current production data from a SYBASE database, through an oracle transparent GATEWAY

Installed and implemented a new

Contact this candidate