SUMMARY:

• I am an accomplished database & eBiz suite administrator with demonstrated success in designing, architecting and implementing various solutions with sound performance considerations. I have a good blend of technical expertise, leadership and communication skills and a very good team player. I have eighteen years of experience in Oracle database domain.
• Expert DBA in Oracle 10g, Oracle 11g, Oracle Apps 11i, R12 administration
• Installed/administered multi node application architecture with Parallel Concurrent Processing and RAC nodes
• Upgraded eBiz suites from 11i to R12, between versions of 11i, using staged appl tops, customized patch drivers for better performance
• Migrated eBiz 11i from HPUX to Linux
• Used templates to standardize environments using Autoconfig and cloning procedures
• CRS/RAC/ASM/Dataguard/Golden Gate Installation, Configuration and Administration
• Performance tuning experience with AWR, Oracle Enterprise Manager, Oracle Wait Events, TKPROF
• Rman backup, restore and recovery, solid in backup and recovery concepts
• Performed database upgrades, cross platform migration, migrations using datapump
• In production support role, I have good experience in incident management, problem management, helped formulate various operational metrics and identified automation tasks to improve operational excellence
• Closely worked with change management, release management, program management teams, helped prioritize various IT programs and release alignments
• S - OX controls related process and knowledge
• Proficient in Unix shell scripting and perl

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Consultant, Database Administrator

Responsibilities:

• Upgraded eBiz instance to 12.1.3 from 11.5.10. Separately, upgraded another 11.5.9 instance to 11.5.10 using staged appl tops and distributed patching
• Successfully implemented Rman backup, setup Data guard installation.
• Performed database upgrades, patch updates
• Installed and administered Golden Gate for replication
• Installed CRS/RAC on Oracle 11g, used ASM instances for storage.
• Took lead on Operational issues, that involves performance issues, used AWR, TKPROF
• Published Operational Metrics to the clients, demonstrating reduction of issues, covering proactive steps, automation tasks, short and long term fix status.
• Incident management, problem solving, open communication with clients, flexible with availability, being on calls, 24/7 technical escalation contact, collaboration with all stake holders are some of my positive skill and qualities.

Environment: Oracle database 10g,11g RAC, OEM 11g, 10gAS, Apache, Linux, HP-UX Risc/IA, Solaris

Confidential, San Jose CA

Lead Database Administrator

Responsibilities:

• Supported production env in P1 issues, working with cross functional teams towards issue recovery, root cause identification, short term and long term fixes. I always looked for options to automate tasks to avoid reoccurrence and reduce issues
• Executed projects that involved Apps/DB upgrades from 11.5.10.2 to 12.1.3, ASM implementation, cross platform migration (HPUX->Linux), downtime optimization, patch optimization, staged appl top upgrades with eBiz suite, distributed patching
• Setup PCP and helped define autoconfig standardization using customized templates
• I was good as a team player and as well a lead administrator
• Installed several CRS and RAC systems, from oracle 9i to oracle 11g.
• Involved in various data migration projects, using datapumps, transportable tablespaces, custom scripting
• Setup dataguard installations
• Performed database and SQL Tuning using AWR, TKPROF, OEM and other methods
• Involved in Golden Gate implementation as part of the POC project
• Helped define Standards/scripts/process, DR policies. Involved in various tuning assignments with statspack, TKPROF, involved in s-ox controls and processes
• Collaboration with cross functional flow leads, release and program teams

Environment: eBiz 11.5.10, 12.1.3. Oracle 8i OPS, 9i, 10g, 11g RAC, SSO, 10gAS, Apache, Linux, HP-UX Risc/IA, Solaris

Confidential

Consultant, Oracle Production DBA

Responsibilities:

• Installed eBiz patches, troubleshoot issues in production environment, performance tuning, backup management using legato networker, Veritas Netbackup and BCV backups.
• High availability was implemented using veritas cluster software and VCS services are defined to handle automatic failovers. Created and maintained standby installations using oracle dataguard.
• Responsibilities included providing support on 24/7 on-call basis that is shared on a rotational basis within the team.

Environment: AIX 5L, 4.x, Solaris 5.7, Oracle9x 8x, 7x, Netbackup, Networker, TSM, Oem, VCS, Hacmp

Confidential, Chicago, IL

Consultant, Sr. Oracle Production DBA

Responsibilities:

• I administrated Oracle Database and eBiz Applications installation.
• Performed new production installation of Oracle Applications and deviced a new backup strategy Also performed database and application tuning.

Environment: Sun Solaris 5.7, Oracle 8/8i, Oracle Enterprise Manager with Diagnostic pack and Tuning Pack, Rman, Oracle Applications 11.0.3

Confidential

Consultant, Senior DBA

Responsibilities:

• Tokio Marine Management is an insurance provider, clients include Toyoto, Mitshubishi. Various applications that are running processes claims information, issuing s and other DSS applications.

Confidential, GA

Consultant, Oracle DBA

Responsibilities:

• I was responsible for creation, tuning and maintenance of clinical resource management. Performed a lead role in migration of 7.3.3.3 db to 8.0.5 . Also coordinated with Veritas to implement Netbackup for backing up databases. Using Rman, EBU and Netbackup, i was responsible for the backup of enterprise databases.

Confidential

Sr Associate DBA

Responsibilities:

• Application DBA for Corporate Banking Product Called FlexCube. The product is a GUI version of leading banking product Microbanker from Confidential corp India.
• Duties included creating and maintaining user accounts, managing space usage, objects creation, planning backup and restore strategy, Database sizing and performance considerations. Responsible for determining and managing storage specifications for the table-spaces, table indexes, rollback segments, creation of users, creation of roles and granting roles to users, SQL statements tuning. Also created scripts for startup and shutdown procedures.

Confidential

Associate DBA

Responsibilities:

• Duties included creating and maintaining user accounts, managing space usage, objects creation, planning backup and restore strategy, Database sizing and performance considerations