Oracle Database Specialist, Oracle DBA

Job not on LinkedIn

🔥 0 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

• 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).