Oracle Data
Resume:
Mrinal Kumar
OCP Certified (DBA)
Oracle id-oc0916807
Passport no-j5001420 (INDIA)
Oracle Exadata certified
Oracle RAC
Oracle streams
Oracle Apps (11i/r12)
Total Experience- 4.2 years
H1-B VISA (USA) Admit Until Date-09/30/2015
Working HCL AMERICA
JOB TYPE (PERMANENT)
***************@*****.***
Experience Profile:
• Certified OCP/10G/ORACLE EXADATA professional with experienced in installation and
creation of databases, database administration for Oracle 9i/10g and 11g
• Expertise in performing logical backups using export and import Utilities, performing Physical
(Online and Offline) database backups, Flashback Database, Flashback Query, Flashback Table,
administration of Backup and Recovery (Logical and Physical), creating clone and standby
databases and configuring / managing Data Guard
• Experienced in Table space management and user management
• Planned: logical and physicaldatamodeling,normalization,replication,integrity,security, Capacity
Planning: performance analysis of database servers and storages in standalone and clustered
environment
• Experienced in undotablespace management. Implemented multiplexing of control files & redo
log files. Good understanding of all type of startup and shutdown process. Monitoring RAC
database with SRVCTL
• Good knowledge of managing schema objects
• Experienced in monitoring the users sessions/locks/blocking sessions and taking appropriate
steps to increase the performance.
• Good understanding of Oracle Exadata and HCC (high columnar compression ratio)
• Creating and managing the ASM database
• Performed DB cloning using RMAN, Transportable table space with Data pump
• Knowledge of data warehouse on Oracle11g
• Worked on servers like Oracle Exadata/HP superdome/IBM /SUN/INTEL32bit,64bit
• Operating system: Aix/Solaris/HP-UX/LINUX
• Experienced in programming: shell script/sql/plsql/RMAN
• Backup/Recovery: Rman/User Managed Backup /Recovery
• High Availability: RAC/CRS/Grid Infrastructure/Data guard/Replication/ASM
• Tuned operating system/network/database parameters/SQL/plsql
• Worked with OEM / DB verify / Log miner / Tkproof / SQL*Loader / import /export/Data
pump/AWR/ADDM
• Knowledge of oracle streams 11g(CDC change data capture), Golden gate data replication, RAC
setup and experience in RAC environment & RAC like configuring SAN & NAS servers
• Knowledge on RMAN Utility and Log Miner, Tivoli
• Worked with various O/S like Linux, Solaris, & AIX
Technical Competency:
Software Oracle DBA 9i/10G/11GR2, PLSQL, Java, Oracle RAC, Oracle Data Guard,
Oracle BI (Business Intelligence Tool), Backup/Recovery, Oracle Exadata,
ERP, Oracle RMB (Revenue Management BI), Oracle Apps
O/S Linux, UNIX, Windows, Solaris
Education:
• B.Tech. (Computer Science Engineering), Chandigarh Eng. College, Landran,
Mohali, India
Certification:
• Oracle Certified Professional (OCP)
• Oracle Exadata Certified
Professional Experience:
HCL America December 11 – Till Date
Merck, NJ
Role - Oracle DBA
Responsibilities Managed:
• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Tables
paces and Temporary TS etc.
• Implemented nightly backup routines, which includes Oracle Managed Backups complete and
incremental methods to optimize the time-window for backups.
• Created users, roles, profiles & audited users according to the application requirement.
• Implemented ARCHIVELOG process to produce local and remote Archive log files with Multiple-
Archive log Destinations for high-availability of the Database.
• Performed Weekly stats gathering activities
• Performed weekly rebuild partition index
• Managed threads for CDR(core database repositories) database
• Tuned the DOP value according to instance work load
• Managed data flow for the database users
• Created views as per the users requirement
• Monitored CDC with oracle streams
• Managed primary database with standby database during DR exercise
• Refreshed database and data load
• Managed Temp table space/undo table space for various database
• Worked with three main repositories OMDB(One Merck Database) / CDR(Core Database
Reposetories / AERECON
• Managed 25 databases, partition/sub partition/exchange & partition for data warehouse
• Managed RAC instances and data guard standby server
• Reported to business during database audit logs.
• Coordinated with onsite and offshore team members
• Understood the users requirement by meeting schedule
• Managed the many application issue and ora error with users.
• Resolve SAS issue to connect oracle / exadata servers
• Estimated table space size
• Tuned the plsql procedure with developers by doing analysis for execution plan
• Created many shell scripts for database monitoring
• Checked invalid objects for databases and making it valid with scripts
• Monitored chained rows and migrated rows
• Monitored unusable indexes for IT/DEV/PRODUCTION database
• Loaded Medical data from worldwide by estimating the database and new data ratio
• Provided security with creating users and password profile according to policy26
• Explored optimum utilization of exadata cell index & HCC(COLUMNAR COMPRESSION)
• Monitored and deployed the TNS and LISTENERS For RAC database
• Monitored RMAN
• Transported the Table space from production database and plugged-in it in development
database for the usage of developers
• Extensively used Export /Import utilities for selective Backup and defragmentation
• Monitored the Database growth and increase the table space size in production database
• Installed Oracle 11g on Linux
• Created the Private, Public and Global database link
• Flashback Database, Flashback Query, Flashback Table
• Created primary database storage structures (Table spaces) as required, modifying the database
structure, as necessary, from information given by the application developers
• Created Nonstandard Block Size Table space
• Regular Monitored Alert log Files on Day to Day Basis
• Monitored Table spaces/Tables/Indexes
• Enrolled users and maintaining system security. Controlling and monitoring user
• Involved in data transfer using export/import
• Kept the system highly available i.e. 24hours*7days of a week.
• Created and maintained database links for data transfer
• Export/Import, Standby physical database Data loading using sql loader
• Recovery of database in various cases of media failure.
• Involved in managing and maintenance of space allowed
Environment: Oracle 11g, Oracle Exadata, SQL*PLUS, SQL*NET, OEM, SQL*Loader,
Import/export/data pump/Toad, Linux /UNIX
IT PROINFORMATIONS, India September 09 – December 11
E Planet Solution Pvt. Ltd
Role – Oracle DBA
Responsibilities Managed:
• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Tables
paces and Temporary TS etc.
• Implemented nightly backup routines, which includes Oracle Managed Backups complete and
incremental methods to optimize the time-window for backups.
• Created users, roles, profiles and Auditing of Users according to the application requirement.
• Implemented ARCHIVELOG process to produce local and remote Archive log files with Multiple-
Archive log Destinations for high-availability of the Database.
• Transported the Table space from production database and plugged-in it in development
database for the usage of developers
• Extensively used Export /Import utilities for selective Backup and defragmentation
• Monitored the Database growth and increase the table space size in production database
• Installed Oracle 10.2.0 on Linux
• Created the Private, Public and Global database link
• Flashback Database, Flashback Query, Flashback Table
• Created primary database storage structures (Table spaces)
• To the companies requirement, modifying the database structure, as necessary,
• From information given by the application developers
• Created Nonstandard Block Size Table space
• Regular monitored Alert log Files on Day to Day Basis
• Monitored Table spaces/Tables/Indexes
• Enrolled users and maintained system security.
• Controlled and monitored user
• Accessed the database
• Data transfer using export/import
• Kept the system highly available i.e. 24hours*7days of a week.
• Created and maintained database links for data transfer
• Export/Import, Standby physical database Data loading using sql loader
• Involved in recovery of database in various cases of media failure.
• Involved in managing and maintenance of space allowed
Environment: Oracle 10g/9i/11g, SQL, PL/SQL, Shell Scripting, RAC, SQL*Plus, SQL*NET,
SQL*Loader, Import, Export, Data pump, OEM, TCP/IP, NFS, NIS, Windows
NT/XP, Linux, Solaris, AIX
Permanent Address-
MRINAL KUMAR
S/0-DR.T.P.SINGH
#36, NEW READERS COLONY
MUZAFFARPUR, BIHAR
CIVIL STATUS-INDIAN, MALE, SINGLE
LANGUAGE KNOWN-ENGLISH, HINDI
DATE OF BIRTH-06/SEPT/1986
FATHERS NAME- TARUNESHWAR PRASAD SINGH
Current Address
Mrinal Kumar
2 West Warren Street, ISELIN
New Jersey, 08830
USA
DATE:
PLACE: NEW JERSEY (USA)
Contact this candidate