David Lima - Support Specialist

Overview

Oracle DBA automation engineer (mid-level) specializing in operational automation for Oracle memory tuning and migration from AMM to ASMM. The strongest proven skill is building production-focused Bash automation for Oracle operations, demonstrated by scripts/oracle_memory_tuning_26ai.sh which perform prechecks, PFILE backup, SPFILE handling, parameter application, controlled restart and post-validation. The public artifacts lack unit or integration tests, formal vulnerability analyses, detection rules or cloud/IAM hardening work.

Phone

Timeline

Database Infrastructure Analyst · Middle

Central IT · Full-Time

May 2021 to Mar 2026 4 Years 10 Months Cabo Frio In office

Provided administration and production support for Oracle and MySQL databases in a corporate environment with availability and SLA requirements. Investigated SQL slowdowns using execution plans, indexes, statistics, sessions, and performance records. Performed and validated logical exports/imports and logical backup/restore using Oracle Data Pump and MySQL tools. Managed database users, roles, and permissions and supported directory integrations, including operations for PostgreSQL in Docker-based setups.

MySQL

PostgreSQL

Linux

Windows Server

Active Directory

Docker

Database Analyst / IT Support · Middle

EasyBus Software Ltda. · Full-Time

Mar 2018 to Sep 2020 2 Years 6 Months Cabo Frio In office

Supported production Oracle environments tied to a corporate ERP and investigated application and infrastructure incidents. Assisted with data movement between staging and production with integrity validation. Supported Windows Server and Active Directory and participated in separating Oracle and Active Directory services across different servers to reduce resource contention.

Windows Server

Active Directory

Database Administrator · Middle

News Systems Análise e Projetos · Full-Time

Jan 2010 to Jan 2018 8 Years Cabo Frio In office

Installed, configured, maintained, and updated Oracle 11g/12c environments. Managed tablespaces, datafiles, and database instance parameters and monitored alert logs and incidents. Ran logical backups using Data Pump and legacy export/import utilities. Supported developers with SQL diagnostics and general database performance troubleshooting while administering operational Linux environments.

Linux

Estácio

Bachelor's Degree · Systems Analysis and Development (Technologist)

2017 Brasília, Brazil

Infrastructure Support Analyst · Middle

Transportes Oriental S/A · Full-Time

Feb 2007 to Dec 2009 2 Years 10 Months Cabo Frio In office

Provided support for a corporate ERP, including Windows servers and TCP/IP networking. Participated in recovery activities to restore service after hardware failures. Supported operational continuity for production environments according to established procedures.

Windows Server

TCP/IP

IT Support Technician · Middle

Praxio / BGM Rodotec · Full-Time

Aug 1999 to Jan 2007 7 Years 5 Months Cabo Frio In office

Implemented and supported corporate systems with Oracle client connectivity configuration (tnsnames.ora and sqlnet.ora). Supported operational Oracle 8i/9i environments under guidance. Worked on connectivity and day-to-day operational assistance for database-related setups.

Projects

oracle-dba-scripts

A GitHub repository listed in the CV that focuses on Oracle DBA scripts. The resume does not provide repository functionality details or a specific project goal beyond the repository name. The candidate uses it as a public example of automation-related database support work.

Technical skills

SQL

Databases

Oracle

PostgreSQL

MySQL

DevOps

Linux

Windows Server

Docker

TCP/IP

GitHub

Windows

Apache HTTP Server

Ubuntu

DevOps

Observability

CI/CD

SRE

Debian

CentOS Stream

Middle DevOps Engineer Confidence: Medium Generalist

Oracle DBA automation engineer with middle-level practical skills in operational scripting and memory tuning for Oracle instances, specializing in end-to-end AMM to ASMM migration automation. The strongest proven skill is automation of Oracle memory tuning embodied in the oracle_memory_tuning_26ai.sh script that performs pre-checks, PFILE backup, SPFILE creation, parameter changes, restart, post-validation and structured report generation. There is little or no public evidence of CI/CD pipelines, container orchestration, Infrastructure as Code, automated rollback gates or integrated alerting and dashboards.

CI/CD Pipelines

1/10

Automated build and deploy

Minimal CI/CD signals only; no real pipeline engineering, only Git commands and a suggested git workflow in an example script.

Evidence

Automacao_Tuning_Performance/scripts/EXEMPLO_USO_COMPLETO.sh: lines suggesting git add and git commit -m 'Lab: Oracle Memory Tuning Automation'

Infrastructure as Code

Managing servers with code

Not evidenced in public code

Containerization & Orchestration

Working with containers

Not evidenced in public code

Observability & Monitoring

2/10

Watching system health

Basic observability-by-reports: structured pre/post checks and generated reports are present but no dashboards, alerting, SLOs or routed alerts.

Evidence

Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: report generation block piping output to ${REPORT_FILE} and instructions to monitor v$sysmetric for 24h

Automacao_Tuning_Performance/scripts/EXEMPLO_USO_COMPLETO.sh: extraction of before/after RAM and Swap metrics for downstream reporting and posts

Reliability & Incident Response

3/10

Keeping systems up

Operational reliability practices are visible - safe backup before change, validation after restart, and structured reporting - but no formal runbooks, rollback automation, or incident playbooks.

Evidence

Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: PASSO 2 BACKUP DO PFILE (CREATE PFILE from SPFILE) and saving /tmp/init_pre_memory_change_26ai.ora

Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: PASSO 5 SHUTDOWN/STARTUP and PASSO 6 VALIDAÇÃO with post-restart checks

Cloud & Cost Optimization

Smart use of the cloud

Not evidenced in public code

Expertise

Site Reliability Engineering· Middle

Observability & Monitoring· Middle

Industries

Information Technology· Middle

Technologies

DevOps

CI/CD

Observability

SRE

Bash· mentioned only

Recommendations

Use this developer to build operational DBA automation tools and reliable maintenance runbooks for Oracle environments, focusing on safe change procedures and validation.
Integrate these scripts into a repeatable delivery pipeline with tests and artifactization so tuning runs can be audited and replayed (add CLI input validation, dry-run and non-destructive modes).
Add observability integrations such as structured logs, export of key metrics to Prometheus/Grafana or a monitoring platform, and create alerting rules and runbooks tied to those alerts.
Extend the automation to include rollback or canary strategies and automated safety checks before restart to reduce blast radius when applying parameter changes.

Repositories

The developer's experience in this domain has been verified based on AI analysis of the following repositories:

DBA Automacao_Tuning_Performance View_dictionary

Middle Security Engineer Confidence: Medium Generalist

Oracle DBA automation engineer (mid-level) specializing in operational automation for Oracle memory tuning and migration from AMM to ASMM. The strongest proven skill is building production-focused Bash automation for Oracle operations, demonstrated by scripts/oracle_memory_tuning_26ai.sh which perform prechecks, PFILE backup, SPFILE handling, parameter application, controlled restart and post-validation. The public artifacts lack unit or integration tests, formal vulnerability analyses, detection rules or cloud/IAM hardening work.

Vulnerability Analysis

1/10

Finding security weaknesses

Minimal vulnerability-mitigation awareness shown via operational backups and pre-change checks, but no root-cause vulnerability analysis or PoC artifacts.

Evidence

davlima/Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: CREATE PFILE backup before parameter changes and explicit prechecks

Cryptography & Secure Protocols

1/10

Using encryption correctly

Small evidence of secure-password handling intent but no rigorous cryptography or protocol work.

Evidence

davlima/Automacao_Tuning_Performance/.skills/senhas_seguras_gestao.md: imports (secrets, string) and generate_oracle_secure_password stub

Offensive Security / Pentesting

Testing by attacking

Not evidenced in public code

Defensive Hardening

3/10

Making systems harder to break

Practical defensive hardening and operational safety in DB changes: backups, pre/post validation, constrained parameter changes and controlled restarts; good operational automation but not full security hardening or least-privilege IAM controls.

Evidence

davlima/Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: pre-checks, PFILE backup, SPFILE creation, parameter apply and post-validation davlima/Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai_IMPROVED.sh: structured reporting and safer orchestration davlima/DBA/DBACDN-TABLESPACES1.sql: tablespace management guidance and operational safeguards

Detection & Incident Response

2/10

Spotting and handling attacks

Basic incident-awareness via structured logging and before/after reports that help triage, but no DFIR tooling, detection rules or forensic artifacts.

Evidence

davlima/Automacao_Tuning_Performance/scripts/oracle_memory_tuning_26ai.sh: generates structured tuning_report_* with baseline and post-validation output davlima/Automacao_Tuning_Performance/scripts/EXEMPLO_USO_COMPLETO.sh: collects and compares reports across VMs

Compliance & Threat Modeling

1/10

Planning against threats

High-level operational documentation and README context exist, but there are no formal threat models, compliance mappings, or STRIDE-style analyses.

Evidence

davlima/DBA/README.md: operations objectives and technologies listed davlima/Automacao_Tuning_Performance/README.md: problem framing and environment constraints for AMM→ASMM automation

Industries

Information Technology· Middle

Recommendations

Develop more robust testing and dry-run modes for the automation scripts (unit tests or synthetic environments) so changes can be validated without touching production.
Add defensive security controls - avoid SSH implicit assumptions, introduce least-privilege connectors (use an orchestration user or jump host) and remove reliance on root definer privileges in DB artifacts.
Integrate monitoring and alerting outputs (Prometheus/Cloud monitoring, syslog/SIEM) and produce simple detection signatures or runbooks for rollback/incident response.
Create idempotent IaC or orchestration wrappers (Ansible/Terraform/HashiCorp Vault for secrets) to manage credentials and enforce consistent deployment across environments.

Repositories

The developer's experience in this domain has been verified based on AI analysis of the following repositories:

DBA Automacao_Tuning_Performance View_dictionary

Intern Backend Developer Confidence: Low

A backend-focused DBA and automation author at a junior level whose primary strength is practical database administration and shell scripting. The strongest proven skill is database administration and automation, evidenced by README content describing Oracle and MySQL support scripts and Bash automation. There is no public evidence of REST API design, schema migration histories, transaction/isolation decisions, robust testing, or production resilience patterns.

API Design

How well APIs are designed

Not evidenced in public code

Data Layer & Database

Working with databases

Not evidenced in public code

Scalability & Performance

Handling load and speed

Not evidenced in public code

System Architecture

Overall system structure

Not evidenced in public code

Security & Auth

Protecting data and access

Not evidenced in public code

Reliability & Observability

Stability and monitoring

Not evidenced in public code

Industries

Information Technology· Middle

Recommendations

Develop small RESTful wrappers around common DBA operations to demonstrate API design, versioning, and idempotency handling.
Add a clear migration history and example schema evolution scripts showing safe ALTER paths and rollback plans.
Introduce automated tests and CI for key scripts, plus a simple observability layer (structured logs, basic metrics) for operations tooling.
Containerize and document an operational runbook including graceful shutdown, timeouts, and retry/backoff for remote actions.

Repositories

The developer's experience in this domain has been verified based on AI analysis of the following repositories:

DBA sql View_dictionary

Job preferences

Work permits: Peru