Mark Hartzell OD

*** ***** ***** *** ********* WV, 304-***-****, ad1q1n@r.postjobfree.com

Experience

IT Database Product Lead

Regal Rexnord, South Beloit MI (Remote Worker) Nov 2019 - Dec 2023

• Oracle Database 11g & R12 Administration and EBS 12.0.2

• Bash and Perl scripting

Database Administrator, Senior

WV Network, Morgantown WV (Remote worker) Jun-2014 – Oct 2019

• Oracle 11g & 12c Database Administration and Oracle FMW 11g Administration, backup and upgrades

• Red Hat Linux Server Administration for multiple systems.

• Ellucian Banner Application Database Admin, upgrades using command and ESM, and troubleshooting

• Perl and bash scripting for automation of client jobs and notification of job status esp failures. Database Administrator, Senior

WV School of Osteopathic Medicine, Lewisburg WV Feb 2010 – Jun 2014

• Oracle 11g Database Administration and Oracle FMW 11g Administration, RMAN backup and upgrading

• Red Hat Linux Server Administration, server installation and configuration

• Ellucian Banner Application Database Administration, installation, upgrades, and pl/sql troubleshooting

• Oracle PL/SQL programming and development, creating new jobs, procedures and triggers

• Web Application Development using Perl scripting and ColdFusion

• Bash scripting for automation of monitoring and job execution and notification Senior Oracle Developer

Public Interest Data, Alexandria, VA Jun 2008 – Feb 2010

• Oracle 10g application PL/SQL development and maintenance, trigger and package creation.

• Application SQL performance tuning.

Oracle DBA

Ellison Computer System, Sterling, VA Nov 2007 – Jun 2008

• Contract to GSA / Enterprise Service Center

• Maintain and monitor over 30 Oracle database instances across Sun Solaris and Windows servers

• Install Oracle database and application patches and updates, as well as security hardening of the systems.

• Perform data extractions on scheduled basis as well as on an as needed basis for application developers.

• Shell and PL/SQL scripting for job automation and server maintenance and log file organization. Report Developer / Oracle DBA

Nortel Government Solutions, Fairfax, VA July 2001 – Oct 2007

• Contract to US Patent & Trademark Office (USPTO) / Search and Information Resource Administration

• Designed and implemented data reporting database objects, created normalized tables and indexes for optimized reporting resulting in a 10 fold decrease in reporting run times

• Wrote over 200 SQL and Perl scripts for regularly scheduled reports, 95% of which export to Excel.

• 750+ ad-hoc SQL scripts written for user data requests, data exported to users in many data formats, ex excel, delimited files, MS Access, and html presentations

• Developed web based user report request and retrieval interface for 100+ routine reports and adhoc’s as needed, improving and simplifying user access to data

• ETL (extract, transform, load) activities performed on user supplied data, usually excel files, to supply extracted data back in same file formats

• Wrote Perl scripts for reading and writing external files in ETL actions

• Utilized of Oracle’s EXP/IMP program for large scale data transfer between oracle servers of different versions as well as schemas, for weekly scheduled tasks

Mark Hartzell

547 Stone Ridge Way Lewisburg WV, 304-***-****, ad1q1n@r.postjobfree.com

• Created shell and Perl scripts for report automation as well as system monitoring resulting in a 50% reduction in manpower and more reliable / on-time reporting

• Improved performance of SQL thru constant re-evaluation of database schema objects and physical database parameters to increase efficiency and decrease run-time, manpower and system resources

• Established backup and recovery standards for server file storage and database objects to tape

• Trained and consulted in the use of SQL (Structured Query Language) to other site employees, enabling more efficient of manpower and less performance impact on servers by optimizing queries Chief Clinical Information System

United States Air Force Sept 1998 – July

Air Combat Command Surgeon General’s Office

• Clinical consultant to LAN/WAN technical and software team for DoD multi-million dollar revamp of its Composite Health Care System (CHCS) undergoing Clinical Beta testing at two treatment facilities

• Technical oversight for four medical facilities migration to Windows 2000 Active Directory Domain

• Consultant to IM/IT departments of 17 MTF’s on issues of clinical implementation of new systems

• Responsible for over $6M of central procurement of information systems hardware and software for 17 hospitals to include research, purchase, and distribution

• Help desk support for 130+ command staff, to include PC configuration, deployment and software training

• Provided Windows NT and 2000 Server admin of 130+ staff accounts, network storage, daily data backup and disaster recovery

• Officer In Charge of three command staff system technicians responsible to daily staff support as well as manning and technical consultation to 17 facilities Information Systems offices

• Management of Air Crew Contact Lens Program and Executive Physicals Security Clearance: USAF Secret, Inactive, Jul 2001 Skills

Version Experience

Oracle (database admin) 9i, 10g, 11g, 12c 9 years

SQL / PL/SQL scripting Oracle 11 years

Red Hat Enterprise Linux 4,5,6 9 years

Perl 7 years

Shell scripting bash 7 years

Apache 5 years

HP AIX user 7 3 years

Solaris user 11 4 years

HTML 6 years

CSS 4 years

Certifications / Training / Education

Doctor of Optometry, Pennsylvania College of Optometry, Philadelphia PA BS, Visual Science, Pennsylvania College of Optometry, Philadelphia PA, BS, Biology, Delaware Valley College, Doylestown PA, Oracle Certified Professional 10g, 2007

Contact this candidate