Database administrator
trade bank of iraq
مجموع سنوات الخبرة :9 years, 6 أشهر
* Auto report DB with email all daily maintenance reports (File Size, Memory, users expiry, scheduler Status)
* apply audit policy
* Install and manage audit vault with install agents in all servers
* Install full recovery scenario with 3 Dataguard Databases on located in Baghdad and others located in Erbil (sync per commit)
* apply PCI requierments
* audit vault auto report
* Restore Full ENv. From Rac to single Node with all Parameter changes
* sql server installation on windows server 2019
* auto job backup for sql server DB with windows schedular
* Restore Backup from one server to another
* oracle auto email any query with PDF or excel, Csv format
* Oracle GoldenGate installation full Data protoction Sync Per commit
* Data guard open mode read only with acess to specify users with privillage to insert or update on DG server
* Oem create Role for shutdown server and send it via email (incident Roles)
* EastNets AML Profiling System Integration (Company Side)
*BackOffice Reporting Extraction
*Credit Card Project Integration (Company Side)
* Tableau statistic system and Reporting
*Installing and Configuration the oracle database 11g
and 12c and 19c on the server hardware (Linux6, linux7, linux8 & win Server)
*install weblogic and Configuration 12c with Domain and RCU
* install and Configuration of Oracle Enterprise Manager Cloud Control 13C (Oracle's solution to manage/monitor various database/applications which may be running on Cloud infrastructure or on-premise)
*creating and managing the table and other objects used to manage the application data
*creating and managing database users (apply PCI Requirements & limit unauthorized access)
* install Patch and upgrade oracle Database
*Approve all production schema changes
*Control all migrations of Oracle schema objects
*Implement Oracle failover technology using (DATA GURAD Physical and Logical)
*Establishing reliable backup and recovery procedure for the database (Full, Incremental, Differential)
*Managing data security
*monitoring and tuning database performance
*Analyzing trends and forecasting resource and storage requirement
*Writing an SQL Oracle Script in Oracle 11g and 12c
* Knowledge of ALL Oracle backup and recovery scenarios
*providing operational DBA support to both production and non‐production database environments
*DBA level knowledge of Unix fundamentals and shell scripting
* Design, Install and admin/maintain Oracle Data Guard
* Install S2M Select System from Scratch (Database, Weblogic & all Configration)
* Design, Install and admin/maintain OEM, Grid Control
* Backup and Recovery (RMAN, Cloning, Data Guard, Export/Import)
* Resource Monitoring (CPU, memory, I/O, etc…)
* Oracle patches provisioning.
* Diagnostic evaluation (ADDM, AWR, ASH)
*Encryption Data and Table Using Oracle Wallet
* Auditing Data and Database Using Oracle Audit Vault
- installation and Configuration DVR And NVR (installation IP's Cameras and coaxial)
- installation IP's Phones on Linux environment
- installation and Configuration windows server 2008 and 2012
-Active Directory (Windows Server domain Controller)
-Share Server (Configuring Disk Quotas, user privileges)
-Kasper Sky Security Center Administrator
ICBS Core Banking Administrator
-Installation, Configuration and Upgrading Oracle Database (Windows Environment)
- Writing an Oracle SQL scripts in Oracle 11G and 12C.
1. responsible on products distribution in Baghdad district / alrusafa side.
2. also weekly follow up the sales with the clients.
3. collect the bills from the beauty Centers & Pharmacies.