|
SUMMARY
Functioned as Senior and Lead Architect /Oracle Database
Administrator/Application developer, Senior Systems Analyst, Program
Manager, Technical Support Specialist and Oracle Financial APPS DBA (for
10.7 and 11i versions). Extensive use and maintenance of CRM apps and
GL, AR, AP 11i modules.
Over 15 years experience in the IS field with over 13 years of specific
experience in implementing 8i/9i/10g advanced features to improve
performance of ERP applications.
Specialized in converting DBs from NON RAC environment to RAC
environment and vice versa on UNIX and Red Hat Linux Operating system.
Specialized in the installation, administration, design, development and
implementation of Data Warehouse applications, Financial applications,
Oracle ERP Applications and Oracle Application Server, Oracle
replication and RAC configurations, installation and configuration of HA
installations using Quests Shareplex product, Oracle Streams, Oracle
Dataguard, Legato SW with RMAN, capacity planning, resource management
and installation of EMC enterprise storage subsystems.
Strong working knowledge in the following tools/features: Oracle
utilities, Oracle Administration and Performance Tuning (via OEM,
Precise, Toad, SQL Navigator), Oracles 9i advanced features, Oracles and
shareplexs replication, UNIX/Perl scripts, Backup/Recovery (RMAN, Tivoli
Storage manager and Legato), EMC's Timefinder and SRDF SW.
Worked with very large Oracle Databases and Data Warehouse systems of
3TB+, multiple fact and dimension tables. Extensive use of ETL tool to
load data into oracle.
Strong working knowledge in configuring SYMMETRIX 8730 and 1000P storage
systems of EMC to manage 3 TB+ storage systems.
SKILLS
Software:
Oracle
(Version 7.X to 8i to 9iAS) back end and front end tools (CDE 2000
products), EMC's TimeFinder and SRDF, Oracles SQL NET, SQL Loader,
Oracles RAC on UNIX/W2K servers, Oracle OEM tools, Oracle Names Server,
RMAN, Oracle Designer, BMC's Patrol, Legato backup SW, SQL Server 2000,
UNIX Shell, Perl, Awk, SQL Navigator, TOAD, Microstrategy reporting
system, Quest Central for Oracle, EMCs Autoadvise, Veritas VCS 4.0,
IBMS GPFS and HACMP, Shareplex replication.
Operating
Systems:
HP-UX (OS version 11.0), NCR UNIX OS, SUN UNIX OS, AIX UNIX OS, Linux
OS, Windows NT/2000 and Compaq Tru UNIX/DIGITAL UNIX.
Languages:
UNIX C, Microsoft C, SQL, Oracles PL/SQL, PRO*C, 4GL's,
UNIX and VAX DCL Scripts, Fortran, Pascal, Cobol, SAS, LISP, IBM
Assembly, C, C++, UNIX shell scripts, awk and Perl scripting.Hardware:Sun Microsystems(workstations, midrange servers and
E10K servers), HP 9000 Series, NCR UNIX systems(SMP/MPP architecture),
Compaq's Tru UNIX, DGs and IBMs RISC machines, EMC storage subsystems,
IBM 4341, Windows NT servers/clients.
CONSULTING EXPERIENCE:
EBS
in
NJ
June 2006 to Present
Oracle SeniorDBA/Architect
Migrating 5 TB from a two node RAC to a 5 node RAC on Linux AS 4.*
using ASM and 10gR2.
Installed and configure a 5 node RAC using 10gR2 and ASM using the
Oracles low cost storage initiative approach, develop backup and
recovery procedures using RMAN and perform day to day DBA tasks
supporting DB applications.
UBS
in
NY
July 2005 to June 2006
Oracle SeniorDBA/Architect
Installed, configured and supporting a 2 node RAC
production/development environments using 10g on Sun Solaris and
Veritas VCS. Enabled TAF, Load Balancing and develop application
code using PL/SQL.
Implemented and supporting a HA solution using 9i/10g Oracle Data
Guard for the banks production DB environment using Oracles ASM
architecture
Provided training to in-house DBAs and perform daily DBA tasks that
includes migrating 9i DBs to 10G, perform backup and recovery via
RMAN tools and trouble shoot DB performance issues.
Oracle
Corporation(Evenings and Weekends) Dec 2005 to March
2006
Oracle SeniorDBA
Consultant to Alcoa
Configured and supported ASCP and ODP, in a 11.5.10 ERP
implementation
Provide APPS DBA support for multiple ERP test, QA , Dev and Prod
installations
Troubleshoot DB performance issues when ASCP and demand planning
plans were being built using shared and non-shared plan partitions
Coresys, NJ (Evenings and Weekends) May 2005 to October 2005
Oracle APPS DBA
Provide ORACLE APPS DBA support for multiple Coresys clients that
includes 11i application upgrades, patching, provide backup and
recovery operations, perform DB and application cloning, improve and
monitor DB and application performance for 8i, 9i and 10g DBs using
oracle applications from 11.0.3 to 11.5.10
Install, configure and maintain applications on 9ias application
servers
Install, configure and maintain Oracle 10g Portal environments on
RedHat Linux Enterprise 3
Configure and implement a DR solution using 9i Physical standby DB on
a 3-node implementation.
Troubleshoot and solve application performance problems using a
multitude of tools that includes 10g grid and Toad products.
Stryker
Corporataion February
2005 to May 2005
Oracle Senior DBA/APPS
DBA/Architect
Installed, configured and supported a 2 node RAC 9.2.0.6 primary DB
and a 2 node RAC 9.2.0.6 physical standby node using IBMS GPFS, HACMP
on IBMS p series servers.
Installed, configured and maintained multiple test/development/QA
11.5.10 Oracle Financials DBs on a multi node setup(DB tier is IBM
AIX and application tier nodes as Linuxx86). Implement Load
balancing via TAF on RAC nodes, implemented STATSPACK reporting to
proactively monitor a number of DBs.
Performed DB/application cloning using Adclone and DB migrations,
applied DB/Application patches via adpatch/opatch, configured
concurrent managers to handle varying work loads, performed backup
and recovery using RMAN and monitored multiple DBs via OEM/Toad/Foglight.
Provide daily database maintenance support to 100s of financial ERP
users.
Working knowledge of Oracle Advanced Planning module (centralized and
decentralized approach).
Federal
Reserve Bank of NY
July2004 February 2005
Oracle Senior DBA/APPS
DBA/Architect
Installed, configured and supported production/development
environments. Each of the environments comprised of a 2 node RAC
9.2.0.5 primary DB and a 2 node RAC 9.2.0.5 physical standby node
using Solaris and Veritas VCS 4.0.
Enable oracle streams to implement bi-directional replication between
multiple DBs for production/test/ QA environments. Implemented a
robust RMAN with Legato Tape SW for all production DBs at the Bank.
Provided training to in-house DBAs and implemented load balancing on
all RAC DB instances
Convert and migrate few SQLSERVER DB applications to an Oracle based
DB system.
EMC
Corporation/Lockheed Martin Mar
2004 July 2004
Oracle Senior DBA/Architect
Migrated 3+TB ERP Oracle databases from SYMMETRIX 8730 to SYMMETRIX
1000P I/O subsystems, with emphasis placed on improving Oracle
application performance.
Implement Oracle 9i
advanced features at the instance level, application level, and net
configuration level, and re-engineer application to extensively use
Oracle partitioning feature .
Install and configure Oracle Diagnostic 9i pack, implement external
tables, implement and analyzed statspack data captured every one
hour.
Using EMC tools
such as autoadvise capture object level statistics, generate reports
and plan for improved database performance at the disk file level and
also at the application level.
Pitney Bowes
Jan 2004 Mar 2004
Oracle Senior DBA/Architect
Configured and supported a 9.2.0.4, 2 node Oracle RAC implementation
on W2K OS.
Train
in house ORACLE/SQL server DBAs.
Developed standards to proactively monitor their production DB
application.
Designed and developed PL/SQL modules for Click Stamp Online WEB
application.
Implemented new Oracle 9i availability and recoverability features
such as flashback query, 9i log miner enhancements and use of new 9i
RMAN features.
Consultant to
United Parcel Services
Jul 2003 Jan 2004
Oracle Senior
Consultant
Implemented and tested HA/DR solutions for multiple databases using
Shareplex and EMCs products on HP UNIX nodes. Configured
SUN/HP/NT/2000K platforms to implement HA solutions.
Migrated 2+TB Oracle 8i to 9i DBs. Provided production support for
multiple UPS databases.
Implemented and maintained a 2 node Oracle RAC system using W2K and a
logical standby database for a reporting application. Performed the
same on a 2 node using Linux OS.
Trained in house ORACLE/SQL server DBAs.
Installed and implemented hot/cold backups using Oracles RMAN
utility.
On a
daily basis configured all systems to generate statspack reports and
make recommendations to the application development team and the DBA
team to improve performance. Customized statspack reports to capture
OS performance data using a multitude of UNIX utilities (i.e. use of
UNIX tools such as sar, vmstat, glance, iostat and etc). Configured
and maintained a Names Server environment.
Developed technical documents as per UPS standards and trained in
house DBAs. Configured SUN/HP servers prior to the porting of
databases from/to external systems. Developed best practices
documents that address
backup/recovery/installation/configuration/performance tuning of data
warehouse DB applications.
Troubleshot and solved performance problems using OEM, Toad and SQL
Navigator.
Provided applications DBA support for multiple Oracle Financials
applications such as installing/configuring the forms server,
report server, concurrent manager servers and applied patches
using adpatch utility.
Installed, upgraded and performed application cloning of Oracle 11i
applications between production, development and QA systems.
Extensive use of AD utilities such as adpatch and adadmin utilities.
Installed and configured Oracle Advanced queuing and workflow
applications in 11i.
IT
Convergence
Jul 2003 Jul 2003
Trainer
Developed a 5 day course material for Oracle DBAs in the
implementation and usage of Oracle 9i advanced features
Taught the same course for a group of 8 Oracle DBAs at PTC Inc., in
Boston
Schering-Plough
Corporation
Jan 2003 - Jul 2003
Oracle Senior DBA/Architect
Implemented 21 CFR Part 11 auditing/security/backup/recovery
procedures across all production, validation and development database
instances on UNIX Open VMS and NT/W2K servers.
Installed and configured RAC implementations using Sun cluster disk
subsystem. Implemented Oracle 9i advanced features such as external
tables for ETL type processing, heavy use of 9i init ora parameters
affecting application performance, Redo log mining, use of advanced
RMAN features and Oracle Flashback queries.
Migrated 7x and 8i database instances on NT/W2K servers to 9i
versions on HP, SUN, AIX UNIX servers. Identified expensive SQL
queries and tune them to improve application performance
Developed functional specifications and developed standards to
implement auditing and backup/recovery procedures of databases
according to Schering-Plough Corporation standards
Bristol-Myers
Squibb
Oct 2002 Jan 2003
Oracle Tuning
Specialist/Architect
Installed 9iAS, 9i and 8i databases on E10K domains. Designed and
implemented WEB enabled applications that support the Research
scientists at BMS for multiple Drug Discovery Projects
Implemented extensive tuning measures for the applications using
multiple monitoring tools such as OEM, Toad, Quest Center for Oracle,
and home grown scripts
Redesigned many parts of the application to start using the Oracles
table level partition architecture handling tables that have 40 to
100 Million records
Installed and configured a RAC implementation using Oracles CFS on
clustered Windows 2000 servers
Implemented 21 CFR Part 11 auditing/security/backup/recovery
procedures across all production database instances on NT/W2K servers
CVS Corporation
| 
top
