Oracle Database Administrator
ICSFS
Total years of experience :2 years, 11 Months
Position Description:
I'm currently responsible for installation of the environment (OS, Database, Application server) to implement the BANKS core banking system at the customer side and manage all the production, HA and DR servers in addition to the test and UAT environments . Installation, implementation, monitoring, performance tuning and resolve issues and bugs are also part of my duties.
Main Responsibilities:
• Full implementation of new environment, install Linux RedHat on all the servers, prepare the application servers connecting them with the load balancer and installation of the RAC database nodes .
• Prepare the DR and HA side using the Oracle Dataguard Technology or SAN to SAN replication.
• Prepare UAT and test servers upon customers requests.
• Implement the Banks (ICSFS core banking system) on all environments .
• Solve all customers issues related to performance, functionality and bugs.
• Implement any new Oracle technology related to databases requested by customers like Oracle database vault and oracle audit vault.
• Help customers to take backups, easy restore techniques and implementing audit policies .
Skills
• OS: Linux RedHat, Unix AIX, Windows server and Sun Solaris.
• Database: Oracle 9i, 10g and 11g, Oracle Dataguard, and Oracle real application clusters (RAC), Oracle ASM and Filesystem, DB2 9.5+, SQL 2005 and SQL 2008.
• Servers: Production, development, UAT, HA and DR.
• Oracle Audit Vault 12 and Oracle Database Vault.
Working on the big three flavours of databases Oracle, DB2 and SQL Server on different environments like Unix, Linux and Windows, doing the administration tasks on the servers .
Responsibilities :
1) Install DB on the server.
2) Create, Migrate and Opening the DB.
3) Backing up the DB.
4) Managing users on DB and customize the privileges for each user.
5) Recover DB failure.
6) Monitor the performance of the DB and evaluate server hardware.
7) Tasks related to the applications that are connected to the database.
8) Managing all the HA and DR servers beside the production and development servers .
9) Create audit policies on the database to maintain security and respond to the audit notes .
Skills :
• OS : Windows server, Unix AIX and Linux scripting
• Database : DB2 9.5 and above, SQL 2005 and SQL 2008, Oracle 10g and 11g, Oracle Data guard, Oracle Real application clusters (RAC), SQL loader .
• Servers : Production, development, HA and DR .
• Storage replication technology PPRC.
Web developer creating recruitment websites like Bayt.com with some new features upon customers request, I have uset TCL as a backend programming language and HTML, javascript, JQuery and AJAX as frontend programming language
I have acheived several times the highest grade among my collegues and the following are some of these subjects : Digital Logic , Operating Systems,System Programming,Calculus II ,Computer Architecture ,Field Training and some of the labs. My gradutaion project was HRMS on Oracle 10g , this system is intended to be used by HR department , this system is dynamic and can be applicable in anycompany where even the company name will be written in a specific field and at startup the HR admin will fill all the required fields and create users for his team , after that the HR team will handle adding oher employees and their information and using the system you can also monitor employees vacations , attendance ,leaves and othe information.
