Post Job Free

Resume

Sign in

Senior Oracle DBA

Location:
United States
Posted:
March 11, 2015

Contact this candidate

Resume:

Jeffrey J. Kroma

**** ********* *****

Naperville, Illinois 60540

312-***-****

acoojm@r.postjobfree.com

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