Database Manager
Commercial Bank of Kuwait
مجموع سنوات الخبرة :32 years, 1 أشهر
o Installed and Configured Oracle 10g, 11g & 12c Real Application Clusters with an Automatic Storage Management Feature on Ramsan 620, Ramsan440 & HP EVA storage, Verident & Huawei Flash Drives.
o Installed and configured Oracle 11g Real Application Clusters Database on Oracle VM.
o Used USSD & Write accelerator to improve performance.
o Creation and maintenance of high availability databases using Active Data Guard with real time apply feature.
o Implemented Disaster Recovery System to protect the database from failure and reduce the down time. Using SAN replication to DR Site.
o 24x7 Production support and maintenance of Oracle Databases, OLTP/VLDB including design and optimization.
o Installation & configuration of Oracle 10g IAS & IDS on different platforms.
o Creation of Application users and Responsibilities.
o Setting up Audit Trails
o SQL Tuning, Database Tuning, Designed Backup & Recovery procedure using RMAN.
o Created and distributed Tablespaces across multiple disks to reduce the I/O contention and to maintain optimal flexible architecture, spread partitioned tables across multiple tablespaces, Maintaining Indexes etc.
o System administration duties including Startup and Shutdown, Monitoring the Oracle process.
o Administering oracle process on Linux Operating System
o Disk Administration, User Management, System Accounting and auditing.
o Designed and created the main production database.
o Migration of data from the mainframe to oracle Database .
o Creation of Application users and Responsibilities.
o Customization of Menus.
o Setting up Audit Trails.
o Gone through Interface tables SQL* Loader control file to transfer data from flat file to vender interface table
o Installed and Configured Oracle 10g Real Application Clusters with an Automatic Storage Management Feature and migrated the data from single instance database to RAC Database.
o SQL Tuning, Database Tuning, Designed Backup & Recovery procedure using RMAN.
o Created and distributed Tablespaces across multiple disks to reduce the I/O contention and to maintain optimal flexible architecture, spread partitioned tables across multiple tablespaces, Maintaining Indexes, Rollback segments, Redo logs.
o System administration duties including Startup and Shutdown, Monitoring the Oracle process,
o Disk Administration, User Management, System Accounting and auditing.
o Implemented Disaster Recovery System to protect the database from failure and reduce the down time.
o Creation and maintenance of high availability databases using many techniques including Data Guard and standby databases.
o Administration, Maintenance & tune up of ORACLE database under Unix. SQL Tuning, Database Tuning, Database Upgrade & testing & documenting Backup & Recovery
o Creating and distributing of Tablespaces across multiple disks to take care of contention and creating partitioned tables across tablespaces.
o System administration duties including Startup and Shutdown, Monitoring the Oracle process, Disk Administration, User Management, System Accounting and auditing.
o Patch management as per Oracle instructions.
o Created, configured and administered physical standby database.
o Creation of Application users and Responsibilities.
o Customization of Menus.
o Setting up Audit Trails.
o Creation of Document sequence.
o Creating and Administering Folders.
o Setting up profile options.
o Customization of Forms and Reports and concurrent programs.
o Creating and administering concurrent Managers.
o Gone through Interface tables SQL* Loader control file to transfer data from flat file to vender interface table
o Imported journal information into GL module using SQL * Loader
o Applying Database and Oracle Application patches on 11i and 11.5.10.
o Installation & Configuration of Oracle Database on Unix Platform.
o Creation of Application users and Responsibilities.
o Customization of Menus.
o Setting up Audit Trails.
o Performance tuning of SQL scripts.
o Database Tuning, Database Upgrading.
o Database backup and recovery and documenting the process.
o Security Administration by creating users with appropriate ROLES & PRIVELEGES.
o System Administration duties including startup and shutdown of Database as well as host OS.
o Disk Administration, User Management System Accounting and Auditing,
o Patch management as recommended by Oracle, Sun for optimal performance of the database.
o Administration, Maintenance and Tuning of Oracle Production Database.
o Shell scripting for automating production database backups.
o Scheduling automatic backups in Cron.
o Implementation of General Ledger Symbols Security & Money Market Packages.
o Monitoring Database performance through Tablespace monitoring.
o Optimizing the Database with relation to fragmentation.
o SGA Performance monitoring and sizing.
o Developing Alert reports
o Security Administration by creating users with appropriate ROLES & PRIVELEGES.
o Performed system administration duties including Startup and Shutdown of application, database and host OS.
o Implementation of Share Broker package for Investments company involved in trading shares.
o Monitoring Database performance through Tablespace monitoring.
o Optimizing the Database with relation to fragmentation.
o SGA Performance monitoring and sizing.
o Developing Alert reports
o Security Administration by creating users with appropriate ROLES & PRIVELEGES.
o Performed system administration duties including Startup and Shutdown of application, database and host OS.
o Monitoring the Oracle process, Disk Administration, User Management, System Accounting and auditing.
o Analyzing trace and log files to determine and resolve potential problem areas.
o Design of Backup and recovery and its subsequent implementation.
'A' Grade
Oracle Certified Database Administrator
Oracle Certified Database Administrator 10g
Sun Certified Solaris Administrator Solaris 9
Sun Certified Solaris Administrator Solaris 8
Oracle Certified Database Administrator 9i
Oracle Certified Database Administrator 8i
Oracle Certified Database Administrator 8