This position is responsible for the overall management of the information technologies infrastructure for Community Living (Offices of Housing, Residential Life, Dining and Scheduling and Event Services).
The primary duties and responsibilities of this position are to continue the maintenance of the HousingSQL database as well as the development and progression of the StarRez Student Housing Software, both of which are used to track and maintain information on students living in University owned housing.
Additional responsibilities are to manage the engineering, design, upgrades, and on-going operations of all Community Living computing resources, databases, storage, software, workstations, servers, computing hardware, etc. These responsibilities include, but are not limited to; infrastructure planning and needs assessment; management of all development and production computational resources; management of security of and access to all Community Living computational resources; maintenance and continued development of Community Living disaster recovery plan; maintain an inventory of Community Living computational resources; formulate solutions to business problems with electronic data processing technology; development/programming, testing and maintenance of relational database management applications as well as the StarRez Housing System; support and execute a comprehensive data backup program; create systems/templates and reporting that satisfy the needs of the office; work with management, programmers and developers, vendors, IT staff within and outside JHU.
This position requires extensive working knowledge of Microsoft Access for the development and maintenance of the HousingSQL database system.
Essential Job Functions:
A primary responsibility of this position is to continue the management of the HousingSQL database application, which utilizes MS Access and MS SQL Server. This system is currently running parallel with StarRez.
Database administrative duties include, but are not limited to: database backups, index design and maintenance, database optimization, problem analysis and resolution, proactive database monitoring, platform fault tolerance, disaster recovery, reporting, and security configuration.
These duties are both highly diversified and specialized governed generally only by broad instructions and dependent upon the individual's own comprehensive analysis and judgment. The Manager of StarRez must exercise a wide range of independent judgment related not only to the technical aspects of assignment, but to the work, scope and performance of others associated with task. The position will be expected to balance multiple work assignments/priorities; work collaboratively with internal/external, operations, functional/business, and vendor staff, providing technical expertise, support, and guidance.
Administer, manage and maintain a 30+ user/50+ node 4-department Microsoft Server network. Diagnose, trouble shoot, upgrade and resolve problems. Trouble shooting to include being able to distinguish between hardware failure, software failure, network problems and/or user error.
Community Living Servers are housed and maintained at JHU IT in Mt. Washington. Perform system backups, maintenance and/or resolve problems related to the Windows Network, MS-SQL based housing database, and other data/databases when needed.
Share administration functions, front line support and training for the Maximo Asset Management Software. This application is served from Plant Operations and administered by their IT Systems Project Manager.
Provide primary help desk services and/or network access to appropriate members of the Dining Services vendor as specified in the appropriate contract. (No longer needed)
Manage software/hardware support related to the scanning of checks.
Construct ad-hoc and permanent reports/queries for the HousingSQL/TA100Pro/Access/Maximo and StarRez applications using Access, Crystal Reports, or StarRez software as necessary to assist in planning and day-to-day needs.
Design reports/systems/templates to maintain and verify accuracy of room occupancy, provide statistical and financial data, to satisfy auditing requirements and the ad-hoc reporting needs of the Community Living offices.
Administer and maintain the department's IIS web server that provides small data gathering applications for office use. Support staff members who design, organize and upload files to the Community Living website.
Provide training and documentation on basic software applications including network applications. Prepare and maintain web based user manuals for HousingSQL and other systems. Provide individual and small group training on packaged software to meet the specific needs of the department. Provide training on other technology related topics as needed.
Act as primary contact with outside vendors to manage all contracts for software and hardware maintenance support, maintain inventory and licenses of all software running on the network and individual workstations. Act as liaison with the IT Systems Project Manager at Plant Operations for the Maximo system, EMS for the security access system vendor and, Student ID Card Service for the installation and configuration of one card applications. Coordinate networking between Community Living and other University departments. Interact with other campus departments such as Student Accounts, ID Card Services and the Registrar's Office regarding the sharing and transfer of data electronically; determine the appropriate data configuration; create and execute import and export files for the purpose of database population interfacing with specialized software application, for HousingSQL, StarRez, or other Housing applications.
Analyze and make recommendations for new software applications for project management, space planning and other Community Living needs.
Bachelor's degree required, preferably in Computer Science or a related field. Additional experience can be substituted for education. Minimum of three (3) years of IT experience with emphasis on database management, MS Access/SQL experience and the ability to learn different proprietary software. Additional education can be substituted for experience.
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.
Licensure, Certification, Registration:
Preferred: MCSE, MS SQL Server, A+, MS Access
Special Knowledge, Skills, or Abilities:
Must have a demonstrated ability to communicate clearly and effectively with staff, directors, vendors, consultants, and other JHU IT staff.
Ability to independently analyze and resolve complex problems. Ability to work with web development tools.
MS SQL Server
StarRez Student Housing Software
Check scanning - TS400 Scanner and PST EZ-Scan software
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130... years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Baltimore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.