Database Architect

Posted 2 Days Ago
Be an Early Applicant
Schenectady, NY, USA
In-Office
130K-150K Annually
Senior level
Information Technology • Logistics • Software • Transportation
The Role
Owns and administers SQL Server infrastructure supporting hundreds of client databases. Responsibilities include performance tuning, monitoring, indexing, backups, recovery, high availability, upgrades, capacity planning, data quality, schema consistency, retention, client data requests, security permissions, and production support. The role uses T-SQL, PowerShell, and automation, collaborates with DevOps and development teams, documents procedures, and incorporates AI tools into database engineering workflows.
Summary Generated by Built In

Database Architect (SQL Server)

Pay Status and Classification: Exempt, Regular Full-time

Supervisor Title: Vice President, Software Development

Work Location: This position is primarily remote, with select team meetings in-person at our Schenectady, New York headquarters. Candidates must reside locally or within commuting distance to attend these meetings on an as needed basis.

Position Purpose: The Database Architect owns the SQL Server platform behind Transfinder's school transportation and public safety products, keeping hundreds of client databases fast, healthy, and recoverable. This role tunes performance, assists with backups and high availability, plans upgrades and capacity with DevOps, and partners with development teams on database changes. The Database Architect carefully uses AI tools every day to work faster and raise the quality of database work across the team.

Essential Duties and Responsibilities:

  • Performance Tuning and Monitoring: Finds and fixes slow queries, stored procedures, views and report queries using execution plans, wait statistics and Query Store. Owns the in-house SQL Server monitoring and metrics system, including its collection jobs, reporting and alerts for long-running queries, failed jobs and servers that stop reporting. Recommends and builds indexes and works with development, QA and support to diagnose performance issues and production incidents.
  • Backups, Recovery and High Availability: Collaborates with DevOps on backup jobs, backup validation, retention and restore testing, with backups stored in AWS S3. Runs integrity checks and maintenance jobs. Maintains Always On availability groups and log shipping, and supports failovers.
  • Server Management, Upgrades and Capacity: Plans and carries out SQL Server version upgrades with Development and DevOps, supports monthly patch windows and checks jobs and services after each one. Maintains the scripts that configure new SQL Server instances. Monitors server load (CPU, IO, waits, database size and client count) and recommends rebalancing clients across servers when a server becomes too heavy.
  • Data Quality, Retention and Releases: Keeps schema consistent across hundreds of client databases and corrects drift. Finds and cleans up bad or duplicate data and works with developers to stop it at the source. Maintains data retention jobs across products. Reviews database changes and release scripts before they ship.
  • Client Data Requests: Writes custom SQL exports, imports and one-off data fixes for client projects, working with support and implementation teams.
  • AI-Assisted Engineering: Uses 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. Validates AI output before it reaches production and follows company policy on which tools may access client data. Prior experience with AI tools is not required; training is provided.
  • Security and Documentation: Manages SQL logins and permissions and advises on access requests from integrations. Documents processes, runbooks and troubleshooting steps in Confluence so others can follow them.
  • Other duties and projects as assigned.

Required Skills and Abilities:

  • Strong T-SQL, including stored procedures, views, functions and reading execution plans.
  • Hands-on SQL Server performance tuning: 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 at once 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 not required).
  • Clear written and verbal communication; able 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.

Experience and Education:

  • Minimum of 5 years' experience administering or engineering Microsoft SQL Server in production.
  • Experience supporting a multi-tenant environment with one database per client preferred.
  • Experience running SQL Server on AWS EC2 and using S3 preferred.
  • Experience with PowerShell (dbatools) or Python for automation preferred.
  • Experience with SQL Server version upgrades and migrations preferred.
  • Familiarity with Git, pull requests and Jira preferred.

Physical Requirements:

  • Prolonged periods of sitting at a desk and working on a computer.
  • Must be able to lift up to 15 pounds occasionally.

Annual Salary Range: $130,000.00 to $150,000.00

Salary is established based on various factors, including, but not limited to, prior employment history, job-related knowledge, education and training, skills, and geographic location.



Skills Required

  • At least 5 years of experience administering or engineering Microsoft SQL Server in production
  • Strong T-SQL skills, including stored procedures, views, functions, and execution plans
  • Hands-on SQL Server performance tuning, including indexing, wait statistics, Query Store, blocking, and parameter sniffing
  • Working knowledge of backups, restores, integrity checks, SQL Server Agent, and Always On availability groups or log shipping
  • Ability to manage many databases through scripting and automation
  • Clear written and verbal communication with 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
  • Experience supporting a multi-tenant environment with one database per client
  • Experience running SQL Server on AWS EC2 and using Amazon S3
  • Experience with PowerShell using dbatools or Python for automation
  • Experience with SQL Server version upgrades and migrations
  • Familiarity with Git, pull requests, and Jira
  • Willingness to learn and use AI tools daily
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Schenectady, NY
Year Founded: 1988

What We Do

Transfinder is a software development company specializing in logistics and transportation management solutions for K-12 schools and other organizations, offering tools for routing, scheduling, fleet maintenance, and GPS tracking to optimize operations.

Similar Jobs

Vanasse Hangen Brustlin Logo Vanasse Hangen Brustlin

Architect

Professional Services • Transportation • Energy • Design
Hybrid
6 Locations
2300 Employees
105K-175K Annually

Ensono Logo Ensono

Architect

Cloud • Information Technology
Easy Apply
Remote or Hybrid
United States
3000 Employees
155K-210K Annually
Hybrid
New York, NY, USA
289097 Employees

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Acting Supervisor I

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
New York, NY, USA
16000 Employees
17-28 Hourly

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account