Tech Holding

Senior SQL Server Architect – Contract

Tech Holding

contract

Posted on:

Location Type: Remote

Location: Mexico

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSAzureCloudMS SQL ServerSQL

About the role

  • Design and architect scalable, high-performance SQL Server environments
  • Assess existing database systems and define architecture improvements across performance, indexing, and query optimization
  • Lead end-to-end database migration initiatives (on-prem to cloud, version upgrades, or re-platforming)
  • Optimize stored procedures, queries, and schema design for large-scale datasets
  • Partner with DevOps and infrastructure teams on deployment, monitoring, and automation strategies
  • Implement best practices for backup, recovery, high availability, and disaster recovery (HA/DR)
  • Analyze and resolve complex performance bottlenecks in production environments
  • Provide technical leadership and mentorship to engineers and database developers
  • Ensure data integrity, security, and compliance across database systems

Requirements

  • 7+ years of experience working with Microsoft SQL Server in production environments
  • Proven experience operating at an Architect or Senior-level DBA capacity with ownership of database decisions
  • Deep expertise in query optimization, indexing strategies, and performance tuning
  • Strong experience with SQL Server 2016 or newer
  • Hands-on experience with high availability solutions (Always On, clustering, replication)
  • Proven experience leading database migrations end-to-end (on-prem to AWS/Azure or hybrid environments)
  • Strong understanding of database design, normalization, and large-scale data modeling
  • Experience supporting high-volume, production-grade systems
  • Advanced T-SQL skills
Benefits
  • Equal Opportunity Employer
  • Commitment to diverse and inclusive workplace
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL Serverquery optimizationindexing strategiesperformance tuningT-SQLdatabase designnormalizationlarge-scale data modelinghigh availability solutionsdatabase migration
Soft Skills
technical leadershipmentorshipcollaborationproblem-solving