Oracle Database Specialist, Oracle DBA
Posted 1hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Oracle Database Specialist optimizing corporate database environments for critical systems. Ensuring availability, security, and performance in Oracle Database administration.
Responsibilities:
- Administer, monitor, and maintain Oracle Database environments with high availability.
- Analyze and optimize the performance of SQL and PL/SQL queries used by systems and applications.
- Develop and recommend improvements to queries, procedures, and routines with a focus on performance and scalability.
- Proactively monitor database performance across development, staging/QA, testing, and production environments.
- Identify performance bottlenecks and implement corrective and preventive actions.
- Recommend improvements to data modeling to increase efficiency, performance, and data integrity.
- Perform data loads, migrations, and replications between environments using Oracle administration tools.
- Assess technical impacts resulting from changes to database structures.
- Manage backup policies, disaster recovery (Recovery), and service continuity.
- Implement and oversee maintenance routines, updates (patches), monitoring, and capacity planning.
- Define best practices for Oracle database administration and governance.
- Support development teams in creating solutions that follow database best practices.
Requirements:
- Technical Knowledge
- Oracle Database administration (11g, 12c, 19c or higher).
- 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.
- Management of Tablespaces, Datafiles, and Redo Logs.
- 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.
- Differentials
- 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 critical high-availability environments.
- Familiarity with agile methodologies and DevOps.
- Experience
- Minimum of 3 years of experience as an Oracle Database Administrator (Oracle DBA).
- Experience in administration, monitoring, support, performance, and optimization of Oracle databases in corporate mission-critical environments.
Benefits:
- Quality healthcare: Bradesco Saúde Nacional plan with medical and dental coverage.
- Meal support: Swile card for meals.
- Mobility: Transportation allowance (Vale Transporte) for commuting.
- Financial peace of mind: Exclusive banking credit package.
- Life insurance: 100% coverage at no additional cost.
- Education support: Exclusive discounts on courses and educational institutions.
- Physical wellness: Access to gyms through Wellhub (Gympass).
