Summary
A IT division manager, Unix System Administrator, Database Administrator, Software Engineer with 30 years experience in a vast array of industries ranging from small businesses to government organizations.
Software development experience for 30 years with a full understanding of the System Development Life Cycle (SDLC). Looking for an environment conducive to learning and growing a career.

Employment History:

Confidential, (08/07– Current)

Responsibilities include

• Fully automated the operations of a health care related business using a custom web based application to run the diagnostics division

Languages/database/frameworks used for application are:

• PHP – Used web and command line technology for total solution.
• MySQL – Multi-Gigabyte MySQL Cluster database to support diagnostics operations for maximum uptime and scalability.
• Javascript – Used to enhance user experiences ranging from simple spreadsheet like capabilities to reference table lookups using known criteria.
• Ajax – Used to enhance speed of database access and improve programmer readability.
• jQuery – Used to improve the user experience with the numerous interface frameworks like Tabs and Accordions and to improve the programmer readability.
• CSS – Used to standardize the look and feel.
• Unix shell script – Automated reports that were needed to be sent periodically to various email accounts.
• Complete solution was housed on a Sun Solaris Unix based blade system using 4 of the 5 logical domains (LDOMs). Blades are Sun\'s T1 processors with 8 cores of 4 threads per core. There were 2 primary domains and 2 guest domains. Each domain consisted of a MySQL Cluster data node.
• Unix System Administrator Highlights
• Managed Sun Microsystem\'s Blade 6000 system with 2 – T1 based blades using 5 virtual domains (LDOMs) containing a production web based application along with test and production mirror environments.
• Managed Windows based Sun X4200 server housing a PACS (High end software used by Radiologists to read patient studies from videos and images) system.
• Automated database and other crucial file backups from Blade 6000 system and X4200 server to a Sun tape storage system and to other servers for redundancy and quick recovery.
• Manual and automated monitoring of system resources from the OS level to the database level. Used tools like sar, vmstat, iostat, mpstat, etc. Monitored available disk space and RAM via cron based shell script.
• Setup and maintenance of Sun SAN disk array using a hardware based RAID 5 configuration
• Desktop support for 12+ systems
• Support for ~15 diagnostics techs in the field
• MySQL DBA Responsibilities included:
• Managed production, production mirror and various test databases.
• Automate backups using binary logs for up to the minute recovery and exports
• Application DBA related skills include:
• Designing database architecture to support custom application for businesses
• Ongoing schema changes to support efficient operations of applications
• SQL tuning for efficient code execution
• Resource monitoring and tuning of the environment
• Moved production and test databases to various servers as resources required.
• Magento
• Investigated use of XML-RPC calls for interface to medical software using HL-7 protocols
• Built a very basic prototype using shopping cart functionality to use for a purchasing site
• Worked with customer classes, inventory, checkout, etc.
• Reviewed other functionality like GoogleAnalytics, API, etc.

Confidential, (11/05 – 08/07)

Responsibilities include building, tuning and maintaining production databases for a web based application.

• Installation of Oracle and Sybase on in-house systems
• Writing Unix shell (bash) scripts to automatically configure database environment
• Scripts that automate many administration tasks
• Periodically rebuild indexes
• Defragment databases
• Manage disk resources
• Monitor and tune performance
• Full and incremental backups
• Update index statistics
• Tuning and resource management scripts maintain the health of the system and keep it running optimally.
• Backup and restoration of databases
• PL/SQL/T-SQL batch operations for various data migration tasks
• Unix shell scripting to automate recovery

Confidential, (08/02 – 11/05)

Maintained and enhanced a web based application that allows students, teachers, parents and school administrators to access real time information about student performance in school.

• Developed in a client/server database called 4th Dimension to increase functionality of existing product or to fix problems as they arise.
• Required knowledge base included senior level 4th Dimension skills, advanced database design and implementation, Web based languages such as HTML, CSS and JavaScript.
• Used JavaScript for client side computations on worksheets used in several functions in PowerSchool
• Used JavaScript for reference data lookups improving the interface over the old HTML only methods previously used.
• Major accomplishment involved reverse engineering a .dbf database file to create from scratch an interface between the automated scheduling system and PowerSchool. Key data elements were transferred using the .dbf data files. Received a desktop Mac and 17” monitor as a bonus.
• Another major accomplishment was completely automating the installation and setup of the PowerSchool database infrastructure using Sybase as the backend. This installation was cross platform (Mac & Windows) and was written exclusively in Unix shell scripting.
• Assisted others in various projects including report cards, grading systems, student and teacher specific functionality, etc.
• Was involved in scalability projects as we started moving into larger school districts.

Confidential, (03/2000 – 08/02)

Maintained and enhanced a web based application that allows students, teachers, parents and school administrators to access real time information about student performance in school.

Developed in a client/server database called 4th Dimension to increase functionality of existing product or to fix problems as they arise.

• Required knowledge base included senior level 4th Dimension skills, advanced database design and implementation, Web based languages such as HTML, CSS and JavaScript.
• Used JavaScript for client side computations on worksheets used in several functions in PowerSchool
• Used JavaScript for reference data lookups improving the interface over the old HTML only methods previously used.
• Major accomplishment involved reverse engineering a .dbf database file to create from scratch an interface between the automated scheduling system and PowerSchool. Key data elements were transferred using the .dbf data files. Received a desktop Mac and 17” monitor as a bonus.
• Another major accomplishment was completely automating the installation and setup of the PowerSchool database infrastructure using Sybase as the backend. This installation was cross platform (Mac & Windows) and was written exclusively in Unix shell scripting.
• Assisted others in various projects including report cards, grading systems, student and teacher specific functionality, etc.
• Was involved in scalability projects as we started moving into larger school districts.

Confidential, ( 10/97 – 03/2000)
Software Engineer

Duties included:

• Developed a custom client/server application to support occupational related services operations
• Desktop support
• Unix System Administrator
• Oracle Database Administrator
• Network system administrator
• DBA work on a production system which was in production for 5 years.
• Shell scripting for automation of backups, auto-loading and importing of data from mainframes into Oracle database, transferring Oracle data to another machine for inclusion in an Intranet Web server
• Complete set up of Sun SparcStation 4 workstation, Sun Enterprise 250 and Sun Enterprise 450 server to house Oracle RDBMS, e-mail, web server, etc.