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.
Required Qualifications
- 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.
Regards,
Manoj
Derex Technologies INC
Contact : 973-834-5005 Ext 206
All your information will be kept confidential according to EEO guidelines.
