Do you want to work for a company that breathes technology, offers new challenges, and provides a work environment focused on continuous professional development? Check out the profile below and apply! **Education:** Bachelor's degree completed in Computer Science, Computer Engineering, Information Systems, or related fields. **Mandatory Experience for the Position:** * Minimum of 5 years of proven experience specifically working as a Database Administrator. **Mandatory Technical Knowledge for the Position:** * Proficiency in Oracle Database (11g, 12c, 19c or later) and/or PostgreSQL (version 11 or later). * Experience with data modeling (conceptual, logical, and physical), using tools such as ERwin, Oracle SQL Developer Data Modeler, pgModeler, or equivalents. * Writing advanced SQL, including subqueries, CTEs, views, procedures, functions, and triggers. * Knowledge of PL/SQL (Oracle) and PL/pgSQL (PostgreSQL). * Database administration in development, testing, and production environments. * Database versioning using Liquibase or equivalent tool. * Experience with ElasticSearch, including data indexing, queries, and support for information analysis. * Knowledge of physical storage structures, including tablespaces (Oracle), schemas, indexes, partitioning, and data organization strategies. * Evaluation and optimization of database performance, including execution plan analysis. * Application of best practices for security, data integrity, and consistency. **Desirable/Differentiating Knowledge:** * Experience with high-volume data environments. * Experience in public sector projects or regulated environments. * Oracle or PostgreSQL certifications. * Postgraduate degree in Database Management or related fields. * Experience with government or judicial systems (integration with PJe). * English proficiency for technical reading and writing. **Behavioral Skills/Soft Skills:** * Strong analytical ability and attention to detail. * Organization and responsibility in administering critical environments. * Clear communication with technical and functional teams. * Proactivity in identifying and solving problems. * Ability to follow established standards, processes, and guidelines. **Key Responsibilities and Duties:** Database Administration and Governance * Installation, configuration, and upgrade of Oracle Database Management Systems and related products, such as single-instance and RAC DBMS, Enterprise Manager, Data Guard, and Golden Gate. * Administration of Oracle and PostgreSQL databases across projects, ensuring availability, reliability, and data integrity. * Management of users, profiles, roles, and access privileges. * Monitoring resource usage and database growth, acting preventively. * Ensuring compliance with internal technical standards, regulatory requirements, and client-defined assumptions. * Creation and maintenance of effective Backup and Recovery policies and procedures. * Planning database growth and capacity. Data Modeling and Structuring * Building, maintaining, and evolving system data models. * Detailing database tables and structures, defining physical storage layout, indexes, constraints, and relationships. * Ensuring alignment between the data model, business rules, and project technical guidelines. Queries, Performance, and Optimization * Executing, reviewing, and optimizing SQL queries to improve performance and reduce resource consumption. * Analyzing execution plans (EXPLAIN PLAN, EXPLAIN ANALYZE). * Optimizing procedures, functions, views, and SQL scripts. * Proposing structural improvements, such as index tuning, partitioning, and data reorganization. Versioning and Integration with Development * Implementing and maintaining database versioning with Liquibase, ensuring traceability and change control. * Collaborating with development teams to ensure consistency between application code and database schema. * Supporting data structure evolution, maintenance, and correction throughout the project lifecycle. Technical Support and Compliance * Analyzing and resolving database-related incidents. * Documenting models, standards, structures, and technical decisions. * Ensuring adopted solutions comply with internal standards, client regulations, and industry best practices. **Contract Information** Compensation: To be discussed. Working Hours: 20 hours per week — Monday to Friday — from 2:00 PM to 6:00 PM. **Benefits:** Access to courses on e-learning platforms ### **Department:** CRP Tecnologia