Overview
Work History
Education
Additional Information
Timeline
Generic

Zeba Khan

Abu Dhabi,AZ

Overview

8
8
years of professional experience

Work History

Lead Auditor

KPIT Technologies
  • Certified Additional projects Project 1.
  • Designed and developed form using Oracle APEX Application and contributed in database design.
  • Formulated SQL queries, functions and processes as per customization requirement for APEX Project 2.
  • Performed user management activities such as user creation, assigning responsibilities to multiple users for Red Prairie application.
  • Responsible for creating roles and adding privileges to roles in Oracle 10g as per client requirement.

Al
Dubai
11.2017 - 02.2021
  • Independently install, customize and integrate commercial software packages.
  • Facilitate root cause analysis of system issues.
  • Analyse existing SQL queries for performance improvements.
  • Performed backups using SQL commands.
  • Objectively assess a company’s IT and/or business processes.
  • Assess the company’s risks and the efficacy of its risk management efforts.
  • Identifying shortfalls or gaps in processes.
  • Carried out internal audit for Oracle Databases.
  • Using SQL modified data as per the requirement of client.
  • (Delete, Update, Insert) etc.
  • Maintain statistics and data for completed Projects for future.
  • Prepare presentation in PowerPoint & Dashboard as per the requirement of client.
  • Experience as MIS-Executive in maintaining IT-Dept.
  • Which deals in Documentation & reporting.
  • Prepare presentation in PowerPoint & Dashboard as per the requirement of management.
  • Performed user management activities such as user creation, assigning responsibilities to multiple users.
  • Working in India and UAE market in the field of IT has enhanced my skills, working capacity and increased my ability to evaluate the opportunities in SQL, PL/SQL and Database.
  • Experienced with strong background in.

Functional Consultant

Techno
01.2013 - 11.2016
  • Created and maintained functions, procedures, packages, triggers, cursors, tables, partitioned tables, views, constraints, indexes, synonyms, sequences, analytic functions.
  • Export/Import of Tables, schemas, full databases.
  • Solved L2 issues which impacts the business and production.
  • Working on daily issues faced by the end user, along with system generated issues.
  • Worked on creating tables, partitioned tables, views, constraints, indexes, synonyms and sequences.
  • Working experience of Unix commands like ls, cat, grep , cp, rm, mv, hostname,pwd ,crontab ,tail more etc.
  • Maintenance of database objects, monitor and killing the blocked session using TOAD.

Pune ( Associate DBA )

KPIT Technologies
08.2012 - 12.2013
  • Experience in spfile,pfile,granting roles and quotas, log files and alert log files,AWR reports.
  • Performed backups using data pump and RMAN.
  • Performed Oracle Database installation for test databases.
  • Performed regular DBA activities such as Managing Database, Storage, System Security Profiles, monitoring table space size as per requirement.
  • Adding data files, resizing data files to database as per requirement.
  • Creation of users and assigning roles, privileges and profiles to users.
  • Performing Logical backups using Data pump.
  • Experience of creating database using DBCA utility.
  • Starting and shutting down instance as per requirement.
  • Performing regular DBA activities such as monitoring table space size as per requirement.
  • Take corrective actions to resolve table space issues.

Education

Bachelor of Computer Application -

University of Pune

Additional Information

  • Team Work , Responsibility Analytical Dedicated Adaptable Detail Oriented Awarded as “Award of Excellence” Achievements

Timeline

Al
11.2017 - 02.2021

Functional Consultant

Techno
01.2013 - 11.2016

Pune ( Associate DBA )

KPIT Technologies
08.2012 - 12.2013

Bachelor of Computer Application -

University of Pune

Lead Auditor

KPIT Technologies
Zeba Khan