Charles Edward Vopicka

Owner, Free State Drivers
1620 South 8th Street West
Missoula, MT 59801
(406)549-1263

Education

• Forestry M.S. Degree - The University of Montana, Missoula (2007)
• Forestry B.S. Degree - The University of Montana, Missoula (2003)
• Park Management A.A.S. Degree - Frederick Community College (1999)

Training / Certification / Workshops

• Google IT Automation with Python Professional Certificate (3/2020)
  • Automating Real-World Tasks with Python (3/2020)
  • Configuration Management and the Cloud (2/2020)
  • Crash Course on Python (2/2020)
  • Using Python to Interact with the Operating System (2/2020)
  • Introduction to Git and GitHub (2/2020)
  • Troubleshooting and Debugging Techniques (2/2020)
• Google IT Support Professional Certificate (6/2018)
  • IT Security: Defense against the digital dark arts (6/2018)
  • System Administration and IT Infrastructure Services (5/2018)
  • The Bits and Bytes of Computer Networking (4/2018)
  • Operating Systems and You: Becoming a Power User (4/2018)
  • Technical Support Fundamentals (3/2018)
• Independent Contractor Exemption Certificate - MT Dept. of Labor and Industry (3/2015 - 3/2025)
• Maryland EMT - Basic (12/15/99 - 12/31/02)
• National Ski Patrol Outdoor Emergency Care Technician (12/98 - 12/01)
• High Angle Rescue Level II training at SOLO (10/04/98)
• Wilderness EMT at SOLO (09/98 - 09/00)
• EMT - Basic training and National Registry of EMT’s certified (trained at SOLO) (10/02/98 - 03/31/01)
• Wilderness First Responder at SOLO (09/98 - 09/00)
• High Angle Rescue Level I training at Stonehearth Open Learning Opportunities (SOLO) (1998)

Work Experience

• IT Department Team Lead and Database Administrator - MT Department of Agriculture - Helena, MT (2024/05 - Present)
  • Manage IT team priorities in accordance with CIO and Agency requirements
  • Address security matters
  • Lead Dept IT Staff with assignments and seeking approvals
  • Act as liason between State IT, Dept IT, and Agency Leadership
  • Database Development and Management (MS SQL Server / Oracle / MySQL / SQLite / MS Access)
  • Systems Automation, Integration and Migration
  • Desktop and Systems Support
  • Project Development and Management
  • Network administration
• Database Administrator - MT Department of Agriculture - Helena, MT (2021/05 - 2024/05)
  • Database Development and Management (MS SQL Server / Oracle / MySQL / SQLite / MS Access)
  • Systems Integration and Migration
  • Desktop and Systems Support
  • Project Development and Management
• IT Department Team Lead (interim) - MT Department of Agriculture - Helena, MT (2023/03 - 2023/08)
  • Manage IT Priorities
  • Address security matters
  • Lead Dept IT Staff with assignments and approvals
  • Act as liason between State IT, Dept IT, and Agency Leadership
  • Take on many of the responsibilities of CIO and Network Administrator in their absence
• Statewide Projects Technical Support - Montana State Library - Helena, MT (2018/11 - 2021/05)
  • Customer Support
  • Software development and management
    • ASP.NET
    • T-SQL
    • Python
  • Database Administration (MS SQL Server DBA)
  • Archive and metadata management
  • CMS Management (CONTENTdm, Recollect)
  • Data conversion between metadata standards
• Owner - Free State Drivers - Missoula, MT (2006 - present)
  • Sustained yield analysis
  • Inventory design auditing
  • Develop and maintain client databases (MS Access, MySQL, SQLite)
  • Computer repair and maintenance
  • Develop and maintain client websites
  • Software development (Python 3, PHP, VBA, VB.NET, JS, C, C++, FORTRAN)
  • Software training
  • Technical support
  • Workshop development and hosting
  • Sewing machine repair
• Co-owner - The Pen-Guins - Missoula/Helena, MT (2008 - present)
  • Custom pen turning
  • Custom bowls
  • Custom woodturning
  • Custom embroidery digitizing and layout
• Research Assistant II - the University of Montana, Missoula (2007)
  • Database development and maintenance
  • Technical support for faculty, staff, and students
• Database Manager - Forest Biometrics Research Institute - The University of Montana, Missoula (2004 - 2006)
  • Develop and maintain FBRI Databases and GIS
  • Technical support for contributing organizations
  • Technical support for FBRI staff
  • Maintain computers
  • Training
  • Field studies
  • Hardware and software development
  • Maintain website
• Research Assistant II - Forest Biometrics Research Institute - The University of Montana, Missoula (2003 - 2004)
  • Technical support for contributing organizations
  • Technical support for FBRI staff
  • Maintain computers
  • Data Entry Specialist - Forest Biometrics Research Institute - The University of Montana, Missoula (Summer 2003)
• Outdoors Department Assistant Department Head - Camps Airy and Louise (Summer 2002)
  • Lead team building events through a combination of High and Low ropes exercises with campers
  • Lead Rock Climbing Events
• Outdoors Department Quartermaster Camps Airy and Louise (Summer 2001)
  • Maintain and replenish stocks
• Outdoors Department Staff - Camps Airy and Louise (Summer 2000)
• Support Staff for System for Student Success (SSS) - Frederick Community College (1999 - 2000)
• Computer Lab Aide - Frederick Community College (Fall 1998)
• Technician Assistant at the USDA - Natural Resource Conservation Service (Summer 1998)
  • GIS
• English Dept. Senior Technical Advisor - Frederick Community College (1997 - 2000)
• Computer Lab Aide - Frederick Community College (1997 - 2000)