Database Analyst – Mid-level

Jobtailor

Rio de Janeiro

Presencial

BRL 120 000 - 180 000

Tempo integral

14 dias+

Recebe mais respostas dos empregadores

Envia um currículo específico para a oferta em poucos minutos.

Resumo da oferta

Jobtailor is seeking a skilled Database Developer to design, optimize, and maintain complex SQL Server-based data architectures for enterprise data integration. You will work across PK, index strategies, and partitioning while collaborating with software teams to ensure robust data access and performance.

The role emphasizes stored procedures, PL/SQL scripting for automation, and proactive performance tuning to support BI and analytics workflows with Power BI and SSRS/SSIS ecosystems.

Qualificações

Advanced SQL Server experience and expertise in T-SQL coding.
Experience creating and optimizing stored procedures, functions, triggers and views.
Strong knowledge of relational data modeling and normalization.
Performance tuning, execution plans, indexing and partitioning.

Responsabilidades

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 databases and applications.

Conhecimentos

Advanced SQL Server experience

T-SQL proficiency

Performance tuning

Data modeling

Security/permissions management

Ferramentas

SQL Server

Relational data modeling

Stored procedures

Views

SSIS

SSRS

Power BI

Azure SQL Database

Partitioning

Monitoring tools

Descrição da oferta de emprego

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 databases 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
Skills in performance tuning (execution plan analysis, indexing, partitioning)
Experience with ETL processes and handling large volumes of data
Knowledge of database security and permission management
Experience with transaction management and concurrency control
Familiarity with monitoring and performance analysis tools
Experience versioning database scripts (Git, SVN, etc.)
Knowledge of Azure SQL Database or other cloud solutions is a plus
Experience with Power BI, SSIS and SSRS is a plus
Knowledge of NoSQL databases is a plus
Experience with Big Data and Data Warehouse is a plus
Familiarity with Agile methodologies (Scrum, Kanban) is a plus

Core Competencies

Demonstrates advanced expertise in SQL Server and T-SQL for developing, optimizing, and maintaining complex database structures and processes. Proficient in performance tuning, data integration, and ensuring data integrity and security.

Highest-signal resume keywords