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 ↗
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.