Page * of **

Venkateswara Vadlamani

Los Angeles, CA 90034

Email:abli9e@r.postjobfree.com

Phone: 626-***-****

Summary:

• Over 20 years of experience with Oracle RDBMS product.

• Over 15 years of experience in Design, Implement, and maintain High Available and large scale

Distributed Database environments on Sun Solaris, HP, AIX, Sequent, Pyramid hardware.

• Over 3 yes of experience with Oracle 11G RAC and 8 Years of experience with Oracle 10G/9i RAC.

• Expert knowledge in designing and configuring Disaster Recovery Solutions with Oracle Streams,

Oracle Replication, Standby and distributed database options.

• Over 13 years of experience with Ralph Kimbal, Bill Inmon Data Warehouse Methodology, with Dimensional

Modeling, Star Schemas, Operational Data Store, leveraging large data warehouses.

• Expert knowledge in establishing database management systems, standards, operational procedures,

according to SOX compliance standards

• Extensive experience in managing complex production database environments.

• Supported more than 800 production database environments at various client sites.

• 6+ years of experience with Oracle ASM volume manager.

• 4+ year experience working for IBM as a Senior Oracle DBA

• Extensive experience working as an Oracle Specialist - DBA, Data Modeling, and Unix Administration.

• Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive

Decision Support Systems.

• Over fifteen years of experience in developing conceptual, logical, and physical data models for complex

business situations using ERWIN, Oracle CASE and other data modeling tools.

• Strong business analyst with experience in UML modeling using Rational Clear Case. Used UML models to

capture business logic embedded in stored procedures of client server applications.

• Over 10 years of experience with Oracle Parallel Server and Oracle Real Application Cluster.

• Over 15 years of experience with Oracle Advanced replication.

• Experience with SAP installation, configuration, and setup on Oracle database in UNIX environment.

• 10 Years of experience in Administration of Oracle Sever on WINDOWS NT/2000 environment.

• Over 10 years experience in writing Unix shell scripts, PL/SQL and Pro*C and Query Optimization.

• 2 year of experience with Oracle 10g, on HP/Sun Solaris environment

• Extensive experience with Veritas Volume manager, Veritas File System, Legato Networker, and Oracle

Recovery Manager (RMAN).

• 12 years experience as Data Modeler with Oracle Designer, Erwin casetools and Business Objects.

• Solid understanding of Oracle Enterprise Manager, BMC Patrol, and Platinum Oracle/Unix monitoring

tools.

• Experienced Application Architect, Business Analyst, Lead DBA, and Project Manager.

• Strong communication skills; Trained Oracle DBAs and supported 250+ programmer teams.

Technical Skills:

Hardware Sun ES 3000,3500,6500,450,EMC Clarion 5.x HP9000/3000, RS/6000, SEQUENT, PYRAMID, PCs

Operating Systems Solaris 2.5/7, AIX, HP/UX, ULTRIX, Xenix, Windows NT/95/98, DOS

Databases ORACLE 6/7/8.0.5/8.1.5/8.1.7, 9.2.x, 10 g,11g SYBASE 11.1, 12.3, INFORMIX 7/9/APB Web

Data Modeling Tools Oracle Designer 2000/CASE, ERWIN, Data Architect, System Architect, Easy CASE

Database Tools OEM, SQL*Loader, SQL*Net, Oracle Packages, triggers, stored procedures, DBassit, rman, cron,

tkprof, JDBC, ODBC

Software Tools Business Objects, JDK 1.2, Visual Age 2.0, MS Project, EBUTool

Web Related Tools Cold Fusion 4.x, MS Front Page, Java script, Micro Strategy, Business Objects

Languages PL/SQL, Pro*C, Unix Shell Scripts, HTML, CGI Scripts

System Design & Requirement Analysis, Functional Analysis, Business Process Reengineering, Product Evaluation,

Development Information Warehousing, Data Modeling, Normalization, Query Performance Assessment, Testing,

Documentation and Implementation.

Other Skills Project Leader and Trainer.

Page 2 of 10

Professional Experience:

Position: Sr. Oracle DBA Feb 2008 till now

Fox Film Entertainment, Los Angeles

As a Senior DBA responsible for setup of High Available solutions, with 7/24 database availability for several business

critical applications for domestic and international home entertainment. Implemented RAC 10g/11G, BMC Sancopy,

Data Guard solutions for OLTP, Data Warehousing and Disaster Recovery solutions.

• Installation and configuration of several multi node Oracle 10/11G RAC environment on Solaris 9/10,

AIX 5.1/5.6 system on SUN M9000,M5000, E6900, RS6000, SP2 series of computers.

• Production support for more than 300 databases on 7/24 schedule .

• Conducted several proof of concept studies for high availability and transaction throughput with

Oracle RAC architecture, demonstrating the vertical and horizontal scalability capabilities of Oracle

10/11G RAC server.

• Production support of large databases of sizes more than 50 TB with 32/64 CPU and 1TB memory

configuration.

• Configuration of Oracle Grid, Cache Fusion, Oracle Real Application Clusters Guard, for High

Availability and load balancing, for several databases.

• Configuration of Transparent Application Failover(TAF) with Listener and Node load balancing

methods

• Performed tuning for RAC databases improved inter instance latency by tuning SGA pools, hands on

analyzing Statspack reports, identifying and analyzing wait events, optimizing PGA pools. Configured

dynamic SGA pool memory sharing

• Implemented 10g Cluster Ready Service CRS on AIX and Solaris servers, used nodeapps,

crsctl, ifcfg, vipca, cluvfy, ocrdump, misc tools.

• Wrote scripts to prevent RAC node instance eviction issues.

• Implemented 10g Grid Controller OMS server for monitoring EM, with server and 200 client

agents installed and wrote scripts to maintain daily tasks like cleaning generated metric captured

xml files, running EM broken jobs, restarting agents etc.

• Implemented and configured ASM (Automatic Storage Management 10g Feature), on EMC

storage, which included a base for more than 2 dozen 10g databases with 500gb FRA, flash

recovery area for archive and flashback purposes.

• Migration and consolidation of several single instances in to multinode RAC database.

• Configured and installed Oracle ASM volume manager, and replaced veritas volume manger software

for the enterprise. Migrated several terra bytes of data into Oracle 10/11G ASM disk groups.

• Configured and implemented RMAN parallel backup of large files in excesses of 500GB in size.

• Migrated LOBs from basic files to Secure files, utilized the deduplication option of 11G.

• Configured and implemented Single Client Access Name (SCAN) for Several 11G RAC databases

• Setup several adaptive thresholds with AWR moving window baselines to capture many performance

related metrics

• Utilized I/O Calibration to reorganize the file system between Flash and SATA drives.

• Encrypted several tables with Oracle Wallet for several PeopleSoft HR and Finance applications

• Implemented column masking functionality for sensitive tables.

• Enabled table compression for several data warehouse applications saved more than 20 terra bytes

• of storage.

• Configuration and setup of Oracle Streams and Data guard replication methods for data synchronization

between Los Angeles and Chandler Data centers.

• Implemented full System Development Life Cycle for several data marts, and OLTP applications.

• Implemented Star schema design, dimensional modeling, ETL design, physical database design for

several DataMarts.

Page 3 of 10

• Installation, configuration and management of several Physical Standby Database, with Active dataguard

functionality and Snapshot Standby Database in 11g environment.

• Created several Flashback Data Archives to stage historical data

• Configuration, and setup Oracle Enterprise Manager Grid Control 10G/11G, and QUEST spotlight and

performance analysis tools to administer more than 400 production and development servers.

• Configuration and implementation of 10G physical and logical data guard, streams for disaster recovery and

high availability requirements

• Migrated several oracle development and qa databases into oracle 11G RAC environment

• Supported several My-SQL databases with replication options.

Environment: Oracle 8i/9i/10G/11G, AIX 5.x, HPUx 10/11.x, Solaris 8/9x,OEM, PLSQL, RAC, EMC, RAID, SAN,

Unix, Linux, Shell scripting, Clustering, RMAN. RS 6000, SUN 2900, SUN 6800, M9000,M5000, SUN 10k and 10K,

HP V240 series, SQL backtrack, Commvalut. Net backup . Mysql 5.0

Position: Sr. Oracle DBA August 2007 till Jan 2008

Client: Ericsson, Plano TX

As a Senior Oracle DBA, supported several databases on 7/24 schedule under HP/UX, SUN and INTEL

platform, utilizing Oracle Grid Control. Configured backup and recovery operations for several databases with

RMAN/Commvalut backup systems.

• Installation, configuration of several databases in 6 node Oracle 10G RAC environment on Sun/Intel

Platforms.

• Installation, configuration of Solaris 9/10 operating systems on Sun E2900 and Sun E4900 series of

servers

• Production support of large databases of sizes more than 5 TB with 32 CPU and 1TB memory

configuration.

• Migration of several databases from oracle 9i into Oracle 10G environment

• Installation, configuration of ASM storage Manager.

• Migration of terabytes of data into ASM Disk groups

• Configuration, and setup Oracle Enterprise Manager Grid Control 10G to administer more than 300

production and development servers.

• Production support of more than 200 Databases on 7/24 routine.

• Performance tuning of Operating Systems, Network and Database Servers.

• Backup and recovery of databases with Rman and EMC Symmetry

• Expert knowledge of SQL perfomance tuning & PL/SQL, database security.

• Expert knowledge of UNIX shell scripting with Ksh, to generate capacity planning reports, database

server performance reports and backup and recovery procedures.

• Responsible complex software installations, upgrades and license verifications, fault detection,

escalation and repair, assisting developers with code roll-out and operational troubleshooting,

performance metrics collection

• Solid skills in database performance factors, monitoring tools and tuning procedures.

• Configured Physical and Logical Standby Database and datagaurd for 6 node RAC cluster

ENVIRONMENT: Oracle 9i, 10 G 10.2.3.0, HPUNIX 10/11, Solaris 9,10, OEM, Rehat 3.x/4x. Sun E2900,

E4900.

Page 4 of 10

Position :Sr. Oracle DBA Feb 2004 – July 2007

Client: IBM GSA/ Toyota Motor Sales, Los Angeles

• Setup, installation, configuration of Oracle 9i/10G databases on HP/Sun and AIX environment, with Real

Application Cluster (RAC) environment, for Toyota Motor Sales and Toyota Financial Systems.

• Design and development of requirement definition documentation, based upon interview sessions with

business users.

• Implemented full System Development Life Cycle for several data marts, and OLTP applications.

• Implemented Star schema design, dimensional modeling, ETL design, physical database design for

several DataMarts.

• Conduction and facilitation of JAD sessions.

• As a senior member of IBM operational support, established database procedures and standards

according to SOX standards.

• Design of logical, physical data models with Erwin data modeling tool.

• Design of Acord XML message framework for exchange of Acord Messages between Claims and Insurance

internal requirement.

• As a part of IBM’s engagement, responsible for design and implementation to migrate more than 150

Terabytes of Oracle data to Disaster Recovery Site in Phoenix, AR with Oracle’s Disaster Recovery

options such as Standby Database, Data Guard, and Advanced Replication of 9i and 10G.

• Design and develop technical documentation for overall data warehousing components, which includes

Staging process, ETL process, Business Intelligence report writing requirements.

• Lead technical team of 5 people, in the development of business intelligence components including data

models, ETL, enterprise reporting, architecture and infrastructure, testing and deployment.

• Configuration, deployment of Cognos Data Warehousing products, such as Decision Stream, Power Play

enterprise server, Impromptu web reports, for all 4 data marts.

• Administered more than 200 production databases, with 7/24 support, as a part of IBM’s oprations

support.

• Configuration of Oracle Grid, Cache Fusion, Oracle Real Application Clusters Guard, for High

Availability and load balancing, for several databases.

• Configuration of Transparent Application Failover(TAF) with Listener and Node load balancing

methods.

• Partitioned large tables with range partition methods for several data mart schemas.

• Designed and created several fact and dimension data models, materialized views, and slowly changing

dimension data models for large corporate data warehouse.

• Expert knowledge in installation, upgrades, migration and application of Oracle patches.

• Migration of several oracle databases in to 3 or 4 node RAC configuration

• Setup and configuration of Data Guard, Multi Master, Read Only and Snapshot replication for several

supply chain datamart environments.

• Configuration, and deployment of Oracle Enterprise Manager(OEM), integrating more than 200 production

and 300 development databases. Utilized oracle 10g OEM grid to deploy software across multiple nodes.

Configures OEM pager and email notification schedules.

• Extensive utilization RMAN for backup and recovery from single node to multimode RAC databases.

• Implemented backup and recovery procedures and standards for the data in excess of 70 TB in

capacity.

• Review, approve, apply and test patches, changes and/or modifications to Oracle relational database schemas.

• Resource of application team in PL/SQL coding and query optimization.

• Extensive experience with performance tuning at systems and application level.

Environment: Oracle 8i/9i/10G, AIX 5.x, HPUx 10/11.x, Solaris 8/9x,OEM, PLSQL, RAC, EMC, RAID, SAN,

Unix, Linux, Shell scripting, Clustering, RMAN. RS 6000, SUN 2900, SUN 6800, SUN 10k and 10K, HP V240

series, SQL backtrack, Commvalut.

Client: Merk Medco, NJ Aug 2003 – Jan2004

Position: Sr. Oracle DBA

Page 5 of 10

Responsible for requirement analysis, functional specifications, entity modeling, logical database design, physical

database design for a large Data Warehouse, for Nation wide Trade Promotion System for Consumer Health Care

division.

• Administered more than 90 databases on Oracle 8i, Oracle 9i and Oracle 10g by 7/24 schedule, for a large

online prescription management company.

• Installation and configuration of Oracle 9i RAC database in a 4 node cluster, on HP and Sun

environment.

• Responsible for designing, developing, and deploying large Corporate Data Warehouse(Data Resource

Center), integrating Shipment, Consumption, and Invoice data.

• Design of Fact Tables, Dimensional Tables, and Slowly changing Dimensions, as per the Require

Specification Document.

• Lead a team of 4 developers, in implementing ETL Staging, Transformation, and Loading procedures.

• Designed several Data Marts, integrating external data such as ACNeilson, and IRI consumption data.

Migration and consolidation of several databases into Oracle Real Application Clusters.

• Setup, installation, configuration of Oracle 8i/9i, and 10g databases on HP/Linux environments.

• Configuration of several Multi master replication, Standby databases, between multiple locations of

Medco in U.S.A, with real time no data loss synchronous options.

• Migration of several databases from Oracle 8i to Oracle 9.2.0.5.0 and Oracle 10g RAC environment.

• Star schema design, ETL process design, dimensional modeling, for a large data warehouse.

• Performed 7/24 online production support, for databases over 4 Terabytes in capacity, in Oracle and

Sybase environments.

• Integrated online backup with BMC’s SQL backtrack and RMAN.

• Involved with performance tuning at Systems and Application level utilizing Oracle utilities, and third

party database monitoring tools.

• Resource to Application staff with PL/SQL, Unix and perl scripting

• Setup and monitoring of multi master replication between several pharmacies.

• Setup and configuration of several knowledge modules of BMC’s Patrol tool.

Environment: Oracle 8i, 9.2.x, 10g. Patrol4.2, Sybase 11.2, 12.5, HP 9000, Sun 6500, AIX SP2 . SQL backtrack.

Client: Solo Cup Chicago, IL Jan 2003 - July 2003

Sr Oracle Data Architect/Modeler/DBA

As an Data Warehouse Architect, responsible for design and implementation of Corporate Data warehousing project

using Oracle 8i/9i, ERWIN 3.5, and Business Objects. Specific responsibilities include:

• Administered several Oracle 8i, Oracle 9i, databases for supply chain management system

• Setup, installation, configuration of Oracle 9i databases on Sun environment, with Real Application

Cluster (RAC) environment, for a large Enterprise Data Warehouse.

• Configuration of Cache Fusion, Oracle Real Application Clusters Guard, for High Availability and load

balancing.

• As a Data Warehouse Architect responsible for managing and performing complex services engagements,

such as Developing Business intelligence Solutions, including design and implementation of Data

Warehousing solutions.

• Design of Large Corporate Date Warehouse with Logical Database design, Physical database design, and

entity modeling of Cash Load and Dividend applications, with Dimensional Modeling and Star Schemas, and

Materialized views option of Oracle 8i/9i.

• Installation, configuration, and setup of Informatica Server on Sun Solaris environment.

Design of Extract, Transformation, and Loading process with Informatica Server, Pl/SQL, and SQL * Loader.

• Setup, configuration, and installation of Oracle8i/9i, Design, and development of multiple universes to

address diverse reporting requirements .Business Objects 5.0 on SUN 450 machines

• Setup and configuration of Multi Master, Read Only and Snapshot replication for several supply chain

datamart environments.

• Implemented Star schema design, dimensional modeling, ETL design, physical database design for several

DataMarts.

• Review, approve, apply and test patches, changes and/or modifications to Oracle relational database schemas.

Page 6 of 10

• Work closely with the Solaris Systems Administrators as well as the applications development team to design,

implement and test new features and functionality

• Management of several production servers, both on OLTP and Data Warehousing in Oracle 9.2.x RAC

environment, with sizes over 10 Terabytes in capacity.

• Reorganization and migration of several databases into Oracle 9.x environment

• Implementation of partitioning, parallel query, bit-mapped index, Updatable materialized view options of

Oracle 9i release for several data marts.

• Implemented backup and recovery procedures with Rman, and BMC backup solutions, utilizing SQL

backtrack

• Resource to IT staff in performance tuning applications in PL/SQL, and SQL.

Environment: Oracle 9.2.x, Data Integrator 6.1, Erwin 4.5, HP 9000, Sun 6500, Sun E10000

Client:Beverly Enterprises, Fort Smith AR Jan 2002 - Dec 2002

Sr Oracle DBA/Data Warehouse

• Setup, installation, configuration of Oracle RAC (Cluster Database) on Windows 2000 environment,

for a large Enterprise Data Warehouse.

• Star schema design, dimensional modeling, fact table design and staging environment design for several data

marts.

• Involved with Tuning of Windows Memory, to configure Oracle Memory beyond 8 GB

• Installation, configuration, setup of several Oracle 9i servers on Windows/2000 platform on HP Proliant

Servers.

• Supported several SAP databases on Oracle environment, with SAP DBA utility. Performed installation of

SAP environment on windows servers, and performed SAP basis administration. Designed backup and

recovery procedures for SAP database.

• Resource to application developers in SQL, PL/SQL query tuning, and optimization utilizing Explain Plan

SQL trace utilities

• Migration of several production servers into Oracle 9.2.x RAC environment, consolidating over 10 databases

into RAC.

• Implementation of partitioning, parallel query, bit mapped index options of Oracle 9i release for several data

marts.

• Configuration of Oracle Enterprise Manager, BMC Patrol database monitoring tool, Recovery Manager,

integrating backup and recovery of several Oracle databases.

• Resource to IT staff in PL/SQL, SQL Coding assistance, mentoring Oracle 9i features.

Environment: Oracle 9.2.x. 8.1.7, People Soft, Oracle XML, Windows/2000, HP Proliant 570, HP 9000. SAP 4.x

Client: SWISS RE, Armonk NY Dec 2000- Dec 2001

Sr Oracle DBA

Administered several Oracle 8i, Oracle 9i databases for Accounting, Claims and Retro processing systems.

• Migration of substantial portion of DB2 database, located on mainframe in Zurich, into Oracle 9i

environment. Logical database design, physical database design of Global Operational Data Warehouse.

• Setup, installation and configuration of Oracle Parallel Server(OPS) on Oracled 8.x environment,

consolidation over 100 database into three node OPS environment.

• Migrated several SQL server, DB2, and oracle 8.1.7 releases into Oracle 9.x environment

• Resource to application developers in SQL, PL/SQL query tuning, and optimization utilizing Explain Plan,

SQL trace utilities

• Migrated several SQL statements from Oracle 8i to 9i environment.

• Designed Insurance standard Acord XML protocols, for reinsurance claims processing systems.

• Implemented Range and composite partitioning options for several data warehouse tables.

• Performance tuning, monitoring of several Oracle production servers.

• Production support for several mission critical database servers on HP9000 and Windows/2000 environment.

• Design, implementation of Operational Database, integrating several data centers in Canada, Europe, and

Northern America.

• Installation, configuration of Modelmart 4.x, a repository of Erwin diagrams, facilitating sharing of Corporate

data models across Canada, Europe, and North American facilities.

• Involved with performing tuning, Query optimization, PL/SQL, and SQL coding assistance/

Page 7 of 10

• Design, development, and implementation of standby database for a large operational accounting system.

Environment: Oracle 9i, Oracle 8.1.7, HP 9000, Windows 2000

Client: Pfizer, Morris Plains NJ Mar 2000 - Nov 2000

Sr. Oracle DBA

• In conjunction with Booze Allen Hamilton consulting company, Conduct JAD facilitation sessions with

business users, designing Requirement Analysis, Functional Specification documentation

• Logical database design with Erwin 3.5/4.0 release

• Physical database design, with partitioning and striping options of Oracle 8.1.7 release

• Migration of data from multiple sources to the Data Warehousing environment

• Implementing backup and recovery procedures with RMAN utility.

• Performance tuning at System, Application, and Database level.

• Resource to application team in coding and optimizing SQL/PLSQL language.

Environment: Oracle 8.1.7, Erwin 3.5/4.0, Micro strategy 6.0, Informatica, Business Objects 5.1, HP 9000 K series,

NT, Windows 2000.

Metlife, New York City NY Oct 1999 - Feb 2000

Sr. Oracle DBA/Data Warehousing

• Project: Responsible for design, implementation of Corporate Data warehousing project. With Oracle 8i

release. Setup, configuration, and installation of Oracle 8i on Sun Solaris environment.

• Migration, and update of several databases from 7.x, 8.x into Oracle 8i release with partitioned options.

• Support of several Database Instances both at production and developmental level

• Implementation and configuration of Standby Database release 8i between three sites of Metlife.

• Logical Database design, Physical database design, entity modeling of Data Warehousing Project

• With Dimensions and Materialized views option of Oracle 8i.

• Implementation of Data warehousing models with ERWIN.

• Performance tuning of SQL/PLSQL code to optimize query performance.

Environment: Oracle 8i.8.1.6, Erwin 3.5, Business Objects 5.0, Web intelligence 2.5, SUN 450, SUN SPARC

10,20, Storage A1000, D1000

Jan 1998 – Sep 1999

Client: Sun Microsystems /Terra.com, Piscataway, NJ

Sr. Oracle DBA/Solaris Admin

Project: Telefonica, is the telephone giant in Spain, started an Internet portal called Terra.com.

• Monitoring of Oracle 8I Server on 24 x 7 time schedule, including installation, configuration, performance

monitoring, tuning and database reorganizations to maximize database availability and response time.

• In a team of two, responsible for configuration of Veritas Volume Manager, Veritas File System, Veritas First

Watch, High Availability Setup, Legato Networker, to support Oracle Databases over 5 TB in size, and

Email’s over 19 TB of sizes on EMC Clarion environment.

• Setup, installation, configuration of Oracle 8I Advanced Replication, Snapshot Replication, and Standby

Database Replication between two locations of Terra Networks establishment in New Jersey and New York.

• Worked with Legato, and EMC vendors to evaluate the fault tolerant, and disaster recovery methods.

• Evaluated EMC Time Finder, EMC SRDF, Legato Disk mirroring, Veritas Disk Mirroring software for

replication of Terra Networks Portal from New Jersey to Long Island.

Environment:

Hardware: Sun 3500,3000,450,250 EMC Clarion FC 5700, Sun Storage L1000,

Software: Solaris 2.5/6/7, Oracle 8.0.5, 8.1.5, 8.1.7, PL/SQL, Shell Scripts, Netscape Enterprise Server3.5, Netscape

Application Server, Cold Fusion Server 4.0, Business Objects, Oracle WebDB Server, Oracle Designer 2000, Oracle

Developer 2000, OEM 2.x, Shopping Engine, Legato Networker 5.5

IBM Australia May 97 – Dec. 98

Client: Dept. of Land and Water Conservation (Govt. of Australia)

Sr. Oracle DBA

Page 8 of 10

• With the support from Oracle Corporation (Virginia, U.S.A), player a key role in installing, configuring,

trouble shooting, and migrating of Geographical data from UNIX Genemap flat files into Spatial Database

(ORDBMS) features of Oracle 8I release 8.1.5 and 8.1.6.

• Migrated several 7.3.x and 8.0,x databases into Oracle 8I test environments.

• Setup and configuration of WebDB, Oracle Application Server 4.0.x, Oracle JSever. Design, and deployment

of Internet application with PL/SQL, and Java languages on Oracle Application Server.

• Setup, and implementation of RMAN catalog solutions with Legato Networker media management software

for backup and recovery of more than 50 Oracle/UNIX Servers.

• As a part of Y2000 team, reviewed more than 75 Applications for Optimization of SQL/PLSQL code.

• Setup, configuration of Oracle Designer 2000 repository, ERWIN modeling tools.

Hardware: Sun Sparc 10,20,60 E3000, E4500, PC AT.

Software: Oracle 7.2.x, 7.3.x, 8.0.5,8.1.5, Sun Solaris 2.6 Rman, Ebu tool, OEM 2.0.4, Oracle Application Server 3.0,

4.0.Oracle Designer 2000 SQL Windows 5.0.4, ERWIN 3.5

IBM GSA, Sydney Australia Nov 97- April 98

Client: Telstra, Sydney

DBA Team Leader/ Data Modeler

• As a DBA team leader, supported a team of 6 member for installation, configuration of several Oracle

Database Instances on multiple machines to facilitate staging and testing process for Y2K compliant Oracle

Database Servers.

• As a Team leader, reviewed more than 30 applications towards Year 2000 compliant guidelines and

procedures.

• Implementation of Oracle Data migration, backup and recovery procedures, for migration of data from

production servers to test servers for staging the testing environment.

• As a part of Y2k team reviewed several applications and implemented several performance-tuning

techniques, both at application and server level.

• Acted as a resource person to application developers of SQL, PL./SQL, and Pro*C programs.

Hardware: Sun Sparc 5, 10,20, Sun E10000.

Software: Sun Solaris 2.5/6, Oracle 6.x/7.0.x/7.x, Oracle*Forms 4.5, Oracle*Reports 2.5, Oracle*Developer 2000,

Oracle*Designer 2000, PL/SQL, Pro*C

IT World Professional Consulting, Singapore Aug. ‘96 – Sep. ’97

Client: National Computer Systems Pte. Ltd., Singapore

Oracle DBA Team Leader/Data Warehousing

• As a DBA Team leader, responsible for setting up of Distributed, Replicated, Clustered, and Web

environments of Oracle Database Software on Sun 3000,4500 and 6500 hardware platforms, for the tender

approvals with several Government Departments.

• Provided production support on 7x24 basis for more that 50 Oracle Servers on Sun Solaris, AIX, and HP

platforms.

• Installation and configuration of SAP on series of government servers. Performed the duties of SAP basis

administrator at various government sites. Developed backup and recovery procedures utilizing unix pipes

for the backup file sizes extending more than 2GB in size.

• Designed and implemented a large database over 4 TB with High Availability for Singapore

Telecommunications, with Technical support from Oracle Corporation and Sun Microsystems

• Setup backup and recovery procedures with EBU, and RMAN utilities of Oracle Server with Netbackup and

Legato Media Management Software

• Conducted Oracle workshop in NCS and trained more than 50 IT staff to learn Oracle DBA/Application

development.

Environment: Oracle 7.1.4,7.2.3,7.3.2,7.3.3,7.3.4,8.0.4, Oracle Web Application, Server 3.0, Advanced Replication

Option, Oracle Parallel Server, SAP R3 3.10, Informix 7.12, IUS 912, Sun ES3000, E4500, E6500, Sparc 20, HP 9000,

Sun Solaris 2.5.1,

Unilever New York City, NY June 95 Dec 95

Position: DBA

Project: Unilever is one of the largest household consumer goods manufacturers in the world. This data center handles

the IT operations of the North America for this multinational giant. Some of the key applications supported in this

center include financial and management information systems. In a team of three Oracle DBAs, was responsible for

providing production/testing support for several databases in client Server configuration.

Page 9 of 10

• Design, and implementation of intranet solutions with Oracle 7.3 Web Server HTML options.

• Logical database design, physical database design, crosses functional to facilitate data sharing across several

divisions.

System Environment: HP 9000 K200 series, G40, G30. HP 3000, PC/AT Compaq, ORACLE 7.0.16, 7.2.x, ORACLE

FINANCIALS 9.0, SQL PLUS 3.1, PL/SQL 2.3, 2.x, ERWIN 2.1/2.5., Business Objects 2.x, Cognos, InfoHub 2.x, HP

UX ver 9.x, 10.x, SQL*DBA, SQL * Loader.

GE Capitol Stamford,CT Oct 94 June 95

Position Data Architect/Oracle DBA

• As a senior Oracle Consultant responsible for design of a large Data Warehouse of the requirements of

Commercial Real Estate.

In a team of two, responsible for conducting, review sessions with business users, for the design of a large

Corporate Data Warehouse.

• Design of Dimensional Modeling, Star Schemas, changing dimensions, and establishment of data

staging process.

• Evaluation, deployment of ETL tools such as Infohub,Infopump, and Cognos.

Designed several source to target mappings, as per business rules.

• Design and development of several universes from Business Objects to facilitate report-writing requirements.

• Establishing procedures for Oracle RDBMS such as space allocation, file layout, update schedules, backup

and data archive strategy, database tunable parameter settings.

• Resource for Oracle/UNIX development staff providing both SQL/PLSQL coding assistance and aiding in

general design decisions as part of the development team.

• System Environment: HP 9000 K200 series, G40, G30. HP 3000, PC/AT Compaq, ORACLE 7.0.16, 7.2.x,

ORACLE FINANCIALS 9.0, SQL PLUS 3.1, PL/SQL 2.3, 2.x, ERWIN 2.1/2.5., Business Objects 2.x,

Cognos, InfoHub 2.x, HP UX ver 9.x, 10.x, SQL*DBA, SQL * Loader.

Fidelity Investments, Boston MA June 93 Sep 94

Position: Oracle DBA

Fidelity Investments implemented Oracle Parallel Server option for their vantage 20/20 project in Boston on

Pyramid Hardware with Tuxedo as the TP monitor. As a part of DBA team my specific responsibilities include :

• As an Oracle DBA, involved with logical database design, physical database design of Oracle Database with

Distributed and Replicated options.

• Performed the role of TUXEDO administrator in optimizing FML buffer allocation of TUXEDO application.

• Designed and developed PRO*C, and SQL/PLQL code in interfacing with Tuxedo Application.

Environment: Sun Sparc 10,20, PYRAMID, Orcle 7.2.x, SQL * Loader, ERWIN 2.0

New York Merchantile Exchange(NYMEX) Houston Mar 92 May 93

Position : DBA /Data Warehousing

In a team of two, responsible for Requirement Analysis, Dimensional Modeling, Star Schema Design, Logical

Database Design, and Physical Database Design for Enterprise wide Data Ware Housing Pilot Project. Specific

responsibilities include:

• Conducting Joint Application Development sessions with business users and mapping them into Dimensions

and Star Schemas towards Order Entry System and Data Warehousing requirements.

• Trained personnel in IS department on usage of Erwin2.5 Data Modeling Tool for Logical Design, Physical

Design, and Schema Generation.

• Implemented Star Schema, Data mining solutions with Cognos tool

Performance tuning at System level and at application level.

System Environment: HP 9000, RS/6000, PC/AT.HP/UX 9.0, 10.0, ORACLE 7.1.4,7.1.6.,7.2.3,7.3, PL/SQL 2.3,

Business Objects 2.x, Cognos 2.x

LGK COMPUTER SERVICES INC

INVENTORY MANAGEMENT SYSTEM (Aug '91 - Feb '92)

Systems Analyst

• Developed Bill of Material(BOM's) for an Inventory management system for a machine tool manufacturing

firm.

Page 10 of 10

• Used SQL* FORMS for data entry applications.

• Designed SQL*MENU to develop screens and

• SQL* REPORTS for developing stock reports.

• Used Pro*C to integrate the performance of the system.

• ENVIRONMENT: RS/6000, ORACLE 6.0, SQL*FORMS, SQL*MENU, PRO*C, SQL*REPORT WRITER

• Responsible for requirement analysis, functional specification, Schema Development and Data Modeling for

a video rental agency.

• Developed ER Diagrams for the system, and used normalization techniques to design database tables using

Case*Dictionary, and Case*Designer.

• Developed screens using SQL*FORMS 3.0, and CASE*GENERATOR.

• ENVIRONMENT: RS/6000, HP 9000, ORACLE 6.0, FORMS3.0, CASE*DICTIONARY,

CASE*DESINGER, CASE*GENERATOR, SQL*REPORT WRITER 1.1.

P.N.B.ENGINEERING SERVICES, India

Advances Against Shares System (Jun '86 - Jul '91)

Programmer /Analyst

• Designed, developed, tested and implemented an Advanced Against Shares system for employee's

cooperative bank.

• Developed modules for marker prices, values instruments, and display of customer information.

• Used Application Productivity Tool, Data Workbench, and DB/Library to design database tables, forms, and

reports.

• Worked with ISQL, developed triggers, and procedures to provide integrity of the database.

• ENVIRONMENT: SUN 4/20, SYBASE 4.0, SUN/OS, ISQL, APT, DWB, DBLIB.

Education:

• M.B.A (Information Technology) Argosy University, Orange County U.S.A 2007

• M. Phil Jawaharlal Nehru University, India 1987

• M.S. Jawaharlal Nehru University, India 1983

Certifications:

• Oracle Certificate Professional 11G DBA 2010

• Oracle Certified Professional 10G DBA 2009

• Oracle Certified Professional 9i DBA. 2002

• Oracle Certified Professional 8i DBA 2002

• Sun Certified Solaris 8 Admin. 2002

• Certificate of Proficiency in UNIX & C 1993

• Diploma in RDBMS 1993

• PGDCA 1991

Contact this candidate