Senior Oracle DBA
Resume:
Jeffrey J. Kroma
Naperville, Illinois 60540
******@************.***
SUMMARY
Computer professional with in depth experience in managing large production class computer
systems at the database, operating system, and application levels across multiple platforms and
applications. Able to analyze situations from both the business and technical perspectives.
Capable of working with customers at all levels including senior management, technical
management, and end users. Proven ability to manage technically diverse teams.
EDUCATION
UNIVERSITY OF CHICAGO, GRADUATE SCHOOL OF BUSINESS, Chicago, Illinois 1995
Master of Business Administration
Concentration in Finance and Accounting (GPA 3.8/4.0). Dean’s list 6 out of 6 times, Graduation with Honors.
ILLINOIS INSTITUTE OF TECHNOLOGY, Chicago, Illinois 1988
Master of Science, Computer Science (GPA 3.9/4.0).
Thesis work involved a Prolog implementation of Charniak's AI based Frames System.
UNIVERSITY OF ILLINOIS AT CHICAGO, Chicago, Illinois 1981
Bachelor of Science, Mathematics/Computer Science (GPA 4.8/5.0 - Major GPA 5.0/5.0).
Member of Phi Beta Kappa, Phi Kappa Phi, and Phi Eta Sigma honors societies, James Scholar, Dean's list all 12
quarters, Honors Day Recognition, Graduation with Highest Departmental Distinction and College Honors.
EXPERIENCE
AMERICAN BAR ASSOCIATON (ABA), Chicago, Illinois March 2002 – December 2014
Senior Oracle Database Administrator – Project Manager
Responsible for the management of all Oracle E Business Suite, Teradata Data Warehouse, Oracle
Application Server, Oracle Application Express, Oracle Discoverer 10g, Clarity Business
Intelligence, and LSoft Maestro environments. These responsibilities included administration of
all databases as well as administration of the major applications running on said databases.
• Responsible for Oracle E-Business Suite database administration from versions 11.5.5 to 12.0.4.
• Managed over twenty Oracle 10g and 11g databases across various environments.
• Responsible for the installation/management of all internal Microsoft SQL Server databases.
• Implemented/maintained Oracle’s Grid Control and RMAN database management utilities.
• Setup/maintained Oracle Configuration manager within My Oracle Support.
• Installed/upgraded/managed Clarity Business Intelligence application.
• Installed/upgraded/managed LSoft’s Maestro, LISTSERV, and LSMTP email list management software.
• Performed various auditing functions including user accounts at all levels and database object access.
• Performed upgrade of Oracle E-Business Suite from release 11.5.10 to 12.0.4.
• Responsible for Oracle RDBMS upgrades to 9i, 10g, and 11g.
• Installed Oracle E-Business Suite release 11.5.5 and played key role in the conversion from legacy system.
• Installed/upgraded Teradata’s Data Warehouse solution.
• Installed/managed Oracle9iAS application.
Page 2
Jeffrey J. Kroma
• Project management duties including management of ADP Connection project from the Information Services
perspective.
• Managed team of three DBAs responsible for all current databases and planning for database futures.
• Managed an additional group of four individuals responsible for the daily operations and futures planning for
the Wintel, both server and desktop, and UNIX environments.
• Implemented development, QA, production life-cycle model for all databases and associated applications.
• Designed/implemented capacity planning tools in place to project database growth and usage trends.
• Automated many daily/weekly/monthly administration tasks.
• Established/implemented backup policies for all databases.
Page 3
Jeffrey J. Kroma
DARC CORPORATION, Chicago, Illinois April 1999 – March 2002
Operations Manager
Functioned as the Operations manager for DARC’s internal environment. Responsibilities
included Oracle DBA/Oracle Application Administrator/System Administrator for all of DARC’s
internal UNIX systems.
• Managed between thirty-five and forty-five databases that ranged from V7.3.4 to V8.1.7. Installed and
upgraded the various versions.
• Managed/installed Oracle E-Business Suite releases from 10.7 character to 11.5.3 (11i) in fifteen databases.
These Oracle E-Business Suite applications were installed across the Sun Solaris, Compaq Tru64, Hewlett
Packard HP-UX, and IBM AIX operating systems.
• UNIX system administration of ten Sun SPARC servers. Installed and upgraded various versions of Solaris
including 5, 6, and 8. The majority of these servers contained Sun A1000 disk arrays that were configured for
optimal performance and recovery.
• Maintained the porting environment for the ISIX software division. Servers included a Sun Sparc station, a
Compaq Alpha, a Hewlett Packard HP9000, and an IBM RS/6000. Installed/upgraded operating systems residing
on these systems.
• Designed/implemented a backup/recovery process for the 1.5 terabyte of disk storage via Sun’s Solstice
Backup (a repackaged version of Legato’s backup solution).
• Ensured that all systems were Y2K compliant from an operating system, Oracle database, and Oracle E-
Business Suite perspective.
• Coordinated an entire rebuild of DARC’s computer facilities in the Chicago office including the planning of
the facility from a physical, HVAC, and power perspective.
• Check Point training to provide backup support of the site’s Check Point firewall.
FERMI NATIONAL ACCELERATOR LABORATORY, Batavia, Illinois September 1988 – April 1999
Computer Professional VII (1993 - 1999)
Lead Oracle DBA, UNIX system manager, Oracle Applications manager, and PeopleSoft
Applications manager for Business Services.
• Application administrator for PeopleSoft Human Resources, Oracle Financials™, Designer 2000, Enterprise
Manager, and WebServer products, and Computer Associate’s CCC/Harvest application in Digital Unix and
Windows NT environments.
• DBA responsibilities included the installation, upgrade, and maintenance of Oracle databases as well as
database creation, database backup, and database performance monitoring. Upgraded Oracle from V7.0.13 to
V8.0.4.
• System manager for the DEC Alpha systems. Upgraded Digital UNIX from V1.3 to V4.0B.
• Upgraded Oracle Financials™ V9.4 to V10.7NCA. Installed PeopleSoft Human Resources V4.0 and
upgraded to V7.5.
• Maintained the Oracle software and DEC software/hardware contracts.
• Integrated Oracle Data Browser™ and SQL*Net® into Macintosh and Windows NT client/Windows NT
server environments.
• Documented the Oracle Optimal Flexible Architecture and system security at the Digital Unix operating
system, Oracle database, and the Oracle Financials™ application levels.
• Completed the Oracle DBA masters program (V6 and V7) along with a number of additional Oracle and
DEC courses.
Computer Professional VI (1988 - 1993)
System manager and backup team lead for the group that maintained Fermilab’s Central Facility VAX clusters, the
Distributed Software Group (DSG).
• Primary system manager of various standalone VAXes and a twenty-seven node VAX Mixed Interconnect
cluster. Installed, upgraded, evaluated, and maintained various software packages, performed system tuning,
monitoring, and software development.
Page 4
Jeffrey J. Kroma
• Performed liaison duties between the DSG, DEC's Colorado Customer Support Center, the local DEC office,
and the computer operations group including working with these groups on the diagnosis of software/hardware
problems.
• Oracle Database Administrator. Upgraded from Oracle V6 to Oracle7.
• System manager, user liaison, and technical contact for Fermilab's field test DEC AXP system used to beta
test various DEC and third party software/hardware products including OpenVMS and TGV Multinet.
Page 5
Jeffrey J. Kroma
IIT RESEARCH INSTITUTE (IITRI), Chicago, Illinois June 1982 – September 1988
Research Programmer/Analyst
Responsible for all technical computing facilities within the IITRI Chicago organization.
• System manager of a DEC VAX 11/785 and two DEC MicroVAX IIs. Installation and upgrades of VMS,
system tuning, installation of software products, installation/maintenance of DECnet, and installation of the
company wide Ethernet.
• Wrote an interface between Research and Locomotive Evaluator Simulator, Bolt, Beranek and Newman's
(BBN) RS/1, and the SAS statistical package, and participated in the writing of a data capture/management system
for the project.
• Liaison to the Life Science division with responsibilities that included the upkeep and creation of new utilities
for BBN’s RS/1. Work included maintaining and updating a data capture/management software package
developed by GD Searle.
• Wrote a database search system that interfaced IBM PCs with videodisc players.
• Maintained, licensed, and purchased software including RS/1, SAS, and INGRES.
• INGRES DBA including initial installation.
• Member of the IIT/IITRI committee tasked with developing a corporate wide policy for IIT/IITRI computing.
In charge of Chicago's technical support for the MIS database including design through implementation of the
database.
TRITON COLLEGE, River Grove, Illinois 1982
Instructor
Taught introductory Basic on a Bouroughs computer to two classes.
BELL LABORATORIES, Naperville, Illinois 1981
Member of the Technical Staff
Compared certain areas of different electronic switching systems (ESS) used in the design of an export ESS.
COMPUTER EXPERIENCE
• Operating Systems: Sun Solaris, HP-UX, IBM AIX, Digital Equipment Corporation (DEC) Tru64, Linux,
DEC OpenVMS, Windows 95/98/2000/NT, and MAC OS
• Hardware: Sun Sparc, DEC Alphas, Hewlett-Packard HP9000, IBM RS/6000, DEC VAXes, Wintel PCs, and
Apple Macintosh
• Databases: Oracle, Microsoft SQL Server, INGRES, and RDB
• Languages: SQL, PL/SQL, Fortran, BASIC, C, PL/I, Prolog, IBM assembler, and VAX MACRO Assembler
• Third Party Software: Oracle E-Business Suite, Oracle Application Server, Oracle Application Express,
Oracle Discoverer 10g, PeopleSoft, Teradata Data Warehouse, Check Point Firewall, Computer Associate’s
CCC/Harvest, Mindbridge Intranet solution, Clarity Business Intelligence, Remedy Service Desk Express, Lotus
Notes, and various L-Soft products
Contact this candidate