Oracle Supply Chain
Resume:
KRISHNA SEN
Boonton Twp., NJ *7005
973-***-**** *********@*****.***
SENIOR IT PROFESSIONAL
Expertise in all phases of design, development, deployment, application and
production support of Oracle databases. Skilled at managing all aspects of
large Oracle Databases (upto 4T and version 11g), RAC, Data Guard, Grid
Control, RMAN and general DBA tasks. Adept at dealing with various database
environments and external storage devices. Extensive experience on Unix as
well as Windows platform and managing systems based on Oracle's best
practices.
TECHNICAL SKILLS
Oracle Database Platform Oracle 11g, 10g, 9i and 8i
RAC, Data Guard
HA/DR Solution AWR/ADDM (grid control)
Architecture Statspack
System and Application AIX 5.3, Sun Solaris, HP-UX, RedHat Linux ES AS,
Performance Windows 2003,
Operating Systems SQL, PL/SQL
Programming Languages RMAN, SOL-BACKTRACK/TSM, OMNIBACKII, EXP/IMPORT, DATA
Backup & Recovery PUMP
PROFESSIONAL EXPERIENCE
MEDCO HEALTH SYSTEMS, Franklin Lakes, NJ 2007 - 2011
Sr. Oracle DBA - Production Support
Supported 3 mission critical (24x7) applications - ALPHA (2T), Workflow &
Imaging (4T) for this large PBM company having over 250 Oracle databases.
The Application uses multiple environments with 9i, 10g & 11g versions of
Oracle on AIX5.3 and HP.
Upgrade:
. Upgraded non production and production databases from 9i to 10g, 10g
to 11g and 9.2.0.8 to 11g
Monitoring and Tuning Database:
. Monitored disk space and proactive capacity planning based on prior
usage
. Monitored database performance using Grid control, statspack and
inhouse scripts, i.e., database elapsed time report, maintaining
database weekly performance baseline and I/O stats
. Tuned Databases - Estimated and set SGA_MAX, buffer_cache,
shared_pool, shared_pool_reserved, pga_aggregate_target, Processes,
resizing redologs, adding redolog groups, undo_retention
Monitoring and Tuning Sqls:
. Monitored sql performance using Grid control and in-house plan change
report, change of sql performance in terms of elapsed time report,
Setting sql profile for desired performance outcome
. Assisted Application Developers with recommendation to tune sqls
Security:
. Created and maintained users and Application/process IDs as per
security clearance policy
. Used LogMiner for investigation of deleted rows from a critical table
Backup & Recovery:
. RMAN, SqlBacktrack/TSM, export/import, data pump
. Performed Flashback recovery to restore schema tables dropped
accidentally by user
. Supported Data Guard configuration
Application support & releases:
. Supported application release efforts by creating database objects
. Created and altered tables, views, materialized views, indexes, types
. Deployed packages and procedures
Troubleshooting:
. Key member of triage conferences that troubleshot application slowdown
to determine root cause.
. Shared database performance metrics (statspack/awr) with entire group
. Checked for errors and other diagnostic investigations
KRISHNA SEN
Page 2
973-***-**** *********@*****.***
VITECH CORP., New York, NY 2007
Oracle Consultant (Development)
. Automated RMAN backup strategy with newer RMAN functionalities in
Oracle 10g eg. Bock Change Tracking, Compressed Backupsets
. Developed and executed RMAN Restore and Recovery in a multitude of
scenarios
. Created and refreshed new instance with RMAN cloning.
. Created and maintained 10gR2 single instance and RAC databases
. Developed and maintained databases
. Developed protocol to monitor client databases with RDA (Remote
Diagnostic Agent)
. Tuned databases and Sqls - AWR, ADDM, Statspack.
ORACLE CORPORATION, Iselin, NJ 2006
Principal Consultant
. RAC 10g R2: Implemented 10g RAC R2. Installed RAC on 2 node cluster
running Solaris 10 (SPARC 64 bit) with an EMC PowerPath storage unit
connected through SAN. Used Oracle clusterware (CRS) for software
clustering and Oracle Automatic Storage Management (ASM) for managing
the raw disks.
. RAC 10g R1: Conversion from 10g Standalone to RAC. Deployed RAC
cluster based on 2 Linux servers, running Oracle 10g R1 using OCFS,
EMC PowerPath / Navisphere in an EMC Clariion SAN environment from 10g
standalone single instance
. Database HA / DR Solution Implementation. Implemented primary and
standby replication through Oracle DataGuard
PICATINNY ARSENAL, NJ 2005 - 2006
Oracle Consultant
Managed Oracle 9i single instance databases on Solaris 9, HP and Linux
RHEL3.
. Implemented Backup and Recovery strategy using RMAN.
. Production upgrade from Oracle 9i to 10g.
. patches - CPUApr2005, CPUJul2005
. DBA Support.
RETAIL AUTOMATION, INC., Totowa, NJ 2001 - 2004
DBA/Developer
Oracle 9i/8i single instance databases on HP-UX and Windows NT with EMC
storage.
. Installed Oracle software and created databases
. Set up and automated batch processes via cron and NT
scheduler
. Performed query optimisation- Application and Database tuning
. Backup procedures - RMAN, OMNIBACKII. Also full and incremental
logical backups at times through Export/Import Utility
. Production Support and troubleshooting
. Application Development work related to interfacing of data flow from
Oracle DB to Legacy system and vice versa using pl/sql.
UNILEVER BESTFOODS, Englewood Cliffs, NJ 1997 - 2001
Programmer/Analyst
. Supported Sales & Marketing division of Bestfoods and provided
Business Intelligence solutions
ii Supported Sales Incentive System: Visual Basic 5.x, Crystal Report,
Oracle on NT.
. Plan/LE: Visual Basic 6.0, Oracle on NT.
. Backend program to interface Legacy/Oracle: PL/SQL, Oracle on
NT.
. B I tools used - Crystal report, Focus.
EDUCATION & TRAINING
Oracle 10g RAC Training, OU, Reston, VA
In house Deep Dive training on RAC and Grid Control
Oracle 8x Database Administration, Comet Technology, NJ
Unix Shell Scripting, Raritan Valley Community College, NJ
MS in Science, SNDT University, Bombay, India
AWARDS - UNILEVER/BEST FOODS
Received Supply Chain Recognition Award for integral contribution in the
'Supply Chain Initiative'
Received Lightning Award for developing applications in house, saving
significant IT dollars
PERSONAL
US Citizen
Contact this candidate