Apply on Employer Site

Jenzabar · 3 days ago

Senior Database Architect

United States

Full-time

Remote

Senior Level

$90K/yr - $107K/yr

Jenzabar is seeking a Senior SQL Database Architect responsible for aligning with business requirements and implementing effective database structures. The role involves designing and debugging SQL queries, optimizing system performance, and managing multiple database systems while assisting in training development team members in SQL best practices.

CRMEducationSoftware

No H1B

Responsibilities

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

Qualification

SQL DMLSQL DDLMicrosoft SQL ServerDatabase designDatabase administrationCommunication skillsOrganizational skills

Required

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