via Adp
$100K - 140K a year
Lead design and delivery of advanced SQL Server database solutions focusing on architecture, tuning, and monitoring for scalability and performance.
Over 10 years experience with SQL Server and T-SQL, mastery of query design and indexing, and proven leadership in database performance initiatives.
JOIN US AND "CREATE YOUR VISION" ABOUT US S&S Activewear is a leading North American, tech enabled specialty distributor of imprintable apparel, including t shirts, fleece, athletic wear, headwear, workwear, scrubs and accessories. We pride ourselves on being the “critical link” that enables our 100+ brand partners such as Adidas, Columbia and Gildan to reach our hyper fragmented base of customers, comprised of apparel decorators, eRetailers and promotional products distributors that embellish apparel items for diverse end consumer use cases (e.g., everyday wear, concerts, fitness attire, life events, team sports, etc.). At S&S, we differentiate in the market through a customer service focus, strategic product portfolio, world class distribution infrastructure, a collaborative growth culture and a relentless focus on technology and innovation. Our success has compounded since the Company’s humble beginnings in 1988 as a regional t shirt distributor to a leading, multibillion dollar value-added distribution platform that drives market penetration for our suppliers while enabling growth, operations and fulfillment for a diverse range of customers across channels and business sizes. Today, we continue to strive to be the apparel distributor of choice by inspiring and fostering growth for customers, employees and suppliers, anchored in our commitment to Lead with Respect, Never Settle, Own the Outcome, Win Together, and the belief that Innovation Powers Our Hustle. These values guide how we serve, how we collaborate and how we continuously improve, ensuring we deliver on our promise of service, deep relationships, innovation, continuous improvement and accountability. ABOUT THE ROLE 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. SCHEDULE & LOCATION Monday-Friday, Full-Time, Exempt Remote Available 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 YOU WILL DO * 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. WHAT WE'RE LOOKING FOR * 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. WHAT MAKES YOU STAND OUT * 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) Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk or listen. Working Environment This job operates in a professional office environment. This role routinely involves standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Reasonable accommodation may be provided to enable people with disabilities to perform the essential functions. Equal Opportunity Employer S&S Activewear welcomes people of all backgrounds and experiences and are committed to creating a diverse culture and supporting human growth. We are proud to be an equal opportunity employer and are committed to providing equal opportunity for all employees and applicants. We conduct business without regard to sex, race, creed, color, religion, marital status, national origin, citizenship status, age, pregnancy, sexual orientation, gender identity or expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. Our policy is to recruit, hire, train, promote, assign, transfer, and terminate employees based on their own ability, achievement, experience and conduct and other legitimate business reasons. S&S participates in E-Verify and will provide the federal government with your Form I-9 information to confirm you are authorized to work in the U.S. This job offer is contingent upon the completion of a satisfactory background check.
This job posting was last updated on 2/27/2026