FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Database Analyst – Mid-level
Fadami - Software & InnovationDatabase Analyst designing and optimizing SQL databases for efficient solutions at Fadami Software & Innovation in Brazil. Involves complex queries and collaboration with development teams.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
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
Advanced SQL Server ExperienceT-SQL ProficiencyPerformance Tuning SkillsETL Process ExperienceDatabase Security Knowledge
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQL ServerT-SQLRelational Data ModelingStored ProceduresPerformance TuningETL ProcessesTransaction ManagementConcurrency ControlDatabase VersioningNoSQL Databases
Tools & Technologies
Power BISSISSSRSAzure SQL DatabaseMonitoring Tools
Industry Keywords
Data WarehouseBig DataAgile MethodologiesScrumKanban
Tech Stack
Tools & technologiesAzureETLNoSQLSQLSSISSubversion
About the role
Key responsibilities & impact- 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
What you’ll need- 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
Benefits
Comp & perks- Flexible meal/food allowance (VA/VR) — R$ 858.00/month
- SulAmérica health plan (monthly subsidy of R$ 440.00; no co-payment)
- SulAmérica dental plan
- Psychological support via Psicologia Viva
- Birthday day off + R$ 100.00 gift voucher
- Culture allowance — R$ 50.00/month
- Icatu life insurance
- Wellhub (Gympass) for employee + dependents
- Transportation allowance