Data Administrator – Oracle, PowerDesigner

Job not on LinkedIn

🔥 5 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Certsys

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2007

🤖 Artificial Intelligence

🏢 Enterprise

🤝 B2B

Artificial Intelligence • Enterprise • B2B

Certsys is a company focused on driving digital transformation in public institutions through advanced AI solutions. They offer innovative services aimed at optimizing processes, enhancing decision-making, and providing faster, more personalized services to the population. Their offerings include hyperautomation, AI, cloud solutions, and scalable digital products designed to meet the demanding needs of the public sector.

📋 Description

• Develop and maintain conceptual, logical and physical data models using SAP PowerDesigner. • Model and evolve Oracle databases, ensuring integrity, consistency and standardization of structures. • Perform reverse engineering and synchronization of data models with database environments. • Produce and maintain technical documentation for models and data dictionaries. • Generate and validate DDL scripts for creating and modifying database objects. • Define and enforce modeling, naming and data governance standards. • Support development, architecture and DBA teams in defining the best solutions for storing and organizing data. • Analyze the impact of model changes and propose solutions to ensure performance, scalability and data quality. • Ensure models comply with business rules and organization standards. • Participate in system evolution projects, integrations and digital transformation initiatives.

🎯 Requirements

• Proven experience as a Data Administrator (DA) or Data Modeler. • Experience in data modeling and administration projects in corporate environments. • Experience with Oracle databases and data governance processes. • Experience working in multidisciplinary teams, supporting developers, architects and DBAs. • SAP PowerDesigner (required). • Oracle Database. • SQL (queries and optimization). • DDL (CREATE, ALTER, DROP). • Conceptual, Logical and Physical Data Modeling. • Reverse engineering and model synchronization. • Version control tools (Git) – desirable. • Azure DevOps or Jira – desirable. • Microsoft Office suite, especially Excel – desirable. • Relational modeling and data normalization. • Referential integrity and data quality. • Data governance and documentation. • Data dictionary. • Naming and data architecture standards. • Impact analysis for data model changes. • Generation and validation of DDL scripts. • Data Warehouse and ETL concepts (desirable).

🏖️ Benefits

• High-quality healthcare: Bradesco Saúde Nacional plan with medical and dental coverage. • Meal coverage: Swile card for meals. • Mobility: Transportation voucher for commuting. • Financial wellbeing: Exclusive banking credit package. • Life insurance: 100% coverage at no additional cost. • Investment in education: Exclusive discounts on courses and educational institutions. • Physical health: Access to gyms through Wellhub (Gympass).