Role Overview
- Develop and optimize complex queries using SQL Server;
- Create and maintain stored procedures, functions, triggers, views and packages;
- Design and model relational databases, defining table structures, indexes and relationships;
- Perform query tuning and optimizations to improve performance;
- Implement indexing strategies and table partitioning;
- Develop PL/SQL scripts for process automation and data integration;
- Implement and manage jobs and schedulers for batch data processing;
- Ensure data consistency, integrity and security;
- Create and maintain technical documentation for implemented structures and processes;
- Monitor and troubleshoot database performance and concurrency issues;
- Collaborate with development teams to ensure efficient integration between the database and applications.
Requirements
- Advanced experience with SQL Server;
- Proficiency in T-SQL for writing and optimizing code;
- Knowledge of relational data modeling and normalization;
- Experience creating and optimizing stored procedures, functions, triggers and views;
- Skill in performance tuning (execution plan analysis, indexes, partitioning);
- Experience with ETL and handling large volumes of data;
- Knowledge of database security and permissions;
- Experience managing transactions and concurrency;
- Familiarity with monitoring and performance analysis tools;
- Experience versioning database scripts (Git, SVN, etc.).
Differentials:
- Knowledge of Azure SQL Database or other cloud solutions;
- Experience with Power BI, SSIS and SSRS;
- Knowledge of NoSQL databases;
- Experience with Big Data and Data Warehouse;
- Familiarity with agile methodologies (Scrum, Kanban).
Tech Stack
- Azure
- ETL
- NoSQL
- SQL
- SSIS
- Subversion
Benefits
- Flexible meal/food allowance (VA/VR) — R$ 858.00/month;
- SulAmérica health plan (monthly subsidy of R$ 400.00 and no copay);
- SulAmérica dental plan;
- Psychological care through Psicologia Viva;
- Day off on your birthday + gift voucher of R$ 100.00;
- Culture allowance — R$ 50.00/month;
- Icatu life insurance;
- Wellhub (Gympass).
Parnerships and Agreements
- Veiga de Almeida University — undergraduate and graduate programs;
- Open English — English and Spanish courses;
- Affiliated beauty salon — discounts on services;
- Movida — vehicle rental with special conditions;
- Agreement with SESC;
- Discounts with the Hotel Fazenda Montanhês Group.
Other