Pankaj Y.

Expert on Oracle Database Admin. Experience In Oracle Database Management. High level capacity to build a database configuration and management. • Planned and implemented high availability solutions using Oracle 11g/10g RAC, Standby Database management. • Perform database software installation, configurations, patches, and upgrades Oracle 9i, 10g and 11g in various environments. • Implement Oracle Enterprise Manager Grid Control (OEM 10g/12c) for centralized monitoring and administration. • Experience in the Administration and Development of Client/Server applications using Oracle SQL, PL/SQL etc • Experience in applying Opatch and Patchset to the databases. • Experience in database performance monitoring, analysis and tuning. • Provided 24x7 production support for Oracle 11g/10g/9i databases on various platforms • Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Backup (Cold and Hot), Recovery, Cloning, Space management, Troubleshooting, Database Design, SR support, Unix Shell Scripting and Documentation • Experience in creating users, configuring grants, roles, privileges and managing tablespaces. • Expertise in Oracle Backup and Recovery for a VLDB. • Experience in Data Migration using RMAN and Oracle Data Pump, Export/Import • Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups • Managed very large size database of maximum size more than30TB • Implement, Maintaining and Troubleshooting High Availability Architecture(DR Planning and Solution) • Proficient on Physical Standby configuration and management 10g/11g. • Experience in RAC 10g/11gR2 configuration on Linux/Solaris/windows platform. • Manage Disaster recovery and full database RMAN recovery. • Proficient in physical standby database, Snapshot standby and active dataguard • Experience on conversion from Physical standby database to snapshot standby database. • Database Administrator proficient at supporting Oracle installations which require real time data replication using GoldenGate Transaction Data Management Tool. • Expertise in Replication and Extracting data and applying on production using GoldenGate. • Running backups HOT/COLD/full, Incremental backup from the GRID control • Knowledge on Oracle support process for technical requests using Metalink and other support features • Experience in crontab, Active Batch, job scheduling and management tool. • Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases • Experience in data integration and data movement and using oracle Sql*Loader, External table, Export Import utility. • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. • Experience in database query tuning performance tuning using various techniques analytical functions, with clause, Indexes, Partitions, Clusters, explain plan, TKprof.