Oracle Performance Dba

2 weeks 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

    4 weeks ago

    Abu Dhabi, United Arab Emirates Avanza Solutions Full time

    Job Role: Oracle DBA Education: Graduate, preferably CSE/IT Certifications: Oracle Certified Professional 12c is a must. Experience: Minimum 10 years of hand on experience in Oracle Database Administration and Linux / Unix Location: Dubai Contract Duration: 12 months Extendable Roles and Responsibilities: - Creates and maintains all databases required for...

  • Oracle performance

    7 days ago

    abu dhabi, United Arab Emirates ATRIBS METSCON GROUP 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...

  • Dba

    4 weeks 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

    1 month ago

    Abu Dhabi, United Arab Emirates P S SOLUTIONS Full time

    Should be able to handle the project independently. - Ability to prepare the documentation and user manuals for assigned projects - Capable of developing customized reports using Crystal Reports and Developer/ Apex reports. - Good troubleshooting skills including debugging, tracing and providing solutions. - Should be able to recommend/suggest/implement the...

  • DBA Oracle My Sql

    1 week ago

    abu dhabi, United Arab Emirates Bricks Full time

    Job DescriptionInstallation, configuration, and upgrade of MYSQL/Oracle database software, including EBS components.Patch management, database version upgrades, and optimization for efficient EBS operations.Performance tuning and optimization.Comprehensive Backup and recovery management as per SLA, RPO for all prod databases.Expertise in Oracle E-Business...

  • Oracle Programmer

    3 days 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

    6 days 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 Apps DBA

    4 weeks ago

    Abu Dhabi, United Arab Emirates NMC Healthcare Ltd Full time

    Manage databases operations of various flavours in line with policies and ensure availability and performance of application are effectively handled.Responsible for uptime of healthcare applications and database.Provides application systems administration including maintenance e.g., configuring and monitoring tomcat application servers, java and scheduling...

  • Oracle Apex Developer

    6 days 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 Developer

    1 month 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 Apps DBA

    4 days ago

    abu dhabi, United Arab Emirates NMC Healthcare Ltd Full time

    Manage databases operations of various flavours in line with policies and ensure availability and performance of application are effectively handled.Responsible for uptime of healthcare applications and database.Provides application systems administration including maintenance e.g., configuring and monitoring tomcat application servers, java and scheduling...

  • Oracle Apps DBA

    3 weeks ago

    abu dhabi, United Arab Emirates NMC Healthcare Ltd Full time

    Manage databases operations of various flavours in line with policies and ensure availability and performance of application are effectively handled.Responsible for uptime of healthcare applications and database.Provides application systems administration including maintenance e.g., configuring and monitoring tomcat application servers, java and scheduling...

  • Oracle Apps Dba

    4 weeks 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...

  • Systems Analyst 2-it

    1 month ago

    Abu Dhabi, United Arab Emirates Oracle Full time

    Systems Analyst 2-IT-230000FL **Applicants are required to read, write, and speak the following languages***: English **Preferred Qualifications** As a Solution Architect on the Support Services Organization aligned with Client team, you will work in a team environment to provide functional and technical expertise/consulting to our clients. As you work...

  • Backend(Oracle)developer

    4 weeks 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 Ebs Techno Functional

    6 days ago

    Abu Dhabi, United Arab Emirates Americana Computer Systems LLC Full time

    Collaborate with business stakeholders to understand their requirements and translate them into technical solutions within Oracle EBS. Configure, customize, and implement Oracle EBS modules such as Financials, HRMS, SCM, etc., according to business needs. Develop and maintain custom reports, interfaces, extensions, and workflows to enhance the functionality...

  • Oracle Technical Consultant

    2 weeks ago

    abu dhabi, United Arab Emirates Mubadala Energy Full time

    About the job Oracle Technical ConsultantROLE PURPOSE:To develop and maintain Enterprise Resource Planning (ERP) and its relevant management information and reporting systems within Mubadala Energy.To perform the development of systems initiatives including requirement gathering, designing, prototyping, production building, testing, training, migrating and...

  • Software Developer Specialized in Oracle

    4 weeks 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...

  • Database Administrator

    4 weeks ago

    Abu Dhabi, United Arab Emirates Antal International Full time

    High understanding of the MYSQL /SQL database, Related utilities, and tools. - Good understanding of the underlying operating system. - High knowledge of the physical database design. - MySQL/SQL certified professional. - Ability to perform both MYSQL /SQL and operating system performance tuning and monitoring. - Knowledge of ALL MYSQL /SQL backup and...

  • Oracle ERP

    3 days ago

    Abu Dhabi, United Arab Emirates BlackStone eIT Full time

    BlackStone eIT is a leading computer software company specializing in innovative Oracle ERP solutions. We are currently seeking a skilled and experienced Oracle ERP Consultant to join our team. As an Oracle ERP Consultant at BlackStone eIT, you will have the opportunity to work on diverse Oracle ERP projects and collaborate with cross-functional teams to...