Brian Lomasky
SUMMARY
Senior Oracle 10g, 9i, 8i, Oracle 8, and Oracle 7 Database Consultant
Infrastructure Performance Tuning
Parallel Design and Implementation, and Replication
Administration of VLDB databases up to multi-Terabytes in size
Best-selling Oracle Author
TECHNICAL EXPERTISE
Databases - Oracle 10gr2, 10g, 9ir2, 9i, 8ir3, 8ir2, 8i, Oracle 8,
Oracle 7, Certified Oracle DBA, Certified Oracle 10g technician,
Oracle Workgroup Server, Oracle Parallel Server, Oracle RAC
Hardware Platforms/Operating Systems - HP9000, HP/UX, SCO UNIX,
Sun6000 Suncluster 3.0 and 2.2, Sun E25K, E15K, E10000, SunFire 280R,
SunFire 6800, Sun E4500, Sun V880, SunOS and Solaris, Veritas
VolumeManager, Veritas Cluster Server (VCS), Veritas Quick I/O,
Veritas Database Edition, Veritas Foundation Suite, Egenera, IBM
pServer 690, IBM RS/6000 SP and AIX, Pyramid Nile, Sequent Numa
DYNIX/ptx, HP Compaq Digital (DEC) Alpha Unix/TruClusters, SGI Irix,
Linux x86 (RedHat and SuSE), VAX/VMS 8600 clusters, Windows NT
clusters, EMC Symmetrix TimeFinder/SRDF/BCV, EMC CLARiiON, RAID,
Oracle Names, Oracle Net, Net8, SQL*Net, DECnet, NetWare, RSX-11M-PLUS
Languages - Oracle SQL, SQL*Plus, PL/SQL, SQL*Loader, SQR, BASIC,
FORTRAN, COBOL, DCL, MACRO, DATATRIEVE, FMS, RMS, Unix/Linux shell scripts
Industries - Educational, Financial (Banking, Credit Card,
Investment), Government (Federal, Military, State), Health Care
(Hospital, Insurance), Industrial (Gas, Plastic), Insurance, Internet
(eCommerce, Web Hosting, ISP), Manufacturing (Consumer, Electronics,
Furniture), Retail, Software Developers, Telecommunications (Cellular,
Cable Television), Utilities (Gas, Electric)
Applications - Artemis Project Management, ASK/MANMAN Material and
Requirements Planning (MRP) Systems, Baan, Banner, Component
Information Systems, Contract Administration, Credit Card processing,
Data Warehouse, Dialysis database, e-Commerce (PC Sales, Portal web
site, Search Engine), Emergency Medical Service, Employee Benefit Plan
management, Fingerprint Matching, Gas and Electric Brokering, Incident
Tracking, JD Edwards Purchasing, Leasing, Noetix Views, Oracle
Accounts Payable, Oracle Inventory, Oracle Financial Applications 11i,
10.5, and 9.04, Oracle InterOffice, Oracle Purchasing, PeopleSoft, SAP
SKILLS
Performance Analysis and Tuning
. Hardware (Sun, HP, IBM SP, Digital, Pyramid, Sequent, Linux,
Win NT, EMC DMX and Symmetrix, EMC CLARiiON)
. Operating System (Unix, Linux, OpenVMS, Windows NT)
. Database (Oracle 10g, 9i, 8i, 8, 7)
. Application (SQL and PL/SQL)
Oracle Parallel Fail Safe / Oracle Real Application Clusters Data Guard
. Configuration, Installation, Tuning
. Sun Cluster, Veritas VCM, EMC Symmetrix / PowerPath
Oracle Parallel Server Clusters / Oracle Real Application Clusters (RAC)
. Configuration, Installation, Tuning
. Design for fault tolerance and maximum throughput with high
Tps
. Oracle and Unix Distributed Lock Manager (DLM/IDLM)
configuration
. Sun, HP, IBM SP, Linux, Pyramid, Sequent, Compaq Win NT, EMC
Symmetrix
Oracle Advanced Replication
. Symmetric and Asymmetric
. Synchronous and Asynchronous
. Snapshot and Multi-Master
. Implementation and Configuration
. Production OLTP and Corporate Data Warehouse (DSS) systems
Oracle Parallel Query
. Configuration and Implementation
. Parallel Processing performance monitoring and tuning
Oracle Advanced Queuing
. Architecture design
. Multi-node Configuration and Implementation
Oracle 8i Data Cartridges
. InterMedia Text (Context) installation and verification
Database Backup and Recovery
. Advise clients on proper backup and recovery strategies
. Institute database archive processing consistent with
business requirements
. Implement database backup and recovery procedures
. Provide options for disaster recovery and fail over scenarios
. Create and configure Oracle Standby Database
. Design to minimize downtime and risk exposure in the event of
hardware or software failure
. Interface with Legato Networker, Veritas Netbackup, HP
Omniback, Alexandria Backup products, and EMC TimeFinder BCV
Monitoring
. Configuration and Database structure analysis
. Daily growth and periodic trend analysis
. Automatic Database Error and Exception notification
procedures
Database Design and Maintenance
. Physical and Logical design
. Optimal object sizing and placement
. I/O subsystem configuration (Mirroring, Striping, RAID0+1,
RAID5)
. Database Object and Application Partitioning
. Custom data loading procedures
. Develop and deploy Oracle database monthly archival
procedures
. Operating System configuration and tuning
. Production (OLTP) and Data Warehouse (DSS) systems
. Very Large Database (VLDB), multi-Terabyte
. EMC Symmetrix
Installation
. Oracle 10g, 9i, 8i, 8, 7, Oracle Names, Net8, SQL*Net, Oracle
WebServer, Oracle 8i iFS (Internet File System)
. HP/UX, SunOS and SOLARIS, IBM SP and AIX, Pyramid, Linux x86,
NetWare, VAX/VMS, Compaq Digital (DEC) Unix, SCO Unix,
Windows NT
Operating System Configuration
. Unix kernel parameter settings and optimization
. Unix Logical Volume Manager (SLVM, LVM, Veritas)
configuration
. Created automatic Unix system startup and shutdown procedures
for Oracle and Parallel Cluster Database
. VMS Sysgen parameter and account parameter settings and
tuning
. Windows NT registry parameter settings and configuration
Troubleshooting
. Investigate and correct for poor system and database
performance
. Analyze and correct ORACLE7 database corruptions
Security
. Audit database security configuration
. Audit operating system security environment
Training
. Advise and train clients on proper system and database
procedures
. Recommend appropriate database monitoring tools
. Present national and local Oracle training sessions (Oracle
Education, IOUG-A conference, Oracle OpenWorld conference,
Northeast Oracle User's Group, on-site company training)
. Present technical sessions at national DECUS and ASK/MANMAN
conferences.
. IOUG National Oracle Certification (Chauncy Group
International, Educational Testing Service)
Development
. Design, code, and install tools and procedures to support
world-wide MRP systems and operations
. Created system management and security programs and
procedures
. Created end-user and staff programmer documentation
CAREER EMPLOYMENT
DBA Solutions, Inc., Arlington MA
Principal, March 1999 to Present
. Oracle DBA Consulting
. Utilizing the skills as described above
Oracle Corporation, Redwood Shores, CA
Senior Principal Consultant, February 1998 to February 1999
. Oracle On-Site Database Analyst - Nationwide
. For Manufacturing, Insurance, Financial Services, Education,
and Government organizations
. Utilizing the skills as described above
Database Technologies, Inc., Newton, MA
Senior Principal Consultant, June 1996 to February 1998
. Oracle DBA Consulting for Manufacturing, Telecommunications,
Financial Services, Energy, Medical, and Retail companies
. Utilizing the skills as described above
Teradyne, Boston, MA
Senior Software Engineer, February 1987 to June 1996
. Designed, coded, and installed tools and procedures to
support world-wide MRP systems and operations in an
environment consisting of clustered VAX/VMS systems using
ASK/MANMAN, BASIC, FORTRAN, DCL, and MACRO, and 2 HP 9000
Series 800 systems using HP-UX 9.04, ORACLE7 RDBMS, ORACLE
Applications 10.5, and a Component Information System.
. Designed, coded, and installed DBA tools to support ORACLE
applications.
. Implemented Oracle replication to corporate data warehouse.
. Installed, maintained, and supported VMS system software,
ORACLE7 RDBMS, and ORACLE Applications for VAXcluster and
Unix systems.
. Evaluated and implemented system management and security
needs.
. Trained and created documentation for users, programmers, and
DBAs on VMS applications and tools, ORACLE7 tools, and PC
software.
. Presented technical sessions at national DECUS and ASK/MANMAN
conferences.
Simmonds Precision Products, Vergennes, VT
Software Engineer, December 1985 to February 1987
. Provided technical support and managed VMS/VMS 8600 upgrades
and software maintenance.
. Designed, coded, and installed database development, software
tools, and security monitors using BASIC, FORTRAN, DCL, FMS,
and RMS
Times Fiber Communications, Wallingford, CT
Senior Software Development Engineer, March 1983 to December 1985
. Software development on Digital VAX/VMS 11/780
. Performed system management, upgrades, and technical support
Faria Corporation, Uncasville, CT
MIS Manager, May 1980 to March 1983
. Performed system software design, implementation, debugging,
coding,
. operation, training, and user interfacing for manufacturing
systems
Com-Pute, West Hartford, CT
Software Consultant, August 1978 to April 1980
. Software consulting for commercial customers on a variety of
business applications
Computer Assistance, West Hartford, CT
Software Consultant, February 1978 to August 1978
. Software consulting using RSTS/E and BASIC-PLUS-2
Com-Pute, West Hartford, CT
Software Consultant, May 1976 to February 1978
. Software consulting
PUBLICATIONS
Layout of Oracle Databases on EMC Symmetrix Systems, EMC Corporation, 2002
Oracle Scripts, O'Reilly & Associates, Inc., 1998
Education
International Oracle Users Group, Chicago, IL
Oracle DBA seminars.
Oracle Education, Redwood Shores, CA
Oracle SQL, PL/SQL, DBA, and internal technology courses.
Oracle Applications System Administration and Financials.
Control Data Institute, Burlington, MA
Certification in Computer Programming
Computer programming course including COBOL, FORTRAN, assembly, and
machine languages.
Northeastern University, Boston, MA
Courses in FORTRAN, COBOL, and BASIC languages.
Rev 24
Member number:4815
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 1999 Software Contractors' Guild,
Post Office Box 257,Nottingham, NH USA 03290-0257