Lead Oracle Database Architect Resume
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.