Database Application Specialist

Description

SUMMARY
Responsible for resolving work requests and completing projects that support customer needs specific to enterprise applications and database technologies including administration of the college's account provisioning application, document management solution, collaboration and productivity tools, and learning management system. Performs the role of technical lead to implement enterprise technologies and incorporate college systems and workflows with existing campus technologies.

Essential Functions

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

Resolves work requests and completes projects involving Enterprise Technologies functions and capabilities. Completes task assignments and modifies priority levels based on service impact and customer needs.

Focuses on customer needs specific to network account, database, Colleague (ERP), learning management system (Canvas) and Colleague reporting tool (Webi).

Anticipates, identifies, researches, develops, and documents solutions to customer problems. Works with peers and vendors as needed to determine the best possible solution.

Monitors product lifecycles to maintain continuous vendor support and completes upgrades or replacement projects prior to support expiration.

Researches and resolves issues identified by end users during testing of Enterprise Technologies system upgrades and system maintenance updates.

Reviews enterprise system capabilities, workflows, and limitations to determine if requested changes and enhancements are possible within existing systems. Designs system specifications to best meet end user needs while maintaining information security standards.

Works with and often leads teams on projects that maintain or improve systems that serve and support students. Coordinates project team meetings, logistics, and scheduling of events. Establishes and executes a clear and concise communication plan.

Evaluates project proposals to assess feasibility and requirements. Determines scope, cost, and duration; ensures that college strategic goals are addressed in project planning efforts.

Implement enterprise technologies and incorporate new systems and workflows with existing campus technologies including extracting, transforming, and loading of data.

Assists end-users with reporting needs including defining, designing, writing, and implementing new reports that extract information from the college's enterprise systems.

Integrates college information contained in academic, administrative, operational and directory-enabled databases or sources.

Maintains SQL and related database technologies. Ensures business continuity by implementing and testing disaster recovery protocols and procedures.

Manages application-level user and group security for Enterprise Technologies applications.

Serves as facilitator for departmental liaison group(s). Promotes relationships between Information Technology and the college community while increasing support and understanding of current and emergent enterprise technologies.

Collaborates with peer institutions to exchange knowledge and share best practices. Participates in regional user groups and online communities to gain insights on technical applications and solutions.

Writes and maintains documentation of changes to technical processes, procedures, and user support materials. Translate and communicate technical information into non-technical terminology.

Routinely trains end users and technical support staff to use enterprise technology services and features.

Ensures that external and internal regulations and policies governing data management are met including regulations concerning information security, compliance audits, and data privacy.

Report all information security threats and activities that may compromise or destroy data to IT management in a timely manner.

Understands, supports, and actively demonstrates the College's mission, vision, beliefs, and values.

SUPERVISORY RESPONSIBILITIES
This position has no direct supervisory responsibilities. May assign work to other department employees while functioning as project manager and may direct the work of student employees.

CONTACTS AND PURPOSE OF CONTACTSInternal: Frequent contact with college personnel within and outside of the department in planning, coordinating, information sharing, problem solving, and technical specification capacity. Communication often occurs under extremely tight deadlines affecting the implementation or repair of services affecting several thousand users.

External: Regular contact with vendors, consultants, and colleagues at other colleges and universities regarding technology and service activities.

Minimum Qualifications

QUALIFICATIONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Knowledge of:
Minimum

advanced database administration and information security management practices
advanced enterprise-level network, hardware, and software configurations and troubleshooting procedures
modern collaboration methods and terminology (MS Office 365 preferred)
basic student information system methods and terminology (Ellucian Colleague preferred)
learning management system methods and terminology (Canvas preferred)
document management methods and terminology (Softdocs preferred)
customer relationship management methods and terminology (Raiser's Edge preferred)
Microsoft Office (Word, Excel, Access, Outlook, and PowerPoint / current version)
Microsoft Windows Server environment (Active Directory and Domain Services preferred)

Preferred

experience working in educational institutions
service management methods and terminology
project management software (MS Project preferred)
virtual server management (VMWare preferred)
authentication methods and terminology (SAML 2.0 preferred)
business intelligence methods and terminology (SAP Business Objects preferred)
one industry standard programming language (PowerShell, C++, Java, VB, etc.)
web server technology (IIS and Tomcat preferred)
ITIL methods and terminology

Skills and Ability to:
Minimum

manage multiple competing-priority projects and work requests by utilizing time management techniques
work independently and in teams while supporting a diverse population of users
be customer service oriented, self-motivated, and work under tight timelines with minimal supervision
use logic and reasoning to identify the strengths and weaknesses to complex problems and develop, evaluate, and implement appropriate solutions
provide excellent written, listening, questioning, and oral communication
establish collaborative opportunities between departments to help advance institutional operations
develop and conduct one-on-one and group trainings
work with confidential records and electronic files related to the position
perform accurate work without close supervision or oversight
participate in or lead successful technology projects and deployments involving testing, technical support, communication, training, scheduling, and implementation efforts
live the college's beliefs of total commitment to student success (TCS2) and follow the college's values while fulfilling its mission and vision

Preferred

effectively use industry standard project management techniques
read, analyze, and interpret general business periodicals, professional journals, technical procedures, and governmental regulations

Education and Experience:
Minimum

Associate's degree in technology related program; or five years of related experience

Preferred

Bachelor's degree in technology related program

Language Skills Ability to read and interpret documents such as rules and laws, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Must be able to communicate technical problems verbally and in written form by using teaching and communication methods that the customer can relate to. Ability to effectively present information orally or in written form. Ability to quickly develop written and verbal communication for mass distribution to customers during college wide system disturbances.

Mathematical Skills Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Reasoning Ability Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical, written or diagram form and deal with several abstract and concrete variables. Creative thinking is a must. Ability to handle change and multiple projects in a high volume, fast paced environment. Follow a project through from beginning to end.
LICENSURE, CERTIFICATION, REGISTRATION OR OTHER REQUIREMENTSMust have a valid driver's license.

PHYSICAL DEMANDSThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle . click apply for full job details

---