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
Jan 2002 Oct 2002
Oracle Senior DBA/Architect
Lead Oracle applications designer/developer/DBA for retail pharmacy
production/development data warehouse database instances. Installed
and upgraded database from 7/8i/9i on Suns E10K nodes with multiple
domains. Currently involved in Database design and administering of
CVSs datawarehouse databases (6 terra bytes). Also managed
PeopleSoft databases on HP UNIX
Implement Oracles 8i advanced features to the existing data
warehouse environment. Compiled reporting requirements, designed and
generated reports via MicroStrategy.
Designed and developed applications using PL/SQL and shell/perl/awk
scripting that loads and process large data file feeds on a daily
basis
Extensive use of ERWIN to track schema changes both at the logical
and physical model. Developed SDLC design/functional documents for
CVSs applications
Designed and developed perl/shell scripts to perform online rebuilds
of partitioned tables and partitioned indexes to remove fragmentation
Monitored application performance using monitoring tools such as
Precise, TOAD, Oracles OEM and SQL Navigator. Identified slow
running queries and improved their performance via hints, table/index
reorgs, and reengineer application code.
Designed and developed algorithms to rebuild indexes, converted
non-partitioned tables to partitioned tables, performed backup
(logical/physical) and recovery operations via RMAN, and monitored
database performance via Patrol software
Designed, developed and implemented daily loads into databases via
ETL tools (Informatica). Installed Oracle products on the UNIX
servers, NT/W2k servers, and client tools on multiple clients
Developed technical documents for the upper management describing the
growth patterns of the datawarehouse disk subsystems from the
perspective of disk usage and system usage
INGDirect
Sep 2001 Dec 2001
Oracle Technical
Lead DBA
Designed and implemented a disaster recovery solution using standby
database approach for AIX UNIX nodes and NT platforms using Oracles
Data Guard tool.
Installed and maintained development and production SQL Server 2000
databases for the Bank. Designed and developed procedures to import
data into Oracle/SQL server databases using Informatica tool.
Supported 4 production databases on a 24x7 basis
Planned future requirement for INGs Databases and applications
Commerzbank
Aug 2000 Sep 2001
Oracle Technical Lead DBA
Supported a very large data warehouse instance that has multiple fact
tables and several dimension tables. In charge of developing perl/shell/awk/PLSQL/Oracle
SQL Loader/Oracle export and import scripts to load more than a
million records into the fact tables on a regular basis.
Installed and maintained Oracle 8i/9i production/development and
system testing databases and Oracle 11i applications on Compaq Tru
UNIX nodes. Used ERWIN tools to monitor database schema change
requests. Extensive support for more than 15 database instances, most
of them were production database instances.
Migrated test and production database on UNIX servers from 7.* to 8i
and Oracle Financials 11.5.1 to 11.5.x on UNIX servers. Manager
databases via Oracle Names Server.
Installed and configured middle tier processes such as apache, forms,
web server, OMS, concurrent manager and report server on UNIX/NT
platforms for Oracle Financial and Oracle Portal 9iAS applications.
Responsible for installing, upgrading and application cloning of
Oracle 11i applications between production, development and QA
systems. Extensive use of AD utilities such as adpatch and adadmin
utilities.
Configured and maintained advanced replication between 8i databases
in NY, Singapore and Germany. Designed and developed automated
scripts to monitor growth rate of tablespaces, tables, logfiles for
future planning. Extensively tuned applications running on
databases.
Conducted an exhaustive study of current systems. Based on the
findings designed proposed a failover system for multiple production
systems that uses EMC's Symmetrix Remote Data Facility (SRDF) and
Timefinder product between systems in NYC and Rye. Extensive support
for more than 15 database instances, and most of them were production
database instances
Performed backup's and recovery using RMAN and Legato Networker using
tape subsystems
Developed technical and functional requirement documents and trained
in house DBA's
Merck &
Co.
Mar 2000 Aug 2000
Senior Oracle Database Administrator
Responsible for providing DBA support for 10+ development/test/QA
instances using Oracles OEM and 5+ production instances. Most of
these databases comprised of marketing/sales data
Technical member in Mercks Database and OS standards implementation
team
Implemented advanced replication between DBs on W2K/UNIX servers
AT&T
May 1999 Mar 2000
Senior Oracle
Database Administrator
Installed and maintained 20+ instances and developed automated
procedures to transfer data between multiple instances and production
database instances on HP UNIX and Sun UNIX platforms
Implemented simple/complex snapshots between Master and multiple
slave databases
Dendrite
International
Mar 1999 May 1999
Senior Oracle
Database Administrator
Responsible for DBA functions including installation, monitoring and
tuning of 10+ Oracle instances on HP UNIX nodes
Responsible for capacity planning, space management, monitoring and
tune DBMS apps
Dow
Jones
Apr 1998 Aug 1998
Oracle Database Administrator/Consultant
Designed and implemented simple/complex snapshots and perform backup
and recovery
IEEE
Jun 1997 Apr 1998
Oracle Database
Administrator
Responsible for all DBA functions including installation, monitoring,
tuning of 10+ instances, installed and tuned SQL*NET on HP UNIX and
Sun Solaris UNIX nodes
Performed duties of Oracle Financial Applications DBA and applied
patches
AT&T
Sep 1996 May
1997
Senior Oracle
Database Administrator
Designed and implemented a Financial Community Data Warehouse
database using Oracle 7.3 on a parallel server database instance
(i.e. OPS ) on NCR UNIX 4100/4300 SMP systems
Objective Systems Integrators
Apr 1996 Aug 1996
Oracle Database Administrator
Tuned Oracle applications to improve performance
The World Bank
Jul 1995
Apr 1996
Oracle Database Administrator
DBA for Imaging Application on DEC Alpha (UNIX) and AIX UNIX systems
Xerox
Corporation
May 1994 Feb 1995
Database Administrator/UNIX Administrator
Performed DBA duties, and responsible for the development and
production support of workflow and imaging.
Cincinnati
Bell Information Systems, Inc. Apr
1994 May 1994
Oracle Database Administrator
Reviewed and modified the logical and physical design to enhance
applications
General
Analytics Corp
Nov 1992 Jan 1994
Project Manager/Database Administrator
As a hands on Project Manager, responsible for design and development
of an Electronic DBMS system
Wang
Laboratories
Feb 1992 Nov 1992
Senior Database Administrator/Systems Engineer
Designed, developed and implemented workflow and imaging applications
MSCI
Technologies
Feb 1991
Dec 1991
Senior Systems Analyst/Project Manager
Responsible for the design of a large document storage and production
systems for US Navy.
Cincinnati
Bell Information Systems
Nov 1988 Jan 1991
Project Leader/Systems Consultant
As Project Manager designed, developed and implemented a CALS
compliant application
Electronic Data
Systems
Jun 1987 Nov 1988
Oracle Database Administrator
Designed and implemented a centralized Electronic Publishing database
using Oracle
Boeing
Computer Services
Mar 1986 May 1987
Senior Systems Analyst
Responsible for the implementation of data transfer solutions between
VAX/VMS computer systems
University Of
Maryland
Feb 1981 Feb 1987
Served (part time) as Assistant professor and instructed several
computer related courses
EDUCATION:
M.S. Computer Science, University of Maryland, 1982
M.S. Mechanical Engineering, Howard University, Washington DC, 1978
B.S. Mechanical Engineering, Bangalore, India
|