Anuj Kumar Email & Phone Number

California, United States

Sunnyvale, Ca, Us

Sunnyvale, Ca, Us

Sunnyvale, Ca, Us

Hartford, Ct, Us

• Extensive Experience in Database Administration (9i to 11gR2, 12c), RMAN backup and recovery, MAA architecture comprising Oracle RAC, ASM, Dataguard (Physical, Logical, Snapshot and Active).• Basic understanding of NoSQL databases and Hadoop clusters.• Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.• Experience in writing UNIX Shell Scripts with Linux Redhat AIX flavor and scheduling Cron Jobs.• Extensive experience in Oracle Streams and Golden Gate Active/Active replication for zero downtime migration and upgrades.• Extensive experience in Oracle Database migration and consolidation using various methodologies like Oracle Transportable Tablespaces, Split Mirror techniques for very large database migrations, Oracle datapump and RMAN.• Highly skilled in Oracle Dataguard Technology, Active Dataguard, Dataguard Broker and managing physical/logical standbys which are being currently used in client systems for data replication, availability, reporting and disaster recovery.• Highly skilled in Real Application Clusters and Grid infrastructure implementation and administration. Also have intermediate level of knowledge in Oracle Exadata environment.• Extensive experience in capacity and resource planning for database infrastructure as well as database memory management using techniques like Huge Pages, Oracle ASMM/AMM.• Extensive experience in performing disaster recovery drills of critical databases by recovery using multiple kind of backups.• Extensive experience in managing OEM 12c cloud control including managing/upgrading OMS, managing OEM agents, implementing organization level monitoring as per business needs, automating database patching, upgrades using OEM 12c.

Indianapolis, Indiana, Us

• Provide 24*7 database supports for around 500 Mission Critical Manufacturing Applications and Databases running mostly on MAA with RAC, ASM and Dataguard.• Installed, configured and managed 11g RAC databases on 4 node cluster.• Configuration of SCAN in 11gR2 RAC.• Migrated non-asm databases to asm.• Managed databases on HA configuration using Veritas clustering.• Design and support Physical and Logical Standby Databases and Active Dataguard for highly available critical reporting systems used at various sites.• Deployed application databases on Metro HA using EMC VPLEX mirroring techniques as well as VMware. • Responsible for oracle software installations, database design, database migration, data loading, database upgrade, backup and recovery, databases refresh, consolidation, capacity and resource planning etc.• Applying patch sets and routine security patches.• Monitor database utilization and capacity to meet application demands.• Excellent hands on experience in managing RMAN Backups.• Configuration of Oracle/RMAN backup on NFS, VERITAS netbackup, EMC Avamar.• Managing ASM instances, adding/migrating disks, rebalancing etc.• Decommissioning of Database as per Customer requirements. • Database Cloning with RMAN and cold backup to create duplicate databases.• Proactive performance tuning and recommendations implementation with the help of advance oracle features and performance tuning tools like AWR, ADDM, SQL Tuning Advisors, Access Advisors, STATSPACK, SQLT, SQL Monitoring, SQL Plan Management.