Oracle DBA

TriosysIT Inc.

Dallas, TX, United States

4 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Azure Cloud Computing Databases System Configuration Extract Transform Load (ETL) Database Design Oracle Data Guard Linux Disaster Recovery Middleware File Transfer Python (Programming Language)

+16 more

Oracle Databases Oracle (Applications) Oracle Forms Oracle Rac Performance Tuning Shell Script PL-SQL Apex Code Scripting Oracle Access Manager Sql Optimization Bi Publisher Oracle Enterprise Manager System Availability Amazon Relational Database Service Oracle Cloud Infrastructure

Requirements

Database Administration: Installing, configuring, patching, and upgrading Oracle Databases.

Backup and Recovery: Expertise in Oracle Recovery Manager (RMAN) for data protection, Data Pump (EXPDP/IMPDPD)

SQL & PL/SQL: High proficiency in querying and scripting to manage data.

Performance Tuning: Monitoring, diagnosing, and optimizing SQL queries and database instances.

Operating Systems: Proficiency in Linux/Unix environments.

Security & Compliance: Managing user access, roles, privileges, auditing, and encryption.

Proficient in shell scripting to create/update Cron jobs.

Oracle Forms and Reports administration:

Installation & Configuration: Setting up Oracle Forms/Reports, running the Repository Creation Utility (RCU), and configuring domains using the Configuration Wizard.

Monitoring & Performance: Using Oracle Enterprise Manager Fusion Middleware Control to monitor Reports Server, manage job queues, and optimize performance.

Security Management: Securing applications with Oracle Internet Directory (OID) and Oracle Access Manager (OAM).

Environment Setup: Managing, configuring and setting up file transfers.

Deployment: Deploying and managing forms, reports, and ensuring proper connectivity to the Oracle Database.

Experience/Knowledge in Apex/BI Publisher Migration, Installing, configuring, and maintaining.

Advanced & Cloud Skills

Cloud Infrastructure: Experience with Oracle Cloud Infrastructure (OCI), AWS RDS, or Azure.

Data Guard/RAC: Managing Oracle Real Application Clusters (RAC) and Data Guard for high availability and disaster recovery.

Automation: Scripting (Shell, Python) to automate routine maintenance tasks.

Data Modeling & Warehousing: Understanding database design, ETL processes, and warehousing.

Knowledge on Batch scheduling tools (EX: CA Workload Automation).

Soft Skills

Problem-Solving: Troubleshooting critical production issues under pressure.