Oracle Database Specialist (Oracle DBA)

Description

**Profile: Oracle Database Specialist (Oracle DBA)** ===================================================== **Responsibilities** --------------- Responsible for the administration, support, and optimization of Oracle Database environments, ensuring availability, security, integrity, performance, and continuity of databases supporting critical corporate systems. **Key Responsibilities and Duties** **Main Responsibilities** -------------------------------- * Administer, monitor, and maintain high-availability Oracle Database environments. * Analyze and optimize the performance of SQL and PL/SQL queries used by systems and applications. * Develop and propose improvements to queries, procedures, and routines focused on performance and scalability. * Proactively monitor database performance across development, staging, testing, and production environments. * Identify performance bottlenecks and implement corrective and preventive actions. * Propose data modeling improvements to enhance information efficiency, performance, and integrity. * Execute data loads, migrations, and replications between environments using Oracle administration tools. * Assess technical impacts resulting from changes to database structures. * Administer backup policies, disaster recovery (Recovery), and service continuity. * Implement and oversee maintenance routines, updates (patches), monitoring, and capacity planning. * Contribute to defining best practices for Oracle database administration and governance. * Support development teams in creating database solutions aligned with industry best practices. **Requirements and Qualifications** **Technical Knowledge** -------------------------- * Oracle Database administration (11g, 12c, 19c or later). * Advanced SQL and PL/SQL. * Performance tuning (SQL Tuning and Performance Tuning). * Oracle Enterprise Manager (OEM). * Oracle Data Pump (Export/Import). * RMAN (Recovery Manager). * Oracle ASM (Automatic Storage Management). * Oracle RAC. * Oracle Data Guard. * Oracle GoldenGate (desirable). * Table and index partitioning. * Tablespace, datafile, and redo log management. * Oracle Optimizer statistics. * DDL, DML, DCL, and TCL. * Relational and multidimensional data modeling. * ETL and data integration. * Experience with very large databases (VLDB). * Performance monitoring and diagnostics. * Backup, restore, and recovery. * Linux/Unix for Oracle environment administration. **Additional Information** **Differentiators** ---------------- * Oracle OCA or OCP certifications. * Experience with Oracle Exadata. * Knowledge of Oracle Cloud Infrastructure (OCI). * Experience with automation using Shell Script or Python. * Experience in mission-critical, high-availability environments. Knowledge of Agile methodologies and DevOps. * **Experience** --------------- * Minimum 3 years of experience as an Oracle Database Administrator (Oracle DBA). * Hands-on experience administering, monitoring, supporting, tuning, and optimizing Oracle databases in mission-critical corporate environments. **Join Certsys and Be Part of the Digital Transformation in the Public Sector!** Are you passionate about technology and innovation, and do you believe true digital transformation begins with cultural change? Then you’re ready to make a difference in the public sector — with us! At Certsys, our mission is to accelerate the digital modernization of government organizations. To achieve this, we need talents like you — curious, creative, and committed to innovating every day. #### **Why Certsys Is the Right Place for You?** **Real Impact**: Participate in projects that transform public administration through innovative technology. **Innovation Culture**: Innovation is our mindset. Contribute ideas and solutions that make a difference. **Cutting-Edge Technology**: Work with market-leading tools and deliver exceptional results. #### **Benefits That Make a Difference:** **Quality Healthcare**: Nationwide Bradesco Health Plan, including medical and dental coverage. **Guaranteed Meals**: Swile card for your meals. **Mobility**: Transportation allowance for your commute. **Financial Security**: Exclusive banking credit package. **Life Insurance**: 100% coverage at no additional cost. **Education Investment**: Exclusive discounts on courses and educational institutions. **Physical Health**: Access to gyms via Wellhub (Gympass) **Join Certsys!** www.certsys.com.br