Kamal Alkhatib Email and Phone Number
TECHNICAL SKILLS & EXPERTISEPROFESSIONAL EXPERIENCE• In most projects responsible for gathering and analyzing the requirements, defining the required standards, designing the database, developing, testing, implementing and maintaining the developed pl/sql code and the database.- Defining the required standards for naming conventions and to achieve the optimal performance and avoid hard coding. Also creating the required packages and tables to handle exception errors. - Creating the required database objects.- Using the required tools to locate and monitor high SQL statements and to check the execution plans. - Using SQL*Loader and External tables to loading the required data into the database.• Oracle DB installation and configuration (Oracle 11g /12c). • ETL tools(SQL* Loader, external tables,DataPump, RMAN, transportable tablespace, Informatica ). • performance tuning(execution plans,SQL tracing, TKPROF, dbms_profiler, Statspack, dynamic performance views,AWR, ADDM) .• database logical and physical design( partitioning, IOT, clustering and heap table, indexing and integrity constraints). • SQL and PLSQL skills (analytical functions, collections, dynamic sql, ref cursor, procedures, functions, packages, exception handling, triggers, views). • UNIX shell scripting(function, Library,gawk,sed,regex,crontab) • TOAD, PL/SQL Developer• List of technologies : Linux RedHat,Centos, MSWindowsXP/2003, Oracle forms and reports 11g,Oracle database 11g,12c,Oracle application server 10g.
-
Tata Consultancy ServicesPleasantville, Ny, Us
-
Pl/Sql DeveloperTata Consultancy Services Sep 2022 - PresentMumbai, Maharashtra, In
-
Performance TuningInfosys Oct 2020 - Aug 2022Bangalore, Karnataka, InI worked on a project to support performance tuning related issues for city bank. the main task was to tune the long running queries by using different techniques like recommend gathering stats, using hints, adding indexes, suggest re-writing queries etc. -
Plsql DeveloperFreelance Feb 2020 - Jul 2020Al-khatib for poultryPayroll and inventory system (feb-2020 to jul-2020)Sample code on:https://github.com/kamalalkhatib/inv_payroll-projectThis project included the following tasks:• Gathering the user requirements and doing logical and physical design.• Creating Database Storage Structures ( tablespaces and datafiles).• Creating the required packages, procedures and functions to achieve the required tasks(DML operations, salary calculations, inventory operations and reporting) and to organize the work. • Creating the required triggers to maintain data integrity.• Using bulk binds( which improves the performance) to insert salary details into the required tables.• Creating the required tables and packages to be used in error exception handling.• Using explain plan, AUTOTRACE, TKPROF and RUNSTATS package to test different database physical design scenarios and to make sure there is no mistakes in the execution plans are chosen by the optimizer.• Using indexes to improve performance for main queries. • Using SQL developer for Automation Testing, debugging, creating data models and checking execution plans.• Using unix shell scripting(gawk,sed) to clean the old data.using external tables to load old data into database tables.
-
Oracle Plsql Developer(Free Lance) Jan 2018 - Jan 2020• Car parts warehouse project.( Flamotechs reference Qusai (815) 981-6645)This project included the following tasks:- Gathering the requirements.- Doing logical design.- Doing physical design.- Developing and implementing the database- Creating Database Storage Structures- Using bulk binds to improve performance.- Define standards for naming conventions.- Define standards to avoid hard coding and creating the required packages to achieve that.- Creating the required tables and packages to be used in error excep-tion handling.- Using explain plan, AUTOTRACE, TKPROF and RUNSTATS pack-age to test different database physical design scenarios and to make sure there is no mistakes in the execution plans are chosen by the op-timizer.- Using indexes to improve performance for main queries.Environment: Oracle 12c, SQL Developer, PLSQL, linux• Payroll Application (stay healthy- Jordan)Analyzed and evaluated the developed database and helped in the following areas:- Eliminating data redundancy.- Defining integrity constraints to enforce business rules - Adding indexes to the main queries to improve performance.- Using different table types to achieve better performance.- Using bulk binds to improve performance.
-
Plsql DeveloperNational Center For Security And Crisis Managment Oct 2007 - Jan 2018I was a member in a team who developed many applications like:• Inventory System• HR system• Operational and crisis management applicationsMy major tasks were including:- Installing and configuring the database.- Gathering user requirements.- Doing logical design.- Doing physical design.- Creating Database Storage Structures- Developing and implementing the database.- Configuring and developing backup using RMAN.- Creating views, procedures, and functions for GIS department to show inci-dents on the map.- Using Data Pump for logical backups and schema migrations across environ-ments.- Maintaining tables, indexes to improve performance.- Participating in deploying DB backup policy.- Monitoring various DB activities such as backup, error logs, space,Objects, performance, users and sessions- Defining standards and rules to achieve optimal performance, avoid hard coding, handle exception errors, and writing easy maintainable code.
-
Plsql DeveloperCivil Defense 2006 - 2007plsql developer which included creating the required tables, views, procedures, functions and packages. Oracle forms and reports developer
Kamal Alkhatib Education Details
-
Alzaytoona University (Jordan),Computer Information System
Frequently Asked Questions about Kamal Alkhatib
What company does Kamal Alkhatib work for?
Kamal Alkhatib works for Tata Consultancy Services
What is Kamal Alkhatib's role at the current company?
Kamal Alkhatib's current role is Oracle database developer with experience in database logical and physical design, pl/sql development , performance tuning and knowledge and certificates in database administration.
What schools did Kamal Alkhatib attend?
Kamal Alkhatib attended Alzaytoona University (Jordan),.
Who are Kamal Alkhatib's colleagues?
Kamal Alkhatib's colleagues are Anshuman Gaurav, Yash Jatav, Rini Patra, Shabana Syed, Hemalatha Sabbisetty, Nathamume Ramanujem, Mamatha B.
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial