Technical Consultant - Database Admin

Caselle•Provo, UT

1d•Remote

About The Position

The Technical Consultant - Database Admin assists in a wide range of technical activities supporting the implementation, maintenance, and upgrade of Caselle software products. This position serves as a technical resource throughout the implementation process and works with customers and internal teams to ensure software environments are properly installed, configured, secured, and prepared for successful use. Primary responsibilities include software installations, user and security setup, data transfers, software upgrade assistance, technical troubleshooting, and implementation environment management. The Technical Consultant works with both customer IT resources and internal Implementation, Support, Product, and Engineering teams to resolve technical issues and ensure implementation activities are completed accurately and on schedule. The position is also responsible for completing technical closeout activities for new-logo implementations, including creating and retaining appropriate backups of customer data at the conclusion of the implementation for company record-retention purposes.

Requirements

2+ years of experience in technically related support activities for both customers and back-end systems
Experience installing, configuring, maintaining, or supporting business software applications
Experience working with Windows Server and workstation operating systems
Experience with software installation, system administration, application configuration, and troubleshooting
Experience working with databases, data transfers, backups, restores, or similar data-management activities
Understanding of user administration, permissions, security groups, and application security concepts
Ability to troubleshoot technical issues involving applications, databases, connectivity, permissions, and system configuration
Knowledge of Windows-based software environments and general system administration concepts
Strong technical troubleshooting and problem-solving skills
Excellent communication and customer service skills
Detail-oriented with an emphasis on accuracy when working with customer data, software configurations, security, and backups
Bachelor's degree in Computer Science, MIS, Information Systems, or related field (or 3+ years direct work experience, or equivalent combination of education and experience)

Nice To Haves

Experience assisting with software upgrades or application version changes
Experience implementing security and data-handling practices appropriate for enterprise or government software
Advanced experience with Caselle applications or similar enterprise software applications
Experience with database management, system administration, application security, data transfers, backups, and software upgrades

Responsibilities

Install and configure Caselle software applications and supporting components for new and existing customers
Coordinate software installations with customer IT personnel, System Consultants, Project Managers, and other Implementation resources
Verify customer environments meet applicable technical requirements prior to software installation or upgrade
Configure and maintain software environments required throughout the implementation process
Assist with workstation, server, application, database, and related configuration necessary for Caselle software operation
Troubleshoot installation, configuration, connectivity, permissions, and application-related issues
Serve as a technical problem-solving resource for customers and Implementation team members throughout implementation projects
Work with internal technical, Product, Support, and Engineering resources to resolve complex issues when escalation is necessary
Assist with the creation and configuration of customer users within Caselle software applications
Configure user access, application security, permissions, groups, and related settings based on customer requirements
Support authentication and application access configuration as required by Caselle products
Troubleshoot user access, permissions, authentication, and security-related issues during implementation
Assist customers and Implementation staff with file management, security, and other system-level functionality within the Caselle ERP solution
Perform and assist with the secure transfer of customer data required for software implementations, conversions, testing, and other project activities
Coordinate data transfers between customers, Implementation resources, and other authorized internal teams
Verify transferred data is received, stored, and available in the appropriate location for implementation activities
Assist System Consultants and conversion resources with loading, moving, restoring, or otherwise managing customer databases and implementation data
Troubleshoot technical issues associated with data transfers, database restores, file access, and related implementation processes
Follow established security and data-handling procedures when receiving, transferring, storing, or accessing customer information
Assist customers and internal teams with Caselle software upgrades and related technical activities
Review customer environments and applicable technical requirements in preparation for software upgrades
Coordinate upgrade activities with customer IT resources, Support, Implementation, Product, and other internal teams as necessary
Perform or assist with software updates, database updates, application installations, and other components of the upgrade process
Assist with pre-upgrade preparation, including verification of appropriate system and data backups
Troubleshoot technical issues identified during or following an upgrade and document activities, issues, and resolutions
Complete technical closeout procedures at the conclusion of each new-logo implementation
Create or obtain a final backup of the customer's implemented Caselle data following completion of the implementation
Verify that required backup files are complete and accessible prior to archiving
Store implementation backups in the designated company location according to established file-naming, security, and record-retention procedures
Maintain appropriate documentation identifying the customer, implementation completion date, backup date, and location of retained data
Coordinate with Implementation leadership, IT, and other applicable teams regarding the long-term retention or archival of completed implementation data
Collaborate with System Consultants, Project Managers, Support, Product, Engineering, and other technical resources to support successful customer implementations
Serve as a liaison between customer IT personnel and internal technical teams when technical coordination is required
Educate Implementation and Support staff on technical processes with the goal of improving issue resolution and the overall customer experience
Develop and maintain internal documentation related to installations, user setup, data transfers, upgrades, backups, and other technical implementation processes
Identify opportunities to improve, standardize, and document technical implementation procedures
Maintain accurate records of technical work completed for customer projects