{"id":502,"date":"2025-10-31T18:38:20","date_gmt":"2025-10-31T18:38:20","guid":{"rendered":"https:\/\/skillbasedmatching.com\/jobs\/?post_type=jobpost&#038;p=502"},"modified":"2025-10-31T18:38:24","modified_gmt":"2025-10-31T18:38:24","slug":"senior-sql-database-architect-product-development-remote","status":"publish","type":"jobpost","link":"https:\/\/skillbasedmatching.com\/jobs\/current-jobs\/senior-sql-database-architect-product-development-remote\/","title":{"rendered":"Senior SQL Database Architect \u2013 Product Development (Remote)"},"content":{"rendered":"\n<p><strong>Jenzabar<\/strong> is seeking a <strong>Senior SQL Database Architect<\/strong> to join their Product Development team.<sup><\/sup> This critical, remote role is responsible for the design, effective implementation, and maintenance of database structures for Jenzabar software.<sup><\/sup><\/p>\n\n\n\n<p>The pay range for this full-time position is <strong>$91,000 \u2013 $108,000 per year<\/strong>, plus an annual bonus and a full range of benefits.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Core Responsibilities<\/h3>\n\n\n\n<p>This Senior Database Architect will align database structures with the company&#8217;s business requirements, ensuring effective performance and implementation across multiple customer systems (a multi-server environment).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database Design &amp; Modeling:<\/strong> Collaborate with design and development teams to create database designs, perform <strong>database modeling<\/strong>, and effectively communicate <strong>schema structures<\/strong>.<\/li>\n\n\n\n<li><strong>SQL Development:<\/strong> Design, create, and debug <strong>SQL queries, stored procedures, triggers, functions, and views<\/strong> (using SQL DML, DDL, and DCL commands).<\/li>\n\n\n\n<li><strong>Performance &amp; Maintenance:<\/strong> Optimize system performance through <strong>index tuning and disk optimization<\/strong>. Maintain and update databases used by the product development team across multiple versions of Jenzabar software.<\/li>\n\n\n\n<li><strong>System Administration:<\/strong> Manage <strong>replication, backup processes, partitions, storage, and access controls<\/strong>, and oversee user privileges (SQL permissions). This is critical due to the <strong>multi-server deployment<\/strong> across hundreds of customer systems.<\/li>\n\n\n\n<li><strong>Mentorship &amp; Training:<\/strong> <strong>Assist in training Development team members<\/strong> in SQL best practices and database management; mentor junior team members.<\/li>\n\n\n\n<li><strong>Strategy &amp; Compliance:<\/strong> Stay informed about new releases of <strong>Microsoft SQL Server<\/strong> and evaluate their potential impacts.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Required Skills and Expertise<\/h3>\n\n\n\n<p>The ideal candidate must have extensive experience in Microsoft SQL Server administration and development, coupled with proven mentoring abilities.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Core Technology:<\/strong> Extensive experience installing, configuring, troubleshooting, and maintaining <strong>Microsoft SQL Server<\/strong> database systems.<\/li>\n\n\n\n<li><strong>SQL Expertise:<\/strong> Proven ability to design and code complex database procedures, triggers, and views. Expertise in teaching and applying <strong>SQL DML, DDL, and DCL commands<\/strong>.<\/li>\n\n\n\n<li><strong>Architecture Knowledge:<\/strong> Deep understanding of <strong>relational database concepts<\/strong> and database delivery concepts in <strong>multi-server environments<\/strong>.<\/li>\n\n\n\n<li><strong>Education:<\/strong> Bachelor\u2019s degree in Computer Science, Information Technology, or a related field.<\/li>\n\n\n\n<li><strong>Preferred Skills:<\/strong> Experience managing databases in <strong>high-availability<\/strong> production environments, proficiency in <strong>T-SQL<\/strong> queries, and familiarity with a <strong>higher education environment<\/strong> and <strong>Microsoft Active Directory<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>Jenzabar is seeking a Senior SQL Database Architect to join their Product Development team. This critical, remote role is responsible for the design, effective implementation, and maintenance of database structures for Jenzabar software. The pay range for this full-time position is $91,000 \u2013 $108,000 per year, plus an annual bonus and a full range of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","jobpost_category":[46],"jobpost_job_type":[39],"jobpost_location":[],"jobpost_tag":[622,2259,2263,2261,695,2262,2255,81,2253,2390,2254,2257],"class_list":["post-502","jobpost","type-jobpost","status-publish","hentry","jobpost_category-data","jobpost_job_type-remote","jobpost_tag-database-design","jobpost_tag-database-replication","jobpost_tag-higher-education-tech","jobpost_tag-index-tuning","jobpost_tag-microsoft-sql-server","jobpost_tag-multi-server-environments","jobpost_tag-product-development","jobpost_tag-remote","jobpost_tag-senior-database-architect","jobpost_tag-sql-dml-ddl-dcl","jobpost_tag-stored-procedures","jobpost_tag-triggers"],"_links":{"self":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost"}],"about":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/types\/jobpost"}],"author":[{"embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"jobpost_category","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_category?post=502"},{"taxonomy":"jobpost_job_type","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_job_type?post=502"},{"taxonomy":"jobpost_location","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_location?post=502"},{"taxonomy":"jobpost_tag","embeddable":true,"href":"https:\/\/skillbasedmatching.com\/jobs\/wp-json\/wp\/v2\/jobpost_tag?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}