Oracle Apps DBA

DATA INTENSITY LLCCovington, KY
3d

About The Position

We’re looking for a mid to senior level Oracle Apps DBA with MSSQL experience to own day-to-day database operations, performance tuning, high availability, and security across our Oracle, EBS and SQL Server environments. You’ll collaborate closely with application teams, DevOps, and InfoSec to ensure our data platforms are reliable, performant, and scalable.

Requirements

  • 4-7 years of hands-on experience as an Oracle Apps DBA in production environments.
  • Sound knowledge of Oracle EBS 12.2 Architecture, online patching tool ADOP and changes between 12.1.3 and 12.2.x
  • Experience in Oracle WebLogic Admin/managed sever memory configuration and tuning
  • Experience in Oracle WebLogic and EBS 12.2 ADOP patching techniques
  • Experience working with Oracle cloud infrastructure virtual private networks, compute services, block storage and object storage services
  • Experience in Deploying multiple applications on WebLogic server and maintained load balancing, high availability and fail over functionality
  • Experience working with Oracle/AWS/Azure cloud infrastructure Virtual machine database systems
  • Experience in Oracle cloud infrastructure Virtual machine EBS database systems for 11g/12c/19c
  • Proficiency with Windows Server, Active Directory, and networking basics (DNS, TCP/IP).
  • Familiarity with monitoring/observability tools (native + third-party).
  • Excellent documentation, communication, and stakeholder collaboration skills.

Nice To Haves

  • Experience with/exposure to Oracle Dataguard, Oracle Goldengate, Engineered Systems
  • Experience with SSIS, SSRS, SSAS (or modern equivalents).
  • Knowledge of ETL/ELT patterns, data warehousing, or BI tooling.
  • Experience with DevOps/CI-CD for databases (Git, pipelines, Redgate, SSDT).
  • Scripting in Python or Bash, and infrastructure-as-code (Terraform/ARM).
  • Certifications: Microsoft Certified: Azure Database Administrator Associate, DP-300, or MCSA/MCSE (legacy).

Responsibilities

  • Install, configure, patch and maintain Oracle EBS installations
  • Participate in database and EBS upgrades
  • Migrate databases and EBS installations from on-prem to cloud
  • Configuration of TLS/SSL protocol for EBS 12.1.3 and 12.2.x environments
  • Monitor and tune performance of databases (indexes, stats, query plans, I/O, memory, CPU).
  • Tune EBS environments to improve performance
  • Conduct root cause analyses and implement permanent fixes.
  • Design and maintain backup/restore strategies (native backups, compression, encryption).
  • Implement and support backup strategies for core database and EBS
  • Test and document disaster recovery procedures with defined RPO/RTO
  • Participate in DR exercises for EBS and database
  • Automate routine tasks with PowerShell, Bash,and scripts.
  • Maintain monitoring and alerting for capacity, performance, and availability.
  • Produce runbooks, documentation, and knowledge base articles.
  • Implement encryption at rest/in transit, data masking, and retention policies.
  • Support audits and compliance (e.g., SOX, HIPAA, PCI) where applicable.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service