Over 6.5 years of experience as an Oracle Database Administrator. Involved with the databases from design, development, implementation and administration, which includes installations, support, troubleshooting, backup & recovery, testing, networking, monitoring & managing of users, performance tuning of databases on Oracle 9i/10g/11g /12c using RAC, Oracle Dataguard, Exadata, Oracle Tools, Oracle Enterprise Manager 12c on Linux/Unix & Windows platforms, RMAN on EMC, netbackup, Avamar, IBM Tivoli.
• Oracle Certified Professional DBA, Oracle Certified Expert in RAC and Grid Infrastructure Administration.
• 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.
• 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 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.
Senior Oracle DBA @ • 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. From June 2014 to Present (1 year 7 months) Hartford, Connecticut AreaIT Analyst @ • 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. From December 2010 to June 2014 (3 years 7 months) Indianapolis, Indiana AreaOracle RAC DBA @ From July 2010 to December 2010 (6 months) Noida Area, IndiaOracle DBA @ From June 2008 to July 2010 (2 years 2 months) Noida Area, India
Btech, Computer Science @ Uttar Pradesh Technical University From 2004 to 2008 Anuj Kumar is skilled in: Oracle RAC, Performance Tuning, RMAN, High Availability, Linux, Patch Management, AIX, AWR, OEM, Oracle ASM, Capacity Management, HP-UX, Production Support, Oracle Grid, Private Cloud, Virtualization, Oracle Enterprise Manager, Exadata
Websites:
http://www.cognizant.com