DBA, Systems Architect, Unix, Linux, SAP

Download a Word Version @ http://www.mgmtech.us
Michael A. Gallagher

Email:  [EMAIL PROTECTED]

Mobile:  847-628-7934


Summary
Over fourteen years of extensive experience in large, demanding technical
environments.  Self-directed, proactive, dedicated and dependable.
Excellent performance under pressure in addition to exceptional oral and
written communication skills.



Skill Sets
Systems Administration: HP-Certified System Administrator.  Perform senior
level support for large HP-UX and Solaris environments.  Includes  server
sizing and procurement, proactive hardware and software maintenance,
disaster recovery planning, general security, filesystem creation &
maintenance, kernel tuning, and performance monitoring.   Created Ignite-UX
server and patch/application depots.  Worked in environment with 250+
servers on rotating 24X7 on-call schedule.



Systems Engineering: Perform hardware upgrades & reconfiguration of HP & Sun
servers, O/S upgrades, patch research & installation, performance and
storage optimization, advanced LVM/Veritas tasks, and data/application
migration.  Actively reconfigure database servers to better utilize
available resources.



Programming: Create well-documented tools using Perl 5.6.X, C, PL SQL,
PRO*C, Assembler and Windows for application and systems development.
Examples include: Automated LVM Volume Group creation and optimization,
enterprise-wide user group modification, password file & UID unification,
disk storage allocation reports, OmniBack auditing reports, Oracle database
statistics/reports, various batch jobs, creation & gathering of
configuration profiles from Unix servers for disaster recovery, and various
critical-process monitoring tools.



Project Management: Manage work intake using well-developed procedures to
analyze and meet business objectives. Includes extensive use of Microsoft
Project, making technical recommendations, tracking progress, status
reporting, allocating server resources and performing necessary
administration/engineering work.



Capacity Planning: Analysis of business and application resource
requirements for recommendations to Management.  Includes planning hardware
& software upgrades, database migration & conversion, and proactively
monitoring performance & resource utilization.  Acted as liaison between
Facilities Management staff and Unix Support groups to coordinate the
placement of Unix servers, EMC Storage Subsystems, STK Tape Backup Robotics,
LAN connectivity and power infrastructure.



SAP Basis Administrator:  Performed all aspects of Basis administration from
new configurations, upgrades and day-to-day administration.



DBA: Very strong DBA skills include database creation, user and security
management, schema analysis, data imports & exports, storage usage
statistics, and general maintenance.  Strong fundamental understanding of
support issues in a shared database-server environment.  Involved with
conversion of databases from Sybase to Oracle.  Familiar with Oracle 8i, 9i,
SQL Server 2000 and Sybase.  Performed data modeling with ERWIN and Rational
Rose for OLTP and data warehousing systems.  MicroStrategy and Oracle
certified.



Web Development: Mid-level skills using Macromedia Dreamweaver/Fireworks to
create various websites.  Use Perl to generate web pages & reports.
Examples include a Small Business site, a small Data Warehouse, policies &
procedures documentation site, and a contacts-management site.



Technical Writing: Create documentation to support technical proposals to
management.   Create system-specific documentation for ease of maintenance.
Created a manual for ordering, procuring and building Unix servers within
established guidelines. Also created a Policy & Procedures website for new
and existing documents.  Document all procedures developed and scripts
written.



Hardware
Hewlett Packard: K-Class, L-Class, L-Class, N-Class, T-Class and V-Class

Sun: Enterprise-class servers, UltraSPARC workstations, 280s, 450s, 4500s,
6800s, 420s, A1000 & D1000 Storage Hardware

EMC: Storage Subsystems: Models 3430, 3500 and 3700

Cisco: Cisco IOS, Terminal Servers: Model 2511

F5: BigIP

Storage-Tek: DLT Libraries:  9710 and 9714

DEC: Storage Works Optical Jukebox



Software
Hewlett Packard: HP-UX 10.X & 11.0, MC/ServiceGuard, IT/OpenView, LVM, PRM,
Ignite-UX, OmniBack 3.5, Glance, Perfview

Sun: Solaris 5.6 - 5.8, 8 Veritas Volume Manager, Jumpstart, Veritas Cluster
Manager

Perl: 5.6.1 and below, perl module installation & use, ANSI C, ksh, gcc

Emc: Symmconsole, BCV, SRDF

Veritas: Disk Suite, Volume Manager, NetBackup

IBM: Websphere - MQ Series

Unicenter: Autosys

Apache Software Foundation:  Apache

Macromedia: Dreamweaver/Fireworks studio

Microsoft: NT 4.0, Win2000, Windows XP, 2000 Server, Visio, MS Project

Red Hat: Linux 9.0 and previous

Oracle: Oracle8.X, 9.X and Oracle Financials, WebDB, Oracle Admin Tools,
SQL, PL/SQL and PRO*C

AT&T: SVR3/SVR4 Unix

SAP Basis: 4.6C





Training & Education
Hewlett Packard: Certified Systems Administrator, Managing MC/ServiceGuard,
OpenView IT/Operations Fundamentals,  OpenView IT/Operations Advanced
Administration

Computer Sciences Corp.: Oracle Database Administration

Motorola: Windows NT Server Administration, Sun Systems Administration, Sun
Server/Workstation Hardware Troubleshooting,  ANSI C Programming, SVR4 OS
Internals, SVR3 Unix Administration, SVR4 Unix Administration, M68k/M88k
Server Hardware &  Troubleshooting, Sun Systems Administration, Sun
Server/Workstation Hardware Troubleshooting



Olivet Nazarene University, Kankakee, IL

Masters of Business Administration, 1997



Southern Illinois University. Carbondale, IL

Graduated: December, 1988.

Obtained: BSEE



Post Graduate Studies in Computer Science Engineering and Information
Systems



PROFESSIONAL CERTIFICATIONS



HP Systems Administrator

Sun Systems Administrator

Oracle 8 Database Administrator

Cisco Network Support Administrator

Microsoft Windows NT Administrator

TCP/IP Certified

MicroStrategy Data Warehouse Certified



Experience




To be disclosed, Chicago, IL

05/03 - Present

Consultant
Responsibilities

Project Management of technical projects over millions of dollars.

Group Manager reporting two levels below Chief Information Officer

Veritas products include administration and configuration of the following,
Netbackup, Veritas Volume Manager and file system, Flash snap, Volume
Replicator and Veritas Cluster Server.  In addition implemented and
administrated databases as follows: Oracle with advanced and standby server
replication, Sybase and SQL Server.  Used and maintained Autosys  and
performed in depth Solaris administration along with scripting and
development.



Sapient Corporation at Motorola, Inc

03/03 - Present

Consultant
Responsibilities

Designed and implemented logical and physical database model for an OLTP
database application.  Performed database and systems architecture, database
implementation and support of SQL Server 2000 databases.  Used ER Studio,
Rational Rose to create and maintain the data model and DDL scripts.
Developed PL/SQL scripts and performed performance and tuning for the
databases.  Used Microsoft source safe and maintained the source safe
database for the developers and self.  Used DB Artisan and native tools to
maintain and administrate the databases.



Acxiom Corp, Downers Grove, IL

01/02  - 03/03

Responsibilities:

Performed HP-UX and Solaris Systems Administration tasks for a large
customer base belonging to Acxiom Corporation.

Responsible for implementing and supporting high availability systems using
MC/ServiceGuard and Veritas cluster manager for the HP and Sun environments
on multiple servers.

Performed SAP Basis administration with SAP Basis 4.6C.  Performed system
installs, upgrades and multiple functions on a large landscape containing
two database servers, three application servers, development, Q/A and
integration testing.

Wrote various programs and scripts in the following languages; C, Perl,
Shell, SQL and PL/SQL.

Responsible for the Oracle database in which the SAP systems were running
on.  Performed and designed backup and recovery, disaster recovery
procedures.  Performed day-today operations and database recovery procedures
for the SAP databases.  Performed system refreshes on a monthly basis to
test and non-production servers in the landscape.



Family Video, Springfield, IL

10/01 - 01/02

Consultant

Responsibilities:

Windows 2000 Administrator

Backend Administrator for Oracle Financials 11i

Administration of Oracle 8i including performance and tuning. Backup and
recovery, security administration, Net 8 administration, patches and
environment setup and architecture

ADI, AP, GL, AR and Inventory

Provided training to client personnel.



Cingular Wireless
12/00 - 07/0

Consultant

Performed database administration functions in a Solaris environment using
Oracle versions 7, 8i and 9i.

Used Erwin to create and maintain the OLTP data models. Performed Solaris
system administration functions with a variety of SUN hardware.

Responsible for the administration of 100+ servers and workstations.
(Hardware includes SPARC, Ultra, E2500, and E4500.  HP N, V, L Class
Servers)

Managed environments running DNS, sendmail, NIS and proprietary
applications.  Responsible for 24X7 support of all systems.

Used Veritas File system and Volume Management, Solstice Disksuite, Sun
Cluster Manager 2.2, Secure Shell (SSH), SQL, PL/SQL, Stored Procedures,
Triggers etc



Dempsey and Co.


05/00 - 12/00

Consultant

Planned and executed the re-architecture, implementation, and transition an
IT infrastructure that supports the client's equity trading function.
Responsible for 75 workgroup and domain clients.

Analyzed, designed, constructed and implemented enterprise wide server and
database architecture.

Administrated Oracle databases running on Solaris 8 used to store and
analyze trading and financial information to support business functions.

Configured backup and Primary Domain controllers.

Configured Cisco network gear for point-to-point communications to Internet
and to Dempsey clientele.

Used Norton Ghost to reproduce system images.

Configured Linux Server with Red Hat 6.2 for DNS, pop3 mail, Samba and web
server services.

Configured Apache web server to be used to serve the dempseyco.com domain.

Responsible for operations of 3 Solaris servers serving Nasdaq applications
and 2 Solaris servers serving a proprietary application called BRASS.

Implemented and maintained Check Point V4.0 firewall for network security.

Implemented a trade server to allow personnel to make live trades via their
homes.

HP-UX 11.0 running on K and N class servers, Sun Cluster Manager 2.2, Sun
Solaris 2.8 running on E2500 in a clustered environment



City of Chicago
01/00 - 05/00

Consultant

Project Manager and participant for implementation of the City of Chicago's
Network Operations Center:  A large heterogeneous network consisting of
Nortell and Cisco routers and switches.  Concentrated on LAN/WAN
technologies such as Ethernet, ISDN, T-1, Frame Relay and ATM switching.

Designed, architected and supported Oracle 8 databases containing network
data. Performed duties such as modeling, architecture, backup and recovery,
performance and tuning and security

 Administration of Cluster Manager 2.2, HPUX 10.20 and 11.0 with
MC/Serviceguard

Implemented and configured HP Open View 6.0, HP ITO 5.0, HP ITA 3.2 and Net
Metrix 6.0.

Managed and administrated SUN Solaris Servers, Net Probes with ITO and ITA
and Net Metrix. Installed and configured Autosys.

Implemented and administrated Compaq Servers running Windows NT 4.0. and NT
4.0 Terminal Server.

Implemented Glance Plus Pak and Perf RX into HP ITO across a Solaris Server
environment.

Administrated and maintained Checkpoint Database for the City's firewall.

Developed an auditing program to track adds, deletes and changes to firewall
records, rules and objects.



Diamond Technology Partners
12/99 - 01/00

Consultant

Built a Sun infrastructure:

Administrated Sun Ultra Sparc 4500 servers to support an e-Commerce
infrastructure

Performed database administration for an Oracle 8i based development
environment supporting an OLTP web application, Infoseek Ultra Seek
development, WebLogic Administration and development, java scripting, shell
scripting, Perl programming and C development.

Used Erwin to create relational data model



Comdisco Corp.

07/99 - 12/99

Consultant

Project Manager and direct participant for Oracle DB and HP implementations.

Lead Oracle DBA.  Responsible for a multiple instance OLTP application
environment. Used Oracle 8i, 8.1.5, 8.0.5, Oracle Enterprise Manager Server
configuration, Oracle Diagnostic and Tuning Pack.

Performance tuned the OLTP database

Supported developers and customers.  Executed database backup and recovery
strategy and replication.  Implemented, created, tuned and maintained each
database instance.

Performed server administration and configuration on Hewlett Packard V Class
and N Class servers.



Oracle Corporation
01/99 - 07/99

Consultant

Implemented an infrastructure for the Chicago Public Schools:

Designed and implemented a Hewlett Packard Server farm required for Oracle
Financials, HR, and GL, AR in Oracle 8.0 and Financials 11.2 environment.
Server farm consisted of the following Hewlett Packard products: HP Open
View Omni Back, HP-UX Version 11.0 64 bit, V Class and 10 K Class Servers,
MC ServiceGuard, HP Open View/ ITO, K Class Servers, Process Resource
Manager,

Supported multiple Oracle 8 databases used to store Chicago Public Schools
data.  Responsible for day-to-day support, architecture, modeling, backup
and recovery and security.

EMC Disk Arrays with Time Finder

Provided round the clock operations support and formal training to operators
and administrators for handoff.



Fermi National Accelerator Laboratory
08/98 - 01/99

Consultant

Upgraded Prism Software's FAMIS, a Maintenance Management package, from Rel.
5.0 (AIX based) to Rel. 6.0 (Windows NT 4.0 based).

Devised database architecture (Oracle 7.3.3); planned and executed the
conversion, performance tuned the database; set up backup and recovery
procedures; and customized the application using PL/SQL, Stored Procedures,
SQL, and PRO*C.

Performed data and application testing for data migration and cleansing
efforts and installed application level patches.



Computer Sciences Corporation, Inc.

05/98 - 08/98

Consultant

Assigned to Year 2000 conversion project:

Administrated Oracle 7 databases

Implemented and supported HP ITO and HP OpenView

24 X 7 Infrastructure support of a 200 Node network comprised of various HP,
AIX and NCR servers

Systems programming for enhanced functionality and support of HP ITO using
MIBS

Implemented and upgraded servers

Maintained various Unix sub systems including, DNS, NFS, security,
scheduling, Logical Volume Manager.

Developed multiple modules of Web based Intranet application used for
support personnel.

Configured and supported Oracle 7.3 running on HP-UX 10.20 for the purpose
of supporting network databases.



Renaissance Worldwide

04/97 - 05/98

Sr. Staff Technical Consultant

Representative Assignments:

Motorola Communications and Electronics (10/97 - 04/98)

Conducted a Network Management project for Motorola Sector Networking.

Implemented, designed and configured a Network Management server used to
control Motorola's peer-to-peer network.

Oracle Version 7 database architecture, design, implementation and
administration

Implemented and devised the architecture of Sun Ultra 3 Server with
Metropolis disk array in RAID 5 mode.

Integrated HP-OpenView, Cisco Works, Optivity, Concorde and MIB support.
Built network configuration maps and database to client specifications.
Worldwide network is in excess of 300,000 devices.



CNA Insurance (06/97 - 10/97)

Overall responsibility was to make technical and process recommendations to
management. Assisted the client with architecture, and re-engineering issues
for a Data Warehousing system used to store and track claim and customer
information.

Reviewed re-designed and tuned Sybase and Oracle stored procedures; "C"
source code, awk, Perl and shell scripts.

Tuning tasks included normalization of the system data model, aggregate
tables, re-indexing strategy, re analysis of query plans and optimization,
Oracle and Sybase performance and tuning and Operating System tuning
analysis.

Used Erwin to maintain and create data model

Motorola Communication and Electronics (04/97 - 06/97)

Performed software development and QA Testing for a Motorola wireless data
product used to transmit data to remote mobile units.

TCP/IP, Assembler, Networking, SNMP, Product Development and Quality
Assurance Test Concentrated on Windows 95 MFC, Winsock, Assembler, and
low-level protocol analysis in Hexadecimal format.



Accenture (formerly: Anderson Consulting)

09/95 - 03/97

Manager / Sr. Technical Consultant

Client: Business Integration Providers

Assisted customers in infrastructure configurations. Emphasis placed on all
major UNIX platforms including HP-UX, Solaris, AT&T, and AIX, system design,
configuration, performance and tuning and all aspects of UNIX and
infrastructure.

Provided architecture, performance and tuning, and administrative services
for Oracle and RDBMS issues.

Provided Engagement teams with expertise in server platform sizing,
client/server architecture validation, UNIX implementation strategies,
application architecture review/validation, interoperability and
connectivity strategies/validation, operation backup/recovery strategies,
custom technical document write-up, overall client/server project quality
reviews.

Designed and developed numerous white papers and methodologies for Andersen
internal use regarding Unix, System Hardware, RDBMS Performance and Tuning
guidelines, vendor selection methodology for O.S., RDBMS, and server
hardware, RDBMS and server sizing, performance with various applications.



CNA Insurance (03/95 - 09/95)

09/94 - 09/95

Consultant

Performed Oracle development using PL/SQL, PRO*C, triggers, stored
procedures, sequences etc for the ARMS project.

Wrote "C" language programs using SCCS for source code control

Performed systems administration functions in HP-UX 10.x environment

Performed Oracle Database administration functions including performance and
tuning, and backup and recovery

Application tuning and SQL tuning

Used shell programming, awk, sed and Perl to format data for data loads

Participated in data modeling and logical database design



Motorola Cordless Telephone Manufacturing

01/95 - 03/95

Consultant

Corporate Security Audit for computer infrastructure.

Platforms involved were HP-UX on HP-700 series workstations, System V R4 on
Motorola MPC hardware. Project consisted of implementation of sysload,
X-Windows auto locking mechanisms, TCP/IP and disaster recovery procedures.

Used "C" programming, shell scripting and UNIX administrative technology to
meet Motorola Corporate guidelines. Responsible for design, support and
change control of the new software modules. Database responsibilities
include architecture review, implementation, data migration, optimization
and implementing operation strategies.



Motorola Cellular Infrastructure Group

01/95 - 03/95

Consultant

Developed network software modules to meet security guidelines specified by
Motorola Corporate Computer Security. Project consisted of system and
network-programming techniques in an HP-UX, Solaris, AIX and Apollo
networked environment.

Performed extensive "C" programming, IPC techniques such as shared memory,
socket I/O and pipes.

Used shell programming, Perl, awk, curses and sed to integrate new software
modules.

Responsible for design, support and change control of the new software
modules for a 300 node cellular network.



Motorola, Inc
03/89 - 09/94

Sr. Software Engineer / Sr. Network Engineer /Database Administrator / Unix
Systems Administrator

Details of above experience are available on request.