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

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

SQL DDLSQL DMLSQL DCLdatabase modelingdatabase designtriggersviewsfunctionsstored proceduresMicrosoft SQL Server

collaborationcommunicationmentoringtroubleshootingproblem-solving

Bachelor’s degree in Computer ScienceBachelor’s degree in Information Technology