Remote Database Architect IV - 576

Description:

• The SQL Database Architect will be 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 through index tuning, disk optimization, and other methods.
• The administrator will install, configure, troubleshoot, and maintain database systems, including replication, backup, partitions, storage, and access, while managing user privileges.
• Collaborate with the design and development team to create database designs that meet specified requirements.
• Perform database modeling and effectively communicate schema structures to development staff.
• Demonstrate a thorough understanding of relational database concepts and techniques, implementing them using SQL DDL.
• Gather requirements from software product managers and architects and design relational database objects to meet software goals.
• Update and maintain databases utilized 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 Jenzabar software.

Requirements:

• Proficiency in SQL DML, DDL, and DCL commands is required.
• Strong coding skills in triggers, views, and stored procedures, including code optimization, are necessary.
• The ability to design and code complex procedures, triggers, and views is essential.
• Extensive knowledge of SQL database administration tasks and database delivery concepts is required.
• Experience deploying databases in multi-server environments, with hundreds of client systems, is necessary.
• Expertise in creating and managing SQL permissions is required.
• The ability to install, configure, troubleshoot, and maintain Microsoft SQL Server databases is essential.
• A Bachelor’s degree in Computer Science, Information Technology, or a related field is preferred.
• Experience managing production databases in high-availability environments is a plus.
• Proficiency in Microsoft SQL Server database administration, including scripting for SQL environment management, is preferred.
• Strong experience in writing complex T-SQL statements, stored procedures, triggers, and views is necessary.
• The ability to assist development staff in optimizing SQL queries for system performance is required.
• Experience with data import/export, data conversions, and database patch applications is preferred.
• Excellent oral and written communication skills, with the ability to interact effectively with development staff and clients of varying technical expertise, are necessary.
• Strong organizational skills, with the ability to plan, coordinate, and track tasks effectively while meeting project deadlines, are required.
• Desirable experience includes PowerBuilder, Microsoft Active Directory, and working in an academic environment or with higher education software.

Benefits:

• The pay range for this position is $80,000-93,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.
• Benefits include Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, PTO, Paid Parental Leave, Paid Holidays, Short Term Disability, Long Term Disability, 401K, and Educational Assistance.