SUMMARY

• Have 8.10 years of experience in Oracle Database Administration ( DBA).
• Have worked on Oracle 8.x/9.x/10g/11g databases with Unix, Linux & windows platforms
• Experience in database migrations on Exadata Database Machine (X4 - 2), Oracle 11gR2 RAC installation on Oracle Linux, Oracle RAC administration, Oracle database software installation, database creation, database upgradation, database cloning, backup/recovery/disaster recovery, Database/schema/tables refreshes using Expdp/Impdp data pump utilities, Performance tuning, Database characterset change, space management, user management, knowledge of data guard.
• Ability to handle the project/issues independently, effective client communication and co-ordination, well acquainted with the processes.

TECHNICAL SKILLS

Operating Systems: - Sun Solaris 5.10, Oracle Linux 5 & 6, Red Hat Linux 9, RHEL 4/5, Windows

Tools: - Oracle Enterprise Manager, Oracle 10g Application Server, TOAD, PuTTy, BMC Remedy 7.5

Databases: - Oracle 8i, 9i, 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential, NJ

Database Administrator

Responsibilities:

• Gathering all the database related information for sizing the Exadata Machine.
• Assisting the Oracle & Technical architects for designing the architecture for the databases on Exadata Database machine which involves db instance segregation across the db nodes, CPU COUNT allocation per db instance for instance caging, SGA/PGA parameters sizing, services design for each databases, backup strategy etc.
• Preparing the impact analysis from DBA point of view for the database migration.
• Developing the database migration approach from existing stand alone servers to Exadata Database Machine.
• Involvement with project team to prepare the migration schedule, strategy.
• Involvement in UAT, performance assessment.
• Performing the actual database migration which includes Database creation, setting up initialization parameters, services creation, scan listener setup, storage allocation, large pages settings, database export at source using data pump expdp, transferring the dump files from source to Exadata using parallel secured copy method, performing prechecks before import, consolidating the tnsnames.ora file from each source db server & copying on Exadata db servers, importing the dumpfiles in Exadata db using data pump impdp, post validation which includes rectifying import errors, row count match, objects comparison, invalid object comparison, db link verification, db connection testing using services, modification of tns entries at Application servers like Informatica & OBIEE & provide DBA support to project team after migration.
• Database characterset change from US7ASCII TO WE8MSWIN1252. This involves running the csscan reports to identify the lossy data & appropriate characterset, working with project team to test the lossy data from application tools before change, plan the activity, change the characterset, lossy data verification from application tool after characterset change.
• Involvement in design phase with development team to decide the table structure & partitioning approach.
• Deciding the strategy to bring the historical data from 16 source systems & consolidate it in its respective single table on target datawarehouse system.
• Schema set up & object creations as per the design document.
• Extracting the data from source system using data pump utility & consolidate it by creating dynamic Insert statements.
• Involvement in UAT with development team for the performance benchmarking.
• Production migration planning & implementation.
• Infant care support during post GO-LIVE phase.
• Creating 2 Linux based machines using Oracle Virtual Manager & do the configuration related to network, storage, packages required to setup Oracle RAC env. by coordination with Infrastructure team.
• Installing the 11gR2 Grid Infrastructure & Database software on the 2 node Oracle Linux machines.
• Creating the databases & configuring the schemas/objects for the applications selected for POC, setup the connectivity.
• Preparing database server env by installing Oracle database software, database creation, tablespace creation, schema, object creation & backup configuration.
• Installation of Oracle 10g application server for forms & reports.
• Requirement gathering, Involvement with project team to prepare the migration schedule, strategy, coordination with infrastructure team.
• UAT migration, code migration.
• Onsite-offshore DBA team coordination.

Confidential

Database Administrator

Responsibilities:

• Oracle installation & database creation in 10g, 9x & 8i on Red Hat Enterprise Linux 4, Red Hat Linux 9, Windows 2K/NT platform.
• Implemented Disaster Recovery solution & the task involve regular sync checkup of Standby databases with the Primary database.
• Upgraded Oracle software & database version from 10.2.0.1.0 to 10.2.0.3.0
• Formulating and implementing backup and recovery strategy, routine maintenance, Database Reorganization, I/O Distribution.
• Administration of Tablespaces, Users management, Privileges and Roles & database links
• Transporting data between databases using Export and Import utilities
• Management of Client-Server network connectivity

Confidential

Database Administrator

Responsibilities:

• Installation of Oracle 10g, 8i & database creation on Red Hat Enterprise Linux 4, Red Hat Linux 9, Windows 2K/NT platform
• Created cloned databases for development & testing purposes using Database Cloning Method.
• Managing Tablespaces and Data files, Control File and Redo Log Files
• User managed Backup and Recovery of databases.