Oracle Database Specialist

Job description / Role

Our client, a government agency, require an experienced Oracle Database Specialist.

Key Activities
- Monitors, optimizes and allocates physical data storage for database systems.
- Responds to and resolves web-based database access and performance issues.
- Monitors web-based database system details within the database, including stored procedures and execution time, and implements efficiency improvements. Works with users to maintain high quality data integrity and make recommendations on the course of action to be taken to rectify any data issues.
- Plans and coordinates data migrations between systems.
- Develops, implements, and maintains change control and testing processes for modifications to databases. Ensures storage, archiving, backup and recovery procedures are monitored and runs as per the schedule.
- Performs database transaction and security audits.
- Establishes appropriate end-user database access control levels.
- Develops routines for end-users to facilitate best practices database use.
- Ensures that there is full documentation and procedures covering systems testing including user acceptance testing. Regular review and update of all system documentations.
- Designs logical and physical databases, reviews description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics, such as location, amount of space, and access method).
- Establishes physical database parameters. Codes database descriptions and specify identifiers of database to database management system or direct others in coding database descriptions.
- Defines data as defined in data dictionary (information about data, including name, description, source of data item, and key words for categorizing and searching for data item descriptions).
- Determines and enters changes to data dictionary descriptions, including type, structure, and intended use of data within system.
- Tests and corrects errors, and refines changes to database.
- Enters codes to create production database.
- Selects and enter codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
- Helps programmers and analysts to make changes to database management system.
- Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database. Modifies database programs to increase processing performance.

Requirements

- Strong understanding of database structures, theories, principles, and practices.
- Working technical experience with designing, building, configuring and supporting database servers, including [web-based solution].
- Hands-on database tuning and troubleshooting experience.
- Experience with data processing flowcharting techniques.
- Bachelor’s Degree in computer science, computer engineering , computer applications or related field
- Recognized certificate in related field is desirable
- A minimum of 9 years relevant experience in a management role in a museum or related educational, research organization

About the Company

The Adecco Group is the world’s leading talent advisory and solutions company. We proudly make a difference in the working lives of 3.5 million people every year. Our culture is entrepreneurial and inclusive, and we are united by our passion for making a difference in the world of work. We work with over 100,000 organizations in 60 countries, enabling their success. We have 35,000 people working with us across more than 60 countries and territories.

Adecco has been rapidly growing in the Middle East since 2008, developing a substantial footprint throughout the region. We work across 250 different clients, Adecco has more than 62 full time employees, working in 4 offices, servicing all countries across the GCC region. We offer Temporary Staffing, Permanent Placement, Executive Search, Assessments, Visa And Payroll, Outsourcing, PRO Solutions customised as per client requirements. Adecco Middle East Head Office is based in Dubai with a branch at Abu Dhabi.