Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Database Architect

$130k - $150k

Transfinder

Job Description

Job Description

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.


Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Database Architect in Schenectady, NY vacancy
  • Job-ID27478712Reference26-04962Provide a short description of the Position: Act as Expert Database Architect and L2 Technical Operational Support working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as... 
    Suggested

    Mindlance

    Schenectady, NY
    3 days ago
  • $90.58k - $114.59k

    Position InformationNY HELPS: No55-b/c Eligible: NoAgency: People With Developmental Disabilities, Office forTitle: Data Analyst 2 Occupational Category: Other Professional CareersSalary Grade: 23Bargaining Unit: PS&T - Professional, Scientific, and Technical (PEF)Salary...
    Suggested
    Permanent employment
    Full time
    Internship
    Work at office
    Local area
    Remote work

    State of New York, USA

    Schenectady, NY
    17 hours ago
  • $137.7k - $229.6k

    Job Description Summary As a Principal AI Data Architect, you will define and evolve the enterprise data architecture needed to deliver...  .../ML or GenAI solutions, including one or more of RAG, vector databases, enterprise search, LLM evaluation, agentic workflows, feature... 
    Suggested
    Contract work
    Work at office
    Relocation package

    GE Vernova, Inc.

    Niskayuna, NY
    3 days ago
  • Duties Description The Data Analyst 2 will work in the Data Integration and Governance Team of the Division of Data Strategy and Management, Bureau of Data Analytics, Integration, and Governance under the direction of the Data Integration and Governance Team Lead to build...
    Suggested
    Full time
    Work at office
    Local area
    Remote work

    StateJobsNY

    Schenectady, NY
    3 days ago
  • At Eneco, we are committed to accelerating the energy transition. Through our One Planet strategy, we aim to become climate neutral by 2035 - together with our customers.Digital technology and data play a key role in achieving this ambition. Within the Energy Management...
    Suggested

    Eneco

    Rotterdam, NY
    17 hours ago
  • At Eneco, we are accelerating the energy transition through our One Planet Plan, with the ambition to become climate neutral by 2035. Energy markets are becoming increasingly dynamic and complex due to renewable generation, electrification, and shifting market behavior....
    Shift work

    Eneco

    Rotterdam, NY
    1 day ago
  • Do you enjoy working on complex automation systems and want to make a direct impact on vessels operating around the world? Would you like to apply your technical expertise in an environment where innovation, reliability and scale come together?

    Van Oord

    Rotterdam, NY
    2 days ago
  • Job Requirements At Quest Global, it’s not just what we do but how and why we do it that makes us different. With over 25 years as an engineering services provider, we believe in the power of doing things differently to make the impossible possible. Our people are driven...
    Work experience placement

    Quest Global Services

    Schenectady, NY
    17 hours ago
  • $67.57 per hour

    Payrate: $67.57 - $67.57/hr. Summary: The Digital Transformation & SmartShop Deployment Specialist will play a critical role in accelerating the digital transformation of the Schenectady manufacturing facility. Serving as a primary point of contact for SmartShop-related...
    Hourly pay
    Full time
    Local area
    Flexible hours

    Aditi Consulting

    Schenectady, NY
    17 hours ago
  • $38.59 - $57.89 per hour

    Lead Special Procedure Technologist - IR/Angio The Special Procedure Tech performs specific and specialized duties pertaining to diagnostic and interventional imaging procedures as well as CT (if applicable) which require use of independent judgment, initiative, and...
    Hourly pay
    Local area

    Ellis Medicine

    Schenectady, NY
    2 days ago
  • $60.3k - $88.44k

    Job Title: Human Resources Analyst Summary: The Human Resources Analyst in Shared Services provides primary support for the employee lifecycle and HR work globally, as part of a global HR Services team. Responsibilities include handling diverse and confidential...
    Temporary work
    Internship
    Work at office
    Local area
    Relocation
    Monday to Friday

    Momentive

    Niskayuna, NY
    3 days ago
  • $90k - $180k

    Job Description Job Description Navarro Research and Engineering is recruiting a  Mechanical Engineer in Niskayuna, NY. A DOE L Clearance (or DOD equivalent) is required to be considered for this position. Navarro Research & Engineering is an award-winning federal...
    Contract work
    Temporary work
    For contractors
    Local area

    Navarro Inc.

    Niskayuna, NY
    15 days ago
  • Job Description Job Description CLIENT HIGHLIGHT The client you will be working for is a Fortune 500 Energy and Industrial Technology Company. This opportunity will give you experience in the energy transition sector with a company that is a globally recognized ...
    Hourly pay
    Contract work
    Monday to Friday
    Flexible hours

    West Coast Logistics

    Schenectady, NY
    15 days ago
  • $160k - $180k

     ...Lead Architect Location: Clifton Park, NY, United States Salary Range: USD 160000–180000 Annually Date Posted:Sep 20, 2026 Description Company Overview: When it comes to IT solution providers, there are a lot of choices. But when it comes to providers... 
    Contract work
    Remote work

    Zones

    Clifton Park, NY
    1 day ago
  • Job Description Job Description What You will Do: Support drawing and Bill of Material (BOM) updates for Generator components and assemblies. Interface with manufacturing and sourcing to assist in Non-Conformance Requests (NCRs) and Supplier Deviation Requests...

    Quest Global

    Schenectady, NY
    14 days ago
  • $120k - $150k

    Job Requirements Quest Global delivers world-class end-to-end engineering solutions by leveraging our deep industry knowledge and digital expertise. By bringing together technologies and industries, alongside the contributions of diverse individuals and their areas of expertise...
    Full time
    Temporary work
    Remote work

    Quest Global Services

    Schenectady, NY
    4 days ago
  • $86.1k - $134.6k

    Working at the Naval Nuclear Laboratory we foster pride in belonging to an organization whose culture is made up of these core values: Trust, Empowerment, and Collaboration. Our company promotes a positive culture while ensuring the safety and reliability of our nation'...
    For contractors
    Local area

    Naval Nuclear Laboratory

    Schenectady, NY
    2 days ago
  •  ...procedures for MIS application within maintenance activities. Oversees the identification and correction of file errors within the database. Performs in-depth comprehensive analysis of complex and prioritized unit readiness issues. Analyzes performance data to determine... 
    Full time
    Part time
    Second job
    Trial period

    Air National Guard Units

    Scotia, NY
    4 days ago
  • Supervisory Transportation Security Officer Opportunities in Schenectady Supervisory Transportation Security Officers—or STSOs—manage the people and daily decisions behind airport passenger and baggage screening operations. They supervise Transportation Security Officers...
    Permanent employment
    Full time
    Temporary work
    Trial period
    Flexible hours
    Shift work
    Night shift
    Weekend work
    Day shift
    Afternoon shift
    Early shift

    Transportation Security Jobs

    Schenectady, NY
    19 days ago
  • Supervisory Transportation Security Officer Opportunities in Rexford Supervisory Transportation Security Officers—or STSOs—manage the people and daily decisions behind airport passenger and baggage screening operations. They supervise Transportation Security Officers...
    Permanent employment
    Full time
    Temporary work
    Immediate start
    Trial period
    Flexible hours
    Shift work
    Night shift
    Weekend work
    Day shift
    Afternoon shift
    Early shift

    TSA Hiring Service

    Rexford, NY
    19 days ago
  • Management Analyst This is a National Guard Title 32 Excepted Service Position. Management Analyst Position Description Number T5645000 and is part of the 109th AW, National Guard. This vacancy does not meet the criteria for appointment of annuitants.

    US Government Jobs

    Scotia, NY
    17 hours ago
  • $89.3k - $148.7k

    Job Description Summary We are looking for an Electrical Root Cause Analysis (RCA) Lead Engineer to own the investigation and resolution process for our critical power generation assets. This role is essential to our mission of maximizing fleet availability and minimizing...
    Contract work
    Visa sponsorship
    Work visa
    Relocation package

    GE Vernova

    Schenectady, NY
    3 days ago
  • Declassification Analyst B&A is looking for a Declassification Analyst to join a contract with a federal government client in support of an important mission. This role supports the Naval Nuclear Propulsion Program by conducting detailed classification and declassification...
    Contract work
    Work at office

    Clearance Jobs

    Schenectady, NY
    2 days ago
  • $85k - $110k

    Job Description Job Description Declassification Analyst At Accora, we foster and embrace a distinct set of values that we live by and instill in all aspects of our organization: dedication, commitment, partnership, trust, and recognition. We have incorporated...
    Full time
    Contract work
    Work at office
    Local area

    Accora

    Schenectady, NY
    4 days ago
  • Medior Business AnalystMet jouw inzichten en analyses kunnen we data-gedreven commerciele doelstellingen zetten en weten we kansen te spotten voor verbetering.Wat doe je als Medior Business Analyst bij Coolblue?Bij Coolblue maak je als Medior Business Analist deel uit van...

    Coolblue

    Rotterdam, NY
    1 day ago
  • De energietransitie vraagt om slimme keuzes. Als Lead Strategie Warmtenetten & Bronnen speel je een sleutelrol in de verdere verduurzaming van de Nederlandse warmtevoorziening. Je verbindt strategie, investeringen, operationele realiteit en duurzame groei binnen de warmteketen...

    Eneco

    Rotterdam, NY
    4 days ago
  • Team Lead TypescriptAls Team Lead Typescript geef je leiding aan een backend team dat schaalbare software bouwt in TypeScript. Je begeleidt een team dat uitblinkt in het leveren van hoogwaardige, kostenefficiënte software. Je helpt teamleden doelen scherp te stellen en ...

    Coolblue

    Rotterdam, NY
    17 hours ago
  • Team Lead C#Als Team Lead bouw je een sterk team van developers en maak je samen software waar onze klanten blij van worden. Je coacht, inspireert en programmeert met plezier mee. Met jouw scherpe blik verbeter je processen en motiveer je je team om elke dag een beetje ...

    Coolblue

    Rotterdam, NY
    17 hours ago
  • Lead Transportation Security Officer Opportunities in Rexford Lead Transportation Security Officers—or LTSOs—help keep airport screening operations organized, consistent, and prepared for changing security needs. In this leadership role, you may guide Transportation Security...
    Full time
    Flexible hours
    Shift work
    Night shift
    Weekend work
    Day shift
    Afternoon shift
    Early shift

    Airport Security Careers

    Rexford, NY
    2 days ago
  • Engineer IV Position Summary: Maintains building by independently making high level and complex repairs. Also, by performing preventative maintenance tasks/projects throughout the casino in more than one trade discipline that may include but not be limited to landscaping...
    Flexible hours
    Afternoon shift

    Rivers Casino

    Schenectady, NY
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Architect. Be the first to apply!