You are hereSQL

SQL


SQL Programming

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

Satellite Markets & Research - Linux System Admin, Drupal Developer

Satellite Markets & Research
Covina, CA

2017-08 to 2017-08


Accomplisments: Move Drupal website from Network Solutions to BlueHost; Upgrade Drupal to latest version; Investigate migration to Drupal version 8.

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

SportsGrants Foundation - System Administrator / Software Developer

SportsGrants Foundation
Hood River, OR

2012-08 to 2012-11


Responsibilities: Architect and develop LAMP based website (RapidGiving.org) for collecting charitable donations; Setup Amazon Web Services (AWS) with a Virtual Private Cloud containing 8 server instances in multiple subnets including a load balancer for 4 webservers; Setup domain and IP addresses in AWS Route 53; Setup MySQL database server in AWS RDS Management Console. Install and configure Power MTA email server; Use Twitter Bootstrap for page layout and development; Write custom JavaScript jQuery code for form hiding, navigation and drop down loading; Integrate Janrain Engage for website login from social websites; Integrate Cloudsponge for accessing user email address books; Integrate with PayPal website to collect the donations; Maintain source code in a GitHub repository; Develop Facebook login with FB OpenGraph SDK; Develop Twitter login with Twitter SDK; Collect and post race times from Twitter "tweets" feed.

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.

Hoverstate - Senior Developer

HoverState
Encino, CA

2011-09 to 2012-08


Responsibilities: Work closely with an international team to develop a Drupal based "intranet" website for Health Net. Wrote LINUX sysadmin tools to assist in deploying code changes from CVS to test and staging servers. Wrote and maintained several custom Drupal modules. Architected and developed applications for a hierarchical document library and for policy benefits documentation. Wrote custom PHP application to import thousands of documents from XML into a MySQL database and an Alfresco repository. Wrote custom Drupal module to integrate folders with Alfresco via the CMIS protocol.

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.

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.