Database

Database & Systems Administrator

About Susquehanna:
As a living, learning and working community, Susquehanna University affirms its commitment to being an engaged, culturally inclusive campus. As we seek to embody the rich diversity of the human community, we commit ourselves to the full participation of persons who represent the breadth of human difference. The university encourages candidates from historically underrepresented groups to apply. Susquehanna University is an Equal Opportunity Employer.

Susquehanna University is a national liberal arts college committed to excellence in educating students for productive, creative and reflective lives of achievement, leadership and service in a diverse, dynamic and interdependent world. Its more than 2,300 undergraduates come from 35 states and 22 countries, and all students study away through Susquehanna’s unique Global Opportunities program. Susquehanna University’s 325 acre campus, noted for its beauty, is located in Selinsgrove, Pennsylvania, 50 miles north of Harrisburg in the scenic Susquehanna River Valley, about a three hour drive from Philadelphia, Washington, D.C., and New York City. For more information, please visit https://www.susqu.edu.

Position Summary:
The Database & Systems Administrator will report to the Director of IT Project Management and Strategic Initiatives and will be responsible for installing, configuring, and supporting databases, data structures, data flows, data queries, and systems that support applications with a focus on data integrity, reliability, and security. This position will have primary responsibility for system patching, upgrades, and cloning related to Enterprise applications. In addition, this position will assess, support, troubleshoot, drive end-user training, and effectively communicate about systems/applications that are part of their assigned portfolio, acting as the primary liaison between functional offices and tech support for supported applications. The Database & Systems Administrator will work as an integral member of the IT Strategic Initiatives team, contributing to integration services, supporting database infrastructure, and providing guidance on design, development, performance and optimization. This position needs to be proactive and take ownership of our data environment where they are implementing, documenting, and enforcing best practices across the department.

Specific Responsibilities

• Administer database systems by providing primary support for database maintenance, patch management, and change management for enterprise applications.
• Plan and execute database integration for all administrative database systems including maintenance and conversion, proactive capacity planning, and new applications.
• Maintain database software through upgrades, patches, performance monitoring, and indexing.
• Audit database security and support the audit needs of functional team leads in assessing access and security to systems.
• Collaborate with University departments that maintain independent database systems.
• Install, configure and setup database systems for new database applications.
• Configure backups, ongoing monitoring, analysis, setup database maintenance tasks, and optimization of SQL stored procedures, application queries and database systems.
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, and security issues.
• Identify and apply proactive solutions and corrective measures to minimize downtime.
• Plan short term and long-term strategy for optimizing and enhancing our various data environments consisting of SQL Server, Unidata, ODS, etc.
• Develop queries and reports from database applications and assist co-workers with creating queries and reports.
• Take primary responsibility for system patching, upgrades, and cloning related to the Enterprise System applications.
• Provide system/application administration (access, support, troubleshoot issues, drive end-user training, and effectively communicate) for the assigned portfolio of applications, including but not limited to, Slate, Terra Dotta, The Housing Director, Presence, Ellucian Colleague, etc.
• Act as primary liaison between functional offices and tech support for supported applications.
• Be proactive and take ownership of the data environment to implement, document, and enforce best data practices across the department.
• General - Perform emergency support services during evenings, weekends, and holidays as necessary to support the 24 × 7 information needs of students, faculty, and staff. Contributes to the overall success of Office of Information Technology and the university by performing other duties and responsibilities as needed.
  
  Required Qualifications:
  A bachelor’s degree in Computer Science, Information Systems, or related field. At least 3 years’ experience with database & system administration. The ability to communicate effectively, regularly, directly, and patiently with colleagues whose knowledge and experience range from technical to functional is essential. This position must possess the ability to think critically, work independently, and solve problems.
  
  Physical Demand Position requires the ability to stand or sit for extended periods of time. Position requires the ability to move about the campus. Position requires the ability to talk and to hear instruction. Position requires occasional manual dexterity and the ability to use fingers, hands, and arms to feel, handle, and reach. Position requires occasional stooping, crouching, and bending. Position requires the ability to occasionally lift up to 10 pounds. Working conditions are indoor.
  
  Preferred Qualifications:
  Experience in a higher education, liberal arts campus setting, and hybrid cloud experience.
  
  Special Instructions to the Applicant:
  
  
  Benefits Eligible: Yes
  Number of Months: 12 months
  Other Number of Months:
  Full-Time/Part-Time:
  Work Schedule/Hours per Week:
  Posting Date: 09/02/2021
  Closing Date:
  Open Until Filled: No
  Anticipated Start Date:
  Posting Number: AH00791
  
  To apply, visit https://jobs.susqu.edu/postings/2473