Umair Khan

  • Hyderabad,Andhra Pradesh IN
Umair Khan

Skills

Skills

Oracle DBA

Operating System:        HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,                                                     IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows                                       95/98/NT/2000/XP      RDBMS:                      Oracle 11g/10g/9i/8.x/7.x, Oracle 10g Real Application Clusters                                       (RAC),   Languages:                  SQL, PL/SQL, Java, C, XML     Tools:                          ORACLE 8.x/9i/10i/10g, Recovery Manager (RMAN), Real                                     Applications Cluster (RAC)                                                     Developer Tools:          SQL Loader, TOAD 7.6/7.5

Summary

  • Having 3+ years Experience as Certified Oracle DBA.
  • Expertise in managing Oracle 10g/11g databases on various platforms mostly Linux and Windows (installation/ configuration/ cloning/ upgrading/ Migration/ patching).
  • Extensive experience in Oracle database utilities (RMAN, Import/Export),
  • Thorough understanding of Oracle database backup/recovery strategy and scenarios (logical/physical backup, cold/hot backup, instance/media recovery, complete/incomplete recovery).
  • Good knowledge about migration of database from Linux to windows,
  • Good knowledge about disaster recovery of database manually and by using RMAN.
  • Sound knowledge of oracle architecture 10g & 11g.
  • Expertise in configuring listener & TNS by using NETCA utility.
  • Loading data from flat files into Oracle Database using SQL Loader utility.
  • Transferring the data between the two databases using EXPORT and IMPORT utilities.
  • Transporting table space from on one database to another using EXPDP utility .
  • Expertise in configuring ASM instance.
  • Installing Oracle database on Linux and Windows Platform
  • Retrieving Data Using the SQL SELECT Statement, Sub-queries and Set Operators, Restricting & Sorting Data, Manipulating Large Datasets Using Multi-table Insert and Update Statements.
  • Using DDL Statement to Create and Manage Tables and Other Schema Objects.
  • Controlling User Access, Locking And Unlocking User Accounts, Administering User Security.
  • Creating and Using Table-spaces and Data-files to hold Data.
  • Configuring and upgrading Oracle Server 10g/9i/8i software.

Objective

To secure a position as an Oracle DBA in a competitive company where a high standard of work and effort is both needed and appreciated where in my talents could be channeled into a productive and profitable asset to the organization.

Work History

Work History
May 2010 - Present

Associate Consultant

Technorack IT Solutions Pvt.Ltd

Technorack IT solutions Pvt. Ltd      -      May 2010 – Till Date

Technorack IT Solutions is global business solutions software and Services Company with worldwide network collaborations and an infrastructure of subsidiaries, offices and associated companies in all major technology syndicate such as the middle-east., and qualified consultants, working across industries.

Project

Unilever, Trumbull, CT      -       July 2010 – Till Date

Unilever Home & Personal Care are professional Home Health Care providers. They aremultinationalconsumer goods company. Its products include foods, beverages, cleaning agents and personal care products. It is the world's third-largest consumer goods company measured by 2011 revenues (after Procter & Gamble and Nestlé) and the world's largest maker of ice cream.

Education

Education
Aug 2006 - Jul 2010

B.E

Muffakhan Jah College of Engineering & Technology

Bachelor of Engineering (IT) 2006 - 2010

Muffakham Jah College of Engineering & Technology,

Hyderabad India.

Intermediate - 2004 - 2006

Sri Chaitanya Educational Institutions,

Hyderabad, India.

SSC - 2004

All Saints High School 

Certifications

Certifications
Jan 2012 - Jan 2013

OCA

Oracle Certification Program