Scribd Logo
Upload

Welcome to Scribd!

  • 80 views

    CV Sample Free

    Uploaded by

    Prince Kumar
    Charu Katyal is a Senior Oracle DBA with over 5 years of experience. She has extensive skills in managing Oracle databases including installations, configurations, maintenance, backups, security patching and upgrades. She currently works as a Senior Oracle DBA at Wipro Infotech Ltd where she manages over 500 Oracle databases for telecom client Aircel. Previously, she was an Oracle DBA at YKK India Pvt Ltd where she administered Oracle databases for inventory, stock and accounting systems.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    CV Sample Free

    Uploaded by

    Prince Kumar
    80 views5 pages
    Charu Katyal is a Senior Oracle DBA with over 5 years of experience. She has extensive skills in managing Oracle databases including installations, configurations, maintenance, backups, security patching and upgrades. She currently works as a Senior Oracle DBA at Wipro Infotech Ltd where she manages over 500 Oracle databases for telecom client Aircel. Previously, she was an Oracle DBA at YKK India Pvt Ltd where she administered Oracle databases for inventory, stock and accounting systems.

    Original Description:

    CV Sample free

    Original Title

    CV Sample free

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Charu Katyal is a Senior Oracle DBA with over 5 years of experience. She has extensive skills in managing Oracle databases including installations, configurations, maintenance, backups, security patching and upgrades. She currently works as a Senior Oracle DBA at Wipro Infotech Ltd where she manages over 500 Oracle databases for telecom client Aircel. Previously, she was an Oracle DBA at YKK India Pvt Ltd where she administered Oracle databases for inventory, stock and accounting systems.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    80 views5 pages

    CV Sample Free

    Uploaded by

    Prince Kumar
    Charu Katyal is a Senior Oracle DBA with over 5 years of experience. She has extensive skills in managing Oracle databases including installations, configurations, maintenance, backups, security patching and upgrades. She currently works as a Senior Oracle DBA at Wipro Infotech Ltd where she manages over 500 Oracle databases for telecom client Aircel. Previously, she was an Oracle DBA at YKK India Pvt Ltd where she administered Oracle databases for inventory, stock and accounting systems.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 5

    Curriculum Vitae Charu Katyal

    Charu Katyal
    Designation: Senior Oracle DBA, Wipro Infotech Ltd.
    Experience: 5+ Years
    Email: [email protected]
    Phone No: +91-9711150539, +91-8285130046

    SKILLS SUMMARY

    Oracle Certified Professional DBA with more than 5 years of experience as an Oracle DBA supporting
    production (including RAC environment), testing and development databases, Data Guard, Backup and
    Recoveries, Performance Tuning, ASM Storage.
    Installation and configuration of Oracle 9i/10g/11g databases.

    Creation and maintenance of RAC and stand-alone databases.

    Strong knowledge of RMAN and logical backup.

    Implementing and enforcing security for all Oracle databases.

    Supporting and maintaining Physical/Logical standby databases.

    Recovery of databases in case of failure (loss of control files, data files, table spaces, entire database
    crash).
    Maintaining replication through Golden gate.

    Partitioning of Tables and Indexes.

    Migration/Up-gradation of databases.

    Patching from 10.2.0.1 to 10.2.0.4.

    PSU bundle Patching on 10.2.0.4 (RAC Setup).

    Strong Practical knowledge of oracle 10g features like flashback database, AWR, Temporary Table
    space Group, RMAN features, auditing etc.
    Data transferring with Export/Import utilities, Data Pump.

    Creation and modification of SQL, PL/SQL scripts (stored procedures, triggers, functions and packages)
    and shell scripts.

    EDUCATION

    CERTIFICATIONS

    TRAININGS

    Bachelor of Engineering (Computer Science), M. D. University, India in 20022006.

    Oracle Certified Professional in Oracle 10g Database Administration.

    Oracle Certified Professional (OCP) in Oracle 9i Database Administration.

    Certified for ISMS (Information Management Security System), based on


    ISO 27001:2005 from TUV SUD South Asia Pvt. Ltd.

    Formal training on Oracle 9i from SQL Star Ltd

    Formal training on Red Hat Linux from SQL Star Ltd

    KEY SKILLS/KNOWLEDGE
    Hardware/OS
    Software Products
    DBA Tools / Utilities

    Windows 2003 / XP, Linux, Sun Solaris, AIX, HP-Unix


    Oracle 11g, Oracle 10g, Oracle 9i, RAC, ASM, RAW LVs, STANDBY, DATAGUARD
    OEM, Export / Import Utilities, Oracle Grid, Goldengate, Standby, BCV(Business
    Continuance Volume)

    WORK EXPERIENCE
    Company

    From Date

    To Date

    Year

    Designation

    Wipro Infotech Ltd.

    Apr 2010

    Till Date

    2.3

    Senior Oracle DBA

    Page
    1

    Curriculum Vitae Charu Katyal


    YKK India Pvt Ltd.

    Feb 2007

    Apr 2010

    3.2

    Oracle DBA

    Work Experience

    Wipro Infotech Ltd.

    April 2010 Till now

    Page
    2

    Curriculum Vitae Charu Katyal


    Aircel (Telecom domain): Aircel is a mobile phone service provider in India. It offers both
    prepaid and postpaid GSM cellular phone coverage in 17 telecom circles. It is Indias
    seventh largest GSM mobile service provider with a subscriber base of over 18 million.

    Client
    Project
    De
    scr
    ipt
    ion
    Software & OS
    Role
    Team Size

    The project deals with managing 200 production databases, 150 pre-prod databases and
    100 testing and development databases with Goldengate setup for replication purpose.
    Oracle 11g, Oracle 10g, Oracle 9i, RAC, ASM, Oracle Grid Control, Goldengate, Sun
    Solaris, HP-Unix, Linux, Windows
    Senior Oracle DBA
    14 DBAs

    Responsibilities\Activities:

    Installation and configuration of Oracle9i/10g/11g database.

    Implementation and maintenance of RAC and stand-alone database.

    Regular DBA checkups on the production database through scripts scheduled to run at regular
    intervals using CRONTAB.
    Monitoring databases using Oracle Grid control.

    Supporting and maintaining Physical/Logical standby databases.

    To ensure successful BCV backup.

    Maintaining replication through Goldengate.

    Backup and Recovery scripts using RMAN for Oracle databases.

    Involved in performance tuning and SQL tuning.

    Performed regular production database backup and recovery using BCV, RMAN and Datapump.

    Applying interim/CPU/PSU/CRS bundle patches.

    Database and schema refresh as per requirement using exp-imp and expdp-impdp utility.

    Shell scripting for various DBA related tasks.

    Table and Index partitioning.

    Analyzing schema, tables and indexes on weekly basis.

    Rebuilding of indexes when required.

    Add data files in Tablespaces in RAW File system and ASM.

    Migration/Upgradation of databases.

    RMAN backups for databases/archive logs.

    PSU bundle patching on 10.2.0.4.

    Periodical support database releases.

    Trouble shooting on database issues.

    Monitoring the archive space, taking the archive log backup manually when archive mount point
    goes full.
    Export Backups (table level, schema level, database level).

    Database tuning-using the tools/scripts like AWR, ADDM, statspack, alert log, tkprof utilities.

    Disable or enable the oracle schedules.

    Create Database links between databases.

    Creation of LVs on database.

    Provide technical support and assistance to end user and developers.

    Responding to service and change requests raised by user.

    Attending the CAB meetings for the discussion on change request.

    Page
    3

    Curriculum Vitae Charu Katyal

    YKK India Pvt Ltd.

    Feb 2007-April 2010

    Page
    4

    Curriculum Vitae Charu Katyal


    YKK is a Japanese Zipper manufacturing company. It is 100% subsidiary of YKK
    Corporation, Japan. YKK uses Oracle technologies for stock management, inventory
    control, accounting etc.

    Client
    Project
    De
    scr
    ipt
    ion
    Software & OS
    Role
    Client
    Team Size

    Management of production, stock control management databases and accounting oracle


    databases. Project comprised of 4 production databases, creation of test and
    development databases on requirement.
    Oracle10G, Oracle 9i, Linux, Windows 2003
    Oracle DBA
    YKK
    3 DBAs

    Responsibilities\Activities:

    Installation of oracle database software on Linux and Windows.

    Creation and administration of the physical and logical structure of database.

    Creation and maintenance of all databases required for development, testing and production usage.

    Shell scripting for various DBA related tasks.

    Database administration, managing table spaces and objects.

    Oracle 9i/10g installation on Server and Client Side.

    Creation and administration of users and their profiles.

    Privilege and Role Management.

    Database Export and Import.

    Backup & Recovery Mechanisms (RMAN and User Managed).

    Configuring archive log mode for database.

    Managing redo logs, checking alert log and trace files for errors.

    Suggesting improvement areas in terms of functionality enhancements.

    Daily backup, Disk space management and User management.

    Creation of SQL Scripts as per user requirement.

    Troubleshooting Oracle NET Server Configuration files such as tnsnames.ora and sqlnet.ora .

    Built backup and recovery strategy.

    Review and modification of SQL queries for performance enhancement.

    Creation of Database link b/w Oracle and Non Oracle Databases.

    Performance/Tuning on OS level (Linux Servers)

    Creation of weekly cold backup script, scheduled to run on weekend.

    Assisted organization in switching to higher version of IFS Software.

    Upgrade Oracle 9i Database to Oracle 10g Database.

    Using AWR, ADDM and STATSPACK for performance reports.

    Technical support and assistance to end user and developers.

    Page
    5

    You might also like