Oracle Performance Dba

6 months ago

Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

**Oracle Performance DBA**:
**Salary**:

: Industry Standards

**Experience**:

: 7 Plus Years

**Joining Date**:

: ASAP

**Job Location**:

: Abu Dhabi

**Industry Type**:

: IT Service

**Function**:

: Software Development

**Reporting To**:

: Manager

**Job Type**:

: Full Time

Establish and maintain AWR (Automatic Workload Repository) and Statspack performance baselines for critical databases.
Analyze ADDM (Automatic Database Diagnostic Monitor), ASH (Active Session History), and Statspack reports, as well as log and trace files, to identify performance issues and trends.
Utilize SQL Performance Analyzer and Database Replay for impact assessment of database changes.
Identify and address poorly performing SQL statements through thorough analysis and optimization techniques.
Interpret execution plans and utilize SQL Trace for the diagnosis of SQL statement performance.
Monitor adaptive/dynamic execution plans and automatic reoptimization strategies for ongoing performance improvements.
Utilize Optimizer Statistics Advisor and SQL Access/Tuning advisors for comprehensive SQL statement optimization.
Implement SQL Plan Management to ensure stable and efficient SQL execution plans.
Perform index analysis and implement best practices to optimize database indexing.
Proactively manage optimizer statistics and configure parameters to ensure accurate and efficient query execution plans.
Manage Shared Pool and Result Cache for optimal memory utilization.
Diagnose and resolve buffer cache-related performance problems.
Diagnose and optimize performance issues related to PGA.
Address temporary tablespace-related performance challenges.
Configure Automatic Shared Memory Management.
Configure and diagnose I/O issues to optimize data access performance.
Configure In-Memory Column Store for enhanced SQL performance.
Integrate In-Memory Column Store with other database features.
Conduct advanced compression analysis and implement strategies for optimal database compression.
Create and maintain detailed documentation of performance tuning activities, configurations, and best practices.
Aware of Oracle database releases, patches, and updates.
Plan and execute database patching and upgrade activities, ensuring mínimal downtime.
Respond to and resolve database-related incidents, ensuring timely resolution of performance-related issues.
Collaborate with other IT teams to troubleshoot and resolve cross-functional issues impacting database performance.
Implement and maintain database security best practices.
Ensure compliance with industry and organizational security standards.

**Qualifications**

Bachelor’s degree in computer science, Information Technology or other relevant field of study,
7+ years of Oracle administration and performance optimization experience
Proven experience in establishing and optimizing AWR and Statspack performance baselines for critical databases.
In-depth expertise in analyzing ADDM, ASH, and Statspack reports, as well as log and trace files, to identify and troubleshoot performance issues.
Strong understanding of Oracle Database performance tuning principles, with a focus on SQL statement optimization.
In-depth knowledge of Oracle database architecture, internals, and features.
Strong understanding of SQL optimization techniques and database design principles.
-Powered By

  • Oracle Dba Lead

    6 months ago

    Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    **Oracle DBA Lead**: **Salary**: : Industry Standards **Experience**: : 10 plus Years **Joining Date**: : ASAP **Job Location**: : Abu Dhabi **Industry Type**: : IT Service **Function**: : Software Development **Reporting To**: : Manager **Job Type**: : Full Time Reporting to management on the Oracle DBA team activities. - Lead a team of...

  • Oracle Dba Consultant

    6 months ago

    Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    **Oracle DBA Consultant**: **Salary**: : Industry Standards **Experience**: : 4 Plus Years **Joining Date**: : ASAP **Job Location**: : Abu Dhabi **Industry Type**: : IT Service **Function**: : Software Development **Reporting To**: : Manager **Job Type**: : Full Time Extensive experience in Oracle 19c ,12c. - Install, patch and maintain all...

  • Dba (Oracle & My SQL)

    6 months ago

    Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    **DBA (Oracle & My Sql)**: **Salary**: : Industry Standards **Experience**: : 8 Years **Joining Date**: : ASAP **Job Location**: : Abu Dhabi **Industry Type**: : IT Service **Function**: : Software Development **Reporting To**: : Manager **Job Type**: : Full Time Installation, configuration, and upgrade of MYSQL/Oracle database software,...

  • Dba

    6 months ago

    Abu Dhabi, United Arab Emirates NicheHR Global Full time

    **Job Information**: Industry - IT Services Work Experience - Min 5 Years City - Abu Dhabi State/Province - Abu Dhabi Country - United Arab Emirates Zip/Postal Code - 51133 **SQL DATABASE ADMINISTRATOR (DBA)***: We are Looking for a **SQL DATABASE ADMINISTRATOR (DBA)**for one of our esteemed clients based in Dubai, United Arab Emirates. **Title**: SQL...

  • Oracle (Dba) Developer

    6 months ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    Job description Experience/Skills Desired Minimum 3 Year experience in Oracle Database Administration with excellent knowledge in SQL and PL/SQL, Installing, Configuring and Maintaining Oracle enterprise server 10g, 11g & 12c, Configuring databases for high availability, Standby database technologies, Data Guard. Should be good in Performance Tuning.,...

  • Oracle Dba(ERP Solution)

    6 months ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    We are looking for Oracle Developer to be a part of our team! Job Requirements: Minimum 3 Year experience in Oracle Database Administration with excellent knowledge in SQL and PL/SQL, Installing, Configuring and Maintaining Oracle enterprise server 10g, 11g & 12c, Configuring databases for high availability, Standby database technologies, Data Guard Should...

  • Oracle Programmer

    6 months ago

    Abu Dhabi, United Arab Emirates Minecraft consulting. Full time

    JOB TITLE: SOFTWARE DEVELOPER DEPARTMENT: DESIGN & ENGR. SPECIALIZATION: ORACLE PROGRAMMER EMPLOYMENT TYPE: FULL TIME LOCATION: HEAD OFFICE-ABU DHABI TYPE: ON SITE Job Responsibilities - Performing system analysis - Reviewing programs - Preparing workflow charts - Correcting errors in programs - Writing PL/SQL - Packages, Functions, Procedures, Triggers...

  • Oracle Programmer

    7 months ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    Location: Abu Dhabi **Responsibilities**: - Performing system analysis - Reviewing programs - Preparing workflow charts - Correcting errors in programs - Writing PL/SQL - Packages, Functions, Procedures, Triggers and Complex SQL query. - Perform SQL Query tuning - Maintaining existing packages, procedures. **Job Requirements**: - Bachelor's degree in...

  • Oracle Developer

    6 months ago

    Abu Dhabi, United Arab Emirates NXDT - Sole proprietorship L.L.C Full time

    The Oracle Developer position is a crucial role within our organization, responsible for designing, developing, and maintaining Oracle database solutions to meet the needs of our business. **Responsibilities** - Perform database optimization, tuning, and performance monitoring to ensure efficient system operation. - Collaborate with cross-functional teams...

  • Oracle Developer

    1 month ago

    Abu Dhabi, United Arab Emirates Digital Corner for Network Solutions Full time

    **Responsibilities**: Develop and maintain technical documentation, including functional specifications, technical designs, and user guides. Collaborate with business analysts and end-users to gather and analyze requirements. Perform data migration and integration tasks between Oracle databases and other systems. **Qualifications**: Bachelor's...

  • Software Developer

    6 months ago

    Abu Dhabi, United Arab Emirates Combuzz HR Solutions Full time

    **Job description** We are actively recruiting for an Oracle Programmer(Software Developer) specialized in Oracle, C#, Angular Js, ASP.Net Programmer with 4 years minimum experience and with Bachelor’s degree in Information Technology, Computer Science or in any related discipline. Job Responsibilities - Performing system analysis - Reviewing programs -...

  • Oracle Apex Developer

    7 months ago

    Abu Dhabi, United Arab Emirates Intelloger Full time

    **Job Title: Oracle APEX Developer** **Location: Abu Dhabi, UAE** **Experience: 4yrs** **Responsibilities** - Solution Design: Collaborate with business analysts and stakeholders to design Oracle APEX solutions that align with client needs and business objectives. - In-depth knowledge of technologies such as HTML, jQuery, JavaScript, AJAX, CSS etc. -...

  • Oracle SOA Lead

    6 months ago

    Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    **Oracle SOA Lead**: **Salary**: : Industry Standards **Experience**: : 15 Years **Joining Date**: : ASAP **Job Location**: : Abu Dhabi **Industry Type**: : IT Service **Function**: : Software Development **Reporting To**: : Manager **Job Type**: : Full Time Responsible for the technical development, maintenance and support of Oracle SOA...

  • Oracle Apps Dba

    6 months ago

    Abu Dhabi, United Arab Emirates NMC Healthcare Full time

    Responsible for Postgresql Database administration and management. - Supports developers for custom coding, code migration, interface design, SQL procedures and creates shell/SQL scripts, packages, and stored procedures to manipulate data. - Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. - Accountable for...

  • Oracle Developer

    1 month ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    Job Responsibilities - Performing system analysis - Reviewing programs - Preparing workflow charts - Correcting errors in programs - Created AngularJS Custom Directives to make the code more simple and understandable - Used Custom Angular Services to perform various functionalities - Used third party UI tools like JQueryUI to make the UI more effective -...

  • Male - (Oracle Programmer)

    6 months ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    Location: Abu Dhabi **Responsibilities**: - Performing system analysis - Reviewing programs - Preparing workflow charts - Correcting errors in programs - Writing PL/SQL - Packages, Functions, Procedures, Triggers and Complex SQL query. - Perform SQL Query tuning - Maintaining existing packages, procedures. **Job Requirements**: - Bachelor's degree in...

  • Oracle Functional Consultant

    6 months ago

    Abu Dhabi, United Arab Emirates ANB Solutions Full time

    We are seeking a results-driven Oracle functional consultant to lead our business's Oracle (Oracle EBS and Oracle Fusion) system integration. You will be consulting with senior management to determine our business needs, evaluate the performance of our IT infrastructure, and develop and deploy Oracle solutions. To ensure success as an Oracle consultant, you...

  • Orcale Techno Consultant

    7 months ago

    Abu Dhabi, United Arab Emirates Petals Pre School Full time

    5year+ experience - Oracle Applications Techno Functional Analyst with in-depth expertise in Oracle EBS R12 Quote to Cash modules,Order Management, Shipping, and Accounts Receivables. Must have been involved in implementing and supporting Oracle R12. **Responsibilities**: - Elicit business requirements and map business processes - Create functional...

  • Backend(Oracle)developer

    6 months ago

    Abu Dhabi, United Arab Emirates ENTERPRISE SYSTEMS ANALYSIS TECHNOLOGY (ESAT) Full time

    Experience/Skills Desired Minimum 3 Year experience in Oracle Database Administration with excellent knowledge in SQL and PL/SQL, Installing, Configuring and Maintaining Oracle enterprise server 10g, 11g & 12c, Configuring databases for high availability, Standby database technologies, Data Guard. Should be good in Performance Tuning., Configuring,...

  • Oracle Programmer

    6 months ago

    Abu Dhabi, United Arab Emirates Combuzz HR Solutions Full time

    **Job description** We are actively recruiting for an Oracle Programmer(Software Developer) specialized in Oracle, C#, Angular Js, ASP.Net Programmer with 4 years minimum experience and with Bachelor’s degree in Information Technology, Computer Science or in any related discipline. Job Responsibilities - Performing system analysis - Reviewing programs -...