MS SQL Database Architect (Handson)
Only Local or near by to Atlanta======================SQL Server Architect Atlanta GA [hybrid] Contract
Note:
The senior engineer has to coordinate with our offshore development team. Identifying someone handson & managed the offshore team & client communication will be a key to grow this team. Deep SQL Server architecture & internals — query engine, storage engine, transaction/locking/isolation levels, execution plan internals; 15+ yrs hands-on, architect-level design authority (not admin-level)HA/DR design mastery — Always On AGs, clustering, replication topologies; able to architect DR strategy across on-prem VMs and hybrid cloud, not just configure itCloud migration engineering — hands-on RDS for SQL Server (and/or Azure SQL/MI) migration mechanics: DMS, native backup/restore, licensing model trade-offs (BYOL vs. License Included) Strong Python scripting — automation, tooling, and integration development; not "can write a script" but production-grade automation engineeringAI-assisted engineering fluency — daily hands-on use of AI coding assistants (GitHub Copilot, Claude Code, Cursor, or similar) to accelerate schema design, query optimization, and code reviewLLM/agentic infrastructure exposure — working knowledge of embeddings, vector databases, RAG, and semantic search as they intersect with data platform designAI-enabled database operations — experience evaluating or building AI-driven observability, anomaly detection, or self-healing/auto-remediation tooling for database platformsMCP / tool-integration awareness — familiarity with Model Context Protocol or comparable frameworks for connecting AI agents to data systems Performance engineering at scale — wait-stats methodology, indexing strategy, parameter sniffing mitigation — demonstrable via live plan-reading, not resume claims IaC & CI/CD fluency — Terraform/Cloud Formation, Git, automated pipelines for database deployment and change management Has built production systems on Snowflake: stored procedures, Tasks, Streams, MERGEStrong declarative SQL (CTEs, window functions) Reads and understands Node.js comfortably Has delivered at least one like-for-like migration and can explain how they proved old and new agreed Money discipline: fixed-precision decimals and consistent rounding Reviews other engineers' and AI-generated SQL critically; will do first-line PR review for the team
Nice to have: payments or billing domain, dbt, AWS