Database Architect IV - 576

Jenzabar

Cincinnati, OH

Full Time

Senior

80k-93k

8 days ago

Job Description

About the Role

The SQL Database Architect will be responsible for creating, debugging, and maintaining SQL databases, optimizing system performance, and supporting development and customer teams. This role involves designing database structures, executing enhancement scripts, and ensuring database systems are properly installed, configured, and troubleshoot in a high-availability environment. The position is based in Cincinnati, OH, and offers a full-time schedule with a range of benefits, including health insurance, paid leave, and retirement plans.

Key Responsibilities

Create and debug SQL queries, stored procedures, triggers, functions, and views.
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 management.
Collaborate with the design and development team to create database designs that meet specified requirements.
Perform database modeling and communicate schema structures to development staff.
Gather requirements from software product managers and architects and design relational database objects to meet software goals.
Update and maintain databases used by product development staff across multiple versions of Jenzabar software.
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.

Requirements

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.
Candidate must have a Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience managing production databases in high-availability environments is a plus.
Proficiency in Microsoft SQL Server database administration, including scripting for 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 to plan, coordinate, and track tasks effectively.

Nice to Have

Experience with PowerBuilder.
Experience with Microsoft Active Directory.
Experience working in an academic environment or with higher education software.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field.

Benefits & Perks

Medical Insurance
Life Insurance
Dental Insurance
Vision Insurance
Paid Time Off (PTO)
Paid Parental Leave
Paid Holidays
Short Term Disability
Long Term Disability
401K
Educational Assistance

Working at Jenzabar

Jenzabar emphasizes equal employment opportunities and does not discriminate based on race, gender, age, disability, or other protected statuses. The company values a diverse and inclusive work environment and offers a range of benefits to support employees' well-being and professional growth.

Apply Now