Database Developer
Syracuse University
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Syracuse University seeks a Database Developer to design, implement, and maintain robust database architectures supporting enterprise information systems. The role emphasizes performance optimization, data integrity, and collaboration with cross-functional teams to meet complex business needs.
As the sole developer on the team, you will handle development, troubleshooting, and production support for data warehousing, integrations, and reporting applications, engaging with multiple departments
Qualifications
- Bachelor’s degree and 5–7 years of relevant work experience.
- Strong proficiency in SQL Server, PowerShell, and Python; ETL pipelines across Oracle, AD, and APIs.
- Git version control experience is a plus.
- Knowledge of data warehousing concepts, data modeling principles, and ETL best practices.
- Must communicate effectively with both technical and non-technical stakeholders; able to work independently and as part of a team.
- This position functions as the sole developer on the team; able to manage multiple projects with minimal oversight.
Responsibilities
- Develop and implement database solutions aligned with business requirements.
- Design database structures, tables, and relationships based on data modeling.
- Monitor and optimize performance; fine-tune queries and indexing.
- Establish robust security measures to protect data.
- Ensure scalability considering data volume and concurrency.
- Perform backups, updates, and patches for stability.
- Collaborate with Central ITS and other units on reporting and data integrations.
- Create and maintain documentation for data warehousing and architecture.
Skills
Education
Tools
Job description
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
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.
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.
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.
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.
Standing 15% of the shift. Sitting 65% of the shift. Walking 15% of shift. Frequent kneeling and climbing stairs. Able to lift 50 pounds waist high, 20 pounds shoulder high, 15 lbs. above head. Must be able to carry weight 15ft, with pushing, pulling and holding weight. Comfortable with occasional ladder use/heights Wrist and finger dexterity sufficient to use and operate a variety of hand tools and manipulate small objects. Ability to see, hear/listen, touch and speak is essential to work. Work requires reading, writing, analyzing data, problem solving, and conducting research on a daily basis. Work environment involves 80% indoor and 20% outdoor.
Not Applicable.
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.
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.
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.
Syracuse University fosters a welcoming learning environment where students, faculty, administrators, staff, curriculum, social activities, governance, and all aspects of campus life reflect a broad range of perspectives and experiences. The University community values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to engage with and appreciate the richness of backgrounds, beliefs, and experiences that shape our society. To achieve this, we strive to cultivate a community that respects and encourages open dialogue, understanding, and mutual respect.
Quick Link: https://www.sujobopps.com/postings/113862
- Resume/CV
- Cover Letter
Required fields are indicated with an asterisk (*).
- How did you first find out about this position?
- sujobopps.com (Syracuse University Online Employment website)
- Syracuse University HR Recruiter
- Virtual Career Fair (via NYS Department of Labor)
- SUNY EOC (Equal Opportunity Center)
- Women’s Opportunity Center
- Jubilee Homes
- Syracuse Northeast Community Center
- Interfaith Works
- JobPlus
- Syracuse.com
- Chronicle of Higher Education
- HigherEdJobs.com
- HERC (HERC Higher Ed Recruitment Consortium)
- InsideHigherEd.com
- Indeed.com
- DiverseEducation.com (Diverse Issues in Higher Education website)
- LinkedIn Job Posting
- Job Fair
- Search Firm
- Referred by an SU Employee
- Other
- If "other", please describe how you first found out about this position.
(Open Ended Question)
621 Skytop Road | Suite 1001 | Syracuse, NY 13244 – 5300 | 315.443.4042
2017 - Syracuse University, All Rights Reserved.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
