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.