SQL Server LeadArchitect

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 : Ext 206

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

Yes

Employment Type :

Full-time