Database Developer

Job #: 042945
Location Syracuse, NY
Pay Range: $66,900 –
$86,000
Hours:
Standard University business hours

8:30am âEUR” 5:00pm (academic year)
8:00am âEUR” 4:30pm
(summer)

Hours may vary based on operational needs.

Job Type: Full-time

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 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.
• Other duties as assigned.

About Syracuse
University:

Syracuse University is a private, international research university with distinctive academics, diversely
unique offerings, and an undeniable spirit. Located in the geographic heart of New York State, with a global footprint, and over 150 years
of history, Syracuse University offers a quintessential college experience.

The scope of Syracuse University is a testament to its
strengths: a pioneering history dating back to 1870; a choice of more than 200 majors, 100 minors, and 200 advanced degree programs offered
across the University’s 13 schools and colleges; over 15,000 undergraduates and over 6,000 graduate students; more than a quarter of a
million alumni in 160 countries; and a student population from all 50 U.S. states and 123 countries. For more information, please visit http://www.syracuse.edu.

About the Syracuse area:

Syracuse is a medium-sized city situated in the geographic center of New York State
approximately 250 miles northwest of New York City. The metro-area population totals approximately 500,000. The area offers a low cost of
living and provides many social, cultural, and recreational options, including parks, museums, festivals, professional regional theater, and
premier shopping venues. Syracuse and Central New York present a wide range of seasonal recreation and attractions ranging from water skiing
and snow skiing, hiking in the Adirondacks, touring the historic sites, visiting wineries along the Finger Lakes, and biking on trails along
the Erie Canal.

Application Deadline:
Full Consideration By:

To apply, visit https://www.sujobopps.com/postings/113862

Syracuse University is an
equal-opportunity institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender,
national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran
status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions,
employment, and access to and treatment in University programs, services, and activities.

Syracuse University has a long
history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment
programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally
transformed Syracuse University into the national research institution it is today. The University’s contemporary commitment to veterans
builds on this historical legacy, and extends to both class-leading initiatives focused on making an SU degree accessible and affordable to
the post-9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military
veterans, members of the Guard and Reserve, and military family members.

je-e4a6632ab77f442491ccc0fc8818f27b

Tagged as: Employment