Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
CHANDA TRIPATHI
Email – chanda@yahoo.com
Cell – 732-853-9876
_________________________________________________________________________________________________________
Email – chanda@yahoo.com
Cell – 732-853-9876
_________________________________________________________________________________________________________
SUMMARY OF QUALIFICATIONS
Over 7
years of experience as an IT professional along with extensive experience Sr.Oracle DBA in managing Oracle implementations, upgrade, migration,
database security, disaster recovery solutions, and patch management in a
large complex UNIX and Windows environment. Expert in implementing customer
projects on schedule, within budget, and with high level of customer
satisfaction.
·
Excellent experience in Installation and configuration of Oracle 8i,
9i, 10g ,11g R2 and in UNIX/LINUX and Windows environment.
·
Migrated all application and database servers to AIX 5.1 and
RedHat AS 3.0 Linux running Oracle 10gRAC and 10g Application servers
·
Planned and implemented DR & high availability solutions using
Oracle10g Standby Database using Oracle Data Guard, 9i and 10g RAC.
·
Implemented Grid based monitoring solution for large scale
show manufacturer.
·
Management of schemas, objects & Partitioning the
tables & indexes and in creating and optimizing indexes for
high-performance applications.
·
Proactive Monitoring, identifying areas that need to be improved in
the database using Statspack, AWR, ADDM and 10g OEM Grid Monitoring.
·
Worked extensively in Hot/Cold Backup and Recovery and Cloning of
databases using RMAN with VERITAS Net Backup & IBM TSM.
·
Involved in different scenarios of OLTP as well as DSS
(Data warehouse) databases with a large-scale (multi TB) database.
·
Implemented Oracle GoldenGate installation, configuration,
troubleshooting Golden Gate issues
·
Delivering Oracle Database performance-tuning services for
customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL
TRACE, ORADEBUG, 10g OEM Grid Monitoring custom scripts
troubleshooting Oracle databases using sqltrace utilities.
·
Experienced in Oracle Support processes for technical requests
through Metalink and other Support Procedures.
·
Experience in HP-UX, AIX, SUN SOLARIS, Linux
and Windows environments.
·
Good experience in SQL,
ProC and Shell Scripting, Partitioning, Data modeling with utilities
like OLAP, Logical and Physical Database Design, Backup and Recovery
procedures.
·
Handling Database storage, logical and physical data modeling,
architectural level designing on new projects using tools like ERWIN.
·
Experience in basic and advanced replication using Oracle
Streams and experience in using OEM, TOAD, Oracle Wallet, Data Migrations
using export/import, benchmarking using load testing tools.
·
Used oracle Grid for monitoring .
·
Expertise in maintaining Database Security using security
compliance auditing, expertise in loading data from flat files using external
tables, SQL*LOADER.
·
Participated in appropriate consulting, interfacing, and training
for users.
·
Delivered associated documentation for user interaction with the
database environment
·
Excellent Written And verbal Communication skills with a customer
service oriented attitude.
·
A Self-starter with a positive attitude, willingness to learn new
concepts and acceptance of challenges. Strong listening, interpersonal and
analytical skills.
·
Adding a Disk group, removing a disk group, movement of data
between disk groups in a ASM storage platform.
Technical Skills:
Operating Systems
|
HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,
Red Hat Linux RHEL 2.1, 3.x, 4.x, 5x and Windows
95/98/ME/NT/2000/XP
|
RDBMS
|
Oracle 12c/11g/10g/9i/8i,Exadata
|
Languages
|
SQL, PL/SQL, UNIX Shell Scripting, AWK Scripting, Bash
Scripting, Perl scripting
|
ReplicationSoftware Tools /Utilities
|
Golden Gate, Data Guard
|
Tuning Tools
|
TKPROF, EXPLAIN PLAN, STATSPACK, BITARMOR
|
PROFESSIONAL EXPERIENCE:
SANOFI-AVENTIS
Bridgewater, NJ Nov 2010 – till date _________________________________________________________________________________________________________
ORACLE DBA
Sanofi-Aventis,
a leading global pharmaceutical company, discovers, develops, and distributes
therapeutic solutions to improve the lives of everyone. With nearly 100,000
dedicated professionals in more than 100 countries, Sanofi-aventis is devoted
to advancing healthcare around the world.
RESPONSIBILITIES:
Ø Installation,
Configuration and maintenance of Oracle 10g on AIX, Solaris and Linux.
Ø Planning and
scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
Ø Installation
of Oracle database 10g, 11g RAC (4
nodes) using Oracle Clusterware. Oracle
Data Guard setup done for RAC.
Ø Installation of Oracle 10g &11g management
agent and grid control.
Ø Constantly
monitoring the performance of the databases and viewing alert log files & trace
files.
Ø Proficient in
managing Oracle Instance, database storage structure, schema objects.
Ø
Experienced with OCR and Voting Disk
of 11g RAC.
Ø Involved
& performed Production Change Requests for PRD major DB changes. New DB
creation, Existing DB deletion, various DB Housekeeping activities.
Ø Silent
Installation of 10g & 11g client & Server with AIX.
Ø Applied patches (Patch sets and CPU
patches) and worked closely with Oracle to make Application environment up to
date.
Ø Worked extensively on RMAN
backups and recoveries and
database cloning using
RMAN Duplicate. Trouble shooting and maintenance of RMAN backups and user
managed backups.
Ø Experience in
Planning Database, Sizing table space, Create database, scripts, Interact with
developers and 24x7 production support.
Ø Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database
Partitioning. Collected performance statistics memory usage, data storage.
Ø Adding the
required User Logins, Groups and Users, Granting and Revoking Permission
to/from the users. Co-coordinating with on-site counterpart as well as Clients
and understanding requirements.
Ø Database Upgradation
from 10g to 11g R2 on Linux
environment.
Ø Involved in Performance Planning and Tuning, using
baselines and proactive monitoring, bottleneck elimination and the wait event
interface to identify issues.
Ø Review
changes in segment growth when compared to previous reports to identify
segments with a harmful growth rate.
Ø Experience in shell scripts through cronjobs to automate different types of backups including RMAN. Implemented and maintained
Database security and atomized Administrative tasks.
Ø
Implemented Oracle GoldenGate installation, configuration,
troubleshooting GG issues.
OS Environment:
AIX,SUN SOLARIS 5.10, RHEL5,WINDOWS
ING DIRECT
Wilmington,
Delaware Sep 2008 – Oct 2010
Oracle DBA
A
global financial institution of Dutch origin offering banking, insurance and
asset management to over 85 million private, corporate and institutional clients
in more than 50 countries. ING DIRECT is a member of the FDIC (Federal Deposit
Insurance Corporation) which insures bank deposits.
RESPONSIBILITIES:
Ø Installation and Maintenance Oracle 11g/10g/9i databases IBM-AIX
and Windows environments providing 24*7 Production Support.
Ø Creation,
Configuration and Setting up of RMAN
Catalog databases and registering target databases with the Catalog.
Ø Used Oracle
Streams for Basic and Advanced Data
Replication between Oracle Database Servers and Legacy Databases.
Ø Using
the tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and
TRACE FILE to tune SQL
Queries.
Ø Experienced with all kinds (Status, Performance, and Trend Analysis)
of
DB Monitoring.
Ø Migrated data from
production to qa, test using data pump
expdp/impdp utilities.
Ø Establish standby/cloned databases via Data Guard for Database Disaster Recovery.
Security User Management, Privileges, Roles, Auditing, Profiling,
Authentication.
Ø Administration and Management of Oracle 11g,10g RAC database storage
using ASM by creating failover
groups.
Ø Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related
problems and configured with Application servers on test databases.
Ø Done Point-In-Recovery
(PIT) Database recovery for testing purpose and again recovered back to the
current state.
Ø Downsizing and defragmenting the Very Large
Databases by export / import,
cloning those using RMAN duplicate
features and then upgrading them to
Oracle 10g.
Ø Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
Ø Importing data from flat files into database
using SQL loader and External
Tables.
Ø Configured and Implemented Oracle Flashback technology to recover
tables/database.
Ø Performance tuning of corporate databases,
using tools like SQL trace, AWR, ADDM,
SQL Tuning.
Ø Perform database capacity planning and growth
projection by monitoring the tablespace requirements and ensuring that there is
enough disk space available to support the various end-user applications that
access the databases.
Ø Used ERWIN
for logical and Physical database modeling.
Ø Excellent knowledge of Oracle Architecture,
SGA, Configuration of TCP/IP
protocol, Listeners, TNSnames,
SQLNET, V$ and DBA views.
Ø Mentoring the Database Performance using automated scripts.
OS Environment:
AIX,SUN SOLARIS 5.10, RHEL5,WINDOWS
GLAXOSMITHKLINE
Collegeville, PA July
2006 – Aug 2008 _________________________________________________________________________________________________________
Oracle DBA
A
research-based pharmaceutical company on both medicines and vaccines for the
World Health Organization’s three priority diseases – HIV/AIDS, tuberculosis
and malaria, and are very proud to have developed some of the leading global
medicines in these fields. The mission is to develop innovative medicines and
products that help millions of people around the world.
RESPONSIBILITIES:
Ø Installed and configured Oracle RDBMS on UNIX and Windows environments.
Ø Responsible for administering and supporting
production and development Oracle 9i,10g,11g R1 Databases.
Ø Responsible for installing, upgrade and
configuring the Oracle Server, Creating Databases, Storage Structures and
Objects, Database Backup and Recovery, Monitoring
and Optimizing Database Performance.
Ø
Responsible for setting and managing user
accounts, Granting required
privileges to users.
Ø Carry general
administration tasks using tools like OEM
and Toad.
Ø Involved in Data Warehousing, Data
Modeling, Database Design and
Creation.
Ø Allocated the separate rollback segments for the Batch
processing jobs in order to speed up processing.
Ø Created Logical and Physical standby Databases
to ascertain high availability of database during system crashes.
Ø Worked extensively on Performance
Tuning, Memory (SGA) Tuning, Net backup, EMC
(Time finder and SRDF), RAID and RAW
Device.
Ø Applied patches, keeping applications software bug free, and improving data integrity.
Ø Establish and Document Backup and
Recovery strategies and procedures after evaluating various options including RMAN.
Ø Investigate fragmentation (e.g. row chaining,
etc.).
Ø Worked
on import/export, data pump and SQL- loader.
Ø
Monitored the buffer cache hit ratio and the dictionary cache miss ratio.
Ø Reorganized data files, identified
and eliminated contention factors like I/O, buffers and locks.
Ø Partitioned large tables to increase the performance.
Ø
Worked with
both cost based and rule based
optimization techniques.
Ø Participated in Disaster
Recovery Drills, documented
database and application validation steps.
Ø Generated scripts for daily maintenance activity like analyzing the
tables/indexes, and monitoring their growth rate.
OS Environment: AIX,SUN
SOLARIS 5, RHEL5,WINDOWS
ICICI BANK
Bangalore, INDIA
May 2005 - June2006
________________________________________________________________________________________________________
ICICI
Bank offers a wide range of banking products and financial services to
corporate and retail customers through a variety of delivery channels and
through its specialized subsidiaries in the areas of investment banking, life
and non-life insurance, venture capital and asset management.
RESPONSIBILITIES:
Ø Responsible for managing production, development
& test databases and applications.
Ø Reviewing of
database design document and creating ER diagrams, providing conceptual and
logical data model and translating into physical database.
Ø Verify all
instances are up and run daily reports and test
scripts.
Ø Look in SQL*net for errors and issues.
Ø Worked on VERITAS volume manager and VERITAS Cluster Service.
Ø Creation of
Table space, Data files, Indexes, Rollback Segment and monitoring them.
Ø Responsible
for configuring database memory structure, managing storage allocation,
creating user accounts, roles and privileges for DB operations and security
maintenance.
Ø Used importdp/exportdp and SQL- loader to
load data into tables.
Ø Wrote
extensive Sub Queries, PL/SQL procedures,
functions, database triggers and packages.
Ø Verify enough
resources for acceptable performance.
Ø Developing Hot/Cold
and logical backup scripts to automate the backup procedures.
Ø Performed
Database Tuning, Performed Database Security and Integrity.
Ø Automated
monitoring the databases, performance parameters, and backup/recovery
activities by RMAN and VERITAS backup running Cronjobs and
write UNIX shells scripts for job
automation.
Ø Partitioned
large tables to increase the performance.
Ø Interacted
with data modelers, developers, application owners for gathering the required
information and resolving various issues.
OS Environment:
AIX,SUN SOLARIS, RHEL5,WINDOWS
EDUCATION:
Bachelors of Science
Download Resume Format
.JPG)
0 comments:
Post a Comment