Scribd Logo
Upload

Welcome to Scribd!

  • 55 views

    Aathik G. Mistry: Professtional Profile

    Uploaded by

    Musa Tahirli
    Aathik Mistry is a senior Oracle DBA with over 8 years of experience in database administration including Oracle 8i, 9i, 10g, 11gR2, Exadata, and RAC. He has extensive experience setting up, configuring, tuning, backing up, and migrating Oracle databases. Currently he works as a deputy manager at Vodafone India where he manages a team of 12 DBAs and supports critical production environments. His responsibilities include patch management, database setup, performance tuning, Exadata administration, and resolving incidents and change requests. Previously he has worked at TCS, IBM, Amdocs, and Softenger supporting clients like Best Buy, Vodafone, Globe

    Copyright:

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

    Aathik G. Mistry: Professtional Profile

    Uploaded by

    Musa Tahirli
    55 views4 pages
    Aathik Mistry is a senior Oracle DBA with over 8 years of experience in database administration including Oracle 8i, 9i, 10g, 11gR2, Exadata, and RAC. He has extensive experience setting up, configuring, tuning, backing up, and migrating Oracle databases. Currently he works as a deputy manager at Vodafone India where he manages a team of 12 DBAs and supports critical production environments. His responsibilities include patch management, database setup, performance tuning, Exadata administration, and resolving incidents and change requests. Previously he has worked at TCS, IBM, Amdocs, and Softenger supporting clients like Best Buy, Vodafone, Globe

    Original Description:

    cv

    Original Title

    AathikMistry

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Aathik Mistry is a senior Oracle DBA with over 8 years of experience in database administration including Oracle 8i, 9i, 10g, 11gR2, Exadata, and RAC. He has extensive experience setting up, configuring, tuning, backing up, and migrating Oracle databases. Currently he works as a deputy manager at Vodafone India where he manages a team of 12 DBAs and supports critical production environments. His responsibilities include patch management, database setup, performance tuning, Exadata administration, and resolving incidents and change requests. Previously he has worked at TCS, IBM, Amdocs, and Softenger supporting clients like Best Buy, Vodafone, Globe

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    55 views4 pages

    Aathik G. Mistry: Professtional Profile

    Uploaded by

    Musa Tahirli
    Aathik Mistry is a senior Oracle DBA with over 8 years of experience in database administration including Oracle 8i, 9i, 10g, 11gR2, Exadata, and RAC. He has extensive experience setting up, configuring, tuning, backing up, and migrating Oracle databases. Currently he works as a deputy manager at Vodafone India where he manages a team of 12 DBAs and supports critical production environments. His responsibilities include patch management, database setup, performance tuning, Exadata administration, and resolving incidents and change requests. Previously he has worked at TCS, IBM, Amdocs, and Softenger supporting clients like Best Buy, Vodafone, Globe

    Copyright:

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

    AATHIK G.

    MISTRY
    Contact No: +91-9960333046 Email: [email protected]
    PROFESSTIONAL PROFILE

    Profile Summary

    • Having 8.7 + years of IT experience.


    • Having over 8.7+ years of experience in Oracle Database Administration including RAC.
    • Proficient in database administration involving installation, configuration, Performance tuning, backup-
    recovery and migration of databases, Golden Gate ,working on RAC ,OEM, Exadata Machines
    • An effective communicator with excellent relationship building & interpersonal skills, strong analytical,
    problem solving & organizational abilities, possess a flexible & detail oriented attitude.
    • Currently working as a Senior Oracle DBA / Deputy Manager with Vodafone India Services Pvt. Ltd

    TECHNICAL SKILLS

    Languages : SQL
    Operating system : Windows, RHEL, HP-UX, AIX, SUN SOLARIS, Oracle Enterprise Linux
    RDBMS : Oracle 8i,Oracle 9i , Oracle 10g ,Oracle 11gR2,golden gate, Oracle Exadata ,Oracle RAC
    Tools & Utilities : RMAN, Data pump, BMC Remedy for ticketing, golden gate, Adrci , OEM
    GUI : Toad, OEM

    Key Responsibilities Handled:

    ➢ Working on critical Production, Test and Development Environments.


    ➢ Patch Management (one off patch, Critical Patch Updates, Patch Set Updates)
    ➢ Set up and Creation of an Oracle Instance and DB(RAC and Standalone)
    ➢ Working on RAC setup and trouble shooting in RAC environment.
    ➢ Grid and Database Upgrade from 11.2.0.3 to 11.2.0.4
    ➢ Oracle Grid Patching
    ➢ Working on Exadata X-2,X-5,X-6 Machines
    ➢ Supporting Parts replacements activity for Exadata boxes .
    ➢ Migrating databases from normal machines to exadata machines .
    ➢ Using Srvctl and Crsctl utility for Managing RAC Environment.
    ➢ Basic working Knowledge on Oracle Golden Gate
    ➢ Using Oracle utility like ADRCI
    ➢ Working on flashback database features (creating GRP, Flashback DB to GRP)
    ➢ DB tuning and optimization of DB parameters
    ➢ Handling DB Performance Issues
    ➢ Manage table partitions (adding partitions, merge partitions, split partitions, exchange partitions )
    ➢ Create and manage Oracle ASM , add disks and remove disks from am diskgroups
    ➢ Monitoring and managing standby databases and Datagaurd using DGMGRL
    ➢ Working on 12c OEM grid control for managing and monitoring databases
    ➢ Providing Support to Customer on Change Requests, Incidents and service requests raised in remedy tool.
    ➢ Using traditional Export /Import and Oracle Data pump Utility
    ➢ User management
    ➢ Raise SR with Oracle support and work with Oracle Support engineers for Different issues.
    ➢ Performing Table Re-Organization activities.
    ➢ Use and understand AWR and ASH reports
    ➢ Using RMAN for performing different types of backups.
    ➢ Restore and recovery using RMAN
    ➢ Performing Cloning and restoration activities
    ➢ Working on Materialized View and Database Links
    ➢ Create shell scripts for daily monitoring purpose.
    Employment Details :
    1
    Current Organization: Vodafone India Services Pvt. Ltd

    Clients : Vodafone UK Telecom

    Duration : Apr 2015 – Till Date


    Role : Deputy Manager /Senior Oracle DBA
    Environment: Oracle 9i, Oracle 10g, Oracle 11gr2, RAC, 12c Grid OEM, Exadata x2, x5 ,X6 Machines
    Platform : Sun Solaris, RHEL, OEL

    Responsibilities:

    ➢ Working as a assistant Team lead/Deputy manager for the team of 12 DBA members .
    ➢ Also working as SME for oracle related issues within the team .
    ➢ Working on database migration to Exadata machines .
    ➢ Working on Exadata X-2,X-5 ,x6 Machines
    ➢ Moved around 150 TB Database from normal machine to Exadata machine.
    ➢ Providing Technical support to team members on databases related issues .
    ➢ Supporting any part replacement activities on Exadata machines (Hardisk failure ,flashdisk failure ,battery
    replacement)
    ➢ Working on critical Production, Test and Development Environments as Oracle DBA .
    ➢ Patch Management (one off patch, Critical Patch Updates, Patch Set Updates) for Oracle Rdbms and grid.
    ➢ Set up and Creation of an Oracle Instance and DB(RAC and Standalone) as a part of build activities
    ➢ Working on RAC setup and trouble shooting in RAC environment.
    ➢ Perform oracle Grid and Database Upgrade from 11.2.0.3 to 11.2.0.4
    ➢ Using Srvctl , Crsctl and adric utility for Managing RAC Environment.
    ➢ Working on flashback database features (creating GRP, Flashback DB to GRP)
    ➢ Handling DB Performance Issues
    ➢ Manage table partitions (adding partitions, merge partitions, split partitions, exchange partitions )
    ➢ Monitoring and managing standby databases and Datagaurd.
    ➢ Working on 12c OEM grid control for managing and monitoring databases
    ➢ Providing Support to Customer on Change Requests, Incidents and service requests raised in remedy tool.
    ➢ Performing Table Re-Organization activities.
    ➢ Use and understand AWR and ASH reports
    ➢ Using RMAN for performing different types of backups and recovery activities.
    ➢ Performing Cloning and restoration activities

    Previous Organization: Tata Consultancy Services Ltd.

    Clients: Best Buy Retail

    Duration : Nov 2014 – April 2015


    Role : Oracle DBA
    Environment: Oracle 9i, Oracle 10g, Oracle 11g,RAC,12c Grid OEM
    Platform : IBM-AIX, Sun Solaris, RHEL

    Responsibilities:

    ➢ Monitoring around 400 databases and Troubleshooting the errors and manage space for all databases .
    ➢ Working on RAC setup and trouble shooting in RAC environment.
    ➢ Monitoring and managing standby databases
    ➢ Working on 12c OEM grid control for managing databases
    ➢ Applying Grid Patch on 11gR2 and 12 c versions
    ➢ Applying PSU ,Bugfix patches on Rdbms.
    ➢ Handling Performance issues

    2
    Previous Organization: IBM India Pvt. Ltd.

    Clients: Vodafone India.


    Duration : Dec 2012 – Sep 2014
    Role : Oracle DBA
    Environment: Oracle 9i, Oracle 10g, Oracle 11gR2,RAC
    Platform : HP-UX, IBM-AIX, Sun Solaris, Windows, RHEL

    Responsibilities:

    ➢ Monitoring around 700 databases and Troubleshooting the errors, and manage space for all the databases
    ➢ Database Cloning using BCV server (db refresh of development/test database from production database)
    ➢ Creation and maintenance of partitioned tables (range),index partitions ,maintenance (deletion ,addition of
    partitions, index rebuilding)
    ➢ Working on DB Performance related issues
    ➢ Installation of Oracle software, CPU/PSU patching and binary (version upgrade) patching of databases
    ➢ Daily and monthly exports of normal, partitioned tables, import of tables.
    ➢ Installation and configuration RAC (11gR2) on AIX
    ➢ monitoring around 100 RAC databases and troubleshooting
    ➢ Migration of RAC database from 10.2.0.4 to 11.2.0.3
    ➢ Concepts of Oracle Data Guard
    ➢ Creating Users and assign roles, privileges and profiles to users
    ➢ Adding / Resizing data files if needed.
    ➢ Installing Oracle client.
    ➢ Taking cold and hot backups and level backups using RMAN.
    ➢ Resolve Oracle RAC cluster related issue – virtual ip issue, performance issues
    ➢ Create Database links, synonyms.

    Previous Organization: AMDOCS India Ltd.

    Clients: Globe Philippines


    Duration : JUL 2012 - DEC 2012
    Role : Oracle DBA
    Environment: Oracle 10g, Oracle 11g,
    Platform : HP-UX, IBM-AIX, RHEL

    Responsibilities:

    ➢ Worked as Sr. Database administration for setting up Tests, development, Production databases for Amdocs
    clients.

    Previous Organization: SOFTENGER (INDIA) PVT.LTD (AUG 2009 TO JUL 2012)

    Clients: Idea Cellular (Data Centre)


    Duration : AUG 2009 TO JUL 2012
    Role : Oracle DBA
    Environment: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g,RAC
    Platform : HP-UX, IBM-AIX, Sun Solaris, Windows, RHEL

    Responsibilities:

    ➢ Worked as a Shift lead so handle all shift, take handover from previous shift and distribute work

    3
    ➢ Working as database administrator on Critical production environment with more than 500
    production and test databases.
    ➢ Installing Oracle Server and Oracle client.
    ➢ Creating user Profiles Granting specific privileges and roles to the users.
    ➢ Maintaining table spaces & data files, Control files, Online Redo log files.
    ➢ Taking cold and hot backups and using Rman to take other backups.
    ➢ Creating Schema objects.
    ➢ Responsible for checking rman backup daily status and resolved failed rman backup issue.
    ➢ Applying Critical patches within down time (CPU, PSU and Oneoff) on standalone and RAC
    Database home and Grid home.
    ➢ Taking logical backup using exp or expdp.
    ➢ Monthend activity as per policy – adding table partitions.
    ➢ Purging activities – purges partitioned data as per policy and solve issue after purging.
    ➢ RAC Node troubleshooting – resolved cluster related issue – virtual ip issue, performance issues
    ➢ Refresh materialized views and keep SLA if necessary change the pointing.
    ➢ Create Database links ,Materialized views, and materialized views log.
    ➢ Working on assigned incident and RFC through BMC remedy tool.
    ➢ Monitor Dataguard
    ➢ VLANS and Re-org Activity – moving datafiles from one location to others.

    CERTIFICATION:

    ❖ Oracle Certified Associate – (SQL, Admin I)


    ❖ Completed Oracle Exadata Classroom training from Oracle University.

    Educational Details

    ❖ Bachelor of Engineering in Computer Science and Engineering from Shivaji University Kolhapur.
    ❖ Diploma In Computer Technology.

    Sr.No Degree University/Board Year of Passing Percentage


    1 S.S.C Pune Board March-2000 65.46 %
    Maharashtra India.
    2 Dip. in comp. tech B.T.E Maharashtra India. March-2004 63.62 %
    3 B.E Shivaji University March 2008 62.46%
    Kolhapur Maharashtra
    India.
    4 SQL Oracle Corporation

    Personal Details:
    Name : AATHIK GAFFAR MISTRY
    Permanent Address : G1, Devkinandan Apt, Vikas Chowk Sangli. 416416
    Temporary Address : Alcon Royce Apt, Nibm road, kondwa Khurdh Pune- 48 Maharashtra India.
    Date of Birth : 23rd August 1984
    Marital Status : Married
    AATHIK G. MISTRY
    Oracle DBA

    You might also like