Database Architect
$130k - $150kTransfinder
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.
- 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
$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...SuggestedPermanent employmentFull timeInternshipWork at officeLocal areaRemote work$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...SuggestedContract workWork at officeRelocation package- 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...SuggestedFull timeWork at officeLocal areaRemote work
- 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
- 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
- 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?
- 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
$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 payFull timeLocal areaFlexible hours$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 payLocal area$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 workInternshipWork at officeLocal areaRelocationMonday to Friday$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 workTemporary workFor contractorsLocal area- 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 payContract workMonday to FridayFlexible hours
$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 workRemote work- 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...
$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 timeTemporary workRemote work$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 contractorsLocal area- ...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 timePart timeSecond jobTrial period
- 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 employmentFull timeTemporary workTrial periodFlexible hoursShift workNight shiftWeekend workDay shiftAfternoon shiftEarly shift
- 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 employmentFull timeTemporary workImmediate startTrial periodFlexible hoursShift workNight shiftWeekend workDay shiftAfternoon shiftEarly shift
- 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.
$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 workVisa sponsorshipWork visaRelocation package- 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 workWork at office
$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 timeContract workWork at officeLocal area- 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...
- 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...
- 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 ...
- 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 ...
- 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 timeFlexible hoursShift workNight shiftWeekend workDay shiftAfternoon shiftEarly shift
- 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 hoursAfternoon shift
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Database Architect. Be the first to apply!




