We provide IT Staff Augmentation Services!

Lead Oracle Database Architect Resume

5.00/5 (Submit Your Rating)

Glen Allen, VA

OBJECTIVE:

A responsible and challenging position that utilizes an industrial and military background in computer science and mathematics and includes opportunity for future advancement.

SUMMARY:

  • Twenty years experience in translating customer needs into cost - effective business solutions.
  • Strong experience coordinating customer - developer interaction and project deliverables.
  • Extensive experience applying Software Engineering methodologies and tools in designing both GUI front-ends and database back ends.
  • Strong experience leading, assuming responsibility for, and organizing the various project management and development aspects of several challenging projects.
  • Experience designing and teaching courseware to several groups of people.
  • Strong ability in working well within diverse groups of project team members.
  • Strong ability and desire to stay abreast of latest information technologies.

SYSTEMS/LANGUAGES:

Hardware: Sun Sparc, EIC Server, HP 9000, HP 3000, IBM PC, DEC VAX

Operating Systems: UNIX (Solaris, HP UX, Linux), Windows (7/XP), DOS

Networks / Protocols: TCP/IP, HTTP, Novell, DecNet

DBMS: Oracle 12c/11g/10g/9i/8i/7, MS SQL Server 2000 (includes Analysis Manager), MySQL, Postgres, MS Access, Sybase SQLAnyWhere, HP TurboIMAGE, DBASE IV

Data Warehousing Tools: OWB (Oracle Warehouse Builder) 12c/11g/10g/9i, Sql Server 2000 Analysis Manager

Middleware: Oracle Sql*Net and Net8

Internet /Application Tools: Oracle Confidential (Application Express) 18.1, FrontPage, UltraDev, SnapLogic

Application Servers: Oracle WebLogic, OAS 10g (including Portal)

OLAP: Business Objects Supervisor, Designer, and Reporter; Oracle Discoverer 10g Administrator, Plus, and Viewer

Languages: SQL, PLSQL, TSQL, PRO*C, OO4O, JQuery, Python, asp pages, JavaScript, XML, JSON, HTML, DHTML, FORTRAN, Perl, AWK, Make, Bourne/C/Korn/Bash Shells

CASE Tools: Power Designer, ErWIN

EXPERIENCE:

Lead Oracle Database Architect

Confidential, Glen Allen, VA

Responsibilities:

  • Am leading implementation of database design and performance enhancements of our Oracle 11g OLTP/OLAP environment.
  • And will soon be leading our migration to Oracle 12c to include this version’s partition and compression improvements.
  • Am also responsible for delivery of improved reporting environment to include sought after detailed statistical analysis and faster display.

Oracle Application Express / Discoverer Developer

Confidential

Responsibilities:

  • Working as a key contributor in a team effort to migrate existing legacy applications into a centralized Oracle framework.
  • Responsibilities include documenting requirements, enhancing existing Oracle table structures and creating new database tables, triggers, RI constraints, PL/SQL packages, and building web interfaces using Oracle’s Confidential tool.
  • Have also created several new database and web applications for several different groups Controls, SCCS, SSRL. Have also been a mentor to other Oracle and Java developers in these groups.
  • I also lead a monthly Confidential Users Group at Confidential in which I and other developers share tips/tricks and demonstrate various features of the tool set.
  • PL/SQL packages, triggers, and table design using CASE tools (Power Designer) to reverse engineer several legacy systems; Confidential applications consist of many advanced features: Analytic functions; Oracle’s OO4O as interface between Excel and Oracle; Confidential utilities; use of collections; master - detail forms; JQuery; Dynamic Actions; css style sheets; Web Services in co-ordination with JSON, Oracle Spatial, ArcGIS framework.
  • I am at home with versions 1.x through 5.1.x, having created dozens of applications, many of them complex with many pages and dealing with diverse disciplines (government, financial, scientific). I'm comfortable working with forms and reports (including interactive reports) as well as JQuery and css style sheets, interfacing these with Oracle tables/views/materialized views via AJAX calls. I've been working with many of the new features including dynamic actions, plugins, and charting.
  • I also am the leader of Confidential 's Confidential Users Group and spend a good portion of my time teaching Confidential techniques to several other Oracle developers here at Confidential .

Oracle Application Express Developer

Confidential

Responsibilities:

  • Specific responsibilities include design and testing of Confidential 2.0 forms allowing health care providers to perform DML against an Oracle 10g backend.
  • These constitute about 50 screens, some of which are “green screen” conversions while others are completely new designs based upon specs gathered from personnel.
  • This is a short term contract position that is expected to complete in about a month.

Oracle Application Express Developer

Confidential

Responsibilities:

  • My responsibilities included the creation of several complex reports and forms, menus, and ancillary views and plsql functions using Oracle’s Confidential (version 2.0).
  • I also assisted the project’s Oracle dba in design of underlying tables used to collect data from the web application we were creating.

Oracle Technical Writer

Confidential

Responsibilities:

  • Have written articles covering various Oracle related concepts and tools for the industry-recognizedOracle related educational web site Skill Builders.

Oracle Portal Designer / DBA Consultant / Teacher

Confidential, Buffalo, NY

Responsibilities:

  • The Portal presents complaint/arrest/property/vehicle data from disparate databases integrated within a single web interface and accessible to authorized police personnel.
  • Also conducted weekly Oracle based training for IT staff as well as helping staff with SQL and dba tasks.

We'd love your feedback!