Experience

J. J. Keller & Associates, Inc.

• United States
• Business Consulting and Services
• 700 & Above Employee

• Senior Database Administrator

  • Jul 2015 - Present

  Support MSSQL / MySQL / AWS / Azure SQL enterprise environments. Support MSSQL / MySQL / AWS / Azure SQL enterprise environments.



Plexus Corp.

• United States
• Appliances, Electrical, and Electronics Manufacturing
• 700 & Above Employee

• Database Administrator II

  • Sep 2012 - Jul 2015

  Maintained MSSQL and Oracle databases. Maintained MSSQL and Oracle databases.



Bemis Company Inc

• Database Team Leader

  • Jul 2011 - Sep 2012

  Provides first line support for Microsoft SQL server to other members of the technical team. Acts as Liaison between the database group and the leadership team. Disseminates pertinent information to other team members on a regular basis. Primary support for PeopleSoft PeopleTools upgrade from 8.47 to 8.51. Developed scripting method to migrate data from one database to another for a collation change and Unicode implementation. Worked as part of a project team to coordinate database development and determine project scope and limitations. Show less



Bemis Inc.

• Database Administrator

  • Jul 2006 - Jul 2011

  Responsible for administration / support of over 200 SQL servers (2008R2, 2008, 2005, 2000, 7.0, 6.5) in a 24x7 production environment. Performed all aspects of database administration, including installations, database migrations, security, T-SQL development, backup and recovery, DTS, replication, maintenance and process tuning. Primary support for STAT 5.4.2 and PeopleSoft HRMS 8.9 application, web and database servers. Primary support for Kronos 6.1 Work Force Central application, web and database servers. Primary support for SmartStream 7 Financial application and database servers. Developed and standardized a SQL utility database for sql server monitoring, alerting and reporting. Developed and maintained a comprehensive knowledge base of all application support documentation. Planned, developed and implemented processes for Physical to Virtual server migrations. Primary resource working with the infrastructure group to implement CommVault 8 for database backup / recovery as well as server system state recovery. Planned, developed and implemented custom CommVault 8 backup monitor to maintain SAP service level agreement for database recoverability. Planned, developed and converted several manual administrative processes to automated processes to improve process control, decrease execution time and eliminate potential mistakes. Reviewed and optimized long running queries, stored procedures, views and user defined functions from developers to maximize efficiency. Worked directly with developers on writing efficient code and educated on best practice standards. Show less



Affinity Health System

• United States
• Hospitals and Health Care
• 400 - 500 Employee

• • Jul 2004 - Jul 2006

  Responsible for providing quality and efficient customer support, training / development, and troubleshooting for surgery and emergency department staff.Provided primary administrative support for Meditech "Patient Care Inquiry" module.Prepared full user and system administration documentation for web based prescription system.Planned, developed and implemented new VB scripting process for new device creation into the Meditech system during clinic hardware upgrade project.Provided primary support and training to physicians, mid-level providers and nursing staff for online patient documentation and web based prescription writing.Trained new physicians and mid-level providers in Meditech, On-line prescription software, On-line X-ray system, and MUSE EKG system.Generated views using SQL to be called with Crystal Reports for the Surgery and Emergency department.Assisted the Technical team in the design, development and implementation of new SQL views, stored procedures, and reports for Network Health Plans QNXT system upgrade.Planned, developed and implemented SQL extracts for anesthesia billing automation for surgery department.Planned, developed and implemented QNXT tech project using Boston Scripting Solutions for Claims automation process.Planned, developed and implemented data entry automation into Meditech Materials Management, Pharmacy, and General Ledger module using Boston Scripting Solutions.Continually working to develop additional SQL 2000 skills, currently working toward MCDBA. Show less

• • Jun 2004 - Jul 2006

  Supported multiple clinical applications. Developed Crystal Reports and had extensive involvement in creating T-SQL views for reporting purposes.Developed various automated scripts for data entry using scripting tools.



Aurora Medical Center

• Registered Respiratory Therapist

  • Jan 2004 - Oct 2005

  Responsible for respiratory therapy of adult, pediatric, and neonatal patients. Monitored set up and care of the Puritan Bennett 840 ventilator with graphic evaluation. Monitored the Vision BiPAP for patient care. Utilized the computerized documentation system for patient care. Responsible for respiratory therapy of adult, pediatric, and neonatal patients. Monitored set up and care of the Puritan Bennett 840 ventilator with graphic evaluation. Monitored the Vision BiPAP for patient care. Utilized the computerized documentation system for patient care.



Mercy Medical Center – North Iowa

• United States
• Hospital & Health Care
• 700 & Above Employee

• Registered Respiratory Therapist

  • Jul 2001 - Nov 2004

  Responsible for respiratory therapy of adult, pediatric, and neonatal patients. Monitored the care of the Siemens Servo 300 with graphic evaluation. Performed EKG's and Pulmonary Function Testing at bedside. Monitored the care of the Vision, ST-30, and ST-20 BiPAP for sleep apnea. Participated in Bronchoscope procedures. Responsible for respiratory therapy of adult, pediatric, and neonatal patients. Monitored the care of the Siemens Servo 300 with graphic evaluation. Performed EKG's and Pulmonary Function Testing at bedside. Monitored the care of the Vision, ST-30, and ST-20 BiPAP for sleep apnea. Participated in Bronchoscope procedures.