On-Campus Database Architect & Developer

PeopleAdmin, Inc.; City of Syracuse (NY); On-site; USD 67,000 - 86,000; Full time

Job summary

Syracuse University seeks a Database Architect to design, implement, and maintain the database architecture that supports our information systems on campus. You will optimize performance, ensure data integrity, and collaborate with cross‑functional teams to meet business requirements.

The role combines development, analysis, and production support, focusing on data warehousing, integrations, and reporting. Strong SQL Server skills and scripting are essential for success in this sole‑developer

Qualifications

• Bachelor’s degree or higher and 5–7 years of relevant work experience.
• Strong proficiency in Microsoft SQL Server and PowerShell with hands‑on ETL experience.
• Experience with data warehousing concepts, data modeling, and ETL best practices.
• Ability to communicate clearly with both technical and non‑technical stakeholders.

Responsibilities

• Design and implement database solutions aligned with business requirements.
• Monitor and optimize database performance; tune queries and indexing.
• Establish robust security measures to protect sensitive data.
• Develop data interfaces and dashboards/reports for analytics needs.
• Collaborate with cross‑functional teams and external partners on data integrations.
• Maintain documentation for database architecture, processes, and best practices.

Skills

SQL Server

PowerShell

Python scripting

ETL pipelines

Git

Stakeholder communication

Education

Bachelor’s degree

Tools

Oracle

Active Directory

APIs

Job description

Syracuse University seeks a Database Architect to design, implement, and maintain the database architecture that supports our information systems on campus. You will optimize performance, ensure data integrity, and collaborate with cross‑functional teams to meet business requirements.

The role combines development, analysis, and production support, focusing on data warehousing, integrations, and reporting. Strong SQL Server skills and scripting are essential for success in this sole‑developer