Database Oracle

Ahmed A AlTameemi

PERSONAL DETAILS

Date of Birth: February 28th 1988

Sex: Male

Address: Tacoma, WA

Email: *********.*****@*****.***

Phone: 360-***-****

Work Authorization: EAD

PROFESSIONAL SNAPSHOT

A competent professional with 6 + years of experience in Oracle Database Administration.

A competent professional with 4 + years of experience in Oracle Database Administration Instructor.

Professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of Oracle Application Server 10g, Weblogic 11g and EPS R12

Proficient in database administration involving in installation, configuration, tuning and migration of databases along with database design and management.

Deft in operating database administration under multi-platform environments, including installation and configuration of software, maintenance and disaster recovery management.

Skilled in migration of databases from older to new version with different platforms and upgrading Databases with patch sets.

24x7 on-call Production support for database activities.

AREAS OF EXPERTISE

RDBMS : Oracle Database 9i,10G,11G, 12C, Mysql, Postgre Database, MS sql Server

RAC 11G, Data Guard 11g, Oracle Golden Gate 11g, Oracle Database Security 11g

Applications : Application Server 10g, Weblogic 11g, Oracle E-Business Suite R12

Operating Systems : Redhat Enterprise Linux Ver 4, 5, & 6, UNIX 5.10

Languages : SQL

Others : Shell Scripting

RESPONSIBILITIES

Database Administration

Responsible for the 24/7 support of Oracle Database services to ensure the highest standards of availability,

Flexibility, integrity, security and performance required by business systems .

Responsible for Installation, configuration, deployment and administration of Oracle Database and Real Application

Cluster (RAC) on different nodes with Automatic Storage Management (ASM) on Linux .

Managing Database unknown errors using MOS .

Manage Multiple Database servers on different Sites .

Managing database administration related functions involving in installation, configuration, up grading and patching of Oracle server software and hardware.

Installing, Upgrading and managing RAC with ASM .

Managing standby Databases (Data Guard) .

Handling disaster recovery management, supervising technical team to restore database during system failure. Database / SQL tuning, performance monitoring and troubleshooting.

Managing physical and logical structure of database; bullet proofing the database.

Making and implementing backup and recovery strategies using RMAN & user managed.

Loading data into database using export and import.

Transporting data between databases; assessing current and future storage requirements.

Building test database.

Maintaining user connectivity and configuration.

Looking after patch installation and security management.

Handling Disaster Recovery Management; supervising technical team to restore database during system failure.

Resolving database startup problems and database re-organisation.

Maintaining availability of database by designing backup and recovery strategies.

Collection of Statistics

Develop Shell scripts for automated backups

Monitor Database space usage and Tablespace Growth

RMAN backup, restoration, recovery, duplication of database.

Configuration of RMAN backup and schema wise logical backups

RAC administration, ASM Administration and Performance Tuning (I/O, SQL Tuning)

Troubleshooting and Resolving RAC issues using OS utilities, OS messages, database waits, tracing and tuning database SQLs.

WORK EXPERIENCE

Zain Atheer Telecom (September 2014 -- April 2016 )

Experienced Business Analyst

As the country’s leading mobile operator, Zain has been providing mobile voice and data services in Iraq since December 2003. Currently serving over 13.5 million customers, Zain’s mobile network covers more than 98% of the population to better serve customers and provide world class telecommunication services to all Iraqi citizens, Zain is actively developing innovative voice, data and value added services products. At the same time, the company is enhancing and expanding its network to further improve customer experience across all Iraq governorates.

I was responsible to manage and maintain the IT Operation from Zain Iraq side with Ericsson which covers the manage service of Data Center Infrastructure: Databases, Servers, and Storage. Managing the Key performance Indicator with the MS Ericsson team, managing all the contractual contract papers related to the Support renewal, licensing renewal, and building solid contracts with third party vendors.

Fanoos Telecom (October 2012 -- August 2014)

Senior Database Administrator and Linux Administrator

Fanoos Telecom is a leading provider of landline and internet services to people in seven governorates of Iraq. The company is the leader in fixed wireless telephony.

Accountabilities

Maintaining the 24/7 Mission critical Production Oracle Database on Linux and windows.

Responsible for tens of projects including Planning, design, implementation, Installation,

Migration of different RDBMS including 10g, 11g databases, cluster, Data guard

on different platform .

Managing Storage through ASM (Automatic Storage Management).

Cloning Oracle RAC 11gr2 to single node .

Verify the availability of all the instances.

Backup, Maintenance, Recovery and Tuning of company’s database.

Check for RMAN backup logs for any errors.

Check Alert Log files for “ORA” errors.

Truncate listener logs if size exceeds 300MB.

Check the Servers for any space constraints.

Sizing Memory Components from performance point of view.

Check the databases for any INVALID Objects and rectify the problem.

Check tablespaces for any space problems and their growth patterns.

Database Upgrade from 11.2.1, 11.2.2 to 11.2.3 on RHEL 5 .

Applying Database patches(Patch sets and PSUs)

Database Cloning as per requirement.

Re-organisation of database objects.

Gathering database statistics.

Database Export & Import.

Check DBMS_JOB for any broken or failed jobs.

Setting up new users Managing User Responsibilities.

Backup Oracle Database on Tape Drive vie HP DATA Protector.

Backup MYSQL DATABASES.

Sanity Backup to check if the backup is recoverable or not .

Managing Oracle Database RAC with ASM instances .

Create user and grant privilege in MYSQL Database .

Apply Patches & Bugs Fixes on Oracle Database .

IT Training House: (January 2012 -- April 2016 Baghdad, Irbil)

Worked part time as an Senior Database Instructor, conducting 25 successful oracle courses in database 10g and 11g and WebLogic 11g to different clients.

ITISALUNA TELECOM : (May 2011 -- October 2012)

Database Administrator

ITISALUNA : Is the latest Iraqi telecommunications company and a national fixed telecommunications services and Internet services. Technology provides high quality in the field of wireless communications network fixed (Wireless Local Loop) depending on the latest techniques of the third generation, (CDMA2000-EVDO Rev A), providing the best services to communicate voice and information beneficial permanent user, whether at home or in the workplace, where can benefit from all the advantages of this system, which includes phone calls, use the internet, SMS, voice mail.

Accountabilities

Configure, troubleshoot, Maintain and Monitor Billing System Databases under SUN UNIX Salaries

With SUN Cluster Software Technology.

Install Oracle 11G under RHEL 6.3 for Reporting System .

Provide Support to critical Systems that must be available 24/7 .

Configure the backup Strategies (HOT & COLD Backups).

Responsible with Billing Team for implement new Provisioning setup requests for Billing System.

Backup, Maintenance, Recovery and Tuning of company’s database.

Check for RMAN backup logs for any errors.

Admin for Oracle Application Server (tabs 6.10 & 6.11 ) and Oracle Portal Application .

Publish some report on net vie Discoverer .

Daily Support for CCR & CSR .

Check Alert Log files for “ORA” errors.

Truncate listener logs if size exceeds 300MB.

Sizing Memory Components from performance point of view.

Check the databases for any INVALID Objects and rectify the problem.

Check tablespaces for any space problems and their growth patterns.

Database Cloning as per requirement.

Re-organisation of database objects.

Gathering database statistics.

Database Export & Import.

Check DBMS_JOB for any broken or failed jobs.

Setting up new users Managing User Responsibilities.

Vizocom (October 2010 -- MAY 2011)

Database Administrator

Vizocom is a key VSAT service provider in Middle East and Africa with local offices in Iraq (Baghdad and Basra), Afghanistan (Kabul), Libya (Tripoli), Nigeria (Lagos), UAE (Dubai) and USA (Texas). We also provide turn-key IT and communication solutions such as cable and wireless LAN, Voice over IP, Video conferencing, server setup and any other requirements you might have in the field of IT.

Accountabilities

Install Windows Server 2008 .

Install MYSQL Database and Application (Knowledge Tree).

Create User and Group and assign permission to user.

Backup and restore in MYSQL Database.

Migrate the data from SQL Server to MYSQL Database.

Training all Staff in MOI (Ministry of Interior) .

Projects :

Install and Configure archiving System in MOI (install MYSQL Database and Knowledge Tree Application

And migrate the data from SQL Server to MYSQL Database ) .

Install and Configure the Reporting System (Migrate the data from Oracle 10g running on windows Server 2008

700GB approx in size To Oracle 11g under RHEL 6.3 ),

The implementation was done vie using Rman, Datapump, Cross platform

Transportable Tablespaces .

Reconfigure the Oracle Portal with new Reporting System .

Cloning Oracle Database 11gr2 RAC and ASM to Oracle 11g one node under file system .

Upgrade Oracle database from 11.2.2 to 11.2.3 under OEL5.6

Migrate the all 2012 CDRs from IN Database to Billing Database vie using the exp and imp tolls .

Install and configure the weblogic 11g and Migrate the oracle application server 10g to weblogic 11g and

deploy all fmb from OAS 10g to weblogic 11g .

Oracle 11gr2 RAC and ASM 2nodes installation and configuration under RHEL 6.3 for the Mediation Systems

and insert all CDRs from source (AAA, HLR, IN ) To Billing database vie using the sql loader tolls .

Planning and Implementing Physical Standby Data Guard 11g for Billing System .

Migrate all the Billing Databases RAC ASM 11gR2 3.5 TB Data from HP EVA Storage to

HP 3PAR Storage, The Migration was done with zero downtime .

Worked part time with System Admin Team to extend Zain Iraq Storage and backed up their Databases .

MySQL Database Upgrade From 5.1 To 5.5 in Linux System .

MySQL Database Cluster Installation and Configuration under RHEL 6.3 .

Planning and Implementing MySQL Database Replication between Main And DR site .

HIGHER EDUCATION QUALIFICATIONS

Bachelor in Information Technology & computer Science

Technology University in 2010.

Certifications

Oracle 10g Database Certified Associate Database Administrator

Oracle 10g Database Certified Professional Database Administrator

Oracle Certified Expert, Oracle Real Application Clusters RAC 11g and Grid Infrastructure Administrator

Oracle Database 11g Security Certified Implementation Specialist

Certificate for Tackling the Challenges of Big Data

Courses

R12.x Install/Patch/Maintain Oracle E-Business Suite Ed 1 PRV

Oracle Database Security 11g

Oracle Database Vault 11g

Oracle Audit Vault 11g

Oracle Golden Gate 11g

Contact this candidate