Database Architect

Transfinder•City of Schenectady, NY
•$130,000 - $150,000•Remote

About The Position

The Database Architect owns the SQL Server platform behind Transfinder's school transportation and public safety products, maintaining hundreds of client databases so they remain fast, healthy, and recoverable. The role tunes performance; supports backups and high availability; plans upgrades and capacity with DevOps; and partners with development teams on database changes. The position also uses AI tools daily to improve the speed and quality of database work. Prior AI experience is not required, and training is provided. The position is primarily remote, with select in-person team meetings at the company's Schenectady, New York headquarters. Candidates must reside locally or within commuting distance to attend meetings as needed. The role reports to the Vice President, Software Development and is classified as exempt, regular full-time.

Requirements

  • At least 5 years of experience administering or engineering Microsoft SQL Server in production.
  • Strong T-SQL skills, including stored procedures, views, functions, and reading execution plans.
  • Hands-on SQL Server performance-tuning experience, including indexing, wait statistics, Query Store, blocking, and parameter sniffing.
  • Working knowledge of backups and restores, integrity checks, SQL Server Agent, and Always On availability groups or log shipping.
  • Ability to manage many databases simultaneously through scripting rather than one-off manual changes.
  • Willingness to learn and use AI tools daily as a core part of the job; prior AI experience is not required.
  • Clear written and verbal communication skills, including the ability to explain database issues to developers and support staff.
  • Strong analytical, organizational, and problem-solving skills.
  • Ability to manage time effectively and meet deadlines.
  • Flexibility to support after-hours maintenance windows and production incidents as needed.
  • Ability to attend in-person team meetings at the Schenectady, New York headquarters as needed; candidates must live locally or within commuting distance.
  • Ability to sit for prolonged periods and work at a computer, and to occasionally lift up to 15 pounds.

Nice To Haves

  • Experience supporting a multi-tenant environment with one database per client.
  • Experience running SQL Server on AWS EC2 and using S3.
  • Experience with PowerShell (dbatools) or Python for automation.
  • Experience with SQL Server version upgrades and migrations.
  • Familiarity with Git, pull requests, and Jira.

Responsibilities

  • Find and resolve slow queries, stored procedures, views, and report queries using execution plans, wait statistics, and Query Store.
  • Own the in-house SQL Server monitoring and metrics system, including collection jobs, reporting, and alerts for long-running queries, failed jobs, and servers that stop reporting.
  • Recommend and build indexes and work with development, QA, and support teams to diagnose performance issues and production incidents.
  • Collaborate with DevOps on backup jobs, validation, retention, and restore testing, with backups stored in AWS S3.
  • Run integrity checks and maintenance jobs; maintain Always On availability groups and log shipping; and support failovers.
  • Plan and carry out SQL Server version upgrades with Development and DevOps, support monthly patch windows, and check jobs and services after patching.
  • Maintain scripts that configure new SQL Server instances.
  • Monitor server load, including CPU, IO, waits, database size, and client count, and recommend rebalancing clients when servers become too heavily loaded.
  • Keep schemas consistent across hundreds of client databases and correct drift.
  • Identify and clean up bad or duplicate data and work with developers to prevent it at the source.
  • Maintain data-retention jobs across products and review database changes and release scripts before release.
  • Write custom SQL exports, imports, and one-off data fixes for client projects in collaboration with support and implementation teams.
  • Use AI coding assistants and agents daily to analyze execution plans and slow queries, write and review T-SQL and PowerShell scripts, review database changes, and draft documentation.
  • Validate AI-generated output before production use and follow company policy regarding tools that may access client data.
  • Manage SQL logins and permissions and advise on access requests from integrations.
  • Document processes, runbooks, and troubleshooting steps in Confluence.
  • Perform other duties and projects as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service