SQL Server Software Architect

Tasks

• Assess and redesign existing SQL Server database architecture for scalability, performance, and maintainability.
• Design high-performance database solutions for microservices and AI-driven applications.
• Develop hot, warm, and cold data archival strategies for large-scale databases.
• Perform advanced SQL Server performance tuning, query optimization, indexing, and partitioning.
• Implement high availability and disaster recovery solutions targeting near-zero RPO/RTO.
• Manage database migration, backup, recovery, security, and monitoring automation.
• Collaborate with application development and DevOps teams on database architecture and deployment.
• Provide technical leadership and guidance to development and operations teams.

Requirements

• Local Candidates Only
• 15+ Years
• 8+ years of SQL Server database design, development, and administration.
• Proven experience architecting and redesigning large-scale, high-performance SQL Server databases.
• Experience managing 100TB+ databases and high-volume transactional workloads.
• Strong expertise in T-SQL, stored procedures, triggers, indexing, partitioning, and query optimization.
• Experience with self-hosted SQL Server on virtual machines (VMs).
• Strong knowledge of database scalability, sharding, migration, backup, and disaster recovery.
• Experience with microservices architecture and distributed systems.
• Familiarity with ERwin, PowerDesigner, or similar data modeling tools.
• Tolling industry experience is a strong plus.
• SQL Server certifications.
• NoSQL and hybrid database solutions.
• AI

Location

• Union City, NJ
• Germantown, MD
• Plano, TX
• Houston, TX