Database Developer

Job #

042945

Department Code

31104-1090

Department

Office of Chief Operations Officer

Job Title

Database Developer

Location

Syracuse, NY

Campus

Syracuse, NY

Commitment to On-Campus Experience

Syracuse University is committed to delivering an exceptional student experience through vibrant, engaged campus communities. This position is based at the above campus location and requires regular in-person presence to support our students, collaborate with colleagues, and contribute to our thriving academic environment. Syracuse University values the collaboration, mentorship, and spontaneous connections that happen when our community works together on campus. Remote work arrangements are limited in accordance with University policy.

Pay Range

$66,900 - $86,000

Pay Determination

Pay rates at Syracuse University are based on a combination of factors including, but not limited to, the job responsibilities; the candidate’s education, training, work experience and key competencies; the university’s strategic priorities; internal peer equity; applicable federal, state, local laws, grant funding and contractual requisites; and external market analyses.

Staff Level

S5

FLSA Status

Exempt

Hours

Standard University business hours

8:30am – 5:00pm (academic year)
8:00am – 4:30pm (summer)

Hours may vary based on operational needs.

Job Type

Full-time

Unionized Position Code

Not Applicable

Job Description

As a Database Architect, you will be responsible for designing, implementing, and maintaining the database architecture that supports our organization’s information systems. You will play a crucial role in optimizing database performance, ensuring data integrity, and collaborating with cross-functional teams to meet business requirements.

The Database Architect / Developer will work with all subject matter expects from departments within the Office of the Chief Operations Officer and other Syracuse University departments. This work includes integration of data driven business processes, development of data interfaces, critical tactical and strategic analytical activities, data security and access, as well as development of in-depth dashboards and reports. The Database Architect / Developer will perform development (coding), analysis (troubleshooting), and production support, and provides overall expertise in the area of data warehousing, data integrations and reporting applications.

Education and Experience

• Bachelor’s degree and or five to seven years of relevant work experience.
• Strong proficiency in Microsoft SQL Server and PowerShell and Python scripting, with hands-on experience building and maintaining ETL pipelines that integrate data across multiple systems including Oracle, Active Directory, and third-party APIs.
• Experience with version control systems, particularly Git, is a plus. Knowledge of data warehousing concepts, data modeling principles, and ETL best practices strongly desired.
• Must be able to work effectively with both technical and non-technical stakeholders, communicate clearly at a level appropriate to the audience, and collaborate well both independently and as part of a team.
• Strong written and verbal communication skills required.
• This position functions as the sole developer on the team, requiring the ability to independently manage and prioritize multiple projects with minimal oversight.

Skills and Knowledge

• Ability to work with a diverse group of people at both a functional and technical level and communicate at a level appropriate to audience.
• Ability to work both independently and as part of a team.
• Strong written and verbal communication skills.

Responsibilities

• Develop and implement database solutions that align with business requirements, ensuring efficiency, scalability, and optimal performance. Design database structures, tables, and relationships based on data modeling principles. Monitor and optimize database performance by fine-tuning queries, indexing, and configuration settings. Identify and resolve performance bottlenecks to ensure responsive and efficient database operations. Establish robust security measures to protect sensitive data from unauthorized access or potential breaches. Implement strategies for database scalability, considering factors such as data volume, user concurrency, and s…