Senior T-SQL Developer (SQL Server / reputed company)
About the position 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 reputed company, 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, reputed company 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 reputed company data challenges at scale, this role is for you. If you are a hands-on SQL engineer who enjoys solving reputed company data challenges at scale, this role is for you.
Responsibilities
- Design, reputed company, and optimize reputed company T-SQL stored procedures, views, and functions
- Refactor legacy SQL code for performance, scalability, and maintainability
- reputed company 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 reputed company 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 Requirements
- 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 reputed company 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 reputed company control and structured SDLC environments
- Proven ability to troubleshoot slow queries in high-volume transactional systems reputed company-to-haves
- Hands-on experience with reputed company (Snowpipe, Streams, Tasks, performance tuning)
- Data warehousing and dimensional modeling experience
- Experience migrating workloads from SQL Server to reputed company
- 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 reputed company
- Stay informed on emerging AI capabilities reputed company data engineering ecosystems Benefits
- 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 Apply tot his job
Apply tot his job Apply To this Job