Oracle performance

4 weeks 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 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 cacherelated performance problems.
Diagnose and optimize performance issues related to PGA.
Address temporary tablespacerelated performance challenges.
Configure Automatic Shared Memory Management.
Configure and diagnose I/O issues to optimize data access performance.
Configure InMemory Column Store for enhanced SQL performance.
Integrate InMemory 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 minimal downtime. Respond to and resolve databaserelated incidents ensuring timely resolution of performancerelated issues. Collaborate with other IT teams to troubleshoot and resolve crossfunctional 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 relevan
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 minimal 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 #J-18808-Ljbffr
  • 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...

  • 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 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...


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

  • 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...


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


  • 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...


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

  • 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...


  • abu dhabi, United Arab Emirates BlackStone eIT Full time

    BlackStone eIT is a leading computer software company that specializes in innovative solutions for businesses. We are currently seeking a highly skilled and experienced Senior Oracle Developer to join our team. As a Senior Oracle Developer at BlackStone eIT, you will have the opportunity to work on cutting-edge projects and collaborate with a talented team...


  • Abu Dhabi, United Arab Emirates Injazat Full time

    Overview: As an Oracle Cloud Architect, you will play a pivotal role in driving the successful migration, integration, and management of our critical systems onto the Oracle Cloud platform. Your deep expertise in Oracle Cloud technologies, coupled with your architectural vision, will be essential in shaping our cloud strategy and ensuring the scalability,...


  • Abu Dhabi, United Arab Emirates AceNet Full time

    **Experience**: 8 to 10 years**: **Location**: Abu Dhabi**: **Job code**: 100703**: **Posted on: Jul 11, 2023**:**:**Should have 8 years of proven experience as an Oracle Functional Consultant and 4 Years of experience in HR Module.** **Expertise in Oracle HR modules such as Core HR, Benefits Administration, Payroll, Performance Management, Talent...

  • Product Manager

    7 days ago


    Abu Dhabi, United Arab Emirates Group 42 Full time

    Overview: G42 Cloud is building the MENA region’s largest and most powerful cloud infrastructure designed to make organizations more intuitive, agile and efficient and to solve real-world challenges. G42 Cloud’s world-class infrastructure is built to serve governments, special industries and enterprises of all sizes and leverages the power of artificial...


  • Abu Dhabi, United Arab Emirates ParamInfo Full time

    **Experience**:8-15**Posted**:16 Feb,2023**Location**: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 Extracts, Fast Formulas, Workflow...

  • Oracle SQL Developer

    3 weeks ago


    abu dhabi, United Arab Emirates Tangent International 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, United Arab Emirates ParamInfo Full time

    **Experience**:8-12**Posted**:20 Mar,2024**Location**:United Arab Emirates- Job Title: Oracle Financial Fusion Consultant- Location - Abu Dhabi**Role & Responsibilities** - 8+ years of experience in supporting and managing Oracle Cloud ERP Financial modules implementation projects through the project life cycle. - At least 3 plus years of experience in SQL,...


  • Abu Dhabi, United Arab Emirates Brit Tech Services Full time

    Brit is looking for looking for dynamic individuals with 6-8 years of experience on Oracle Fusion Cloud EPM (Consolidation) Functional with at least 2-3 end-to-end implementations on Oracle Fusion Cloud EPM Consolidation Module. The consultant will work closely with Business Users to understand their consolidation requirements and translate them into...