DBA Analyst - Mid-level

Description

Job Summary: The Centrus is seeking a Mid-level DBA Analyst to provide support, administer, and evolve database environments, ensuring proper operation, performance, and data quality. Key Highlights: 1. Support, administration, and evolution of database environments 2. Focus on Oracle Database and MySQL, advanced SQL, and PL/SQL 3. Work on data modeling, ETL/ELT, and query optimization **Description and Responsibilities:** **Schedule:** Business hours **Level:** Professional **Employment Type:** Full-time – CLT The Centrus is seeking a Mid-level DBA Analyst to support, administer, and evolve the organization's database environments. This professional will contribute to ensuring proper operation, performance, data organization, and quality, as well as drive improvements in routines, processes, and data structures. Responsibilities will focus on relational database administration, development of SQL and PL/SQL queries and routines, data modeling, data integration via ETL/ELT, and data environment optimization. **Key Responsibilities:** * Administer and maintain relational databases, with emphasis on Oracle Database and MySQL; * Apply advanced SQL and PL/SQL for data manipulation and definition; * Manage patches, storage, tablespaces, users, roles, and privileges; * Perform relational and dimensional data modeling; * Support ETL/ELT processes for data integration; * Apply best practices in data modeling, such as Third Normal Form and Star Schema; * Optimize queries and perform database tuning; * Support data quality initiatives and metric definition; * Work with metadata and data dictionaries; * Develop and maintain jobs related to the data environment; * Contribute to the analysis and creation of new routines and process improvements. **Requirements:** **Mandatory Requirements:** * Degree in Information Technology or related field * Proven experience administering Oracle 11g, 12c, 19c, or later database environments * Experience installing, configuring, and upgrading Oracle Database * Experience performing backup and recovery using Oracle Recovery Manager (RMAN) * Proficiency in advanced SQL and PL/SQL * Knowledge of conceptual, logical, and physical data modeling * Experience with relational and dimensional data modeling * Hands-on experience with ETL/ELT processes * Knowledge of query optimization and database tuning * Understanding of data quality, metrics, metadata, and data dictionaries **Desirable Qualifications:** * Experience with Power BI and other data visualization tools * Experience developing and maintaining jobs * Knowledge of data cleansing, standardization, and validation practices * Familiarity with data pipelines and data lakes **Benefits:** Medical assistance, Gym allowance, Daycare allowance, Education allowance, Pharmacy allowance, Medication allowance, Internal benefits, Running club, Maternity leave \- 6 months, Paternity leave \- 20 days, Profit sharing, Supplementary pension, Meal voucher