Back to jobs

Database Architect

Remote

For over four decades, the higher education experts at Jenzabar have been helping colleges and universities across the world thrive through multiple services. The Jenzabar culture is one that fosters an entrepreneurial environment, where employees are encouraged to be creative, work hard, and have a great time while doing so. We believe in open doors, asking tough questions, respecting each other, and surpassing our clients’ expectations every step of the way. It’s an enjoyable place to be, with casual dress 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!

Summary

This position will involve SQL query, stored procedure, trigger, function, and view creation and debugging. Create and execute database structure and data enhancement scripts as required to meet development goals. Create database designs to meet development goals.  Monitor and optimize system performance using index tuning, disk optimization, and other methods. Install, configure, troubleshoot, and maintain a database system. Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within the database environment.

Responsibilities

  • Update and maintain all databases utilized by product development staff, across multiple versions of the Jenzabar software.
  • Work with the design and development team to produce database designs that meet the specified requirements. Perform database modeling and can communicate that model to the development staff to ensure they understand the schema against which they are developing.
  • Work with the Quality Assurance team to test and verify delivery of database changes for releases.
  • Works as needed with the support team to help resolve difficult database issues in our customer base, including system performance. 
  • Works as needed with the data services team to answer any questions or help with difficult technical issues faced during conversion.
  • Stay current with upcoming versions of Microsoft SQL Server and be aware of changes that will affect the Jenzabar software.

Qualifications

  • Complete proficiency in SQL DML, DDL, and DCL commands, proficient coding skills in triggers, views, and stored procedures, and code optimization. Ability to design and code complex procedures, triggers, and views.  Thorough understanding and execution of all SQL database administration tasks.  Thorough understanding of database delivery concepts (structures and data) with the ability to execute this process in a multi-server environment (deployment to hundreds of customer systems).
  • Thorough understanding and ability to create and maintain SQL permissions.
  • Thorough understanding and ability to install, configure, troubleshoot, and maintain a Microsoft SQL Server database system.
  • A thorough understanding of relational database concepts and techniques, and the ability to code the implementation via SQL DDL.
  • Ability to gather design requirements from\with software product managers and architects. 
  • Ability to design relational database objects to meet software design goals. 
  • Ability to recognize and design enterprise-wide requirements to meet application-wide design goals.
  • Candidate must have a bachelor’s degree in computer science, Information Technology, or a related field.

 

Preferred Skills and Experience

  • Must have current experience with database administration using Microsoft SQL Server technologies. Solid knowledge of and experience with scripts required to manage an SQL environment.
  • Proficient in writing complex T-SQL statements, stored procedures, triggers, and views. Need to assist development staff as needed with complex queries and well-performing SQL statements to ensure the proper performance of the system.
  • Experience with data import/export, data conversions, and database patch applications.
  • Excellent oral and written communication skills in order to communicate effectively with development staff and clients of varying technical expertise.
  • Have strong organizational skills-being able to plan, coordinate, and track tasks effectively with a demonstrated history of meeting project deadlines.
  • Experience with PowerBuilder, Microsoft Active Directory and working in an academic environment or with higher education software are all desirable. 
  • Prefer candidates with a minimum of 5 years’ experience, but candidates with less than 5 years of relevant experience will be considered.
  • Experience handling client’s production in high-availability environments is a plus.

The pay range for this position is $85,000 - $102,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.

 

#LI-Remote

Benefits 

Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, Paid Vacation, Paid Sick Days, Paid Holidays, 12 Weeks Paid Parental Leave, 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.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter*

Accepted file types: pdf, doc, docx, txt, rtf

State

Select...
Select...
Select...
Select...

Education

Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Jenzabar’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.