PINAKIN PATEL                                                                   
                      
 [Send email to request phone number] 10-4032      	
[Send email using form at bottom]					               ORACLE/RAC DATABASE
ADMINISTRATOR

PROFESSIONAL SUMMARY:

•	Over 5 years IT experience in Oracle products, both production and development
environments spanning several industries: health care, insurance, financials,
telecom and high- tech.
•	Hands on experience in test, production and development databases. 
•	Worked as a team lead to provide 24x7 on-call production database supports and
leading the team.  
•	Extensive knowledge on database administration for Oracle 8i, 9i and 10g, with
experience within very large scale database environment and mission critical
large OLTP and OLAP systems.
•	Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure,
Listener, TNSNames, SQLNet, V$ and DBA views.
•	Expertise in Unix Korn Shell scripting, and good knowledge in Perl scripting.

•	1.5 years of RAC (9i and 10g) with proficiency in setting up and administering
10g RAC.
•	Procedures, Creation of database, cluster, Maintenance and Troubleshooting 
•	Expertise in supporting client server GUI software and Operating system. 
•	Extensive experience in Dataguard, Grid control.
•	Experience in a variety of hardware and software platforms including;
MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX
•	Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using
tools/utilities like ESTAT/BSTAT, Statspack, Tkprof, Explain plan, Analyze, AWR
and ADDM
•	Performance tuning and diagnosing DBMS and individual database. 
•	Experience in implementation of enterprise databases on enterprise Storage
Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
•	Expertise in Oracle Enterprise Manager (OEM), Grid Control.
•	Write and modify UNIX shell scripts, Perl scripts   to manage Oracle
environment.
•	Extensive knowledge on database backup/recovery strategy (RMAN), VERITAS Net
Backup, Import/Export & Datapump), Capacity Planning, Standby databases using
Netapp filer/Snap Mirror, Shareplex, Oracle configuration management, Dataguard,
database cloning, refresh and patch management.
•	Good co-ordination and communication with system administrators, business data
analysts and development teams
•	Experience in recovering the database in case of failure (Complete/Incomplete
recovery)


TECHNICAL ENVIRONMENT:

OPERATING SYSTEMS:	HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1,
5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.
RDBMS:	Oracle 10g/9i/8.x/ Oracle 10g Real Application Clusters (RAC)
LANGUAGES:	SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting, Perl.
SOFTWARE / APPLICATIONS/ TOOLS: 	ORACLE 8.x/9i/10g,OAS 10g Recovery Manager
(RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, Clusters, Veritas
Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager
WEB TOOLS	HTML, XML






PROFESSIONAL EXPERIENCE:

Client: HerbaLife, Los Angeles, CA.                   	                    		   
            January 2008 to Till Date
Role: Oracle Database Administrator

Responsibilities:
•	24x7 production support for several mission critical systems which utilize
multiple Oracle databases. 
•	System Study & Analysis, Design &Development.
•	Coordinate with UNIX administrators for space management on various servers.
•	Installed Oracle 9i and 10g, RAC database on Windows, Red Hat Linux.
•	Installed RAC on Oracle 10g and worked on ASM feature of Oracle
•	Installation of ASM into various storage parameters like SAN and NAS.
•	System Study & Analysis, Design &Development.
•	 Installation, Configuration and Maintenance of Oracle RDBMS Software.
•	Upgrading databases to Oracle 10g from Oracle 9i.  
•	Creating and maintaining the Oracle databases.
•	Created and managing the database objects such as tables, indexes and views.
•	Table Partitioning, creating Index Organized tables, Creating Locally managed
Table spaces. 
•	UNIX Shell scripting in (cshell) csh, (korn shell) ksh for automating
startup/shutdown of databases, getting system alerts. 
•	Applying patches both Server side and Client side. 
•	Setting up new environments (Development, Production etc).
•	Database Sizing, Tablespace Management and Rollback Tablespace Management,
Transaction Management and Security Administration
•	Created Users, Groups, Roles, Profiles and assigned users to groups and
granted privileges and permissions to appropriate groups. 
•	Manage users, privileges, profiles, schemas using Grid Control of Oracle
Enterprise Manager (OEM)
•	Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold
and Logical backup plans. 
•	Worked on import/export and SQL- loader.
•	Setup backup and recovery procedures using RMAN. 
•	Involved in I/O tuning by moving data files and redo log files to faster
disks.
•	Used analyze table, analyze indexes to tune queries and increase performance.
•	Used hints for SQL tuning and optimization.
•	Performed Explain Plan analysis for Query Optimization and SQL tuning
•	Performed Database and SQL tuning by using various Tools like STATSPACK, AWR,
TKPROF, EXPLAIN PLAN, and optimizer hints.  
•	Responsible for all database activities such as space management, database
security management, rollback segments & creation of DB links between two oracle
servers.


Environment: Oracle 9i/10g, SQL, PL/SQL, Oracle Grid Control, Oracle 10g RAC
TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux, UNIX,
AIX.






Apollo Industries, Gujarat, India                   					            June 2005 –
December 2006
Role: Oracle Database Administrator

 

Responsibilities:
•	Created test database and its application table spaces. Created admin users
and granted the role to the users with high level security to protect the
database from unauthorized access.
•	Provided high degree of coordination between user, technical and  application
to ensure effective database management
•	Performing day-to-day database administration tasks like Tablespace usage,
checking alert log, trace files, monitoring disk usage, Table/index analyze jobs,
database backup logs etc.
•	Implemented Index organized tables to improve the performance.
•	Co-ordinate with UNIX Administrators for space management on various servers
and help in Oracle insatallation, upgrading according to the standards & Quality
assurance.
•	Synchronize Databases with production for data and testing purpose. 
•	Involved in Database Security monitoring, Database Logging & Auditing.
•	Involved in Design and implementation of oracle 10g Dataguard both
physical/logical standby databases.
•	Help Development team for technical issues related to database issues.
•	Creating the database schema, converting VIEWS specific to database.
•	Development of backup and recovery procedures and Import and Export of Data
(Logical Backup) and RMAN and Database cloning
•	Creation of the Test database, Table spaces, Tables and Indexes, Index
rebuilding. 
•	Application tuning using Explain Plan, Tkprof and SQL trace facilities. 
•	Tuning of I/O to reduce disk contention by distributing I/O
•	Assisted in configuring STREAMS.
•	Creating roles and users and Space management.
•	Experience developing and refining data models and data processing
environments.
•	Optimize databases queries and recommend tuning enhancements.
•	Performed troubleshooting of the database.
•	On-going SQL tuning using Explain Plan and SQL Trace
•	Supporting Developers and QA testing.
•	Involved in writing shell Scripts for Backup and recovery methods
•	Database maintaining including backups, restores, imports, exports
•	Data migration, loading with SQL Loader
•	Extracting data from different databases and maintaining.
          
Environment: 
Oracle 10g/9i, Red hat Linux, OEM, SQL PLUS, PL/SQL, RMAN, TOAD.