Manager Oracle
Resume:
Prasad Tammana
Houston, Texas
PH: 949-***-****
*************@*****.***
Experience Summary
> Having 14 years of vast experience in Oracle Database Technologies as
Developer, DBA, FMW Team Lead, Apps DBA and Solution Architect
> Responsible for managing large size Oracle Production databases (7.3
to 11g) with RAC and Data Guard options.
> Having very good experience with Fusion Middleware and Oracle Apps
implementation and administration.
> Architected and delivered multiple projects like E-Business Suite
global implementations, storage Migration to ASM, VMware, Server
Migrations, EMC snap cloning, DR setup, Security & Auditing,
Partitioning and Archiving, Replication (Shareplex and Streams),
Reporting, Gateway to AS400, Compression, and heavily used .com
websites.
> Team Lead for multiple E-Business suite projects and well versed with
OBIEE, BI Apps, BI Discoverer integration, SOA Suite implementation,
integrating with multiple third party applications, Workflow, SSL
Implementation, segregation of duties, PCP, Cloning, Patching and
Upgrades, Load Balancing, DMZ setup, Single signon (SSO), iproducts
implementation, Multilanguage implementation, Forms personalization,
Extension, Migration and system administration.
> Having very good experience in product development and played key role
in developing product called Remote vigil to monitor Databases
Remotely.
> Having deep understanding of Datawarehouse technologies and tuning ETL
and reporting jobs.
> Having extensive experience as DBA (7.x to 11g), Forms 6i/10g, Report
6i/10g, BI Publisher, PL/SQL, RMAN, OEM, Real Application Testing and
Automating tasks using shell scripting,
> Provided extensive support in Installations, Upgrades, Backup and
recovery, Troubleshooting and resolving problems related to
Performance and Tuning.
> Designed applications and databases to achieve High availability and
Scalability for supporting critical Databases in 24*7 environments.
> Worked in Financial, Wireless, Insurance, and Health and Energy
sectors.
> Implementing and improving Standards, Best practices, processes,
automating tasks and mentoring other team members.
> Clearly understanding the Business requirements and designing custom
solutions to fit into the organization needs considering them in terms
of implantation time, maintenance, usability and cost.
> Leveraging technology advancements and working with cross teams to
meet Business needs.
> Very energetic, having excellent analytical, problem solving,
communication and leadership skills.
> Leading technology teams including project planning, coordinate ng
with cross teams, conducting meeting and tracking progress of multiple
projects in highly dynamic and demanding environments.
> Authored chapters for Oracle press book 'Oracle9i OCP DBA Fundamentals
II'
Education details
. Bachelor of Technology in Electrical and Electronics
1 Oracle 8i Certified Professional
Professional Experience
Company - Vedicsoft Solutions, Solution Architect (Apps, SOA and Database)
Client - Allscripts, Atlanta
Jan 2012 - Till date
As Lead consultant responsible for leading and managing multiple
infrastructure projects related to FMW, E-Business suite of Allscripts.
. Implementing and managing Fusion middleware 11g (weblogic, SOA, OSB,
BAM and ODI servers) with High availability options.
. Created security policies and deployment scripts.
. Configuring WLDF, watches and notifications for monitoring.
. Implementing Customer Data Hub (CDH) as Master data management (MDM)
and cascading the information to hub systems using SOA
. Integration of Oracle quoting with salesforce.com with custom SSO
using appsdatasource, SAML Tokens and custom coding.
. Creating scripts for code deployment
. Created Notifications and diagnsotics in weblogic server monitoring
for errors and other events.
. Created scripts for cloning of FMW components.
. Implementing WellsFargo Adapter for payables.
. Installing E-Business suite 12.1.3 with Database 11.2.0.3 and latest
Technology stack (10.1.2.3 and 10.1.3.5) including post product
specific patches
Environment planning for Gold, Development, Configuration, Conversion,
system Testing, Integration Testing and UAT serving multiple projects
and releases.
. Implementing Oracle Secure Enterprise Search 11.1.2.2.0
. Implemnting Oracle Data integrator 11.1.1.5
. Implementing Various SOA components and managing them including EM,
OSB, ODI, BAM, UMS with high availability options.
. Working with network team in implementing F5 Big IP with LTM and web
accelerator for optimizing WAN traffic and SSL for EBS.
. Setup A Health Check On A BIG-IP Loadbalancer To Monitor E-Business
Suite
. Implementing Bi apps for Financials, HR and Sales Analytics using OBIE
11.1.1.5 and BI apps 7.9.6.3 with DAC 10.1.3.4 and Informatica 9.0.1
and Hot fix2
. Evaluating options to integrate salesforce.com for building sales
analytics using universal adapter and FCS third party product.
. Implemented High availability for OBIEE (Horizontal scaling).
. Designed solution to meet seamless integration between internal and
External (for Mobile apps connection) access of analytics with LDAP
for identification.
. Implementing Oracle EPM Hyperion Financial Close Management 11.1.2.2
(Close manager and Account Reconciliation manager) on multi node.
. Implementing Vertex 6.0.
Company - Vedicsoft Solutions, Solution Architect (FMW, Apps & Database)
Client - Kinetic concepts Inc., Sanantonio
March 2011 - Jan 2012
As a Lead consultant responsible for managing FMW, planning and execution
of the Upgrade project
Of Oracle Apps from 11.5.10 to 12.1.3, and 3TB Database upgrade from 9.2 to
11.2.0.2 on AIX 6.1 and Linux 5.1 with 4 internal nodes and 2 external
nodes. The application consists of Financials, Manufacturing and
Distribution modules. My responsibilities include
. Deploying SOA composites and war,jar & ear files
. Tuning JVM and memory settings for garbage collection
. Implemented purging of SOA MDS repository for optimal performance
. Installing OSB, Jdeveloper, and POC for AIA.
. Changing configuration plans as required for code migration between
environments.
. Scripting and automating Sysadmin tasks and DBA Tasks related to
printer setups, Menus, responsibilities and other functionalities
reducing the manual tasks needed during cutover.
. Configuring External servers with DMZ and resolving issues to support
modules like isuppliers, iprocrurement, ireceivables..etc.
. Upgrading E-Business suite from 11.5.10.2. to 12.1.3
. Working with multiple third party applications and teams related to
OBIEE, Noetix Reports, Loftware printing, More4apps, and SOA.
. Tuning critical and mandatory Concurrent jobs such as DQM stage data,
Geo name referencing workers, custom patches and Apps patches to
reduce time for post upgrade steps from 14Hr to 3 Hrs.
. Leveraging technology advancements like pre staging the Application
Technology stack, Distributed AD, importing/exporting stats to
minimize cutover time.
. Working with Datawarehouse Admin in tuning ETL jobs related to OBIEE
BI Apps.
. Troubleshooting OAF personalization, Installing weblogic server 11g,
Deploying ADF
Application and integrating with E-Business suite.
. Automated printers move from AIX to Linux pass through via Windows OS
needed for Apps report printing
. Resolving issues related to setups, configurations, patches, DR
Testing and playing a key role in successful implementation of the
project.
. Preparing and enhancing the cutover Document with the steps needed for
the upgrade.
. Environment planning and preparing the plan for patch deployment.
. Migrating Concurrent Manager from IBM AIX to Linux, and configuring
shared Application Tiers and resolving issues related to them.
. Configuring XML Gateway with OTA and resolving issues with Trading
partners firewall issues.
. Implanting customization of initialization variables and managing all
database parameters using context file.
Company - Vedicsoft Solutions, Solution Architect (Apps, FMW & Database)
Client - Litton Loan Servicing,(Goldman Sachs subsidiary) Apr 2008 -
March 2011
Responsible for managing Development and Production environments
containing Databases, E Business Suite and Middleware and Architecting
database solutions and delivering multiple projects with availability,
scalability, adaptability and security features meeting the business needs.
. Administrating Weblogic server 10.3.3 which includes installation,
application deployments, Domain Creation with templates, cluster
servers management, nodemanager and troubleshooting.
. Apply patches to weblogic server and FMW
. Installation and configuration of SOA, OSB, OHS, and resources like
JDBC, JNDI and JMS.
. Troubleshooting performance issues related to JVM with the help of
jmap and jhat utilities
. Generating wsdl and deploying services to integrate E-Business suite
with other Financial products
. Integrating E-Business suite 12.1.3 and legacy code on Oracle
Databases and services running
on other financial applications.
. Creation and deployment of BPEL composite application having DB and
Oracle Apps adapter.
. Clear understanding of SOAP, WSDL, XML, XSD, Business Rules, WLST,
UDDI, Weblogic security architecture and implementation of policies.
. Responsible for managing multiple Oracle 10g & 11g RAC Databases (OLTP
& Dataware House) on Sun Solaris 10 both Development and Production
environments of sizes ranging from 200GB to 6TB with thousands of
transactions per second.
. Upgraded multiple Databases (RAC and Non RAC) from 10g to 11.2.0.2
with planning, coordinating and implementing it by minimizing the
risks and reducing downtime with transient logical standby.
. E-Business suite upgraded from11.5.10 to 12.1.3 and coordinating the
efforts with Business Team.
. Optimizing Oracle Apps Upgrade process and reducing the upgrade window
by 3 fold by Tuning, Staging, automating various tasks and
accomplishing Database upgrade, Server Migration and Oracle Apps
Upgrade.
. Environment planning, Impact analysis, creating process for patching
and merging with Production changes, laying out process related to
change control.
. Prepared Presentations for Technical Team and Functional Teams for R12
Upgrade showing the differences and new features in the stack.
. Prepared project plan for R12 upgrade and working with cross teams to
resolve the issues while upgrading.
. Automating tasks for custom patching, Apps patching on multi nodes,
Cloning and configuration setups and sysadmin tasks.
. Maintain Databases and Oracle E-Business Suite up to date by applying
quarterly PSU and CPU patches, upgrades related to weblogic server,
ATG, Forms, JDK and family Product patches and cloning.
. Responsible for Creating custom reports using BI Publisher (XML
Publisher) in E-business suite.
. Implemented SSL on Oracle Apps and split Concurrent manager and Web &
Forms of E-Business suite and shared Application Tiers.
. Having strong skills in Performance tuning and troubleshooting issues
caused by very high concurrency. Tuned multiple queries and reduced
the execution times from hours to minutes.
. Reduced monthly refresh time from 18 hours to 2 hours and space usage
from 18TB to 6TB for building 6 different environments (Dev, Test &
Project environment each of 3 TB) by leveraging combination of ASM,
EMC Snap clones and standby database, and intermediate database for
post steps and automating using shell scripts.
. Leveraging ZFS pool to make snaps for long running patches on oracle
apps to rollback point in time and ZFS compression to reduce backup
space and time by 60%.
. Implemented 11g Active Dataguard and 10g Dataguard and carried out dry
run for switchover and automated steps to monitor log gap and deletion
of archive logs, and tuning of network settings based on BDP.
. Reduced CAPEX by Converting VERITAS powerpath to Solaris mpxio,
VERITAS File system to ASM and carried out this conversion in the
least amount of time.
. Reduced RACK space by server consolidation and zoning, and making this
effort of migration of large databases to be accomplished in less than
an hour.
. Evaluated the options to improve backup operations, and worked with
Unix Team to create private LAN and server free backups to segregate
backup traffic and Database Link traffic.
. Implemented 11g Gateway to establish connectivity between Oracle and
AS400.
. Configured and installed 11g RAC with multiple interconnects for HA
and Jumbo Frames for interconnects to improve cluster performance by
20%.
. Prepared script to migrate database changes from dev-test-prod in
regular and E-Business suite environments. This Reduced turn around
time for day to day operation - It works based on OS member ship,
password protected roles, shared Mail folder, checks for standard
rules, validating objects at the end, mailing to requestor with log
files, and highlighting any errors, centralized report to show what
changes were implemented in each databases by whom. This task reduced
the time spent by DBA from approximately 8hrs to 1 hr each day on
average with added benefit of improving change management process.
. Implemented security using TDE, AES, and FGA to meet security
compliance and supported Federal auditing.
. Automated consolidated report for Monthly DB usage and daily Backup
report of all Databases highlighting any failures.
. Capacity planning based on space, IOPS and throughput needs and
working with SAN admins
. Proactive monitoring of databases and providing RCA on critical
issues.
. Advanced performance tuning using Real Application Testing (RAT)
. Monitoring Databases using OSwatcher, Procwatcher, AWR, hanganalyze,
systemstate dumps, cluster Health Monitor, racdiag, SQL Tuning
advisor...etc
. Automated Daily report to execute SQL Tuning Tasks on resource
intensive queries and send recommendations as Email including Index
creation scripts.
. Troubleshooting Database issues using utilities like LTOM,
Hanganalyze, oradebug dumps (Heap dump, process state, error stack),
stackx, Pstack, OSwatcher, procwatcher, sqlt, awrsqlt, AWR, SPM.
. Helped Dev project Teams in data modeling, designing and tuning and
working with cross technology teams, Oracle warehouse Builder,
Informatica, Cognos, ETL Team, UNIX and SAN Teams as needed.
. Proactive monitoring of databases and providing Root cause analysis on
critical issues.
. Upgraded OEM from 10g to 11g and implemented E-Business suite
Application Management packs.
. Working with Informatica and Cognos teams to make analytical reports
available in real time and tuning the jobs.
Company - Herbalife International of America Inc, CA
Team Lead/Senior Oracle Apps DBA
Aug 2007 - Apr 2008
Provided support as a senior DBA/track lead for multiple project
initiatives and production support in managing 11.5.10.2 environments using
10.2.0.3 database running on Linux platform.
. Administrating Oracle Databases development, Test and Production.
. Technical Lead for Global rollout of Oracle applications in Asia
pacific region and Upgrade project.
. Working with Functional and Development teams to meet AIM
deliverables.
. Supporting Development team with Apps conversions, Migrations and
interface tables.
. Implemented Solix Archival solution for Oracle Apps.
. Implemented Oracle streams on 10g RAC
. Configured Load balancing on web and forms nodes using Cisco load
balancer and Parallel Concurrent processing on CM node
. Regular maintenance activities like Cloning and patching of Oracle
applications and custom migrations.
. Maintained application using AD utilities (Adadmin, Adpatch, Adctrl,
Adident, Adsplice, Adautocfg), administration
. Upgrading Oracle Apps to 11.5.10 using staged APPL_TOP to minimize
Upgrade time
. Managing and troubleshooting Parallel Concurrent processing and shared
APPL_TOP
. Performance and tuning of OAF based custom modules using multiple
JVM's and tuning GC
. Created shell scripts to monitor logfiles and long running jobs, and
other production jobs
. Converting of RAC to Non RAC databases and viseversa
. Integrating with multiple 3 rd party products and other systems like
Sabrix tax engine, Agile, Logility.etc.
. Installing SOA components and doing the feasibility study.
. Tuning SQL and PL/SQL code and helping development team.
. Implemented logical apps for segregation of duties
Company - Prompt Technologies, CA
Senior DBA
Client: Verizon wireless, CA, USA Feb
2005 - Aug 2007
Provided support to Verizon Wireless client- Part of Infrastructure team
supporting more than 100 Oracle databases on 9i and 10g, which are on Sun
Solaris. Provided support to major applications: Oracle apps 11i
financial modules, Access manager, Kana Applications,
verizonwireless.com, Self service applications for business customers,
Analytics and Reporting.
. Managing Development, Test and Production Databases
. Tuning Oracle Queries and doing scheduled maintenances.
. Deep analysis of Shared pool contention and Errors using Heap dumps
. Implemented RMAN backups using Tivoli Storage manager and created
extensive reporting on RMAN.
. Carried out Capacity planning, Automation of managing Partitions for a
database of size 1TB.
. Carried out Tablespace Point in time recovery by creating auxiliary
database
. Successfully carried out Billing system conversions involving millions
of customer accounts.
. Supporting Data warehousing systems and Informatica 7.1.4
. Providing support as on call DBA 24*7 for business critical databases
on rotation basis.
. Created shell scripts to monitor shareplex replication, Rman backup
purges, Lock monitoring, database refreshes and other requirements.
. Configured and supported Oracle Applications 11.5.10
. Up gradation of 11.5.9 environment to 11.5.10.2 on Sun Solaris and
reduced patching time by using staged APPL_TOP
. Implemented OID/SSO and Integrated with E-Business suite and Windows
Active Directory
. Regular maintenance of E-Business suite including installation,
patching, cloning and up gradation.
. Troubleshooting of Concurrent manager process, Forms, Web and Database
servers.
. Development and Production Support of Oracle Apps 11i environments
. Installation and Configuration of Application Desktop Integrator
(ADI), workflow notification mailer.
. Implemented 10gAS, 10g RAC, OEM grid control and VCS.
. Carrying out patch analysis and applied one of patches, mini packs and
maintenance packs.
. Configured database replication using Sharable and troubleshooting.
. Implemented sun LDAP directory server 5.2, and developed interface
scripts between LDAP and Oracle database.
Perot systems TSI, Bangalore
Apr 2003 - Feb 2005
Database Administrator
Client UBS (Union Bank of Switzerland), Singapore
Provided production database support to one of the world's largest bank,
Union Bank of Switzerland (UBS). There are close to 800 Oracle databases
(8i to 9i) in Solaris and Linux environment. As a part of Infrastructure
team, my major responsibilities were
. Setting up and maintaining Standby database and RAC on Linux.
. Installing the Oracle software and Creation of databases as per OFA
. Upgrading, applying patches and Cloning of databases.
. Resolving production problems related to performance corruption and
space related issues.
. Carrying out backups and recovery using SQL Backtrack.
. Performance and tuning of SQL queries using staspack, tkprof.etc.
. Troubleshooting and fixing up production problems and providing
support using chat service, alert monitoring, Hotline support and
ticketing services
. Carrying out production changes raised using change control systems
viz-Global Request service and Global Change Management system.
. Raising Tars and liaising with Oracle.
. Implemented Security standards and database auditing.
Oramasters Software India Pvt. Ltd., Hyderabad.
Database Administrator
Jun 2001 - Mar 2003
The company is an MNC, lead by well-known Oracle Technology experts and
Oracle Press authors, Michael Corey and Rama Velpuri. As a Database
administrator, I was responsible for Troubleshooting and solving customer
problems related to Databases and apps by giving online and onsite support
to clients in India and Saudi. My major contributions were
. Prepared the content for Osborne/McGraw-Hill book 'Oracle9i OCP DBA
Fundamentals II'
. Supported major clients in Saudi - MOI (Ministry of Interiors), Coast
Guard, ABBOT Labs, SABB (Saudi British Bank).
. Implemented Replication between DB2 on AS/400 and Oracle using Generic
connectivity.
. Migrated Arabic data from DBASE III to Oracle 8i database
. Developed various scripts for Remote vigil, a database-monitoring
product. It monitors changes in Configuration and Layout, Contention
Management, Database Availability, Memory Management, Object
Management, Process Management, Resource Management, Security
Management and Space Management
MFL Net Services Pvt. Ltd, Hyderabad.
Senior Software Engineer
Nov 1999 - Jun 2001
As a team lead I was responsible to manage a team of technical team of 5
members.
Developed various web and client server applications for insurance sector.
. Installed and managed SQL Server, Oracle Server and Web Servers.
. Carried out System Analysis and Design using Entity Relationship
diagrams and Process flow Diagrams.
. Created Procedures, Triggers, Indexes and tuned complex queries
. Designed application using HTML, Javascript, Java, JDBC and Servlets
. Setting up and managing Database replication in SQL server.
Global Energy Consulting Engineers, Hyderabad.
Software Engineer
Nov 1998 - Nov 1999
Developed various software projects for Electrical sector and related
major companies.
. Responsible for coding using SQL, Pl/SQL, Procedures and Triggers in
Oracle 7.3, C, Pro*C.
. Developing Front end screens using Forms 4.5 and Reports 2.5
. Developed various software applications for the Electrical Sector.
Contact this candidate