Pay
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Schenectady, New York, United States
Actively hiring, first seen by us 1 day agoEmployment type in the employer’s posting: Full timeFrom the employer’s posting
Find and fix slow queries, procedures and views using execution plans and Query Store
Maintain backups, restore testing, integrity checks and Always On or log shipping
Plan SQL Server upgrades and support monthly patch windows
Keep schema consistent across client databases and correct drift
Review database changes and release scripts before they ship
Finds and fixes slow queries, stored procedures, views and report queries using execution plans, wait statistics and Query Store.
Collaborates with DevOps on backup jobs, backup validation, retention and restore testing, with backups stored in AWS S3.
Plans and carries out SQL Server version upgrades with Development and DevOps, supports monthly patch windows
Keeps schema consistent across hundreds of client databases and corrects drift.
Reviews database changes and release scripts before they ship.
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.Read the full posting
Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Day 1
Early. Similar jobs usually come down between day 6 and day 56.
From 14,771 similar postings that came down. Coming down is not always a hire.
1 open job
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Experience with PowerShell (dbatools) or Python for automation preferred.
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.
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.
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.
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.
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.
Security and Documentation: Manages SQL logins and permissions and advises on access requests from integrations.
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.
Experience and Education: Minimum of 5 years' experience administering or engineering Microsoft SQL Server in production.
Experience running SQL Server on AWS EC2 and using S3 preferred.
Experience with SQL Server version upgrades and migrations preferred.
Backups, Recovery and High Availability: Collaborates with DevOps on backup jobs, backup validation, retention and restore testing, with backups stored in AWS S3.
Complete your application on transfinder.zohorecruit.com. The employer’s form will show what is required.
Already applied? Track this application
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Schenectady, New York, United States
This passage needs a closer read in the full description.
No clear work-authorization passage found. Eligibility is unconfirmed.