Mohinder Pal Singh Chopra
Sr. Oracle DBA, having more than 12 years of strong experience
Last active: 12/18/2013
Oracle 10g/11g Certified Professional, having more than 12 years of experience as an Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like day-to-day support, database design database administration and building large OLTP/OLAP databases on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (8.0.5, 8i, 9i, 10g, 11g), Developer 2000/6i, SQL net, SQL*Plus, Pro*C etc.
: Expertise in 10g/11g/12c Grid Control. Installing / implementing OEM 10g/11g/12c Grid Control Management Server and Agent with 10g Repositories to manage 600+ targets( Database include primary and stand-by databases , Grid Control Agents, Server , 9i/10g application server components on more then 100+ server )
: Great experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN, Data pump (expdp, impdp) Export/Import and Transportable Tablespaces.
: Oracle RAC and ASM expert. Hands On Experience in installing, configuring and managing Oracle 11g RAC and 10g RAC. Experience in planning, designing, developing, deploying, maintenance and supporting RAC on Linux (RHEL), Sun Solaris & Windows NT servers for high availability (HA). Patching/upgrading RAC Nodes with 10g/11g Oracle Versions.
: Hands on experience in Oracle Data Guard (9i/10g/11g) both logical & Physical Standby experience on Unix & Windows NT servers.
: Expertise in Environment using Oracle Veritas HA Cluster and Cluster automatic failover configurations.
: Sound Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, PL/SQL, Involved in optimizing SQL queries.Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof : Strong experience in tuning database performance from system as well as query tuning perspective.
: Working experience with Very-Large databases (VLDB) up to 20 terabytes, data migration against Oracle & other databases such as SQL Server.
: Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.
: Extensive experience with Oracle Database Migration/Upgrade.