SQL Server Lead/Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Derex Technologies Inc · 1 week ago

SQL Server Lead/Architect

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level, Lead/Staff
date15+ years exp

Derex Technologies Inc is an IT consulting and software services company based in Harrison, New Jersey. They are seeking a SQL Server Lead/Architect to take ownership of the SQL Server estate, document architecture, and optimize performance while troubleshooting production issues.

Information ServicesInformation Technology
check
H1B Sponsor Likelynote

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

Qualification

Microsoft SQL ServerSSIST-SQLSQL Server AgentDBA experienceProactive communication

Required

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

Company

Derex Technologies Inc

twittertwitter
company-logo
DEREX Technologies, Inc. established in 1996 is engaged nationally in providing professional computer services, including management consulting firm.
dateFounded in 1996
location
Harrison, New Jersey, USA
people-size51-200 employees
web-link
https://www.derextech.com/

H1B Sponsorship

Derex Technologies Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (5)
2023 (7)
2022 (8)
2021 (9)
2020 (10)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Gopi Barala
WCM/ECM/MuleSoft Consultant (Interwoven Teamsite, LiveSite, Alfresco, Vignette, IBM CMOD, MuleSoft)
linkedin
Company data provided by crunchbase