أخصائي رئيسي

**Experience**:

- Oracle EBS (R12.2.x ) : Application upgrades, patching, performance fine tuning, securing the environment, sizing the environment for the business growth, Disaster recovery experience, regular clones, working with various monitoring tools. 24X7 Oracle SR, exposure to multimode mission critical environment would be added advantage
- Oracle Database (19c onwards): database upgrades, RAC configurations, evaluating PSU updates and preparing Patch analysis, utilizing the advanced Features such as partitioning, compression, and data encryption etc. exposure to shell scripting in Unix environment will be added advantage.
- Oracle WebLogic Server: Monitor, identify and handle the stuck thread situations, PSU patching, fine-tuning the WLS time-out thresholds and memory structures to get optimal/ reliable performance
- Architecture: Design the data flow, propose the suitable components for the integrations with justifications.

Prepare technology road map including upgrade/decommission process with various technical components in order to sustain the vendor support contracts.
- Capacity Planning: Capture the business requirements, review the existing resource utilizations and prepare the forecast for the resources with evidences and justifications.
- Project Management : Demonstrate the skills with preparation of project plan, factors consider at various stages of the project, proposing the times lines and collaborative efforts with involved resources

KEY RESPONSIBILITIES / ACCOUNTABILITIES
- Conduct daily operations ensuring that work processes are optimally delivered adopting a continuous improvement mindset
- Provide management information and insights on all dimensions of work area performance to facilitate discussion and decision making, both on a periodic basis and for ad-hoc management requests
- Perform Oracle DB upgrades.
- Perform Oracle EBS and DB upgrades
- High skills in managing configuring and troubleshooting DB servers and DB clusters.
- Planning and Managing Backup and Recovery, Logical/Export Backups, Cold Backups, Hot Backup, RMAN Backups, Full and Incremental Backups
- Create RMAN Scheduler Jobs for Incremental hot backups of 24/7 11g Database
- Monitor disk & table space alerts, database wait events, hang analysis, locks using EM Grid control.
- Create, Manage, and administer database objects, including tables, indexes, views, sequences, functions, packages, and procedures provided by development team.
- Troubleshoot problems with Concurrent Managers.
- Creating the Users and groups in the O/S. Creating the NFS mounts in the system.
- Configuring, administering, and troubleshooting standby (logical/physical) databases environment in single DB instance and RAC/ASM environments.
- Troubleshooting different performance issues
- Hang analysis & Cluster eviction issues
- SQL Tuning with different methodologies, SQL Profiles, and SQL restructure
- Gather Statistics with different strategies based on workload and business
- Database Tuning, Memory Tuning, Backup Tuning & Data Pump Tuning
- Database Resource Manager (DBRM).
- Manage the migration from legacy database systems to new advanced database systems and ensures a smooth transition
- Manage the investigation of and seek solutions for complex problems which classify for 2nd level technical support for databases and ensure swift resolution
- Liaise with external vendors on maintenance and technical support activities, ensuring they are carried out in accordance with Smart Dubai requirements
- Define performance goals at the start of the year in discussion with the reporting manager and ensure that the goals are monitored and achieved during the course of the year
- Take ownership of his/her own learning agenda by identifying development needs and address these gaps with an individual development plan, detailing the appropriate actions to be taken, in consultation with the reporting manager
- Strive to achieve the highest levels of proficiency on all the competencies and skills required to perform the role
- Keep abreast of relevant professional/industry developments, new techniques and current topics through continued education and professional networks
- Implement and monitor approved Department policies, procedures and controls so that all relevant procedural/legislative requirements are fulfilled while delivering quality, cost-effective services
- Optimization of policies, processes and procedures emphasizing digitization and paperless strategies
- Ensure compliance with all relevant information security practices and standards to ensure data integrity and confidentiality

**المؤهلات و المهارات**

MINIMUM QUALIFICATIONS, EXPERIENCE AND SKILLS

**Qualifications**:

- Bachelor’s degree in Computer Science / Information Technology or equivalent

Professional Certifications
- Relevant certification in database management such as Microsoft Certified Database Administrator (MCDBA) or equivalent

Years of Experienc