Oracle DB

I

InOrg

Oracle DB

Remote,
Full Time
Paid
  • Responsibilities

    **Oracle DBA responsibilities:

    Database management and maintenance**

    • Install, configure, patch, and upgrade Oracle database software and related products.
    • Manage the database throughout its lifecycle, from development to production.
    • Design and implement database schemas and storage structures, including tables, views, and indexes.
    • Create and maintain stored procedures, functions, and triggers using PL/SQL.
    • Manage and troubleshoot complex Oracle GoldenGate replication environments.
    • Automate routine database tasks using Python scripting.
    • Configure and maintain high-availability solutions like Oracle Real Application Clusters (RAC) and Data Guard.

    Performance and monitoring

    • Monitor database health, performance, and resource utilization using tools like Oracle Enterprise Manager (OEM).
    • Perform performance tuning and optimization to resolve bottlenecks and ensure fast query responses.
    • Use diagnostic tools like AWR (Automatic Workload Repository) to analyze performance.
    • Troubleshoot and debug database issues, providing timely resolution.

    Security and access control

    • Implement and enforce security policies, procedures, and standards.
    • Manage database user accounts, roles, privileges, and security protocols.
    • Ensure compliance with internal and external regulations.
    • Conduct regular security audits and monitoring.

    Backup and recovery

    • Develop and implement backup and recovery strategies to ensure data integrity and availability.
    • Use Oracle Recovery Manager (RMAN) for backups and restores.
    • Perform regular testing of recovery plans.

    **Required qualifications and skills

    Experience**

    • Prior experience as an Oracle DBA, with relevant experience managing complex Oracle databases.
    • Proven experience with Oracle Application Express (APEX) development.
    • Hands-on experience with Oracle GoldenGate installation, configuration, and troubleshooting.
    • Experience with Python scripting for database automation and management.
    • Strong knowledge of Oracle database architecture, administration, and internals.

    Technical skills

    • Proficiency in SQL and PL/SQL.
    • Strong command of Linux/UNIX operating systems.
    • Experience with high-availability solutions such as Oracle RAC and Data Guard.
    • Knowledge of performance tuning and monitoring tools (e.g., OEM, AWR)