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