Talantix.io
Apetan Consulting•11.02.26
AI SCORE 8.5

Senior SQL Server Database Architect - Remote Position

$120K–$150K/year
RemoteSoftware DevelopmentRelocation
T-SQL•ETL•Microsoft Visual Studio•Database Architecture•Data Ingestion•Performance Tuning•SQL Server

About the Role

We're hiring a Senior SQL Server Database Architect to join our team in a fully remote capacity. In this role, you'll be responsible for building, configuring, and maintaining SQL Server databases, schemas, indexing, and data structures. This is an exciting opportunity to leverage your extensive experience in SQL Server to optimize performance and ensure data integrity.

What You'll Do

  • Build, configure, and maintain SQL Server databases, schemas, indexing, and data structures.
  • Develop and optimize Stored Procedures, T-SQL logic, and ETL components using Microsoft Visual Studio.
  • Ingest data from diverse sources and deliver processed outputs to downstream applications.
  • Monitor, troubleshoot, and maintain ETL jobs, scheduled tasks, and automated workflows.
  • Investigate discrepancies, system issues, and integration failures to ensure reliable data flows.
  • Support operational and financial month-end reporting processes.
  • Maintain enterprise dataflows, transformation logic, and data validation controls.
  • Design and maintain dimensional models for reporting and analytics.

Requirements

  • 8+ years of SQL Server development and administration experience, including installation, configuration, tuning, and maintenance.
  • Advanced T-SQL skills (Stored Procedures, functions, triggers, complex queries, performance tuning).
  • ETL development experience using Microsoft Visual Studio (SSIS or similar).
  • Strong schema design, database architecture, indexing, partitions, and constraints knowledge.
  • Experience with SQL Server security frameworks (roles, permissions, least privilege access).
  • Proven ability to ingest data from databases, APIs, and file formats (CSV, Excel, JSON, XML, SFTP).
  • Experience delivering data to downstream systems via integrations or flat file exports.
  • Solid dimensional modeling skills (facts, dimensions, star/snowflake schemas).

Nice to Have

  • Knowledge of Cognos or Power BI; IQMS experience is a plus.

What We Offer

  • Competitive salary range of $120,000 - $150,000 per year.
  • Comprehensive relocation support packages to help you settle into your new role.
  • Flexible remote work environment.
  • Opportunities for professional development and career advancement.
  • Collaborative team culture with a focus on innovation.
Why This Job8.5 of 10

This Senior SQL Server Database Architect role offers a competitive salary, remote work flexibility, and comprehensive relocation support, making it an attractive opportunity for experienced professionals.

Salary Range
Required
0/1
Optional
0/1
Bonus
0/1

Who Will Succeed Here

→

Proficiency in SQL Server and T-SQL for advanced querying and database management, with a strong understanding of performance tuning techniques to optimize database operations.

→

Self-motivated and disciplined to work remotely, demonstrating excellent time management skills and the ability to handle multiple projects independently.

→

Extensive experience in ETL processes and data ingestion strategies, coupled with a mindset focused on ensuring data integrity and implementing robust database architectures.

Learning Resources

→SQL Server Performance Tuning and Optimizationcourse
→Microsoft SQL Server Documentationguide
→ETL Concepts and Best Practicesarticle

Career Path

Senior SQL Server Database Architect(Now)→Lead Database Architect or Data Engineering Manager(1-2 years)→Director of Database Solutions or Chief Data Officer(3-5 years)

Market Overview

Market Size 2024
$15.2B
Annual Growth
8.5%
AI Adoption in Data Management
35%
Investment in Database Technologies
+25%
Labour Demand for Database Roles
+18%
Avg Salary for SQL Server Architects
$130K

Skills & Requirements

Required
T-SQLETLMicrosoft Visual Studio
Growing in Demand
Azure SQL DatabaseData Science and AnalyticsCloud Database Management
Declining
SQL Server Reporting Services (SSRS)Microsoft Access

Domain Trends

Shift to Cloud-Based Databases
As organizations migrate to cloud solutions, the demand for SQL Server on Azure is expected to grow by 40% by 2025, emphasizing the need for cloud expertise.
Increased Focus on Data Security
With data breaches on the rise, 60% of companies are investing more in database security solutions, making security skills essential for database architects.
Integration of AI in Database Management
Over 30% of SQL Server users are adopting AI-driven analytics tools, which enhance performance tuning and data ingestion processes, indicating a shift towards AI integration in database roles.

Industry News

Loading latest industry news...

Finding relevant articles from the last 6 months

All job postings are automatically gathered by algorithms. We do not review or verify listings, be careful when applying and do not sign-in with iCloud or Google services.