Jenzabar is looking for a Database Architect IV to design, optimize, and maintain our SQL database systems. In this role, you will be responsible for creating and debugging SQL objects, executing enhancement scripts, and providing support for complex database issues to ensure system performance and reliability.
What You'll Do
- Create and debug SQL queries, stored procedures, triggers, functions, and views.
- Execute database structure and data enhancement scripts.
- Design databases to meet development goals and optimize system performance through index tuning and disk optimization.
- Install, configure, troubleshoot, and maintain database systems, including replication, backup, partitions, storage, and access.
- Manage user privileges.
- Collaborate with design and development teams to create database designs meeting specified requirements.
- Perform database modeling and communicate schema structures to development staff.
- Gather requirements from software product managers and architects to design relational database objects.
- Update and maintain databases used by product development across multiple software versions.
- Work with the Quality Assurance team to test and verify database changes for releases.
- Provide support to resolve complex database issues in the customer base.
- Assist the data services team with technical issues related to data conversions.
- Stay informed on upcoming versions of Microsoft SQL Server and evaluate potential impacts on software.
What We're Looking For
- Proficiency in SQL DML, DDL, and DCL commands.
- Strong coding skills in triggers, views, and stored procedures, including code optimization.
- Ability to design and code complex procedures, triggers, and views.
- Extensive knowledge of SQL database administration tasks and database delivery concepts.
- Experience deploying databases in multi-server environments with hundreds of client systems.
- Expertise in creating and managing SQL permissions.
- Ability to install, configure, troubleshoot, and maintain Microsoft SQL Server databases.
Nice to Have
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience managing production databases in high-availability environments.
- Proficiency in Microsoft SQL Server database administration, including scripting for SQL environment management.
- Strong experience in writing complex T-SQL statements, stored procedures, triggers, and views.
- Ability to assist development staff in optimizing SQL queries for system performance.
- Experience with data import/export, data conversions, and database patch applications.
- Excellent oral and written communication skills.
- Strong organizational skills, with ability to plan, coordinate, and track tasks effectively while meeting deadlines.
- Experience with PowerBuilder, Microsoft Active Directory, and working in an academic environment or with higher education software.
Technical Stack
- Microsoft SQL Server
- T-SQL
- PowerBuilder
- Microsoft Active Directory
Team & Environment
Collaborates with design, development, and Quality Assurance teams. Assists data services team.
Benefits & Compensation
- Salary: $80,000-93,000/year
- Medical Insurance
- Life Insurance
- Dental Insurance
- Vision Insurance
- PTO
- Paid Parental Leave
- Paid Holidays
- Short Term Disability
- Long Term Disability
- 401K
- Educational Assistance
Work Mode
This role is global.
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.
