Oracle Sql Server
Resume:
Mohammad Hasan AbdelQader
Amman-Jordan **/**/198*-*****-** 105 82 18 ac5tck@r.postjobfree.com
Professional Summary
I have Nine Years of experience in Database administration and development (Oracle and MSSQL) along with a variety of operating systems that include Windows, UNIX and Linux.
I have Three years of experience in configuring and installing Hadoop ecosystems components and extensive knowledge in Hadoop technologies like spark, Hive, Sqoop. I have a very good experience in integration (ETL) process using multiple tools like Talend, SSIS, ODI.
Presently looking for a related job with a responsible company, that builds upon my extensive skills and qualifications.
Skills
Computer Skills
Operating Systems: Windows, Linux, Unix
Database: Oracle (9i, 10g, 11g,12c), SQL Server 2005,2008,2012 and Familiar with MySQL
NoSQL Database: HBase, familiar with cassandra
Programming Languages: PL/SQL, SQL, Java Servlet, python, Spark, Hive, Pig, Shell scripting
Pyhton libraries: Numpy, Pandas, Matplotlib
Tools: SQL Developer, Eclipse, Anaconda, Talend, WSO2 DSS, Power BI
Cloud: Microsoft Azure, AWS,IBM
Microsoft Office 2007 (Word-Excel-Access-Power Point- Outlook)
Personal Skills
Team spirit
Very good communication skills
Patience, great ambition
Quick learner
Ability to perform under pressure
Languages
Arabic (Mother language)
English (Read, Write – Excellent, Spoken – V.Good)
Experience
RealSoft Advanced Applications (Amman, Jordan)http://www.globitel.com
Senior DBA and BigData Engineer
6/2016 – Current
Working with Hadoop ecosystems and big data using Cloudera and Hortonworks.
Working with Talend Data integration tool and Big data integration tool
Working with Hadoop Ecosystems (HDFS, Hive, Sqoop, Spark and Kafka)
Python modules (Numpy, Pandas, Motplotlib)
In depth knowledge about various Oracle server technologies and tools
Working with powerBI to build dashboards and reports
Database consultant for developers
Administer and manage database environments (production, test, etc.) on a LINUX/Windows environment
Working with Microsoft azure especially HDinsight technology
Connect Microsoft SQL server to Hadoop using polybase feature
Using data profiling tool (Data Quality) on analysis data
Projects
Working in Tabadol project in DSCD Sharjah to integrate 4 government agencies with warehouse database, the warehouse is Hive and I am using sqoop to ETL data from RDBMS to HDFS.
Build ETL process for Tabadol project using Talend integration tool.
Build Hadoop environment for Tabadol project (Hortonworks), this environment contains Ambari, Hive, Sqoop and Spark
Analysis data that come from agencies and build report for each agency
Build BI application for Tabadol projects
Presenting in Microsoft event and talk about Hadoop ecosystems using HDInsight cloud
Install and configure Cloudera cluster (4 nodes) on Realsoft for development
Install and configure Hortonworks (HDP 2.5) as test environment
Present and create the following two demos for Bank of Jordan :
1.Load data from RDBMS to HDFS then analysis data using spark
2.Twitter Streaming analysis using Kafka and spark streaming
Database Migration from Exadata V2 to Exadata X4, VIVA Kuwait
Prepare and configure data guard between V2 and X4, VIVA Kuwait
Convert Oracle NON-CDB to CDB and pluggable on Exadata x5, MOE Kuwait
Install and configure cenots OS,,maria DB and configure httpd, FTP services, Mobily Riyadh KSA
Configure master, slave between Mysql database servers, Mobily Riyadh KSA
Build dashboard that monitor ETL process using JQuery and HTML
Awards
Three weekly achievement in company
One monthly achievement in company
Al-Kahaleej for Computer and Electronics ( Riyadh – KSA )http://www.globitel.com
Senior EXADATA\Database administrator( ORACLE,MSSQL)
4/2013 – 6/2016
Install and configure all databases required for development, testing, and production usage ( ORACLE, MSSQL)
Administer and manage database environments ( production, test, etc. ) on a LINUX/Windows environment
Experience in implementing DR solution, High Availability of database servers using Oracle Grid infrastructure ( RAC ),Failover cluster, AlwaysOn,Database mirroring, replications and Log Shipping, Oracle Data Guard
Strong knowledge of backups, restores, recovery models, database shrink operations, Oracle RMAN, Oracle PUMP .. etc.
Experience on Managing and administering Oracle ASM
Experience in Performance Tuning, Query Optimization, using Oracle Enterprise Manager, data dictionary Performance Monitor, DMVs, SQL Profiler and other related monitoring and troubleshooting tools.
Setup and maintain documentation and standards
Monitoring and administration EXADATA database machine ( RAC DB nodes, CELLS, IB switches)
Good knowledge on the EXADATA Hardware Architecture which includes Database Grid, Storage Grid and Infiniband
Good Knowledge in Exadata features including smart scan, Columnar Compression, Exadata Storage Index and Exadata Storage
Plans and implements backup and recovery of the Oracle, MSSQL database
Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database
Setup and maintain documentation and standards
Perform general technical trouble shooting and give consultation to development teams
SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
Projects
Install and deploy more than one Oracle RAC environment
Working with oracle support on EXADATA prepare process and contact with oracle
Apply latest patches on Oracle databases and EXADATA
Migrate oracle database from HP-UX to EXADATA
Create centralized SQL server failover cluster
Migrate all SQL servers instances to the new Failover cluster environment
Upgrade OEM 12c cloud control to new release
Consolidate all SQL server database to centralized failover cluster environment
Working database part on EMC cloud system
Configure Data guard between Exadata and non-Exadata RAC
Changing IP address of Exadata after moved to new data center
Create script to taking backup from Exadata to EMC backup solution
Working with 12C grid control and making POC with oracle engineer to deploy oracle DBaS cloud using 12C grid control
Solve ASM low disk space by adding new disk in Jezan municipality
Working in BI project with PMU department as BI administrator ( ODI tool, BI administration Tool )
Install and Configure Oracle RAC, solidarity Riyadh KSA
Prepare and Configure Oracle data guard, solidarity Riyadh KSA
Install and configure oracle 12c cloud control, SASO Riyadh KSA
GLOBITEL
Senior Database and software developer
1/2011 – 4/2013
Perform database design that includes database structures, packages, stored procedures/triggers, indexing/index tuning and based on these to perform database sizing and generate scripts to update database structure
Install and configure all databases required for development, testing, and production usage ( ORACLE, MSSQL)
Perform general technical trouble shooting in databases (ORACLE, MSSQL ) and give consultation to development teams
Work with support team and provide 7x24 support when required
Experience in Performance Tuning, Query Optimization, using OEM, data dictionary Performance Monitor, DMVs, SQL Profiler and other related monitoring and troubleshooting tools.
Develop and maintain the admin website ensuring strong functionality and optimization using Java Servlet, ASP.NET,HTML, JQuery
Design report for projects using Crystal report dependencies in Java and ASP.NET
Design chart for projects using High charts plug-in
Using JQuery plug-in e.g. FlexiGrid, popup plug-in and others
Projects
Roam Analyze report and analysis application
Roam Salute reporting application
Migrate database from SQL server 2000 to SQL server 2012
Installing and configure ORACLE RAC environment for test and development
GLOBITEL
Data Management Operator
11/2008 – 12/2010
Perform a data release (once data versioning is established) and to utilize given references from the internet and purchased data.
Responsible for maintaining GSM data for use in Globitel products/projects
Using My SQL and SQL Server 2005 and oracle to maintain Databases
Listing out the database record retrieval events and writing SQL queries for each kind of record retrieval
Perform database design that includes database structures, packages, stored procedures/triggers, indexing/index tuning and based on these to perform database sizing and generate scripts to update database structure
Create and maintain (Oracle, SQL Server, MYSQL ) various database objects, including SPs, Triggers
Projects
Create interface for GGData project using oracle form and report
Develop a routine process to maintain GGData Database and other projects
Build a structure for GGData database on oracle and SQL Server
Greater Amman Municipality
Computer Operator
03/2008 – 11/2008
Worked with team who connected network in Jordan parliament election network project
Make daily, weekly, monthly report for problem that finish
Maintenance computer (Hardware, software troubleshooting)
Education
Al-Balqa' applied University
Bachelor of MIS
9/2004 - 1/2008
Training
Cloud Computing Foundation
Issuer: HP Corporation
ITIL Foundation Certificate in IT Service Management
Issuer: HP
Learn Big Data: The Hadoop Ecosystem Masterclass
Issuer: Udemy
Intermediate Python for Data Science
Issuer: Data Camp
Oracle Database 11g: Administration Workshop I
Issuer: ORACLE University
Oracle Database 11g: Administration Workshop II
Issuer: ORACLE University
Oracle Database 11g: Performance and Tuning
Issuer: ORACLE University
Database Machine ( ExaData )Administration Workshop
Issuer: ORACLE University
Oracle Grid Infrastructure 11g: Manage Clusterware and ASM
Issuer: ORACLE University
Oracle Database 11g: Data Guard Administration
Issuer: ORACLE University
Oracle Database 11g: Backup and Recovery Workshop
Issuer: ORACLE University
Database Machine ( Exadata )Administration Workshop
Issuer: ORACLE University
Microsoft SQL server 2012, workshop for Administrators
Issuer: Microsoft Corporation
Implementing a Microsoft SQL server 2005 Database
Issuer: Arab Academy for Microsoft Technologies.
Maintaining a Microsoft SQL server 2005 Database
Issuer: Arab Academy for Microsoft Technologies.
Microsoft Certified System Administrator (MCSA)
Issuer: PC dot NET Corporation
Oracle certified professional
Issuer: NTC
Microsoft Office Specialist (MOS 2007)
Issuer: General Computers and Electronics (GCE) Corporation
UNIX (Sun Solaris Environment)
Issuer: PC dot NET Corporation
Certification
Hadoop Foundations
Issuer: IBM
ITIL Foundation Certificate in IT Service Management
Issuer: AXELOS Global Best Practice
Microsoft Certified System Administrator (MCSA)
Issuer: Microsoft Corporation
Oracle Certified Expert, Oracle Exadata X3 and X4 Administrator
Issuer: Oracle Corporation
Oracle Certified Association (OCA)
Issuer: Oracle Corporation
Oracle Database 12c Certified Implementation Specialist
Issuer: Oracle Corporation
Oracle Database 11g Administrator Certified Associate
Issuer: Oracle Corporation
Oracle Certified Associate, Oracle Linux 5 and 6 System Administrator
Issuer: Oracle Corporation
Social network account
http://www.linkedin.com/in/mohammadabdelqader
References
Muhanned Maayeh
QA and Production Manager at Globitel
ac5tck@r.postjobfree.com
Ahmed Abuyaman
Development Manager at 4GTSS
ac5tck@r.postjobfree.com
Ahmed Kayyali
DEXXIS Support and Maintenance Engineer at Gemalto
Sayyar Traifi
Database Manager at Al-Khaleej
Contact this candidate