Summary

* Over seven years of experience in Oracle environments as ORACLE

DBA/Developer.

* Implementation of various databases and database schemas intensively.

* Implemented Oracle Streams between different database servers between US

and Ireland on Oracle 10g.

* Experience in Data ware house environment. Intensively used sql loader.

* Monitored the Oracle streaming on daily basis

* Intensively worked on RAC environment.

* Vast experience on Unix and Linux servers.

* Installed and maintained Oracle 8i, Oracle 9i and Oracle 10g,Oracle 11g

database server on various platforms.

* Installed Sql Server on different window servers.

* Performed migration of Oracle version 8i, 9i to 10g release 2 RAC based

environment.

* Experience in working with RAC environment.

* Created and configured Dataguard (Standby Database)

* Experienced in Oracle 8i/9i/10g features (RMAN, Data Guard, and Standby

Database).

* Experience in taking HOT and COLD backup of the database and also the

individual tablespaces.

* Experience in Backup & Recovery techniques using RMAN.

* Implemented different backup policies for different servers using RMAN.

* Restored and recovered the databases in case of disk crash.

* Taken different type of backups on Sql Server.

* Experience in installing patches for upgrades and for various problems.

* Performed the upgradation of Oracle version 8.1.7.4 to version 9.2.0.1

and from 9.2.0.1 to 10.2.0.4

* Experience in taking Remote export due to non availability of space in

legacy servers.

* Experience in taking logical backups of data using oracle data pump

utilities expdp and impdp, to move Oracle data from a database or schema

to another.

* Experience with AIX, HP-UX, Solaris, Linux and Windows NT.

* Experience working with 24x7 production support.

* Creating roles, profiles, privileges and assigning roles to users.

* Extensively worked on monitoring and optimizing the database by

performance tuning

* Monitor usage of the databases and perform database tuning.

* Experience in SQL TRACE and TKPROF.

* Extensive experience in Oracle Partitioning.

* Involved in database monitoring activities using STATSPACK.

* Extensively used tools like SQL*Loader, Toad, SQL developer, Oracle

Enterprise Manager (OEM).

* Documented most critical procedures and trained backup staff to run them.

* Managed Undo Segment in order to avoid "Snapshot too old"

* Worked intensively on Auditing of databases.

* Configured listener in UX 11.11 and Windows NT environment.

* Creating B-Tree Index, Bitmap Index, Reverse Key Index, List Partition

and Range Partition as per requirement for particular table.

* Analyzed Tables, Indexes periodically to optimize the SQL queries.

* Developing UNIX shell scripts and Perl scripts and SQL scripts to carry

out routine checks on databases.

* Monitored indexes and analyzed their status for performance tuning and

query optimization.

* Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL

statements to extract data from the legacy application in the form of

flat files and load the extracted data into the new application.

* Extensive knowledge of Relational Database Management Systems.

* Experience in Oracle Server installation, configuration, performance

tuning, client/server connectivity, query optimization, backup/recovery.

* Experience in working high-transacted OLTP systems.

* Experience in Tablespace management both local and dictionary

* Experience in resource management like data files, online redo log files,

control files, and allocating logical storage structures like

tablespaces, segments and extents

* Implemented proactive monitoring scripts for production databases.

* Extensive experience in writing SQL queries, Stored Procedure, Function,

Views, Triggers.

* Expertise in handling errors using Exceptions.

* Proficient in managing Oracle Instance, database storage structure,

schema objects.

* Experience in Automation of tasks using scripts for creation of database

and configuration of dataguard.

* Knowledge of Automatic Workload Repository (AWR).

* Used dbms_job, dbms_scheduler to schedule the jobs.

* Experience in generating statistics of database using ADDM.

* Participate in planning and implementation of off-site Disaster Recovery

planning and testing. Monitor databases for performance and tune

accordingly

* Strong Knowledge of Creating Public Synonyms.

* Highly motivated, optimistic, excellent team player, enthusiastic, strong

initiative and quick learner of new technologies, Strong interpersonal

and communication skills in dealing with customers.

Technical Skills

Category Technology

Database Skills Oracle 7.x/8i/9i/10g, MS Access

SQL, PL/SQL

Backup planning and implementation

Performance Monitoring, Analysis and Performance

Tuning

Database Recovery (DR) strategy planning and

implementation

Capacity Planning and implementation

Partitioning, Replication, and Standby Database

Administration

Installation, Patch, Upgrade, & Migration

ODBC, JDBC

Operating Systems UNIX (Sun Solaris 8,Sun Solaris 10, 9/HP/AIX4.3),

Red Hat/Fedora Linux,HPUX-11.23

Windows NT/2000/2003

Applications Erwin 3.5/4.1,Oracle Designer 8i/9i/10g

PL/SQL Developer 5.2/7.0, SQL *PLUS, SQL loader

Oracle Management Server (OMS), Oracle Enterprise

Manager (OEM)

Oracle Utilities (Import / Export, SQL*Loader, 10g

Data Pump)

Toad8.5, Quest Central (Spotlight etc.)

Veritas Netback up 5.3/6.0

Crystal Report 8.5/9/10,

Humming Bird

Language UNIX Shell Scripting,SQL,PL/SQL.

Protocols FTP, SFTP, Ssh, Telnet, TCP/IP

Education:

* Masters in Computer and electrical science from NYIT, New York.

Certifications

* Oracle Certified Associate in Database Administration.

* Brainbench Certified Associate PL/SQL Certification.

* Brainbench Certified RDBMS Concepts.

* Brainbench Certified Oracle 9i Administration

* Brainbench Certified Oracle 10g Administration

Professional Experience:-

US Army

Sep 2009-Nov 2010

Role: IT Specialist/Automatic Logistic specialist

Description: US Army is one of the biggest organizations in the world with

highly complex and vast database. As IT specialist responsibilities include

maintaining computer system which include maintenance of databases,

networking and programming.

Responsibilities:

* Application development support to programmers on all aspects of database

programming

* Implemented various databases and database schemas.

* Installed and maintained Oracle 8i, Oracle 9i and Oracle 10g and Oracle

11g database server on various platforms.

* Performed migration of Oracle version 8i, 9i to 10g release 2 RAC based

environment.

* Loading data into Database using the SQL Loader, Export, UNIX shell

script Batch File and managed system Events and Jobs using OEM.

* Supported Developers to write PL/SQL codes more effectively.

* Highly Used DBMS_STATS to gather statistics inorder to enhance the

overall Database performance.

* Improved backup processes resulting in one-minute (downtime) cold

backups.

* Used AWR and ADDM to gather statistics for performance tuning

* Granted Roles and Privileges to users

* Applied Patches during the time of up gradation.

* Vast amount of experience on Unix servers. Most of the database

maintenance and routine tasks have been performed with the help of unix

shell scripting.

* Extens0ively used Crontab for scheduling routine tasks

* Created both b-tree and bitmap indexes for better performance

* Monitored the usage of index and tuned the slow running SQL Queries.

* Creation and maintenance of test schema

* Developed RMAN scripts for database backup and recovery including hot and

cold backup options for both RAC and stand alone instances

* Perform production system problem analysis and recommend corrective

measures in a timely manner

* Strong experience with Unix and a strong ability with Unix shell

scripting

Environment: Oracle 10.2.0.2, Sun Solaris 9, TOAD, OEM, SQL Developer,

Stats pack, TKPROF, Putty, FTP, SFTP SQL, RMAN, Windows NT/2000, Erwin

BAKER HUGHES, HOUSTON

Dec2007 -Aug2009

Role: Sr. Oracle DBA

Description: Baker Hughes is one of the biggest Oil Company. It has large

member networks and provides service all over the world.

Members/Providers/claims data is maintained in Oracle Database. As DBA

responsibilities include maintaining databases, applying patches, monitor

daily database activity, implement customer requirements, coordination with

UNIX team for any support. Storage estimates, testing performance with

tuning SGA and application code, implementation and maintenance.

Responsibilities:

* Installed and maintained Oracle 10g database server on Solaris 9.

* Implemented Oracle Streaming.

* Intensively worked on RAC environment.

* Monitored Oracle Streaming on daily basis. Resolved streaming errors on

daily basis.

* Created and configured Physical Standby database

* Upgraded 9.2.0.1 to 10.2.0.4 on window and Solaris 9 servers.

* Developed Database Backup and Recovery strategies.

* Worked on more than 1 TB of Data

* Involved in the designing of databases and developed the ER Diagrams

with ERWIN and Oracle Designer

* Applied Oracle Patches periodically.

* Managed RAC and Dataguard instances

* Worked with the development team and infrastructure teams in developing

a logical and physical model of the database

* Performed database tuning, application tuning and performance

monitoring using STATSPACK, EXPLAIN PLAN and TKRPOF.

* Recovery of database in case of database crash, disk /media failure etc

* Created Roles and assigned to different users.

* Configured STATSPACK and collected periodical snapshots

* Intensively used DBMS_JOB and DBMS_SCHEDULER to schedule the jobs

* Developed Proactive monitoring scripts for the database and OS

* Deployed Oracle Database Security using administrator defined roles and

privileges.

* Designed and implemented Backup and Recovery strategies for Oracle

database using DATA PUMP Utilities and RMAN Utilities.

* Used SQL Loader, Export, and UNIX shell script Batch File and managed

system Events and Jobs using OEM.

* Performed system auditing, capacity planning and ensuring security

policies are implemented

* Implemented two-node parallel RAC environment of the production

database instance.

* Performed general technical troubleshooting and give consultation to

development team

* Scheduled shell scripts for Physical and logical backup of Oracle

Databases

* Monitored database cluster, application cluster and other RAC

components using Oracle Enterprise Manager

* Managed migration of Enterprise Data Warehouse (3 Terabyte) from HP-

Unix to AIX platform..

Environment: Oracle 8.1.7.4, Oracle 9.2.0.6 and Oracle 10.2.0.1, RH8

Linux, Sun Solaris 8/7, AIX 5.2, Windows NT/2000, SQL Developer, OEM, TOAD,

Oracle Designer.

NYIT

Aug 2006-July 2007

Oracle Developer/DBA

Description: Worked as graduate assistant in university.

Responsibilities:

* Installing and maintaining Oracle 9i database server software at Windows

XP and RH8 Linux, including RDBMS, Apache servers, patching software,

configuring clients.

* Worked on Data ware house environment.

* Installing, configuring and managing Oracle 9i RAC cluster, Oracle

Enterprise Manager, Oracle 9i Infrastructure and Middle Tier cluster.

* Created and configured Dataguard (Standby Database)

* Developing database backup and recovery strategy, providing database

backups using RMAN (command line and GUI OEM).

* Involved in the designing of databases.

* Installation of patches and performed server software upgrades.

* Implementing the Oracle Advanced Replication (Multi Master Replication)

on Mission Critical Databases.

* Created and Worked on Partitioning.

* Involving in the Analysis, Logical Data modeling and Physical Database

Objects creation like Business Transaction Tables and Dimensions Tables,

Indexes, Constraint, M/Views, and Partitions.

* Deploying Oracle Database Security using administrator defined roles and

privileges.

* Designing and implementing Backup and Recovery strategies for Oracle

database using exp/imp and RMAN Utilities. Perform the export of

different schemas.

* Loading data into Database using the SQL Loader, Export, UNIX shell

script Batch File and managed system Events and Jobs using OEM.

* Adding space to the data files to accommodate growth of tablespaces.

* Monitored Trace files and alert log files.

* Monitoring and administering database cluster, application cluster and

other RAC components using Oracle Enterprise Manager.

* Managing migration of Enterprise Data Warehouse (3 Terabyte) from HP-

Unix to AIX platform.

* Experience in troubleshooting alerts and logging service requests with

oracle to solve the problems.

* Providing 24x7 on-call Production Support on database and application

side.

* Acting as a liaison to interact with the database vendors.

Environment: Oracle 8i/9i, RH8 Linux, Sun Solaris 8/7, Sun Solaris 10,AIX

5.2, Windows NT/2000, DBArtisian, SQL Developer, OEM, TOAD, Oracle

Designer, Advanced Replication.

BSNL

June2002 - july 2004

BSNL is state-owned telecommunication enterprise in India. BSNL is the

Third largest cellular service provider, with over 66.88 million customers

as of June 2010 and the largest land line telephone provider in India. BSNL

further plans to increase its customer base to 160 Million by March, 2014.

Its headquarters are at Bharat Sanchar Bhawan, Harish Chandra Mathur Lane,

Janpath, New Delhi. It has the status of Miniratna, a status assigned to

reputed Central Public Sector Enterprise in India

Role: Oracle DBA

Responsibilities:

* Carried out Physical and Logical database design and database

reorganization.

* Installing and maintaining Oracle 9i database server software at

Windows XP and Sun Solaris.

* Created users and roles, and maintained system security

* Backup and Recovery using RMAN and user managed techniques

* Creation of database objects, writing PL/ SQL blocks like stored

procedures, packages, triggers for occasional system requirements

* Used STATSPACK for performance tuning

* Grant privileges and Roles to users Created database objects, managed

partitioned tables, managed table spaces

* Backups taken regularly using Hot Backup and Cold Backup

* Created both locally managed and dictionary managed tablespaces

* Restored and Recovered using RMAN and user managed techniques

* Performed database performance tuning, stats pack reports automation,

stress test on production copy for scalability, resolving production

performance issues

* Maintained data integrity by working on constraints

* Query Optimization using Explain plan and SQL trace with TKPROF

* Tuned Oracle database server to suit 100% additional workload from

existing 250 users to 500 users.

* Proactively monitored the database and database access, and maintained

the database security

Environments: Oracle 9i,Sun Solaris 7, Window XP,RMAN, OEM, SQL Trace,

TKPROF, Toad, Putty, FTP,SFTP

Videocon

Nov 2000 - march 2002

Mumbai, India

Role: Oracle DBA/Developer

Videocon is an industrial conglomerate with interests all over the world

and based in India. The group has 17 manufacturing sites in India and

plants in China, Poland, Italy and Mexico. It is also the 3rd largest

picture tube manufacturer in the world.

Responsibilities:

* Developed the scripts to load log data to database, and process the

data to hourly and daily tables by using stored procedure

* Created and Configured Oracle 8i database

* Designed and implemented dataload process that is running two or more

SQL* LDR together to improve oracle database loading capacity

* Structured and maintained database. Monitored database space usage and

system sizing. Analyzed oracle database performance. Troubleshoot and

supported data system.

* Implemented multi-join queries to generate reports from database per

request

* Exported and imported database for development and QA. Uploaded

database per request

* Used to do HOT backup every day and COLD backup once in two weeks on

the application database techniques using RMAN and conducted disaster

recovery drills

* Designed database. Managed database space usage. Created database

users and managed database security to ensure for the continued

accuracy, reliability and integrity of the data systems.

* Tuned oracle SQL statement by tracing

* Experience in Backup & Recovery and explaining SQL: optimized SQL

statement by using hint to change the access path and join order;

tuned table access, optimized full table scans and index lookups.

* Utilized TKPROF to read the execution plan.

* Managed performance tuning and find the root cause of performance

problems with STATPACK, and developed scripts to automate process and

monitored database usage.

* Used to Interact with Business Analysts to understand the business

requirements and also worked with Java developers to develop

procedures, package and functions.

* Implemented standby database and database replication to realize

database high availability. Created partitions for large table to

improve performance.

Environment: Oracle 8.1.6.0, Crystal reports 8.5, SQL, PLSQL, Sun Solaris

7, Oracle forms, Oracle Enterprise Manager, Toad, and SQL Developer

[pic][pic][pic][pic]

VarunVir Punj

Oracle DBA

917-***-****

abhw8f@r.postjobfree.com

Email: abhw8f@r.postjobfree.com

Contact this candidate