Senior T-SQL Developer, SQL Server / Snowflake

Augeovia Remote Rocketship

RemotoRemotoSêniorCLT8 dias atrás

Salário Estimado

R$ 8.750,00 - R$ 9.583,00

Tecnologias

Azure Git IA

0de 100

Regular

Score da Vaga

Descrição da Vaga

Job Description:

•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 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 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 • 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 Benefits:

•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)

•Paid Long-Term disability and Life Insurance • HSA/FSA plans

•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

Vagas Semelhantes

MySQL PostgreSQL Database Engineer L3

GeorgiaTEK Systems Inc.BeBee

RemotoBrHoje

R$ 11k - 17k/mês

SêniorCLT

Position : MySQL PostgreSQL Database Engineer L3 Location : Remote Brazil Duration: Contract Rate : DOE About the Role We are looking for a seniorlevel database engineer to lead the design deployment and automation of PostgreSQL and MySQL platforms across both cloud infrastructure and Kubernetes env...

Node Python Go MySQL PostgreSQL+8

Ver Detalhes

Desenvolvedor Fullstack [.NET / Vue.js] - Sênior

Framework DigitalTalent.com

RemotoGoiânia, Goiás, BrHoje

R$ 11k - 16k/mês

SêniorCLT

Somos a Framework! Evoluímos grandes marcas em todo o mundo com transformação digital e crescemos continuamente através de agilidade, design e tecnologia. Fazer parte do nosso time é saber que a sua jornada será de desafios reais, de crescimento contínuo e de contato diário com referências em tecnol...

Vue Go AWS Azure GCP+4

Ver Detalhes