Staff Software Engineer (Remote Available)

S&S Activewear LLC • Bolingbrook, IL

7h • Remote

About The Position

In this role, you will lead the design and delivery of advanced technical solutions that strengthen S and S Activewear’s competitive edge. The systems you build and optimize are core to how the company operates and scales, directly influencing our continued year over year growth. As a senior engineering leader, your expertise will shape both current initiatives and long-term technical strategy.

We are looking for a Staff Software Engineer with deep mastery of SQL Server, database architecture, and performance optimization. You will guide our transformation toward a highly performant, reliable, and scalable data platform. This includes partnering closely with Software Engineering, DevOps, Infrastructure, and Product teams to architect, tune, and monitor the mission critical database systems that power our applications.

This role is ideal for an engineer who thrives on query tuning, indexing strategies, storage engine internals, and end to end performance visibility and who can operate as a technical authority and collaborator across teams.

Requirements

• 10+ years of experience with SQL Server and T SQL, with mastery of query design, execution plans, and indexing strategies.
• Deep understanding of database internals: locking, blocking, deadlocks, tempdb behavior, and concurrency models.
• Hands on experience with performance monitoring tools (Datadog, Query Store, SQL Sentry, or similar).
• Proven experience leading large scale performance initiatives or major database modernization efforts.
• Strong understanding of distributed systems, high availability, and fault tolerant architectures.
• Ability to drive architectural decisions, mentor others, and influence cross functional teams.
• Experience collaborating with software engineering teams to implement best practices and data models.
• Proven track record of mentoring engineers and DBAs in database best practices.
• Strong knowledge of how to build and maintain distributed applications.
• Familiarity with CI/CD pipelines and DevOps practices.

Nice To Haves

• Experience with additional AWS services such as S3 and EC2.
• Experience with Microsoft. application ecosystems.
• Experience with automation frameworks for database deployments (Flyway, SSDT, Liquibase)

Responsibilities

• Architect, design, and evolve SQL Server database schemas, indexing strategies, and storage structures for scale and resilience.  Collaborate with software engineering teams to design efficient schema and data access patterns.
• Lead complex performance investigations involving query execution plans, locking/latching behavior, and I/O bottlenecks.
• Establish best practices for T SQL development, code reviews, and database development standards while serving as the organization’s database subject matter expert and technical mentor.
• Build and refine monitoring and alerting for database health, performance anomalies, and long running queries using tools such as Datadog and SQL Sentry in order to quickly identify and triage issues with the application tier.
• Lead efforts in capacity planning, high availability design, failover strategies, backup/restore validation, and disaster recovery readiness.
• Partner with DevOps to improve CI/CD processes for database deployments, integration testing, and migration automation.
• Provide oversight and support for data migration pipelines to data warehouse.
• Evaluate and optimize database configurations including memory, CPU, parallelism, and storage throughput through direct involvement and oversight of 3rd party DBA resources.
• Assess emerging database technologies, cloud capabilities, and performance tooling for potential adoption.

Benefits

• We offer a comprehensive benefits package designed to support your life, health, and future. Benefits begin 0–90 days after hire and include Vacation, Personal, and Sick time; Medical, Dental, Vision, Life Insurance, and Disability coverage; Flexible Spending Accounts; and a 401(k) plan.
• You’ll also enjoy discounts on brand‑name apparel, fun employee events, and meaningful opportunities for growth and advancement. Join a company that invests in you from day one.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed