Database Developer

We are seeking a highly skilled and experienced Database Architect / Developer to join our dynamic team. 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.

Qualifications

• Bachelor's degree and or five to seven years of relevant work experience.

• Strong proficiency, Microsoft SQL Server, Integration services (SSIS), Oracle and working knowledge of principles of Data modeling,

• Microsoft Visual Studio, Microsoft Office applications and Microsoft Operating Systems.

• 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.

Job Specific Qualifications

• 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 system performance. Conduct regular database maintenance tasks, including backups, updates, and patches, to ensure system stability. Troubleshoot and resolve database-related issues, providing timely and effective solutions.

Working with all Auxiliary Services Units subject matter experts and external business partners including collaborating with Central ITS to identify deficiencies in existing reporting and data processing capabilities. Identifying potential technology improvements in systems, reporting and or data integrations to eliminate these deficiencies. Participate in special projects including new system implementations where data exports and imports create additional efficiencies to increase performance and generate maximum output.

Developing documentation on existing and new data warehousing integrations. Create and maintain data models, documenting database structures, relationships, and dependencies.

Develop and update comprehensive documentation for database architecture, processes, and best practices. Maintain and improve existing work instructions and procedures.

Research and stay abreast of changes in data warehouse technology and collaborate with manager and colleagues in how to implement and leverage the new and changing technology.

Physical Requirements

Enter Physical Requirements or "Not Applicable"

Tools/Equipment

Enter Tools/Equipment or "Not Applicable"

Application Instructions

In addition to completing an online application, please attach a resume and cover letter.