Database Engineer (Azure & On-Premises)

Database Engineer (Azure & On-Premises)

Location: Brazil

The Database Engineer will be responsible for designing, implementing, and maintaining the organization’s hybrid LOS data infrastructure across Microsoft Azure and on-premises SQL Server environments. This role requires an advanced understanding of database design principles, data normalization, and the architectural differences between transactional (OLTP) and analytical (OLAP) systems.

The successful candidate will play a key role in ensuring high data performance, integrity, and availability, while leveraging technologies such as table partitioning, data striping, and Azure data services to optimize scalability and efficiency.

Required Qualifications

• Bachelor’s degree in computer science or a related technical field.
• Minimum of 4 years of experience as a Database Engineer, Database Administrator, or equivalent technical role.
• Proven proficiency in Microsoft SQL Server (2016 or newer) and Azure SQL Database.
• Strong command of T-SQL, stored procedures, views, and indexing strategies.
• Demonstrated experience in:
• Data normalization and relational schema design.
• Table partitioning and data striping implementation.
• Designing both OLTP and OLAP database architectures.
• Performance tuning and query optimization for large-scale data systems.
• Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS.
• Familiarity with high availability, failover clustering, and disaster recovery techniques.

Preferred Qualifications

• Knowledge of data warehousing, dimensional modeling, and BI integration (Power BI, SSAS).
• Exposure to DevOps and CI/CD pipelines for database deployments.
• Scripting experience using PowerShell, Python, or similar languages.
• Knowledge of MISMO is a plus.

Core Competencies

• Strong analytical and problem-solving skills.
• Exceptional attention to detail and data accuracy.
• Ability to work independently and manage multiple priorities effectively.
• Clear and professional communication skills, both written and verbal.
• Collaborative mindset with a focus on continuous improvement.