Unisys

Global IT services, cloud, cybersecurity, analytics

Oracle Database Administrator Mid-Level

Database AdministrationPosted on Nov 12

Full-timeRemote in BrazilNo salary listedRemote

About the Job

Requirements

A higher-education degree in Information Technology with a minimum course workload of 360 hours, or any higher-education degree accompanied by postgraduate specialization, master's, or doctorate in Information Technology with a minimum workload of 360 hours.
Two to four years of experience.
Knowledge of Oracle Database administration, including installation, configuration, upgrades and patching; Oracle architecture; multitenant databases; user, role, profile and privilege management; storage management; and database object creation and maintenance.
Experience with backup, recovery and continuity practices, including RMAN, Flashback, Data Pump, Oracle Data Guard, disaster recovery plans and recovery testing.
Knowledge of high availability technologies, including Oracle RAC, Grid Infrastructure/Clusterware, ASM and ACFS.
Knowledge of database performance tuning, including execution plan analysis, AWR, ASH, ADDM, Statspack, optimizer statistics, SQL Plan Baselines and Profiles, SQL Tuning Advisor, indexing, partitioning, memory, I/O, redo, wait events, locks, contention, hints and query rewriting.
Knowledge of database security practices, including auditing, TDE, Data Redaction, hardening, password and privilege management, network encryption, listeners, TNS, SSL and compliance requirements such as LGPD, SOX and PCI when applicable.
Advanced SQL and PL/SQL knowledge, including analytic functions, CTEs, hierarchical queries, procedures, functions, packages, triggers, collections, bulk operations and exception handling.
Knowledge of Linux/Unix, including Red Hat/Oracle Linux, bash shell scripting, networking, SAN/NAS storage, virtualization, kernel parameters, HugePages and resource management.
Knowledge of monitoring and operations, including Oracle Enterprise Manager, alert and trace logs, ADR/ADRCI, capacity management, incident support and My Oracle Support.
Knowledge of cloud database platforms and modernization, including OCI, AWS RDS for Oracle, Azure, cloud migrations, cross-platform migrations, upgrades with minimal downtime and Exadata.
Knowledge of ITIL change, incident and problem management, technical documentation, runbooks, on-call rotations, maintenance windows, version control and DevOps/CI-CD for databases.
Ability to resolve problems independently and prioritize work.
Ability to communicate with developers, infrastructure teams and business stakeholders.

Responsibilities

Install, configure, upgrade and patch Oracle Database environments.
Manage Oracle database architecture, multitenant environments, users, roles, profiles, privileges, storage and database objects.
Perform database backups, restores, recovery and point-in-time recovery, and maintain disaster recovery plans and conduct recovery tests.
Administer Oracle Data Guard, Oracle RAC, Grid Infrastructure/Clusterware, ASM and ACFS for continuity and high availability.
Analyze and tune database performance, including execution plans, statistics, indexes, partitions, memory, I/O, redo and query code.
Review and optimize developers' SQL and PL/SQL code.
Manage database auditing, encryption, hardening, password policies and least-privilege access.
Create and manage database jobs and schedules using DBMS_SCHEDULER.
Monitor database alerts and logs, manage capacity and growth planning, and support incidents using My Oracle Support.
Perform cloud and cross-platform migrations and database upgrades with minimal downtime.
Manage changes, incidents and problems; maintain technical documentation and runbooks; and participate in on-call and maintenance windows.
Use version control and DevOps/CI-CD practices for database work.

Desired Qualifications

Knowledge of Oracle GoldenGate replication.
Knowledge of Database Vault.
Experience using Python or Ansible for automation.
Familiarity with Zabbix, Nagios, Grafana or Datadog.
Experience with OCI Autonomous Database, DBCS, Exadata Cloud Service or AWS RDS for Oracle, and Azure.
Experience with Exadata Smart Scan, HCC and Flash Cache.
Basic knowledge of PostgreSQL or MySQL and heterogeneous database migration.

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. Sistema Operacional e Infraestrutura

Linux/Unix (Red Hat/Oracle Linux), shell script (bash)

Conceitos de rede, storage (SAN/NAS), virtualização

Parâmetros de kernel, HugePages, gerenciamento de recursos

Python/Ansible para automação (diferencial)

8. Monitoramento e Operação

Oracle Enterprise Manager (OEM/Cloud Control)

Monitoramento de alertas, logs (alert log, trace), ADR/ADRCI

Ferramentas: Zabbix, Nagios, Grafana, Datadog (diferencial)

Gestão de capacidade e planejamento de crescimento

Suporte a incidentes, uso do My Oracle Support (SRs)

9. Cloud e Modernização (diferencial)

OCI (Autonomous DB, DBCS, Exadata Cloud Service), AWS RDS for Oracle, Azure

Migrações: on-premises → cloud, cross-platform, upgrades com mínimo downtime

Exadata (Smart Scan, HCC, Flash Cache)

Noções de PostgreSQL/MySQL e migração heterogênea

10. Processos e ITIL

Gestão de mudanças, incidentes e problemas (ITIL)

Documentação técnica e runbooks

Plantões e atuação em janelas de manutenção

Versionamento (Git) e DevOps/CI-CD para banco

11. Habilidades Comportamentais

Autonomia na resolução de problemas e priorização

Comunicação clara com desenvolvedores, infraestrutura e negócio

You will be successful in this role if you have:

Graduação em curso de nível superior na área de Tecnologia da Informação de, no mínimo, 360 horas.

Graduação em qualquer curso de nível superior acompanhado e Pós-graduação (especialização, mestrado ou doutorado) na área de Tecnologia da Informação de, no mínimo, 360 horas.

Experiencia: 2 a 4 anos.

Unisys is proud to be an equal opportunity employer that considers all qualified applicants without regard to age, caste, citizenship, color, disability, family medical history, family status, ethnicity, gender, gender expression, gender identity, genetic information, marital status, national origin, parental status, pregnancy, race, religion, sex, sexual orientation, transgender status, veteran status or any other category protected by law.

This commitment includes our efforts to provide for all those who seek to express interest in employment the opportunity to participate without barriers. If you are a US job seeker unable to review the job opportunities herein, or cannot otherwise complete your expression of interest, without additional assistance and would like to discuss a request for reasonable accommodation, please contact our Global Recruiting organization at [email protected] or alternatively Toll Free: 888-560-1782 (Prompt 4). US job seekers can find more information about Unisys’ EEO commitment here.

About the Company

Unisys

Global IT services, cloud, cybersecurity, analytics

Unisys provides IT services and solutions to businesses and governments, focusing on digital transformation, cloud services, cybersecurity, and data analytics. Solutions are delivered through tailored consulting, managed services, and the sale of proprietary software and hardware to modernize operations, secure IT, and extract insights from data. The company differentiates itself by serving heavily regulated industries with strong security frameworks and by emphasizing ethical technology deployment, supported by thought leadership on topics like blockchain and low-code development. Its goal is to help organizations navigate digital transformation safely, efficiently, and responsibly while driving innovation.

Company size: 1-10
Company stage: IPO
Headquarters: Bethel Township, Pennsylvania
Founded: 1984

Recently Posted Jobs

Explore more opportunities at Unisys

See more jobs