Michael P. Wilson
mike@michaelpwilson.com New Haven, CT
Summary
Database and UNIX Administrator with advanced experience with network administration/design, storage & backup systems, database management, and development of web-based applications who is accustomed to working in high throughput scientific environments and 24x7 multi-host enterprise production environments.
Education
- Master of Science in Computer Science, Rensselaer Polytechnic Institute, Hartford, CT
- Specializing in Database Systems and Network Management.
- Bachelor of Science in Computer Science, Trinity College, Hartford, CT
- Strong concentration in computer engineering, math and physics coursework.
- Associate in Arts, City College of San Francisco, SF, CA - Magna Cum Laude
- Alpha Gamma Sigma Honor Society - President
Computer Literacy
- Linux, Mac OS X, Solaris, HP-UX, IRIX, Tru64, MS Windows
- MySQL, PostgreSQL, Oracle, DB2, Apache, iPlanet, Weblogic, Microsoft, Veritas, Legato, SAS, Stata, Splus, Matlab, GNU/Open Source
- Apple Xserve, Xserve RAID, XSAN, XGrid, Mac Pro, MacBook Pro
- Sun E6500, E4500, E3000, E450, E420R, Netra, Sunfire v100, UltraSPARC 60/10/5, Blade 100, SunRay 100
- Intel Xeon/x86, AMD Opteron, HP 9000, SGI Origin, O2, Iris, DEC Alpha, Motorola 68K/PowerPC
- SQL, PL/SQL, Perl/CGI, Python, C/C++, Java, JDBC, OpenGL, TCP/IP, OSI, DNS, BIND, DHCP, NIS, NFS, RPC, SMB, SNMP
Professional Experience
05/04 - Present Yale University, School of Medicine, Molecular Boiphysics and Biochemisty, New Haven, CT
Database Administrator and Lead LIMS Developer
- Model and implement bioinformatics databases in consultation with experimentalists.
- Evaluate physical data serving and storage needs and recommend hardware purchases to accommodate both needs and budget.
- Develop novel approaches to data storage and retrieval problems to meet requirements within financial constraints.
- Design and code web-based Laboratory Information Management Systems used for high throughput genetic sequencing.
- Contribute to federal grant applications and to quarterly and annual federal grant reports.
- Present regular periodic lectures on work in progress to lab members and at academic conferences.
- Teach and assist faculty, post-doc and graduate students to model bioinformatic data and use the various LIMS.
- Assist with the analysis of data using the Yale Biomedical Super Computing Cluster.
10/01 - 05/04 Argus Networks, Los Angeles, CA, New Haven, CT, & San Francisco, CA
Chief Information Officer
- Materially contributed to start-up venture and saw it through to acquisition.
- DBA on MySQL & Oracle 8i. DB replication, PL/SQL, Triggers, Stored Procedures, Functions
- Administer Solaris 8 & Red Hat Linux on load-balanced servers.
- Perl, CGI, PHP programming with CVS revision control.
- Project manage teams of programmers.
- Provide plain English reports of technical issues to executive management.
- Manage the design and rollout of new high-availability high-density Solaris-based server product.
- Administer Solaris 8 on Sun E6500, E4500 & E450 servers.
- Manage client data entry and DB2 database creation projects.
- Implemented three-tier e-commerce design and configuration using iPlanet, Weblogic and Oracle.
- Led team of graphic and web designers for client websites.
06/99 - 10/01 Yale University, School of Management,
International Center for Finance, New Haven, CT
Senior Unix Administrator, Systems Programmer &
Database Administrator
- Purchased, installed, configured, upgraded, administered and supported Solaris 2.4-2.8, Linux, Tru64, and Mac OS X Server in a 24x7 network of 28-nodes consisting of Sun E420R and Netra T1 servers, Ultra 5, 10, 60 and DEC Alpha workstations, Sun SparcStation20s, SunRay appliances, and Linux and Mac OS X Server systems.
- Engineered fail-over network redundancy to ensure system stability and consistency.
- Troubleshot and tuned network and kernel related issues.
- Managed both RAID and fibre-channel SAN systems and implemented automated backups over a private 100Mb switched network to a Veritas NetBackup server attached to a DLT tape library.
- Wrote UNIX systems programming shell scripts to perform necessary administrative and security tasks.
- Installed and configured Apache HTTPD and MS IIS web servers.
- Installed, created, and recovered DB2/WebSphere databases.
- Served as DBA for ICF financial data collections (CRSP, Compustat, Bloomberg, Morning Star, etc).
- Purchased software and managed licensing, service agreements and data subscriptions.
- Scripted with Perl and CGI, experience includes customization of Open Source code for SSL encrypted user authentication to accept, verify and post online submissions to a scholarly financial journal and its component online forum.
- Taught and assisted Yale faculty and PhD researchers with the creation of custom Perl, C/C++, Java, SQL, SAS, and Fortran based programs used for data extraction and statistical data processing for leading empirical financial research.
- Managed programming team for custom web portal projects at the International Center for Finance.
- Integrated Real Networks streaming media into SOM & ICF websites.
09/95 - 05/98 Trinity College, Hartford, CT
UNIX/NT Network Administrator -- Engineering
Department (06/96 - 05/98)
- Maintained HP 9000 Unix and Windows NT departmental networks.
- Performed hardware and software installations, upgrades and tape backups.
- Managed client/server file systems, user databases and department web pages.
Academic Mentor -- Engineering Department (08/96 - 05/97)
- Teaching assistant for yearlong seminar on Computer Communications.
- Served as academic adviser for prospective engineering majors.
- Conducted lectures, labs, and study sessions.
Staff Assistant -- Academic Computing (09/95 - 08/96)
- Troubleshot campus-wide problems for heterogeneous network.
- Trained and supported faculty and staff in multi-platform environment.
- Staffed help desk and provided user support.
Professional Certifications
Sun Certified System Administrator for Solaris 8
Professional Affiliations
- IEEE, The Institute for Electrical and Electronics Engineers
- ACM, Association for Computing Machinery