DBA Programmer at Nexgen Pharma, Inc.
Greater San Diego Area
- Current
-
- DBA Programmer at Nexgen Pharma, Inc.
- Past
-
- Owner at Garry Multiuser Computer Systems
- Oracle DBA at Strategic Data Systems
- Database Administrator at Information Quest
- Database Administrator at Information Quest / RoweCom
- Senior Support Analyst at Ross Systems
- Data Base Management Specialist at computer sciences corporation
- Data Base Management Specialist at Planning Research Corporation
- Senior Analyst at Beck Computer Systems
- Senior Programmer/Analyst at API Alarm Systems
- Senior Programmer/Network Manager/Datatrieve Manager at Platt Music
- Programmer at Linear LLC
- Education
-
- University of California, Santa Barbara
- Connections
-
17
connections
- Industry
- Information Technology and Services
- Websites
Joel Garry’s Experience
-
DBA Programmer
Nexgen Pharma, Inc.
(Privately Held; 501-1000 employees; Pharmaceuticals industry)
July 2001 — Present (8 years 5 months)
Customized iRenaissance 5.0 Process Manufacturing/Inventory Control package.
Upgraded iRenaissance 5.0 to 5.7, to 6.2.
Performed Oracle DBA tasks.
Installed Oracle 9iAS, OAS10g, 9iR2, 10gR2.
Implemented remote Standby database.
Implemented backup procedures and DBA reporting.
Wrote Gembase reports and online programs.
Increased performance of critical programs.
Converted 8.0.5 database to 8.1.7 multiple instances, then to 9iR2, then 10gR2.
Platforms: hp-ux 11.23 on quad Itanium, hp-ux 11.11 on one one rpr3340 (4 processor 8G), hp-ux 11.00 on one N class (8 processor 8G memory) and two K class (2 processor 1.5G memory, 4 processor 2G memory) servers, Windows 2000, autoraid. Oracle 8.0.5, 8i, 9i, 10g administration. iRenaissance 5.0, 5.7 and 6.2 process manufacturing, supply chain and financials (thin-client) modified via Gembase 6.1-5a, 6.1-6, 7.2, 7.3 programming. NT, W2K, XP clients with Reflections, thin clients and browsers. -
Owner
Garry Multiuser Computer Systems
(Information Technology and Services industry)
March 1984 — December 2007 (23 years 10 months)
Provided design, programming and database maintenance services for various customers.
-
Oracle DBA
Strategic Data Systems
(Military industry)
July 1999 — May 2001 (1 year 11 months)
Installed Oracle software, tools and patches.
Trained DBA's.
Performed Oracle DBA tasks.
Assisted programming staff in shell and SQL programming.
Assisted staff in interfacing to remote systems.
Implemented MRPII and custom programming of Aircraft Manufacturing and Remanufacturing software. Projected database size: 200Gig (plus development and test databases). Assisted with various other hp/ux and Solaris Oracle systems as needed.
Platforms: HP/UX 10.2, 11 on T-600 and V-2500 class machines, autoraid, Hitachi SANS, Netware, NT, Oracle 7.3.2/7.3.4 running Compass Contract 6.1/6.2 applications and custom software, Oracle8.0.5/8.1.6, SQL*Net, Big Brother, Omniback, NT/W2K clients, Exceed X-windows and Reflections. -
Database Administrator
Information Quest
(Information Technology and Services industry)
November 1997 — October 1998 (1 year )
Set up and maintained Oracle hot and cold backup procedures.
Database administration, including investigation and installation of new versions of the database software. Upgraded from 7.3.2 to 7.3.4 and made preparations for installing 8.0.5.
Designed and implemented reports for publishers and other customers.
Participated in development of Information Quest and other products.
Implemented design changes to the database.
Participated in anticipating the hardware and software needs of the database, and made recommendations for procurement.
Negotiated licensing with Oracle.
Reorganized database to properly utilize tablespaces.
Implemented a set of custom monitoring tools.
Tuned large database for performance.
Helped applications programmers tune SQL code.
Propagated database into separate production, development and QA instances. -
Database Administrator
Information Quest / RoweCom
(Information Technology and Services industry)
1997 — 1998 (1 year )
-
Senior Support Analyst
Ross Systems
(Public Company; 201-500 employees; ROSS; Computer Software industry)
February 1994 — October 1997 (3 years 9 months)
Supported Gembase DML (Data Manipulation Language) for customers and Renaissance C/S developers.
Wrote software problem reports for development.
Performed Oracle installation and DBA work in-house.
Oracle telephone DBA support for customers.
Unix system administration inhouse and telephone support for customers.
Shell programming.
Gembase is a 3 tier client/server programming environment that includes rapid application development. The DML allows the same applications code to run on multiple platforms and database engines. I was in the Tools department. My main function was to support GEMBASE, a 4GL rapid application development environment. GEMBASE is the language Ross uses to write applications used in over 2700 companies world wide, including financial applications, and especially targetting process manufacturing. -
Data Base Management Specialist
computer sciences corporation
(Public Company; 10,001 or more employees; CSC; Information Technology and Services industry)
September 1989 — March 1993 (3 years 7 months)
Under GSA contract to the Marine Corp. Designed and programmed software for hand-held computers (Intermec 9440) for housing inspectors, interfaced with UNIX based 4GL database.
Designed and programmed in ACCELL/UNIFY
Sysgened and brought up new SUN 4 UNIX and ported NBI UNIX applications to SUN. BANYAN VINES over ETHERNET gateway.
Brought up dial-in access, over dial-up and dedicated no-dialtone lines.
Supported ORACLE based custom financial system.
Installed ORACLE7.
Remapped PC keyboards to look like VT220s, modified system files to allow network, direct and Sunview applications to work the same.
BSD 4.2, 4.3, and System V UNIX maintenance in both dual and confluent universes.
Programmed in C, AWK, Bourne shell, and C shell when needed.
Provided support for PC/TCP and TCP/IP networking.
Performed VINES system administrator functions.
Programmed in IRL language (barcode).
Provided DBA services for UNIFY and ORACLE.
Wrote C triggers.
Programmed in SQL. -
Data Base Management Specialist
Planning Research Corporation
(Information Services industry)
September 1989 — May 1991 (1 year 9 months)
software for hand-held computers (Intermec 9440 IRL barcode language) for housing inspectors, interfaced with UNIX based 4GL database.
Designed and programmed new applicant waiting list system in ACCELL/UNIFY
Supported users and programmers in existing system.
Sysgened new SUN 4 UNIX and ported NBI UNIX applications to SUN. PC's networked with BANYAN VINES over thinnet to an ETHERNET gateway, allowing access to either UNIX machine, as well as the UNIX machines to use BANYAN print services.
Supported ORACLE based custom financial system.
Installed ORACLE7.
Remapped PC keyboards to look like VT220s, modified system files to allow network, direct and Sunview applications to work the same.
BSD 4.2, 4.3, and System V UNIX
Programmed in C, AWK, Bourne shell, and C shell when needed.
Provided support for PC/TCP and TCP/IP networking.
Performed VINES system administrator functions.
Provided DBA services for UNIFY and ORACLE.
Wrote C triggers.
Programmed in SQL. -
Senior Analyst
Beck Computer Systems
(Information Technology and Services industry)
March 1984 — October 1989 (5 years 8 months)
Designed system for programming PDP-11 and VAX computers.
Designed new Menu, AP, AR, GL, and OE systems for sale.
Analyzed customer's needs, including working with top executives at various customer companies.
Trained programmers.
Extensive applications programming. -
Senior Programmer/Analyst
API Alarm Systems
(Security and Investigations industry)
November 1983 — March 1985 (1 year 5 months)
Designed and programmed telephone bill tracking system, resulting in a savings of thousands of dollars per month.
Upgraded over three hundred programs to new functionality and standards.
Wrote difficult programs.
Trained and managed two people.
Sysgened new computers. -
Senior Programmer/Network Manager/Datatrieve Manager
Platt Music
(Retail industry)
March 1982 — August 1983 (1 year 6 months)
Designed and programmed distributed sales and inventory system for this large retail chain, resulting in a savings of hundreds of thousands of dollars and incalculable business advantage.
Internal consultant and trainer of eight programmers.
Provided technical support for users.
Liason to top management for SICS system. -
Programmer
Linear LLC
(Electrical/Electronic Manufacturing industry)
October 1980 — March 1982 (1 year 6 months)
Converted spaghetti BASIC to USER-11/BASIC+2 relational database.
Trained two programmers.
Wrote sales analyses programs.
Interfaced Apple to PDP-11/44.
Joel Garry’s Education
-
University of California, Santa Barbara
1974 — 1979
Additional Information
Joel Garry’s Websites:
Joel Garry’s Interests:
Database technology, Oracle, manufacturing systems, Corvettes
Joel Garry’s Groups:
-
UCSB Alumni Association -
IOUG – Independent Oracle Users Group -
Oracle Senior DBA Group
Joel Garry’s Contact Settings
Interested In:
- expertise requests
- reference requests
- getting back in touch
