Job DescriptionJob DescriptionDatabase Architect (SQL Server)\nPay Status and Classification: Exempt, Regular Full-time\nSupervisor Title: Vice President, Software Development\nWork 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.\nPosition 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.\nEssential Duties and Responsibilities:\n\n 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.\n 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.\n 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.\n 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.\n Client Data Requests: Writes custom SQL exports, imports and one-off data fixes for client projects, working with support and implementation teams.\n 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.\n 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.\n Other duties and projects as assigned.\n\nRequired Skills and Abilities:\n\n Strong T-SQL, including stored procedures, views, functions and reading execution plans.\n Hands-on SQL Server performance tuning: indexing, wait statistics, Query Store, blocking and parameter sniffing.\n Working knowledge of backups and restores, integrity checks, SQL Server Agent and Always On availability groups or log shipping.\n Ability to manage many databases at once through scripting rather than one-off manual changes.\n Willingness to learn and use AI tools daily as a core part of the job (prior AI experience not required).\n Clear written and verbal communication; able to explain database issues to developers and support staff.\n Strong analytical, organizational and problem-solving skills.\n Ability to manage time effectively and meet deadlines.\n Flexibility to support after-hours maintenance windows and production incidents as needed.\n\nExperience and Education:\n\n Minimum of 5 years' experience administering or engineering Microsoft SQL Server in production.\n Experience supporting a multi-tenant environment with one database per client preferred.\n Experience running SQL Server on AWS EC2 and using S3 preferred.\n Experience with PowerShell (dbatools) or Python for automation preferred.\n Experience with SQL Server version upgrades and migrations preferred.\n Familiarity with Git, pull requests and Jira preferred.\n\nPhysical Requirements:\n\n Prolonged periods of sitting at a desk and working on a computer.\n Must be able to lift up to 15 pounds occasionally.\n\nAnnual Salary Range: $130,000.00 to $150,000.00\nSalary is established based on various factors, including, but not limited to, prior employment history, job-related knowledge, education and training, skills, and geographic location.\n\n \n\n
Click on the below icons to share this job to Linkedin, Twitter!
Job DescriptionJob DescriptionDatabase Architect (SQL Server)\nPay Status and Classification: Exempt, Regular Full-time\nSupervisor Title: Vice President, Software Development\nWork 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.\nPosition 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.\nEssential Duties and Responsibilities:\n\n 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.\n 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.\n 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.\n 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.\n Client Data Requests: Writes custom SQL exports, imports and one-off data fixes for client projects, working with support and implementation teams.\n 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.\n 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.\n Other duties and projects as assigned.\n\nRequired Skills and Abilities:\n\n Strong T-SQL, including stored procedures, views, functions and reading execution plans.\n Hands-on SQL Server performance tuning: indexing, wait statistics, Query Store, blocking and parameter sniffing.\n Working knowledge of backups and restores, integrity checks, SQL Server Agent and Always On availability groups or log shipping.\n Ability to manage many databases at once through scripting rather than one-off manual changes.\n Willingness to learn and use AI tools daily as a core part of the job (prior AI experience not required).\n Clear written and verbal communication; able to explain database issues to developers and support staff.\n Strong analytical, organizational and problem-solving skills.\n Ability to manage time effectively and meet deadlines.\n Flexibility to support after-hours maintenance windows and production incidents as needed.\n\nExperience and Education:\n\n Minimum of 5 years' experience administering or engineering Microsoft SQL Server in production.\n Experience supporting a multi-tenant environment with one database per client preferred.\n Experience running SQL Server on AWS EC2 and using S3 preferred.\n Experience with PowerShell (dbatools) or Python for automation preferred.\n Experience with SQL Server version upgrades and migrations preferred.\n Familiarity with Git, pull requests and Jira preferred.\n\nPhysical Requirements:\n\n Prolonged periods of sitting at a desk and working on a computer.\n Must be able to lift up to 15 pounds occasionally.\n\nAnnual Salary Range: $130,000.00 to $150,000.00\nSalary is established based on various factors, including, but not limited to, prior employment history, job-related knowledge, education and training, skills, and geographic location.\n\n \n\n
yes
Send Us Your Feedback
Sign
In
Please check your email. We have sent you a password reset link.
This link will expire in one hour.
Please input your account's email
Apply to Database Architect
Transfinder • Schenectady, New York
✓
Application Started!
Redirecting you to complete your application...
Get $5 added to your wallet for registering an account. Refer others and get $1 for each successful referral. Earn while you search for jobs and redeem in gift cards!Register to search from millions of jobs across the United States. Upload your resume and get matched with top employers today!
Welcome to SnapRecruit! Your account has been created via Google.
Get $5.00 Added to Your Wallet!
Upload your resume below and apply to this job to have $5.00 added directly to your wallet, activate your account, and qualify for high-priority employer matches.
Perks & Rewards You Receive with SnapRecruit:
$5.00 Resume Bonus
Added automatically to your wallet when you apply with your resume.
$1.00 Per Referral
Earn $1.00 cash rewards for every friend who joins SnapRecruit in the US.
Earn While You Search
Get credited $0.02 - $0.05 every time you explore sponsored job listings.
Amazon eGift Cards
Redeem your earned wallet funds for Amazon eGift Cards delivered to your email.
Get $5 added to your wallet for registering anRegister to search from millions of jobs across the United States. Upload your resume and get matched with top employers today!
account.
Refers others and get $1 for each successful referral.
Earn while you search for jobs and redeem in
gift cards!
Upload your resume for a free professional assessment
Loading, Please wait..!!
Send this job to my email
Please wait..!!
Confirmation
Are you sure?
List of resumes
Confirmation
It is working for Chrome Mozilla only for now
We use essential cookies to keep SnapRecruit secure and reliable. With your permission, we also use optional analytics, AI support chat, and push-alert cookies to improve your job search experience. You can change or withdraw your choice anytime.
Privacy Policy •
Cookie Policy •
Your Privacy Rights