Résumé

-

-

-

-

-

Kilchoer, Jacques Raymond

Employment

-

-

Return to home

Monitoring Automation Systems
Database Administrator
Irvine, CA
September 1999 - September 2000

• Development support of Oracle and Sybase databases used for alarm system monitoring software, on IBM AIX 4
• Moving all Oracle and Sybase databases to a new server.
• Assistance in writing/debugging PL/SQL code.
• Implementing backup strategy.

Tools used
Oracle Server™ (8.0), SQL*Plus, PL/SQL, Oracle Enterprise Manager, Sybase Adaptive Server 11.5

Ceridian Tax Service
Database Administrator
Fountain Valley, CA
January 1998 - September 1999

• Production support of 20 Oracle databases on HP3000 MPE, HP-UX, Windows NT.
• Monitor databases for performance.
• Implement new database models.
• Verify consistency of development/production environments.
• Test and certify new versions of Oracle.
• Import/export of data between different environments.

Tools used
Oracle Server™ (7.1, 7.3, 8.0), SQL*Plus, PL/SQL, Oracle Enterprise Manager, S-Designer.

UNICARE
Assistant Database Administrator
Newport Beach, CA
January 1997 - December 1997

• Maintaining ORACLE and INGRES databases on VMS and Digital UNIX.
• Monitor databases for performance.
• Database modelling for new systems, designing and implementing database using database rules/triggers.
• Import/export of data between different environments.

Tools used
ESQLC and Pro*C (C with embedded SQL), ESQLCBL and Pro*COBOL (COBOL with embedded SQL), PL/SQL, ERWin.

UNICARE
Programmer/Analyst
Newport Beach, CA
April 1992 - December 1996

• Creating a 3-tier client/server application for a Health Care Provider network directory.
• Creating a 3-tier client/server application for tracking long-term and short-term disability patients.
• Enhancements to medical bill validation systems, Health Care Provider network directory systems, and medical Utilisation Review systems.

Tools used for Client/Server development
Windows 3.x, Windows 95, Windows NT, Digital UNIX, DEC C, PowerBuilder, INGRES RDBMS, Oracle RDBMS.

Tools used for other systems
VAX/VMS, VAX C, VAX COBOL, FMS.
Tools used for reporting
Powerhouse Quiz, Datatrieve and INGRES Report Writer.
Professional Coin Grading Service
Programmer/Analyst
Santa Ana, CA
May 1991- January 1992

• Creating and maintaining an inventory, invoicing and data entry system for business.
• Maintaining a system designed using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary), and COBOL.
• Used the software tools MPEX, STREAMX and ADAGER.
• In charge of Macintosh support.
Numismatic Investment Group
Programmer/Analyst
Santa Ana, CA
November 1985 - May 1991

Creating and maintaining an inventory, invoicing and mailing list system for business.
• Designing and implementing databases.
• Designing and coding database retrieval, reporting, entry and updating systems.
• Wrote all programs using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary).
• Set up Vesoft's security system.
• Wrote enhanced JCL using Vesoft's MPEX and STREAMX.
• Maintained data bases with Adager.
• Recommended buying COBOL and rewrote the frequently used programs in COBOL.

Return to top

-	-	-	-	-
Kilchoer, Jacques Raymond
Employment	-	-		Return to home
Monitoring Automation Systems Database Administrator Irvine, CA September 1999 - September 2000 • Development support of Oracle and Sybase databases used for alarm system monitoring software, on IBM AIX 4 • Moving all Oracle and Sybase databases to a new server. • Assistance in writing/debugging PL/SQL code. • Implementing backup strategy. Tools used Oracle Server™ (8.0), SQL*Plus, PL/SQL, Oracle Enterprise Manager, Sybase Adaptive Server 11.5
Ceridian Tax Service Database Administrator Fountain Valley, CA January 1998 - September 1999 • Production support of 20 Oracle databases on HP3000 MPE, HP-UX, Windows NT. • Monitor databases for performance. • Implement new database models. • Verify consistency of development/production environments. • Test and certify new versions of Oracle. • Import/export of data between different environments. Tools used Oracle Server™ (7.1, 7.3, 8.0), SQLPlus, PL/SQL, Oracle Enterprise Manager, S-Designer. UNICARE* Assistant Database Administrator Newport Beach, CA January 1997 - December 1997 • Maintaining ORACLE and INGRES databases on VMS and Digital `UNIX`. • Monitor databases for performance. • Database modelling for new systems, designing and implementing database using database rules/triggers. • Import/export of data between different environments. Tools used ESQLC and ProC (C with embedded SQL), ESQLCBL and ProCOBOL (COBOL with embedded SQL), PL/SQL, ERWin. UNICARE Programmer/Analyst Newport Beach, CA April 1992 - December 1996 • Creating a 3-tier client/server application for a Health Care Provider network directory. • Creating a 3-tier client/server application for tracking long-term and short-term disability patients. • Enhancements to medical bill validation systems, Health Care Provider network directory systems, and medical Utilisation Review systems. Tools used for Client/Server development Windows 3.x, Windows 95, Windows NT, Digital `UNIX`, DEC C, PowerBuilder, INGRES RDBMS, Oracle RDBMS. Tools used for other systems `VAX/VMS, VAX C, VAX COBOL, FMS`. Tools used for reporting Powerhouse Quiz, Datatrieve and INGRES Report Writer. Professional Coin Grading Service Programmer/Analyst Santa Ana, CA May 1991- January 1992 • Creating and maintaining an inventory, invoicing and data entry system for business. • Maintaining a system designed using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary), and COBOL. • Used the software tools MPEX, STREAMX and ADAGER. • In charge of Macintosh support. Numismatic Investment Group Programmer/Analyst Santa Ana, CA November 1985 - May 1991 Creating and maintaining an inventory, invoicing and mailing list system for business. • Designing and implementing databases. • Designing and coding database retrieval, reporting, entry and updating systems. • Wrote all programs using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary). • Set up Vesoft's security system. • Wrote enhanced JCL using Vesoft's MPEX and STREAMX. • Maintained data bases with Adager. • Recommended buying COBOL and rewrote the frequently used programs in COBOL. Return to top