Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
UnknownVisa
Higher Education SoftwareIndustries

Position Overview

  • Location Type: [Not Specified]
  • Job Type: [Not Specified]
  • Salary: $80,000-93,000/year

Jenzabar is seeking a SQL Database Architect responsible for creating and debugging SQL queries, stored procedures, triggers, functions, and views. This role involves executing database structure and data enhancement scripts, designing databases to meet development goals, and optimizing system performance. The administrator will also install, configure, troubleshoot, and maintain database systems, including replication, backup, partitions, storage, and access, while managing user privileges.

Company Information

For over four decades, Jenzabar has been a leader in providing services to colleges and universities worldwide. The Jenzabar culture fosters an entrepreneurial environment that encourages creativity, hard work, and a positive work experience. We value open communication, critical thinking, mutual respect, and exceeding client expectations. The company offers a casual dress code and a relaxed atmosphere.

Mission Statement: "We believe everyone is a masterpiece with great work to do on Earth. Jenzabar’s mission is to create pathways to empower all to know who they are, what work they are destined to do, and how they can unlock their full potential – at home, at work, and in the world!"

Responsibilities

  • 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.
  • Implement relational database concepts and techniques using SQL DDL.
  • Gather requirements from software product managers and architects and design relational database objects.
  • Update and maintain databases used by product development staff across multiple Jenzabar software versions.
  • Work with the Quality Assurance team to test and verify database changes for releases.
  • Provide support to resolve complex database issues for customers.
  • Assist the data services team with technical issues related to data conversions.
  • Stay informed on upcoming Microsoft SQL Server versions and evaluate potential impacts on Jenzabar 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.
  • Ability to install, configure, troubleshoot, and maintain Microsoft SQL Server databases.

Preferred Skills & Experience

  • 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, with the ability to interact effectively with development staff and clients.
  • Strong organizational skills, with the ability to plan, coordinate, and track tasks effectively while meeting project deadlines.
  • Desirable experience includes PowerBuilder, Microsoft Active Directory, and working in an academic environment or with higher education software.

Skills

SQL
Stored Procedures
Triggers
Functions
Views
Database Design
Index Tuning
Disk Optimization
Replication
Backup
Partitioning
User Privileges
Relational Database Concepts

Jenzabar

Software solutions for higher education institutions

About Jenzabar

Jenzabar provides software solutions specifically for higher education institutions, focusing on improving operational efficiency through integrated platforms. Their main products, Jenzabar One and Jenzabar SONIS, combine student information systems (SIS) and enterprise resource planning (ERP) systems, which help manage essential functions like student data and financials. These cloud-based solutions allow colleges and universities to access and manage their data from anywhere, offering benefits such as scalability and cost savings compared to traditional software. Jenzabar serves a wide range of clients, including traditional colleges and universities, as well as institutions that cater to non-traditional students. Their goal is to enhance the educational experience by making campuses more digitally responsive, ultimately helping institutions attract and retain students in a competitive market.

Boston, MassachusettsHeadquarters
1998Year Founded
$58.4MTotal Funding
GROWTH_EQUITY_VCCompany Stage
Enterprise Software, EducationIndustries
501-1,000Employees

Benefits

Health Insurance
Dental Insurance
Vision Insurance
Life Insurance
Disability Insurance
Unlimited Paid Time Off
Paid Vacation
Paid Sick Leave
Paid Holidays
Short Term Disability
Long Term Disability
401(k) Retirement Plan
401(k) Company Match
Paid Parental Leave
Educational Assistance

Risks

Emerging edtech startups pose a competitive threat to Jenzabar's market share.
Rapid technological advancements may challenge Jenzabar's feature integration speed.
Economic pressures on institutions could reduce spending on Jenzabar's solutions.

Differentiation

Jenzabar offers a comprehensive suite of ERP and SIS solutions for higher education.
Their cloud-based model provides scalability and flexibility for educational institutions.
Jenzabar's strategic partnership with Google Cloud enhances their technological capabilities.

Upsides

Increased demand for cloud-based ERP solutions boosts Jenzabar's market potential.
Growing interest in competency-based education aligns with Jenzabar One's offerings.
Rising importance of data analytics supports Jenzabar's analytics solutions.

Land your dream remote job 3x faster with AI