SQL Application Developer

OverviewSQL DeveloperHybrid - Paoli, PATurn5 is a fast-growing eCommerce company serving automotive enthusiasts across multiple brands including AmericanMuscle.com, AmericanTrucks.com, ExtremeTerrain.com and Eckler's.com. We build platforms, content, and customer experiences that help people customize, restore, and enjoy their cars and trucks. We're people-first, team-oriented, and looking for someone excited to contribute to meaningful, high-impact work.What You'll DoWork with developers and project management in a highly transactional OLTP environment to build new and support existing SQL code, structures, and dataEvaluate and performance tune existing procedures and dataAnalyze business needs and software requirements to help determine feasibility of work within time and resource constraintsProject life cycle involvement - planning, estimates, documentation, development, testing and deploymentWhat We're Looking ForWe value strong fundamentals, curiosity, and the ability to grow. If you're stronger on some of these and lighter on others, that's perfectly fine - we're more interested in your ability to solve problems, collaborate, and grow with the team. If you have a solid foundation and are excited to learn, we want to hear from you.Required fundamentals:3-4 years of recent experience with MS SQL Server 2016+, preferably in an e-commerce environmentExperience with designing SQL Structures and procedures to support highly transactional applications.Experience fine-tuning SQL functions and stored procedures called hundreds or thousands of times per minute.Deep understanding of database design principlesExperience with Data modelingCreating tables for relational data, views, stored procedures, and indexes.Technologies you may work with here (These are things you'll encounter, not hard requirements, so exposure to even a few is great):Microsoft SQL ServerSQL Profiler, Performance Monitor, and other related toolsXML, JSON, MS Excel, MS SQL Server, and Tableau Who You'll Work WithYou will work closely with the Manager of Data Engineering, application developers and project management to design, support, and optimize SQL solutions in a high transaction e-commerce environment. We prioritize work-life balance, clear communication and helping each other succeed.Why You'll Love Working HereWe offer:Hybrid schedule:Local (within 50 miles of our HQ in Paoli, PA): typically 2 days onsite per month (yes, month!)Remote: 2 weeks onsite per yearCompetitive compensation in-line with experience & impact, plus a quarterly bonus programComprehensive benefits package including medical, dental, and vision plus immediate vesting on your 401k matchA people-first culture where curiosity, ownership, and collaboration are valuedOpportunities to grow your technical skillset and contribute to impactful, high-visibility productsAbout Turn5Turn5 is one of the largest and fastest growing eCommerce retailers in the Greater Philadelphia area. Best known for our award-winning, eCommerce platforms, AmericanMuscle.com, ExtremeTerrain.com, and AmericanTrucks.com, we've been engaging muscle car, truck, and off-road enthusiasts with exceptional products, services, and experiences since 2004. With the acquisition of Eckler's in 2022, a pioneer in classic car restoration & modification for over 60 years, Turn5's catalog of brands has expanded to now offer aftermarket automotive products for vehicles as classic as the Model T.