Systems Reliability & Integration Analyst

Bates College; Lewiston (ME); On-site; USD 72,000 - 78,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Retirement plan

Paid time off

Dependent care subsidy

Free parking

Library access

Athletic facilities access

Job summary

Bates College in Lewiston, Maine seeks a Systems Analyst to maintain the health, security, and reliability of server applications across self-hosted and SaaS systems. You will optimize SQL queries, support Windows/Linux environments, and collaborate with vendors and campus staff to deploy and configure new technologies.

Join a team dedicated to data integrity, security, and scalable enterprise applications, including Banner, MS SQL Server, WordPress, Moodle, and more.

Qualifications

• Experience with relational database systems such as Oracle, MS SQL Server, MySQL, or equivalent.
• Experience supporting solutions on Windows and Unix/Linux environments and connecting to remote environments.
• Experience with source control systems, configuration management software, or Docker/Kubernetes is desired.
• Experience designing, developing, and maintaining reports using SSRS, Power BI, Argos, Cognos, or other enterprise reporting tools.
• Experience with system implementation and upgrades.

Responsibilities

• Monitors system health and applies upgrades and patches as necessary to keep applications current and protected.
• Diagnoses and resolves performance issues to minimize disruption to College operations.
• Evaluates the impact of new features and application changes on College computing resources before deployment.
• Safeguards system security, stability, and performance.
• Documents processes and configurations to preserve institutional knowledge.
• Participates in weekly, team-shared, on-call rotation to investigate and resolve system outages and issues if needed.
• Provides technical support for a portfolio of self-hosted applications—including open-source, COTS, and internally developed systems—as well as SaaS solutions.
• Partners with vendors and College staff to evaluate, implement, and configure new technologies.
• Configures applications and related tools to support integration and ongoing maintenance.
• Designs, develops, and tests application code to integrate and customize the College and application portfolio.
• Develops and optimizes SQL queries, stored procedures, functions, triggers, and views; designs database tables and indexes.
• Plans and performs data conversions, imports, exports, and migrations.
• Ensures data integrity, security, and system performance.
• Consistently strives to increase level of expertise on application software and security.
• Participates in software evaluations and assessments of new technologies.
• Works collaboratively with other Information Services staff.
• Connects with industry peers to forge mutually beneficial relationships.
• Serves as assigned on College Committees.

Skills

Analytical skills

Problem solving

Systematic thinking

Organizational skills

Programming

Database knowledge

SQL Server

APIs

Communication skills

Team collaboration

Education

Bachelor's degree in Computer Science or related

Tools

Docker

Kubernetes

SSRS

Power BI

Argos

Cognos

Microsoft SQL Server

Job description

Bates College in Lewiston, Maine seeks a Systems Analyst to maintain the health, security, and reliability of server applications across self-hosted and SaaS systems. You will optimize SQL queries, support Windows/Linux environments, and collaborate with vendors and campus staff to deploy and configure new technologies.

Join a team dedicated to data integrity, security, and scalable enterprise applications, including Banner, MS SQL Server, WordPress, Moodle, and more.