An Accomplished Oracle Database Administrator (DBA) With Expertise In Technical Skills And Knowledge For The Growth Of The Firm
Amman,AM
Overview
2
2
Languages
4
4
years of post-secondary education
14
14
years of professional experience
Work History
Database / AIX Administrator Supervisor at IIAB
Oracle Database administrator (DBA) / IBM AIX-OS administrator supervisor
Amman, jordan
01.2018 - Current
Administratively and organizationally supervises the performance of subordinate employees, monitors their working hours, determines and distributes their vacations, and works to develop their skills and experiences and work in a team spirit to ensure that they carry out their responsibilities and tasks with high efficiency.
Follow up and monitor the performance of databases and ensure their efficiency and work on all services by reading their indicators and monitoring storage capacities periodically and calculating the required amount of hard disks.
Managing Oracle & SQL banking databases operating on central machines or servers of the work environment and on all systems (central systems environment, test environment, testing environment or any temporary or permanent available environments)
Analyzing new systems and services and determining their requirements for databases and storage
Preparing studies for future expansion measurements and efficiency measurement (Performance and availability KPI) and recommending defining the environment and location of the databases to ensure the highest level of performance
Installing and configuring databases for services and systems, experiments/training environment, providing support to the departments of the Information Systems Department, and following up with specialized companies regarding databases.
Follow up the work and performance of databases in the emergency center and backup databases, and ensure that instant copies are made on existing devices.
Supervising and monitoring the storage environments of the main servers, and ensuring the validity of backup copies on a regular basis.
Issuing daily/weekly/monthly/when needed reports showing the state of public databases in terms of their validity, problems based on them, and others.
Regularly reviewing and managing database security, which requires adding or canceling some users and organizing their powers to ensure the confidentiality and security of data and according to the approved policy in the bank
Studying, providing solutions and applying them to close the gaps that appear in the internal audit reports, according to the approved periodicity, to ensure that the bank’s databases are free of any gaps.
Follows up with the supplier of the banking system on problems related to the structure of the databases
Implementation of new database projects
Manage and update the operating systems (AIX & Linux) and storage units (SAN Storage) and ensure that they are efficient and work on all services and are free from any problems through a periodic review of the analytical and control files
Implementation and follow-up of procurement procedures for devices and licenses related to databases
Conducting a study and determining the work needs of operating systems, databases, communication and providing technical support to all parties that deal with the database
Database / AIX Administrator Senior at IIAB
Oracle Database Administrator / AIX Administrator
amman, jordan
06.2012 - 01.2018
Oracle Database Administrator, providing 24X7 production and development support 19C/11g/10g/9i databases on different platforms like AIX, Red Hat Linux and Windows.
Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, capacity planning, space management, database security, auditing, troubleshooting, physical and logical database design, TAR support ,Unix shell scripting and documentation
Experience in installation, configuration and administration of Oracle Databases
Implementation of High Availability solutions with Oracle 10g/11g /19C RAC, Physical and Logical Standby Databases (Data Guard)
Excellent experience in cloning oracle databases for development and testing
Experience in Capacity planning & bench marking
SQL Tuning in an Oracle Environment: Excellent experience in performance tuning using EXPLAINS PLAN, SQL TRACE, AWR and ADDM reports
Skills in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand-alone instances
Excellent Troubleshooting skills in OS level and Database level
Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Tablespace Management, Materialized Views
Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, Logical and Physical Database Design, Backup and Recovery procedures
Monitoring and implementing Database security (daily review of privileges , creating profiles , implementing advanced security –transparent data encryption)