SQL Server Lead/Architect

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.

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.