Jenzabar is seeking a Senior SQL Database Architect to join their Product Development team. This critical, remote role is responsible for the design, effective implementation, and maintenance of database structures for Jenzabar software.

The pay range for this full-time position is $91,000 – $108,000 per year, plus an annual bonus and a full range of benefits.

Core Responsibilities

This Senior Database Architect will align database structures with the company’s business requirements, ensuring effective performance and implementation across multiple customer systems (a multi-server environment).

• Database Design & Modeling: Collaborate with design and development teams to create database designs, perform database modeling, and effectively communicate schema structures.
• SQL Development: Design, create, and debug SQL queries, stored procedures, triggers, functions, and views (using SQL DML, DDL, and DCL commands).
• Performance & Maintenance: Optimize system performance through index tuning and disk optimization. Maintain and update databases used by the product development team across multiple versions of Jenzabar software.
• System Administration: Manage replication, backup processes, partitions, storage, and access controls, and oversee user privileges (SQL permissions). This is critical due to the multi-server deployment across hundreds of customer systems.
• Mentorship & Training: Assist in training Development team members in SQL best practices and database management; mentor junior team members.
• Strategy & Compliance: Stay informed about new releases of Microsoft SQL Server and evaluate their potential impacts.

Required Skills and Expertise

The ideal candidate must have extensive experience in Microsoft SQL Server administration and development, coupled with proven mentoring abilities.

• Core Technology: Extensive experience installing, configuring, troubleshooting, and maintaining Microsoft SQL Server database systems.
• SQL Expertise: Proven ability to design and code complex database procedures, triggers, and views. Expertise in teaching and applying SQL DML, DDL, and DCL commands.
• Architecture Knowledge: Deep understanding of relational database concepts and database delivery concepts in multi-server environments.
• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Preferred Skills: Experience managing databases in high-availability production environments, proficiency in T-SQL queries, and familiarity with a higher education environment and Microsoft Active Directory.