Senior Data Administrator

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Create and uphold both logical and physical data models for various systems.

• Develop and evaluate DDL scripts for the creation and modification of tables, indexes, and constraints.

• Assist in the development of stored procedures, functions, and triggers as needed by developers.

• Craft data migration scripts for deployment and upgrade processes.

• Establish and maintain standards for database naming and modeling.

• Aid developers with data access issues and ORM mapping challenges.

• Perform impact analyses related to changes in database structure.

• Generate complex queries for data extraction and reporting purposes.

• Ensure the data dictionary documentation remains current.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or a related IT field.

• A minimum of five (5) years of demonstrated experience in data administration and database modeling.

• Advanced skills in Microsoft SQL Server (2016+), encompassing administration, tuning, indexing, partitioning, and high availability.

• Experience with relational modeling (3NF), dimensional modeling (Star Schema), and denormalization for performance enhancement.

• Proficient in T-SQL (including procedures, functions, triggers, CTEs, and window functions).

• Proven experience in analyzing execution plans, optimizing queries, and identifying performance bottlenecks.

• Familiarity with data migration, ETL, and schema update scripts.

🏝️ Benefits

• Fully remote – Work from the safety and comfort of your home.

• Flexible working hours.

• Birthday day off – including a surprise!

• Support for education and professional certifications.

• Access to Alura.

• Partnership with FIAP.

• Employee referral bonus program.

• Health insurance.

• Dental insurance.

• Vittude – mental health platform.

• Wellhub – support for your physical well-being.

• New Value – discount coupons.

• SESC.

• Meal and/or food allowance.