Database Application Specialist - Jackson College : Job Details

DescriptionSUMMARYResponsible 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 FunctionsESSENTIAL 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 RESPONSIBILITIESThis 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 QualificationsQUALIFICATIONS 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:Minimumadvanced database administration and information security management practicesadvanced enterprise-level network, hardware, and software configurations and troubleshooting proceduresmodern 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)Preferredexperience working in educational institutionsservice management methods and terminologyproject 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 terminologySkills and Ability to:Minimummanage multiple competing-priority projects and work requests by utilizing time management techniqueswork independently and in teams while supporting a diverse population of usersbe customer service oriented, self-motivated, and work under tight timelines with minimal supervisionuse logic and reasoning to identify the strengths and weaknesses to complex problems and develop, evaluate, and implement appropriate solutionsprovide excellent written, listening, questioning, and oral communicationestablish collaborative opportunities between departments to help advance institutional operationsdevelop and conduct one-on-one and group trainingswork with confidential records and electronic files related to the positionperform accurate work without close supervision or oversightparticipate in or lead successful technology projects and deployments involving testing, technical support, communication, training, scheduling, and implementation effortslive the college's beliefs of total commitment to student success (TCS2) and follow the college's values while fulfilling its mission and visionPreferredeffectively use industry standard project management techniquesread, analyze, and interpret general business periodicals, professional journals, technical procedures, and governmental regulationsEducation and Experience:MinimumAssociate's degree in technology related program; or five years of related experiencePreferredBachelor's degree in technology related programLanguage 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, or feel; reach with hands and arms; and talk or hear. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus.WORK ENVIRONMENT The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.The noise level in the work environment is usually moderate.This job requires that the employee is occasionally needed to work a flexible schedule to include some weekend and evening work. The work schedule is determined by coordinating/weighing the available technical and labor resources against prioritized work requests and pre-planned special events. Work may be required during scheduled technology implementations and unscheduled system failures.Travel may be required for professional development and conference opportunities. This description is intended to indicate the kinds of tasks and levels of work difficulty that will be required and shall not be construed as declaring the specific duties and responsibilities. It is not intended to limit or in any way modify the right of any supervisor to assign, direct, and control the work of employees under his or her supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of a similar kind of level of difficulty. Supplemental InformationJackson College only accepts on-line applications though this system. For assistance with this, please call 517-###-####.Please use your legal first and last names on your application. If you are hired, you will have the opportunity to identify and utilize your preferred name.The Jackson College Nepotism policy prohibits hiring of a relative or someone with a familial relationship to work in the same instructional department, office or administrative unit of the College including spouse, child, stepchild, parent, stepparent or sibling of the employee or spouse, aunt, uncle, niece/nephew, grandparent, grandchild, and members of the same household including domestic partner.It is important that your application show all the relevant education and experience you possess (even if you are repeating it from your resume or cover letter). For instance, do not say, See Resume or C/V. Your resume, cover letter, and if a degree is required an unofficial transcript must be attached to your application. Applications will be rejected if incomplete.When you apply for the position, you will get to the document upload area where you will be given an opportunity to attach your documents such as your vita, transcripts, etc.. Instructions will also be found there.The College reserves the right to request proof of degree or certification at a later date if these documents are required as part of the qualifications for the position. Final candidates will be subject to a criminal background as part of the employment process.If selected you will be required to complete the US Citizenship and Immigration Services, Employment Eligibility Verification form I-9 and provide documentation verifying identity and eligibility to work in the United States. Jackson College is NOT able to support Visa applications for employment at the college. Applicants must already be eligible to work in the United States to be considered.Applicants with disabilities may request accommodation to complete the application and interview process. Please notify Human Resources at least three (3) working days prior to the date of need. A copy of Jackson College's Annual Security Report and Annual Fire Safety Report is available on the JC Campus Safety & Security website. The security report contains crime statistics for the previous three years for all of our campus locations and the annual fire safety report, which contains statistics for any reported fires in campus housing units and fire safety systems in these buildings. Additionally, the report contains policies, available resources and information concerning personal safety, fire safety and reporting procedures for both crimes and fires.Applicants have rights under Federal employment laws . Jackson College is an Equal Opportunity Employer that actively supports workforce diversity.Jackson College provides a generous benefit package to full-time staff that includes: medical, dental, vision, employee life/AD&D, optional life for employee and family, long and short-term disability,and travel insurances; personal illness, personal, bereavement and vacation leaves; tuition reimbursement and waivers; 16 paid holidays; and retirement plans. Details are available on the Jackson College website.