ماطبيعة عمل مدير قاعدة البيانات

• Responsible for Database maintenance and troubleshooting

• Cloning Production databases to Test Databases using RMAN

• Backup and Recovery polices for both Production and Test DBs

Using both RMAN backup & recovery and Export & Import Utilities (Data Pump )

• Ability to handle all invalid objects, duplicate items and developing Procedures to help development team

• Tuning the database & managing Optimizer

• Rebuilding indexes

• Installing oracle engine on multiply platforms

• Estimating the database server configuration and capacity

• Database design and creating different Schema objects

• Managing users and roles and Auditing .

• Managing users and developers space’s on the table space

• Estimating SGA & PGA size and managing oracle server performance

• Creating scripts using PL-SQL

• Using SQL-loader for Data migrate from (text & SQL server to oracle 8i,9i and 10g)

• Connecting Oracle to multiple database engines

• Upgrade database engine from (oracle 8i) to (oracle 9i) and to ( oracle 10g)