Data Administrator – Oracle, PowerDesigner

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

📋 Description

• Create and uphold conceptual, logical, and physical data models utilizing SAP PowerDesigner.

• Design and enhance Oracle databases, guaranteeing the integrity, consistency, and standardization of structures.

• Conduct reverse engineering and synchronize data models with database environments.

• Generate and maintain technical documentation for models and data dictionaries.

• Produce and validate DDL scripts for the creation and modification of database objects.

• Establish and enforce standards for modeling, naming, and data governance.

• Collaborate with development, architecture, and DBA teams to identify optimal solutions for data storage and organization.

• Assess the implications of model changes and recommend solutions to ensure performance, scalability, and data quality.

• Verify that models adhere to business rules and organizational standards.

• Engage in system evolution projects, integration efforts, and digital transformation initiatives.

⛳️ Requirements

• Demonstrated experience as a Data Administrator (DA) or Data Modeler.

• Background in data modeling and administration initiatives within corporate settings.

• Familiarity with Oracle databases and data governance protocols.

• Experience collaborating within multidisciplinary teams, assisting developers, architects, and DBAs.

• Proficiency in SAP PowerDesigner (mandatory).

• Knowledge of Oracle Database.

• Expertise in SQL (queries and optimization).

• Skills in DDL (CREATE, ALTER, DROP).

• Experience in Conceptual, Logical, and Physical Data Modeling.

• Capability in reverse engineering and model synchronization.

• Familiarity with version control tools (Git) – preferred.

• Experience with Azure DevOps or Jira – preferred.

• Proficiency in Microsoft Office suite, particularly Excel – preferred.

• Understanding of relational modeling and data normalization.

• Knowledge of referential integrity and data quality.

• Experience in data governance and documentation.

• Familiarity with data dictionary concepts.

• Awareness of naming and data architecture standards.

• Skills in impact analysis for data model changes.

• Experience in generating and validating DDL scripts.

• Knowledge of Data Warehouse and ETL concepts (preferred).

🏝️ Benefits

• Comprehensive healthcare: Bradesco Saúde Nacional plan offering medical and dental coverage.

• Meal support: Swile card for meal expenses.

• Transportation assistance: Voucher for commuting costs.

• Financial advantages: Exclusive banking credit package.

• Life insurance: 100% coverage at no extra charge.

• Educational investment: Special discounts on courses and educational institutions.

• Physical wellness: Access to gyms via Wellhub (Gympass).