4

DBA Oracle Pleno

411 Unisys de Colombia · Remote Brazil · posted 12 Nov 2026
Full-timeOtherRemote

About the job

What success looks like in this role: Administração Oracle Database • Instalação, configuração e upgrade/patching (11g/12c/19c/21c/23ai) • Arquitetura: instância, SGA/PGA, processos de background, redo/undo, tablespaces, datafiles, control files • Multitenant (CDB/PDB) • Gerenciamento de usuários, roles, profiles e privilégios • Gerenciamento de storage: ASM, Oracle Managed Files • Criação e manutenção de objetos: tabelas, índices, particionamento, views materializadas, sequences, synonyms, DB links 2. Backup, Recovery e Continuidade • RMAN: backup full/incremental, políticas de retenção, catálogo, duplicate, restore/recover, PITR • Flashback (Query, Table, Database), Recycle Bin • Data Pump (expdp/impdp), Export/Import, SQL*Loader, External Tables • Oracle Data Guard (physical/logical standby, switchover/failover, Broker, Active Data Guard) • Planos de DR e testes de recuperação 3. Alta Disponibilidade • Oracle RAC (instalação, administração, serviços, troubleshooting) • Grid Infrastructure/Clusterware (srvctl, crsctl) • ASM e ACFS • Conhecimento de GoldenGate (replicação, desejável) 4. Performance Tuning • Análise de planos de execução (EXPLAIN PLAN, DBMS_XPLAN, SQL Monitor) • AWR, ASH, ADDM, Statspack • Estatísticas do otimizador, histogramas, SQL Plan Baselines/Profiles, SQL Tuning Advisor • Estratégias de indexação e particionamento • Tuning de memória (SGA/PGA), I/O, redo, wait events, locks e contenção • Hints e reescrita de queries 5. Segurança • Auditoria (Unified Auditing) • TDE (criptografia), Data Redaction, Database Vault (desejável) • Hardening, gestão de senhas e privilégios mínimos • Network encryption, listeners, TNS, SSL • Conformidade (LGPD, SOX, PCI quando aplicável) 6. SQL e PL/SQL • SQL avançado (analytic functions, CTEs, hierarchical queries) • PL/SQL: procedures, functions, packages, triggers, collections, bulk operations, tratamento de exceções • Revisão e otimização de código de desenvolvedores • Jobs e scheduling (DBMS_SCHEDULER) 7.…

Read the full description on 411 Unisys de Colombia's site ↗

Skills

Upload your CV on LitCareer to see which of these you match.

Similar jobs

V
Medical Writing Science Senior Manager (Hybrid)
Vertex Farmaceutica Do Brasil Ltda · Boston, MA · 15 Nov 2026
V
Senior Director, US Market Access Strategy, Povetacicept (POVE)
Vertex Farmaceutica Do Brasil Ltda · Boston, MA · 15 Nov 2026
V
Senior Medical Science Liaison - Pain (Georgia)
Vertex Farmaceutica Do Brasil Ltda · 2 Locations · 15 Nov 2026
V
Associate Director Medical Writing (Hybrid)
Vertex Farmaceutica Do Brasil Ltda · Boston, MA · 15 Nov 2026
V
Senior Director - US Medical Affairs - Nephrology
Vertex Farmaceutica Do Brasil Ltda · Boston, MA · 15 Nov 2026
V
Executive Director, Regulatory Strategy, Cell & Gene Therapy
Vertex Farmaceutica Do Brasil Ltda · 2 Locations · 15 Nov 2026

Collected from 411 Unisys de Colombia's official careers site by LitCareer. Always apply on the employer's own site; LitCareer never charges you to apply.