Senior Database Architect

The Senior SQL Database Architect will be responsible for aligning with company business requirements and ensuring the effective implementation of database structures. The role involves designing, creating, and debugging SQL queries, stored procedures, triggers, functions, and views. This position requires expertise in executing database structure and data enhancement scripts, optimizing system performance (e.g., through index tuning and disk optimization), and maintaining multiple database systems. Additionally, responsibilities include managing replication, backup processes, partitions, storage, and access controls, as well as overseeing user privileges. The Senior Database Architect will also assist in training Development team members in SQL best practices and database management.

Essential Duties & 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

Skills & Qualifications

Preferred Skills & Experience

The pay range for this position is $91,000-$108,000 / year; however, base pay offered may vary depending on job-related knowledge, geographic location, skills, and experience. This position is eligible for an annual bonus in addition to a full range of benefits. This information is provided per the relevant state and local pay transparency laws for the location in which this position will be performed.

Benefits

Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, PTO, Paid Parental Leave, Paid Holidays, Short Term Disability, Long Term Disability, 401K, Educational Assistance

Jenzabar does not discriminate in employment opportunities or practices on the basis of race, color, sex, gender, gender identity, pregnancy, childbirth and related medical conditions, genetics, genetic markers and carrier status, creed, religion, national origin, ancestry, age, disability, medical condition, marital status, sexual orientation, military service, veteran status, or any other status protected by state and federal laws.

Please Note : Jenzabar does not sponsor applicants for work visas.