Senior T-SQL Developer (SQL Server / Snowflake) at MotivAction LLC.

Saint Paul, Minnesota, United States -

Full Time

Start Date

Immediate

Expiry Date

18 May, 26

Salary

0.0

Posted On

17 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

T-SQL Development, SQL Server, Snowflake, Stored Procedures, Query Tuning, Execution Plans, Indexing Strategies, SSIS, ETL/ELT, CI/CD, Azure DevOps, Git, Data Modeling, Relational Database Design, Dimensional Modeling, AI-Assisted Tools

Industry

Advertising Services

Description

Description Hello, we're Augeo – we are a global leader in enterprise-level engagement and loyalty platform technology, delivering compelling experiences and fostering meaningful connections for employees, consumers, members and channel partners across many industries and verticals. We serve hundreds of clients, including 65 Fortune 500 companies, representing millions of end users. We are thought leaders and disruptors who think differently and creatively, built by entrepreneurs, operators, and innovators. At Augeo, we're passionate about providing an inclusive workplace that values diversity and our sustainability initiatives. Everyone is welcome - our employees are comfortable bringing their authentic whole selves to work. Be you, reach your full potential. We work hard, we play hard and, most importantly, we care to our core about our teams and each other. We over-communicate around everything...especially while we navigate our new hybrid world. We are builders, operators, and innovators who take ownership of business-critical systems. If you are a hands-on SQL engineer who enjoys solving complex data challenges at scale, this role is for you. If you are a hands-on SQL engineer who enjoys solving complex data challenges at scale, this role is for you. What You Will Own Design, develop, and optimize complex T-SQL stored procedures, views, and functions Refactor legacy SQL code for performance, scalability, and maintainability Perform advanced query tuning using execution plans, indexing strategies, and statistics analysis Architect and maintain ETL/ELT processes (SSIS and cloud-based pipelines) Support business-critical reporting and billing systems with high accuracy and performance expectations Implement CI/CD practices for database deployments (Azure DevOps/Git) Contribute to Snowflake data warehouse design, optimization, and data modeling Troubleshoot production performance issues and resolve root causes Collaborate with cross-functional teams to translate business requirements into scalable data solutions Required Technical Expertise (Non-Negotiable) 5+ years of hands-on T-SQL development in production environments Advanced knowledge of: o Query execution plans o Index design and optimization o Locking, blocking, and transaction isolation levels o TempDB behavior and performance impact o Set-based logic and performance tuning Experience building and maintaining complex stored procedures (1,000+ lines of logic) Strong understanding of relational database design and normalization Experience with SSIS or enterprise ETL frameworks Experience with Git-based source control and structured SDLC environments Proven ability to troubleshoot slow queries in high-volume transactional systems Preferred Hands-on experience with Snowflake (Snowpipe, Streams, Tasks, performance tuning) Data warehousing and dimensional modeling experience Experience migrating workloads from SQL Server to Snowflake Exposure to BI tools (Tableau or Power BI) Familiarity with CI/CD automation for database deployments Understanding of SOC2 controls and secure data handling practices Understand how AI-assisted tools can improve development efficiency Use AI responsibly to enhance — not replace — engineering judgment Can evaluate AI-generated SQL for correctness, performance, and security Stay informed on emerging AI capabilities within data engineering ecosystems Technical Screening Expectations Candidates should be able to: Explain how they diagnose and resolve a slow-running stored procedure Interpret and optimize complex execution plans Design an indexing strategy for a high-volume billing table Refactor cursor-based logic into set-based operations Describe transaction isolation impacts in high-concurrency systems Explain trade-offs between SQL Server and Snowflake architectures What Success Looks Like in This Role Improved query performance across reporting and billing systems Reduced production incidents related to database performance Clean, maintainable SQL code with strong documentation Scalable data pipelines supporting enterprise growth Ownership mentality — you treat the database as a product, not a ticket queue Who Thrives Here Engineers who enjoy solving complex performance problems Developers who prefer depth over surface-level scripting Professionals who take pride in clean, efficient database design Individuals who want architecture exposure, not just task execution Education & Experience Two- or four-year degree preferred Experience with SSIS, complex stored procedures, and data imports Familiarity with AI-enhanced development workflows and tools Proficient in Microsoft SQL Server and relational database technologies Work Environment This role operates in a hybrid environment enhanced by AI collaboration platforms. You’ll use tools like Cursor and Copilot to work smarter, not harder. This role routinely uses standard office equipment such as laptop computers and smartphones. 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 occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; and taste or smell. The employee must occasionally lift or move up to 20 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus. Travel Travel is primarily local during the business day, although occasional out-of-area and overnight travel may be expected. Benefits of joining team Augeo We offer Medical, Dental and Vision coverage with additional perks through third party vendors offering more virtual and in person care at your fingertips (must be in select locations) We offer paid Long-Term disability and Life Insurance HSA/FSA plans We offer varying voluntary benefits such as critical, hospital, pet coverage and much more Employee benefit education, campaigns and wellness opportunities 401k retirement matching and financial planning resources Education reimbursement Several EAP resources 13 paid holidays and PTO time Rewards, incentives and gamification for birthdays, Work-aversery's, professional and personal milestones, company involvement and kudos Employee referral bonuses Employee group opportunities Fun, casual and flexible working environment that embraces the hybrid workstyle Career growth opportunities Summer internship program

Responsibilities

The role involves designing, developing, and optimizing complex T-SQL stored procedures, views, and functions, alongside refactoring legacy SQL code for performance and scalability. Responsibilities also include architecting ETL/ELT processes, supporting critical reporting systems, implementing CI/CD for database deployments, and contributing to Snowflake data warehouse design.