Jenzabar

Our higher education SIS, ERP, cloud, and analytics solutions drive digital transformation and enable student success.

Senior Database Architect

Full TimeRemoteTeam 501-1,000Since 1998H1B SponsorCompany SiteLinkedIn

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

Related Categories

Related Job Pages