You are hereDatabase

Database


Database Developer

Michael S. Hearn Enterprises - Owner / Consultant sticky icon

Michael S. Hearn Enterprises
Manhattan Beach, CA

1993-09 to PRESENT


Responsibilities: Independent Computer Consultant (System Architect, Software Developer, System Administrator, Database Administrator, Database Developer, Website Developer)

Contract Experience: Click Here

GCS - Network Admin, Linux System Admin, Oracle Developer, VMware Admin

Global Communication Semiconductors, LLC
Torrance, CA

2013-03 to 2016-03


Accomplishments:
      Windows Administration
    • Lead team for Windows Active Directory conversion from Windows NT
    • Install and configure Windows 2012 Print Server for all LAN printers
    • Setup remote Active Directory and printer servers for satellite accounting office
    • Purchase and implement Xming client for remote W-Windows administration of Unix servers
      CAD Department Support
    • Upgrade CAD software (Cadence, ADS) for CAD engineers
    • Install Solaris, RedHat and CentOS on CAD workstations
    • Trouble shoot problems with CAD workstations
    • Setup Solaris virtual machine as license server
      Network Administration
    • Clean up cabling mess on all network and server racks
    • Redesign entire internal LAN
    • Recommend and Install Network Hardware Upgrades
    • Design and Implement Site-To-Site VPN between 2 local offices and Taiwan office using MikroTik Routers
    • Configure VoIP phones to access SIP server across VPN
      Website Administration
    • Move corporate website to internal virtual machine
    • Fix Javascript problems with multi-language corporate website
      Oracle Linux Administration
    • Configure Linux servers with X Windows XDM for admin GUI access
    • Setup Linux MySQL server for internal testing app
    • Setup internal Sendmail SMTP servers for internal mail relay
    • Move Eyelit Manufacturing software from Windows to Oracle Linux
    • Move Eyelit Oracle database from Windows to Oracle Linux
    • Setup Secondary DNS server with BIND in accounting office
      Eyelit Manufacturing Software Administration
    • Setup development and test instances of Oracle database and app server
    • Work with customer support to troubleshoot problems
      Oracle Database Development (APEX)
    • Wrote Integration software between Eyelit manufacturing and accounting costing DB
    • Wrote Lot Scheduling system (Integrated with Eyelit Manufacturing software)
    • Wrote Quarterly Sales Summary Graphs and Reports
    • Wrote Weekly Production Graphs and Reports
      VMware Environment
    • Install multiple VMware ESXi servers
    • Install HP P2000 DAS (Direct Attached Storage) and connect it to 4 ESXi servers
    • Add disk drives to ESXi servers as needs grew
    • Replace failed controller and compact flash in HP P2000 DAS
    • Setup High Availability Cluster on 3 ESXi servers
    • Select and install Seagate NAS for Virtual Machine backups
    • Setup Virtual Machine backups with GhettoVCB backup software
    • Install redundant UPS battery backup servers
      Documentation
    • Install internal "intranet" server with Drupal CMS
    • Install MediaWiki server
    • Write network and system documentation on Wiki and intranet servers

ByteSlinger.Net - Website Development and Hosting

ByteSlinger.Net
Manhattan Beach, CA

2005-03 to 2011-09


Responsibilities: Design, develop and host custom websites; LINUX system administration for multiple servers at BlueHost.com; maintain backup websites on Macintosh OS X server; primarily using Drupal CMS, PHP, with MySQL databases; Develop custom Drupal modules to meet client needs.

PROSUM (CitizenHawk) - System Architect / System Administrator

CitizenHawk, Inc.
Aliso Viejo, CA

2008-10 to 2009-05


Responsibilities: Evaluate existing hardware and software architecture and security environment; re-architect Dell Linux (CentOS) servers hardware and custom Java software for domain typo-squatting product; system administration for 12 CentOS servers; implement new Java software deployment practices; assist development staff in debugging java software; assist CTO with project planning; trouble shoot network issues; configure/manage network firewalls; move all servers to new hosting facility while maintaining a functioning system.

Prime Contractor: PROSUM

DigiLink Network Services - Software Engineer

DigiLink Network Services
Marina Del Rey, CA

2006-09 to 2007-08


Responsibilities: Design and development of integration system between Voice Over IP (VoIP) usage (EMI, Asterisk, OpenSER) and customer invoicing application, using PHP, Perl and MySQL database.

DigiLink Network Services - System Administrator

DigiLink Network Services
Marina Del Rey, CA

2006-03 to 2008-04


Responsibilities: UNIX System Administration of 10 SUN Solaris servers for Warner Brothers Music Group; upgrading Oracle from 9.x to 10.x, upgrading Lyris List Manager software; write automated backup scripts to create images of all disks on all servers to backup RAID array across NFS mounts; wrote Oracle to MySQL database copy scripts.

ValueStream, Inc. - System Administrator / Web Developer

ValueStream, Inc.
San Diego, CA

2001-11 to 2010-06


Responsibilities: Ongoing customer system support; SUN Solaris and RedHat LINUX system administration; apache webserver patches, upgrades and configuration; DNS configuration and maintenance; Sendmail configuration; IP address conversion for all virtual hosts to new IP block; Perl script to collect addresses for bounced emails; CGI scripts for custom reports from MySQL database; advice for Mac OSX problems; support for Maxsponder email software; configure and install LINUX servers and install at ISP co-location facility; configure LINUX RAID drives; setup root BIND DNS servers for ~200 domains; Perl scripts to do backups and maintain redundant DNS servers; Perl scripts to automaticly configure virtual host websites, including IP address, DNS and apache setup.

IGP Technologies / NowMD.com - System Architect / Software Developer

IGP Technologies
Altadena, CA

2005-08 to 2005-12


Responsibilities: Design, development and implementation of website and database to provide online medical diagnoses; LINUX server system administration, MySQL database administration, Tomcat Java application server administration; designed and implemented web based interface to maintain patients and diagnoses.

Prime Contractor: CFUS Corporation

PROSUM - System Architect / Lead Developer

PROSUM
El Segundo, CA

2003-11 to 2005-05


Responsibilities: Lead 3 developers in design and development of website using Java (Jakarta Tomcat Application Server on RedHat LINUX) and a Microsoft SQL Server database (also works with MySQL database), that offers multiple content applications to residents of Planned Communities; Applications included Email (integrated IPSwitch IMail), Message Boards, Calendar, Photo Gallery, Vendor Directory, Resident Directory, Clubs, Surveys, Help, Community News, and Content Management. System administrators use the website to maintain content directly and upload photos and PDFs into the database. All content comes from the database including all images, stylesheets and navigation menus. Used Expresso (Jcorporate) as the J2EE Framework for user and application security; maintaining 1200 source files using CVS; specifying hardware and software for purchase; assisting network engineers in troubleshooting network issues and hardware installation; data conversion of existing MS SQL Server databases for 9000 users; deploying system for 4 Planned Community websites; used Netbeans for Java development.

Unitrin Financial Indemnity - Software Developer

Unitrin Financial Indemnity
Woodland Hills, CA

2002-09 to 2003-06


Responsibilities: Develop multi-threaded C++ TCP/IP server on AIX UNIX; develop Windows NT2000 DLL libraries (MS C++) to integrate claims application (MS Visual Basic) with TCP/IP interface on AIX server; design and develop custom search GUI as a DLL library (MS C++) to integrate with claims application; design and develop DLL library (MS C++) to access Oracle 8x database; organize installation of all custom integration components.