Jenzabar
Our higher education SIS, ERP, cloud, and analytics solutions drive digital transformation and enable student success.
Senior Database Architect
Location
United States
Posted
58 days ago
Salary
$90K - $107K / year
Bachelor DegreeEnglishMS SQL ServerSQL
Job Description
• Collaborate with design and development teams to create database designs that meet specified business and technical requirements
• Perform database modeling and effectively communicate schema structures to development teams, ensuring clarity in how schemas support application development
• Apply a thorough understanding of relational database concepts, implementing them using SQL DDL to support project goals
• Gather requirements from software product managers and architects, and design relational database objects tailored to software objectives
• Maintain and update databases used by the product development team across multiple versions of Jenzabar software
• Work closely with the Quality Assurance team to test and verify database changes for each release cycle
• Provide support in troubleshooting and resolving complex database issues within the customer base
• Collaborate with the Data Services team on technical challenges related to data conversions
• Stay informed about new releases of Microsoft SQL Server and evaluate their potential impacts on Jenzabar software
• Design enterprise-wide database solutions aligned with application design goals
Job Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Expertise in teaching and applying SQL DML, DDL, and DCL commands, along with skills in writing optimized code for triggers, views, functions, and stored procedures
- Proven ability to design and code complex database procedures, triggers, and views
- Experience teaching SQL database administration tasks and mentoring junior team members
- Deep understanding of database delivery concepts and structures, particularly in multi-server environments (deployment across hundreds of customer systems)
- Strong proficiency in SQL permissions creation and maintenance
- Extensive experience in installing, configuring, troubleshooting, and maintaining Microsoft SQL Server database systems
- Advanced understanding of relational database concepts and the ability to gather and implement design requirements in collaboration with software product managers and architects
- Skilled in designing relational database objects that support software design goals and meet enterprise-wide application requirements
Benefits
- Medical Insurance
- Life Insurance
- Dental Insurance
- Vision Insurance
- PTO
- Paid Parental Leave
- Paid Holidays
- Short Term Disability
- Long Term Disability
- 401K
- Educational Assistance