This position Supervises the WJCC Enterprise Systems team to include the Human Resources, Finance, and Student Information Systems section of the Department of Technology. Responsible for maintenance, availability, integrity, and security of the division’s enterprise SIS and HR/Finance systems. Responsible for overall database management, integrity, and security as well as providing end-user support, reporting functions, and design of specialized utilities. Primary contact for the system’s vendors and user-groups.
Duties and Responsibilities
- Leads the division Enterprise Systems team to analyze end-user requirements, determine report functions and capabilities including specific output layouts with detail and summary items, break-out subtotals and totals, etc. Output may be in the form of paper reports, web pages, or other delivery media. Develops and tracks project completion schedules.
- Applies HR/Finance system patches and upgrades as provided by the system vendor. Tests, debugs, installs, and maintains computer programs and all appropriate system and end-user documentation and instructions. Coordinates with the Enterprise Systems team in developing comprehensive end-user training, including accurate data input and validation.
- Serves as Systems database manager and systems operator, and performs end-user support including setting up user profiles, assigning security controls, and storage management. Analyzes data handling procedures for efficiency, effectiveness, and security. Assists or performs audit trails. Performs routine and periodic backup and restore operations.
- Analyses all observed and reported system errors affecting the division enterprise systems. Recommends or develops procedures and processes to prevent errors from occurring and data/program recovery procedures to assure maximum data integrity. Reports errors to the system vendor and coordinates responses, fixes, and patches as required.
- Develops/implements database updating, reporting, archiving, and maintenance routines, process, and procedures. Develops automated solutions for “batch” updates, routine/special reports, meets with end-users to determine reporting needs and develops solutions to meet those needs.
- Approves work schedules for and supervises the work activities of subordinate personnel, including recommending personnel actions such as hiring and disciplining.
- Develops complex queries and routines for data extractions, uploads, and processing for various third-party systems, Virginia DOE reporting, and online SOL testing purposes. Verifies data integrity and works with responsible personnel to resolve errors. Designs solutions for end users to automate data extraction and reporting requirements.
- Serves as a backup to the DBA – Student Information System.
- Models the WJCC Strategic Plan Values: Individualism, Integrity, Innovation, Accountability and Collaboration.
- Performs other duties as assigned.
Minimum Qualifications (Knowledge, Skills and/or Abilities Required)
- Degree in Management Information Systems, Computer Programming, Database Administration, or related field of study or comparable certification such as MCDBA, MCSD, is desired; Master’s Degree in related area is preferred, or equivalent level of experience in designing and maintaining enterprise-level database systems and programs may substitute.
- At least 4 years’ experience maintaining and administering SQL compliant database systems such as SQL Server, Oracle, or MySQL. Advanced knowledge in data retrieval tools such as SQL and/or Crystal Reports. Must be familiar with application systems/programming in a Windows environment and web applications.
- Knowledge of and experience with Munis or similar HR/Finance information system in a database administrator role is preferred.
- Ability to make independent or team decisions in accordance with established policies; analytical and deductive ability in problem solving; ability to establish and maintain harmonious working relationship with others; skilled in conflict resolution and self-motivated.
- Ability to communicate effectively both orally and in writing. Must be able to supervise junior level personnel and advise, track, and monitor work performances of those employees as assigned.
- Maintain a valid VA driver’s license.
Supervises the SIS DBA, support technician and SIS Analyst.
Performs duties under the supervision of Sr. Director of Technology (or designee)
Working Conditions and Physical Requirements
Extensive hand-eye coordination is required to make use of computers, keyboards, mouse, ability to safely work in and around electronic equipment. Must be able to apply exceptional professional customer service in what can be highly stressful situations while maintaining a professional composure. Must be able to sit at a desk for prolonged periods. Must be able to complete repetitive motions, use a keyboard and/or mouse, and perform repetitive tasks. Must be comfortable in performing mundane tasks as well as being able to quickly switch from one task to another as situations warrant. Must be comfortable working alone, as well as in front of groups of people. Must be able to properly prioritize competing requirements and be comfortable working with tight deadlines and schedules. May be exposed to electrical shock hazards while working on computers and related equipment. Must be flexible to adopt to frequent deadlines and changes in schedule and frequent interruptions. Providing technical support may involve physically moving hardware and supplies, and may require frequent travel among various sites. Requires the physical ability to lift equipment up to 50 pounds, and the ability to climb and work on step ladders to pull and run overhead cables. Hours of work may vary, including some overtime, evening, and weekend hours.