- 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.
-
Oracle performance
Found in: DrJobEN AE A2 - 5 days ago
ATRIBS METSCON GROUP Abu Dhabi, United Arab EmiratesEstablish 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 ...
-
Oracle performance
Found in: Talent AE A C2 - 6 days ago
ATRIBS METSCON GROUP Abu Dhabi, United Arab EmiratesEstablish and maintain AWR(Automatic Workload Repository) and Statspack performance baselinesfor critical databases. · AnalyzeADDM (Automatic Database Diagnostic Monitor) ASH (Active SessionHistory) and Statspack reports as well as log and trace files toidentify performance issu ...
-
Oracle performance
Found in: Talent AE A C2 - 6 days ago
Atribs Metscon Group Abu Dhabi, United Arab EmiratesAnalyze ADDM (Automatic Database DiagnosticMonitor), ASH (Active Session History), and Statspack reports, aswell as log and trace files, to identify performance issues andtrends. · • Utilize SQL PerformanceAnalyzer and Database Replay for impact assessment of databasechanges. · • ...
-
Senior Accountant, Investment Firm, Abu Dhabi, UAE
Found in: One Red Cent EUR eFC C2 - 1 day ago
PER, Private Equity Recruitment Abu Dhabi, United Arab Emirates Full timeAbout our client · We are working on an exciting opportunity with an Abu Dhabi based multi-asset investment firm that deploys capital across public and private markets. The team invests across all sectors, focusing on Europe and the US. What the job involves · The senior accoun ...
-
DBA- Oracle and MySQL
Found in: DrJobEN AE A2 - 4 days ago
ATRIBS METSCON GROUP Abu Dhabi, United Arab EmiratesResponsibilities: · Installation 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 ...
-
DBA- Oracle and MySQL
Found in: Talent AE A C2 - 5 days ago
ATRIBS METSCON GROUP Abu Dhabi, United Arab EmiratesResponsibilities: · Installation configuration andupgrade of MYSQL/Oracle database software including EBS components. · Patch management databaseversion upgrades and optimization for efficient EBS operations. · Performance tuning andoptimization. · ComprehensiveBackup and recove ...
-
ERP Functional Manager
Found in: DrJobEN AE A2 - 5 days ago
Bricks Abu Dhabi, United Arab EmiratesJob DescriptionHaving hands on knowledge of Oracle Apps R12 and Fusion Modules or Oracle eBusiness Suite which includes Oracle Financials/Manufacturing/Supply Chain/HRMS modules.Excellent communication and articulation skills with .Can explain technical solutions with business fl ...
-
Oracle Developer
Found in: DrJobEN AE A2 - 1 day ago
International Development Company for Manpower Supply Abu Dhabi, United Arab EmiratesJob DescriptionRoles & ResponsibilitiesDesign, develop, and maintain Oracle database applications and systems.Write efficient SQL queries and optimize database performance.Collaborate with business analysts and project managers to understand requirements and develop technical sol ...
-
HRIS Administrator
Found in: DrJobEN AE A2 - 5 days ago
Miral Experiences Abu Dhabi, United Arab EmiratesCollaborate with HR team using Oracle Fusion HCM for HR administration tasks and data management. · Ensure accuracy and compliance while collecting, verifying, and updating data in HR systems. · Utilize Oracle Fusion HCM to manage employee data including onboarding, offboarding, ...
-
DBA Oracle My Sql
Found in: DrJobEN AE A2 - 5 days ago
Bricks Abu Dhabi, United Arab EmiratesJob 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 man ...
-
Oracle SQL Developer
Found in: Talent AE 2A C2 - 4 days ago
Tangent International Abu Dhabi, United Arab EmiratesI 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 d ...
-
Project Manager
Found in: DrJobEN AE A2 - 3 days ago
Bilfinger Middle East Abu Dhabi, United Arab EmiratesJob Description · Convert business requirements to concept/ technical specification · Develop PL/SQL based on technical specification · Work along with source system experts in finalizing ETL and report design · Work with other data modeler in preparing the data/ dimensional mode ...
-
DBA- Oracle and MySQL
Found in: DrJobEN AE A2 - 4 days ago
Atribs Metscon Group Abu Dhabi, United Arab Emirates· • Installation, 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 recover ...
-
Apex Programmer
Found in: DrJobEN AE A2 - 1 day ago
EngProsoft Abu Dhabi, United Arab EmiratesDevelop and maintain Oracle APEX applications. Design and Implement scalable and robust enterprise-level solutions. Collaborate with software developers and business analysts to understand business requirements and translate them into technical solutions. Optimize application per ...
-
Oracle DMS Technical Consultant
Found in: Talent AE C2 - 1 day ago
Decision Management Consultants Abu Dhabi, United Arab Emirates Full timeDecision Management Consultants is recruiting 'Oracle DMS Technical Consultant' for one of our client based in Abu Dhabi, UAE. · The Role · You will be responsible for : · Design and develop applications using Oracle ADF (Strong working knowledge on ADF UI, task flows, ADF integ ...
-
PLSQL Developer
Found in: DrJobEN AE A2 - 4 days ago
Iconic IT Consulting Services Abu Dhabi, United Arab EmiratesJob DescriptionRoles & Responsibilities · • Experience in Oracle SQL and PL/SQL · • Advanced PLSQL Programming, Collections and Bulk processing, Analytical functions · • SQL query tuning and PL/SQL Performance Optimization · • Good data analysis skills. · • Senior PL/SQL Develope ...
-
Assistant Accountant
Found in: DrJobEN AE A2 - 21 hours ago
Sundus Recruitment and Outsourcing Services Abu Dhabi, United Arab EmiratesOur client a top financial institution is currently seeking Senior Analyst Programmers to support their Fintech team. · Roles and Responsibilities: · Responsible for development, testing and implementation of in-house applications and Fintech projects · Perform coding, unit test ...
-
Application Support Manager
Found in: DrJobEN AE A2 - 4 days ago
Miral Experiences Abu Dhabi, United Arab EmiratesSupporting the user community which also includes scheduled training on applications to the user community · Responsible for configuring / customizing Maximo application as required · Responsible for configuring Kronos application as per HR Policies · Responsible for application ...
-
Assistant Accountant
Found in: Talent AE A C2 - 1 day ago
Sundus Recruitment and Outsourcing Services Abu Dhabi, United Arab EmiratesOur client a top financialinstitution is currently seeking Senior Analyst Programmers tosupport their Fintech team. · RolesandResponsibilities: · Responsible for development, testing and implementation of in-houseapplications and Fintech projects · Perform coding, unit testing an ...
-
Application Support Manager
Found in: Talent AE A C2 - 6 days ago
Miral Experiences Abu Dhabi, United Arab EmiratesSupporting the user communitywhich also includes scheduled training on applications to the usercommunity · Responsible for configuring /customizing Maximo application asrequired · Responsible for configuring Kronosapplication as per HR Policies · Responsible forapplication testin ...
Oracle performance - Abu Dhabi, United Arab Emirates - Atribs Metscon Group
Description
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.