Senior Database Administrator / Informix Specialist /Architect
http://jacobsalomon.com
Informix Administrator seeking a position in the New York City area. I am a
database administrator with additional, widely varying technical experience in
the software industry as Developer, Programmer, Unix System
Administrator,Trainer, Manual Author, Experienced Public
Speaker/Presenter,Consultant, Customer Service Engineer. Experience with
Financial/Securities Industry, Data Analysis for consistency and integrity
checking, Performance Analysis and Report generation.
Programming Languages:
Shell (Korn,Bourne), AWK, Perl (with DBI and DBD::Informix), Informix-4GL,
SQL(Informix, Oracle), ESQL/C (Informix), C, StoredProcedures/Triggers, RCS
Version Control. Some PL/SQL and exposure to OOP with C++ and Perl
Databases
Informix (since1986) Standard Engine and IDS releases 4 through 11.5, Oracle 9
Operating Systems:
Linux (Red-Hat 3, 4),Solaris (5.8), HP-UX (8, 9), AIX Windows-XP.
Some training in Unix internals,
Software/Tools:
Excel, for benchmark analysis and script generation. For Oracle
administrativefunctions: SQL-BackTrack (BMC Software), TOAD (Quest Software).
JYACC/JAM Forms.
Applications:
Financial Industry: Securities Analysis and Trading, Mortgage-Backed Security
Pools. General consulting: The garment industry, database retrieval tools, design
of menus and forms,electronic phototypesetting, real estate management,
collectionagency, systems integration, Unix system administration. Also worked in
technical support and written [non-Unix] device driversand communication
protocols.
Employment History
Oninit.com(August 2008 to December 2009)
Senior Consultant
•Data Warehouse: Redesigned the entire disk-level layout and adjusted a
server’stuning parameters to reduce disk contention. The first pass reduced a
load job from an all-night procedure to a one-hour job.
•Retail StoreSupport: Converted and upgraded an application from IDS 7.2
onSolaris 32-bit to IDS 11.5 on Linux 64-bit. Sifted ESQL/C code forcompatibility
issues related to the new 64-bit environment. At the same time, converted the
source control subsystem from SCCS to RCS.
Morgan Stanley (November 2005 to July 2008)
Senior Informix Database Administrator:
Environment consisting of overtwo-hundred Informix servers distributed across
dozens of hostmachines in North America, Europe, and Asia, running 24x7
applications on Solaris and Linux. Performed routine administrative tasks such as
creation of new servers, space allocation, server upgrades, duplication of
servers on other hosts by manipulating backup sets.
•Performed frequent troubleshooting on these systems e.g. orphaned shared-memory
segments, frozen servers, tweaking of server parameters for performance issues
•Wrote many scripts to perform administrative function e.g. report on
success/failure of backup jobs, diagnose improperly configured database spaces,
identify invalid BLOB values, monitor temp space during the run of abackup,
display the space occupied by a table. Scripts were written in Korn shell and
PERL.
•Debugged and enhanced legacy administrative scripts e.g. periodic check for a
blocked server, scripts to perform unattended backup/recovery.
•Provided occasional support for database issues closer to the applications:
Developed SQL to determine the identity of a locked stored procedure blocking the
server, noted when a different locking behavior might be more prudent for the
users.
Barnes & Noble, Inc. (April 1999 – October 2005): HP-UX, AIX
Senior Database Administrator:
Routine (and not so routine) administrative tasks e.g. space allocation, user
permissionsin database environments, database backups.
•Resource for the architecture of new databases, including appropriate
datatypes, integrity constraints and triggers. In one case, I reworked a stored
procedure as a 4GL program, cutting the job’sduration by 90%. Similarly, rewrote
a JAVA program that could not complete in three days; my version completed in
three hours. When I was permitted to physically rearrange the spaces across
disks, the run time dropped to under one hour.
•Developed a method to back up the Informix database to (and recover from) a
single file system. The backup now completes reliably in under four hours,
replacing a defective OmniBack scheme that previously ran over six hours.
•Wrote scripts to alert the DBA ofpotential problems (e.g.
tablespace/file-system capacity, fragmentation, resource usage) on six
HP-UX/Informix systems and six Oracle databases on four RS-6000/AIX systems.
Scripts were written in various combinations of PL/SQL, PERL, AWK and Korn Shell.
Wrote additional scripts to defragment tables and reallocate space when the
monitoring jobs did detect potential problems
•Implemented a [simulated] lock-quota monitor, providing a feature not yet
provided by the Informix software.
•Published several Informix utility scripts to the IIUG software library,
written in Korn Shell, AWK, and C.
Garpac (1996– April 1999): HP-UX, AIX, Informix
Database Administrator, Programmer, Unix System Administrator:
DBA as well as Unix system administrator for office and several clients,
including setup of file systems and raw logical volumes. Client systems varied
among HP-UX, AIX, Solaris, and SCO.
◦Performed complete system installation at client sites: Physically
installing the hardware, installing and configuring the operating system, then
the database software and finally, the application.
◦Wrote a label-printing subsystem with a term cap-like database forvarious
label printers.
◦Wrote shell and AWK scripts to perform data conversions, helping clients
convert their existing databases to Informix database formats.
Informix Software (1990 to 1996): Sun-OS, HP-UX, Informix Engines and Tools:
Consultant, Customer Support Engineer, Database Administrator, Programmer,
Trainer:
◦HP-UX System administrator for the HP-9000/827 and G30 training
machines.
◦On-site consultantat Bloomberg, a major provider of financial
information. Wrote tools using C, Korn-Shell, and AWK to assist the
administration of dozens of OnLine systems.
◦Taught several courses, including Relational Database Design and
Architecture, 4GL,SQL, Stored Procedures and Triggers, Embedded SQL for C,
Database and System Administration for Informix Dynamic Server.
◦Contributed several articles and scripts to the internal TechInfo
database (accessible via a Web home page) and published several articles inthe
Informix quarterly, Tech Notes.
◦High-level supportliaison to developers of Informix applications at
AT&T-IMS inPiscataway, NJ.
◦Served Informix’s New York and New Jersey offices in the capacity of
client servicesengineer, traveling consultant and trainer.
◦Participated inpre-sales meetings and provided post-sales customer
services,including consulting and solving (or escalating) reported problems.
◦Coordinator of the customer training program in the New York Office.
Prior Experience (Consulting Assignments prior to 1990)
AT&T Business Sales Division: AT&T 3B2/1000, UNIX/C,INFORMIX-4GL/SQL:
◦Wrote more than twenty interactive applications to maintain and report
the data invarious database tables. Programs were developed using the
INFORMIX-Rapid Development System, then recompiled under INFORMIX-4GL.
ChemicalBank Retail Sales Division: Microsoft C, JAM, TechnicalWriting:
◦Tested more than seventy vendor-written “intrinsic functions” against the
vendor’s [sparse] documentation. Analyzed the vendor’s (mostly uncommented)
source code to determine its functionality and logic. Used this knowledge to
rewrite the vendor’s User Guide to the Intrinsic Functions, adding examples and
guidelines as well as describing known bugs. This allowed the programming staff
to write new applications using these functions.
The North American Investment Bank: VAX 6330, VMS, C:
(NAIB was a division ofCiticorp): Wrote the following applications to support
atrading-floor information service:
◦Multi-page display of information on mortgage-backed security pools.
◦Yield-history of more general types of financial instruments.
◦Designed and coded the structures, macros, and functions to support
several programming tools, replacing tedious, error-prone coding with
table-driven mechanisms. These included field-by-field conversion of unlike
structures, a low-level report generator and a multi-screen recordnavigator.
J.P.Morgan Securities: Time-series financials, VAX-8800, VMS, C,RMS-32, PAMS
◦Wrote the largest component of a real-time data capture application,
designed specifications for that and two other components. The application’s
purpose is to calculate and store the latest prices and other measures of value
on various financial instruments (over fortytypes) as current values as well as
time-series data. The data flow required interprocess communication, which was
performed using PAMS(Process Activation Message Switch, an IP communication
product from DEC).
◦Made significant contributions to the design of the library underlying
the data capture application. This included record layouts and the need/usage of
specific fields, as well as defining the relationships among the various files.
Most important was the preservation of data despite the loss of the process
handling it. This was accomplished by use of a process-auditing trace and shared
memory
◦Was instrumental in getting DEC to add the feature of queues with
multiple readers totheir PAMS product.
◦Provided the means for a master process to monitor the lengths of message
queues, spawning more queue-servers when necessary.
◦Prepared preliminary designs for phase-II optimizations on the more
volatile instruments.
◦Designed and prototyped a utility to allow a user to examine rejected
data and modify it for resubmission. The tool’s user interface screens, which
were developed under JAM, simulate specialized spreadsheets.
◦Query Tool:Integrated several components (JYACC FORMAKER, Oracle,
SmartCom-III,Lotus Symphony) into the design of a forms-driven application and
data dictionary. The package allowed a PC user to retrieve data froma database
with no specific knowledge of the underlying database structure. Rather, the user
specifies English names for database fields. The package translated field data on
a simulated spreadsheetinto SQL, retrieved data from a relational database
(ORACLE) on the host HP-9000 and imported it into a LOTUS spreadsheet on the PC.
Forms were developed under JYACC FORMAKER.
Computing Software Services: INFORMIX-4GL, C
◦Designed the database and screens, coded the programs for a collection
agency,including data entry/query, case tracking, referrals, payment schedules
and disbursement of funds. Provided access controls at both, the table and record
level to prevent unauthorized access/modification to various tables and
individual records withineach table. This was done using both, database security
and explicitcoding within the applications.
◦Wrote aprogramming tool to scan C source code and provide a listing
thatincludes source line numbers, block nesting levels and across-reference
listing.
◦Enhanced anINFORMIX-based law office application by integrating it with a
wordprocessor. Made a similar enhancement to an INFORMIX-basedpersonnel
application to track applicants’ resumes. (This wasbefore database BLOB
technology was available.)
◦At Brown, Harris,Stevens: Real Estate Management: Designed the Informix
database andscreens, coded the application programs for a real estate
managementapplication. Provided for data entry and query, aiding in the saleand
brokerage of co-op and condominium apartments.
MATRIX Software:Form creation, text editing, PDP-11/23, 11/73, MACRO-11
◦Designed and codeda small screen-processing subsystem, providing an
operator interfaceto a CAT-scan laser recorder.
◦Wrote a processcontrol module to direct the movement of film through the
laserrecorder.
◦Wrote a graphics utility that allows an EPSON FX-286 printer to emulate
the laser recorder, producing images similar to what would have appeared on the
far more expensive X-ray film.
Education
New York University School of Continuing Education:
Certificate: VAX/VMS Programming
Certificate: UNIX/C Programming
Brooklyn College:
Bachelor of Science Cum Laude
Major: Mathematics.
Minor:Computer Science (31 credits)
|
