SQL Server Lead/Architect
About The Position
Role: SQL Server Lead/Architect Location: Remote Must have worked on SQL Server Development (SSIS) and SQL DBA Key Responsibilities: Technical Ownership and Architecture Own the full SQL Server estate: databases, schemas, tables, indexes, views, stored procedures, functions, triggers, SSIS packages, SQL Server Agent jobs, schedules, and dependencies. Document current-state and target-state architecture for ETL, scheduling, and data processing workflows. Define and enforce standards for design, coding, deployment, and operational readiness across SQL and SSIS. Partner with application and infrastructure teams to align capacity, availability, and operational practices. Troubleshooting, Performance, and Optimization Diagnose and resolve production issues: slow queries, deadlocks, blocking, timeouts, failed jobs, SSIS execution failures, and throughput bottlenecks. Optimize at the programming layer: execution plan analysis, query refactoring, indexing strategy, SSIS performance tuning, parallelism, batching, and transaction/log management. Optimize at the infrastructure layer: CPU/memory sizing, IO and storage patterns, tempdb strategy, SQL Server configuration, and environment hardening. Establish performance baselines and telemetry and drive measurable improvements against SLAs and business outcomes.
Requirements
- 15 years of hands-on Microsoft SQL Server engineering with senior ownership of production environments.
- Strong SSIS expertise: package design patterns, performance tuning, troubleshooting, configurations, and deployments.
- Deep SQL Server Agent experience: scheduling strategy, dependencies, operational controls, and recovery patterns.
- Advanced T-SQL skills: stored procedures, functions, query tuning, indexing, and execution plan analysis.
- Prior DBA experience supporting production: maintenance strategy, security fundamentals, backup/restore concepts, capacity planning, and incident response.
- Proactive communicator who can lead client conversations, present recommendations, and drive outcomes.
Responsibilities
- Own the full SQL Server estate: databases, schemas, tables, indexes, views, stored procedures, functions, triggers, SSIS packages, SQL Server Agent jobs, schedules, and dependencies.
- Document current-state and target-state architecture for ETL, scheduling, and data processing workflows.
- Define and enforce standards for design, coding, deployment, and operational readiness across SQL and SSIS.
- Partner with application and infrastructure teams to align capacity, availability, and operational practices.
- Diagnose and resolve production issues: slow queries, deadlocks, blocking, timeouts, failed jobs, SSIS execution failures, and throughput bottlenecks.
- Optimize at the programming layer: execution plan analysis, query refactoring, indexing strategy, SSIS performance tuning, parallelism, batching, and transaction/log management.
- Optimize at the infrastructure layer: CPU/memory sizing, IO and storage patterns, tempdb strategy, SQL Server configuration, and environment hardening.
- Establish performance baselines and telemetry and drive measurable improvements against SLAs and business outcomes.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
11-50 employees
