Oracle Performance Dba

1 week ago


Abu Dhabi, 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

  • Senior Oracle DBA

    1 week ago


    Abu Dhabi, Abu Dhabi, United Arab Emirates SecureTech LLC Full time

    **Company Overview: **SecureTech is a leading technology solutions provider based in the United Arab Emirates (UAE), specializing in cybersecurity and IT infrastructure. We are dedicated to delivering cutting-edge solutions to our clients, ensuring the highest standards of security and efficiency in their operations.**Job Location: Abu Dhabi,...


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

    Job descriptionExperience/Skills DesiredMinimum 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

    1 week ago


    Abu Dhabi, 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 best...

  • Oracle Developer

    1 week ago


    Abu Dhabi, Abu Dhabi, United Arab Emirates Enterprise Systems Analysis Technology (ESAT) Full time

    Experience/Skills DesiredMinimum 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, scheduling...

  • Oracle Apps Dba

    1 week ago


    Abu Dhabi, 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 SOA Lead

    1 week ago


    Abu Dhabi, Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    Oracle SOA Lead:Salary:: Industry StandardsExperience:: 15 YearsJoining Date::ASAPJob Location:: Abu DhabiIndustry Type:: IT ServiceFunction:: Software DevelopmentReporting To:: ManagerJob Type:: Full TimeResponsible for the technical development, maintenance and support of Oracle SOA technology stack. Strong experience in working with Oracle SOA Suite (12C...


  • Abu Dhabi, 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...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Mubadala Energy Full time

    About the job Oracle Technical Consultant1.ROLE 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...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    Oracle Fusion Administrator:Salary:: AED15000/monthExperience:: 5 to 7 YearsJoining Date::ASAPJob Location:: Abu DhabiIndustry Type::IT ServicesFunction::ITReporting To:: ManagerJob Type:: Part TimeUrgently looking for Oracle Fusion Administrator for Abu Dhabi location on Contract basis:Responsibilities: Collaborate with internal teams to review, design, and...


  • Abu Dhabi, 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 recovery scenarios.A...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Tech Junction Ltd Full time

    I have a new role with a good client of mine who are looking for an Oracle SQL Developer to work a 12 month rolling contract, location will beAbu Dhabi.Developing and maintaining Oracle database applications using advanced PL/SQL programming language.Designing and developing database schemas, stored procedures, functions, and triggers using PL/SQL.Optimizing...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Mubadala Energy Full time

    About the job Oracle Technical Consultant1. ROLE 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...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates ParamInfo Full time

    13180-Oracle Fusion HCM Techno-Functional Consultant:Experience:8-15Posted:16 Feb,2023Location:United Arab Emirates**Role & Responsibilities:Oracle Fusion / Cloud Techno-Functional Consultant 8+ years. 8+ years of experience in supporting and managing Oracle Cloud HR modules. At least 3 plus years of experience in SQL, PL/SQL, BI Publisher, OTBI, HCM...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Oracle Full time

    Client Operations Manager - Data Centres TApplicants are required to read, write, and speak the following languages: English, ArabicPreferred QualificationsClient Operations Manager - Dedicated Cloud at RegionOCI have an opportunity for a Client Operations Manager who will be responsible for a wide variety of engagement supporting our Dedicated Region Cloud...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Bricks Technologies Systems Full time

    Oracle BI LEAD Publisher:Salary:: Industry StandardsExperience:: 8 to 15 YearsJoining Date::ASAPJob Location:: Abu DhabiIndustry Type:: IT ServiceFunction:: Software DevelopmentReporting To:: ManagerJob Type:: Full TimeShould have at least 12 years of IT experience. Should have worked in at least 2 projects as a BI architect with focus on Oracle cloud...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Michael Page Full time

    As the Senior Oracle Procurement Process Lead, you will be responsible for overseeing and optimising the procurement processes using Oracle Procurement Cloud. You will leverage your deep understanding of procurement best practices and expertise in Oracle modules to drive efficiency, reduce costs and implement strategic sourcing initiatives.Client DetailsA...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates Maharat 71 Full time

    Key Responsibilities Installation, configuration and upgrading of MYSQL/SQL server software and related products. Evaluate MYSQL /SQL features and MYSQL /SQL MCY products. Establish and maintain backup and recovery policies and procedures. Conduct database design and implementation. Implement and maintain database security (create and maintain users and...

  • DBA Oracle My Sql

    1 week ago


    Abu Dhabi, Abu Dhabi, United Arab Emirates Bricks Full time

    Are you an Assistant Finance Director with 5+ years of accounting experience within the Hospitality Industry? If so, read on We are a rapidly growing hospitality provider looking for an Assistant Finance Director to join our finance team. If you have a managerial mindset and experience in both hospitality and accounting, then this might be a good...

  • DBA Oracle My Sql

    1 week ago


    Abu Dhabi, Abu Dhabi, United Arab Emirates Bricks Full time

    Are youan Assistant Finance Director with 5+ years of accountingexperience within the Hospitality Industry? If so, read onWeare a rapidly growing hospitality provider looking for an AssistantFinance Director to join our finance team. If you have a managerialmindset and experience in both hospitality and accounting, thenthis might be a good opportunity...


  • Abu Dhabi, Abu Dhabi, United Arab Emirates ERAM CONTRACTING CO. Full time

    MongoDB Database Administrator needs 5+ years experienceMongoDB Database Administrator requires:HybridLocations: Charlotte, NC, Iselin, NJMust be flexible, weekends if necessaryRequired skills: MongoDB Database Administration, experience with HA/DR - Replica SetAutomation experience is required (Python/YAML/Unix Shell Scripting)AWS experience is plus not...