Oracle Manager
Resume:
[pic] [pic]
SUNIL . K . POOSA
abmiuy@r.postjobfree.com
Objective
Integrate knowledge and experience and implement towards achieving
organization's goal. Seeking a challenging position as a DBA/Architect
in the field of Oracle Application Implementation, Support and
Analysis
Professional Summary:
. More than 7+ years of DBA Experience and 6+ years of experience in
Oracle Apps database administration and expertise with all facets of
Database Design, Performance Tuning, Backups and Recovery, Security
Management, File System Management and Monitoring.
. 3+ year's experience in Oracle Application Server 9iAS/10gAS
Installation, Configuration and Integration
. Adept at the administration and tuning of multiple databases within
mission-critical, 24x7 production environments.
. Expertise in database design, administration, implementation, tuning
and troubleshooting and support of critical production environments
. Expertise in Administering database security, Monitor and optimize
database performance, audit user activities on the database and
monitor the user transactions
. Experience designing and implementing mid to very large databases with
respect to access methods, access time, batch processes, device
allocation, validation checks, organization, protection and security,
documentation, and statistical methods
. Installing / configuring E Business suite in a single node / multi
node and shared Application Tier
. Experience in providing production support for various environments on
Level3 basis using Remedy Ticketing Tool with Enterprise user security
and Oracle internet security. Thorough knowledge of Support systems
using EMC SRDF
. Experienced in Oracle database administration, performance tuning and
backup/recovery within Windows 2003 Server, Sun OS/Red Hat Linux AS 4,
IBM -AIX and HP UX environments.
. Served as SME in all aspects of data management and database design
/DBMS software Expertise in implementing data import techniques, field
level encryption, transact SQL, and extensive experience with all
database objects (stored procedures, UDFs)
. Experienced in Oracle Products Integration.
Core Skills
. Thorough knowledge of Logical & physical standby database [Data Guard]
. Good understanding of DB Links and data archive procedures
. Performed VTM (CPU) vulnerability and patch upgrades
. Experience working on SOX initiatives and change management
. Oracle RDBMS 9i/10g/11g Installation,Configuration & Upgradataion
. Thorough knowledge of backup and recovery procedures, RCSA compliance
of databases
. Middle Tier Troubleshooting / Apps Tuning with Load Balancing
. Good Knowledge on Patch Analysis and Deployment [ad patch, Opatch and
CPU Patches]
. Hands on experience in working with Oracle Streams
. Expertise on Maximum Availability Architecture Design and
Implementation Like 10gRAC,ASM,DataGuard[DR],Flashback, [OEM]Oracle
Enterprise Manager 10g Grid Control Oracle OID, SSO [Single Sign On],
Active Directory & RMAN in a multi Applications environments.
. Backup & Recovery using RMAN- Veritas Net backup interface and Tivoli
. Implemented 2 Node Real Application Cluster on Linux using ASM driver
Interface
. Install, configure and maintain BMC Patrol for Oracle and Sql
backtrack
. Data Migration and Data Modeling including Memory Tuning and SQL
Tuning with Performance Enhancement
. Knowledge of all supporting infrastructure components, including
operating systems, hardware/storage configurations and network
. Designs and normalizes low to medium complexity logical entity models
and converts logical models to physical databases for low to medium
complexity databases
. Allocate system storage and plan for future storage requirements for
the database
. Implementations and Supported various Instances on HP-UX, IBM - AIX,
Linux X86, SUN SOLARIS SPARC Hardware with use of i3 for performance
monitoring
. Provide optimization support to developers and database structural
change impact analysis
. Expertise in design, develop, implement and manage database backup and
recovery plans / disaster recovery plans [Data Guard]
. Has experience in Data Warehousing environment with ETL and 10g
Database by using Oracle as Data warehouse.
. Providing input regarding database standards and best practices
. Upgrade/Migration of Oracle RDBMS 9.2.0.6 to 10g and 11.5.8 to
11.5.10.2 [Sun Solaris]
. Migration of Oracle Database Instances from Test to Dev and Dev to
Prod
Qualification
. Bachelors Degree in Computer Applications
Technical Skills
. ERP: Oracle Apps 11i/12i
. Databases: Oracle 9i/10g/11g
. Appl Sever : 9iAS, 10gAS, Web logic, Oracle workflow, LDAP
. ETL: Informatics, Cognos, Erwin
. Fusion Middleware: OTM, Demantra, Discoverer, OBIEE, BI Publisher,Oracle Portal
. BPEL, SOA Suite, Sabrix, Synchro
. RAC: Oracle 10g RAC, Oracle 11g RAC
. OS: UNIX, Linux, Sun Solaris, IBM AIX, Windows, MS-DOS
. Tools: SQL Developer, OEM10g Grid Control, TOAD, ODBC, SQL*Loader,
SQL*Plus, JDBC Networking: TCP/IP, LAN, WAN, SAN, NAS, DAS config
and administration
. Programming: C,C++,PL/SQL,SQL,Unix SHELL Scripting, Perl Scripting
. Max Avail Arch : 10g RAC, CRS,ASM, Data Guard, RMAN/BCV backups,
Partitioning, Compression, Veritas, Net Apps and Tivoli
Certifications
. OCP Certified for Oracle 9i Database
. OCP Certified for 11i E- Business Suite
. E- Business Suite Support Champion
Work Experience
. Working as Oracle Apps DBA for CISCO SYSTEMS Inc
from Oct'2009 to till date
. Worked as a Lead Consultant for Deloitte Consulting
from October' 2008 to Sep'2009.
. Worked as consultant for Cap Gemini Consulting
from May' 2007 to September' 2008.
. Worked as Oracle DBA for InfoTech Enterprises
From Nov'2002 to Apr'2007
Professional Experience:
[i]
Client CISCO SYSTEMS
Position: Consultant: Oracle Apps Database Administrator
Employer: TCS
Duration: Jan'2010 - Till date
Environment: Oracle 11g Database, 11g RAC, BRIC Localization, DMZ
Configuration
Oracle 10gAS, OTM 6.0, EBS 12.1.1.x,
Responsibilities: Implementation of OM & SCM Modules with EBS 12.1.1 /
11gr2 DB
Performance Tuning, Critical Issues
resolution, Project Co-ordination
Installation, configuration & administration
of OTM 6.0
Performance Tuning & Concurrent Manager Troubleshoot
Integration of OTM with EBS 12.1.1
load balancing, PCP and 4-Node RAC
High Level support of Production & Development Instances
[ii]
Client Norwich Union, Pennsylvania, USA
Position: Team Lead: Oracle Apps Database Administrator
Employer: Deloitte Consulting
Duration: April'2009 - Sep'2009
Environment: Oracle 10g Database, 10g RAC, ASM, Informatica, DMZ
Configuration
Business Objects, Oracle 10gAS, Oracle Demantra 7.1.1,
EBS 12.1.1.x,
Responsibilities: DB Upgrade, Dataflow mappings, Throughput
monitoring, RMAN with Tivoli
Performance Tuning, Critical Issues
resolution, Mentoring Junior DBAs
Conceptualize application solutions and advise on complex
architectures
Installation, configuration &
administration of Oracle Demantra
SGA Tuning, Memory Tuning & Hardware Level Tuning
Integration of Oracle Demantra with EBS
Configuration & Managing environments with failover/high
availability (load balancing, PCP, RAC, Mirrored
Environments, disaster recovery
Determination of table attributes primary and alternate
keys for multiple databases
Level 3 support of Production &
Development Instances
Managed Team of 8 Junior DBA's and Associate DBAs
Onsite/Offshore
[iii]
Client Sony Electronics, San Diego, CA
Position: Team Lead - Oracle Apps Database Administrator
Employer: Deloitte Consulting
Environment: Oracle Database 10g with RAC on Linux, 10g Appl
Server
Oracle E - Business Suite 11.5.10.2
Duration: Feb'2009 - Mar'2009
Responsibilities: SSO - OID integration for Oracle E - Business Suite
11i
(Including Secure Socket Layer and Load
Balancing), 10gAS
Oracle RMAN with Veritas Net Backup
Environment Support for Client with
Development Issues, windows 2003
[iv]
Client LodgeTel Inc, Carson, CA
Project Name: Maximo DB Migration
Position: Sr.Oracle Database Administrator
Employer: Deloitte Consulting
Duration: October'08 - Jan'09
Environment: windows 2003, Oracle10g, IBM AIX, Maximo Application
Responsibilities: Production Server migration windows to Linux
Cloning, Patching, & Migration of Oracle Apps / RDBMS
Database
Data Migration, Code Migration and Custom Migrations
Deploy custom Modules for Developers
Patching, Cloning, Workflow Administration
Apps Technology stacks administration and troubleshoots
ad utilities, autoconfig, concurrent managers, jserv,
forms, reports and discoverer
Performance Tuning of Database [optimization, resource
Management]
Administration and Maintenance of
Production Servers
Installation of Oracle Products
Database Migration, Support Issues during
Migration
[v]
Client Princeton Review, BOSTON, USA
Project Name: Princeton Upgradation
Position: Sr. Oracle DBA
Employer: Cap Gemini Consulting
Duration: Feb'2008 - Sep'2008
Environment: RHEL AS4, Oracle 9i Database, Linux x86, EBusiness
Suite11i
Responsibilities: Upgrade of e-Business Suite [11.5.9 to 11.5.10.2]
Upgrade of Oracle Database [9i to 10g]
Implementation and Maintenance of HRMS
Functionality with core Oracle Financials
CPU/ Maintenance Patches
Bug fixes
Dev / Test Instances support
Deployment of Financial Modules [AP, GL,
FA, PO] and Manufacturing
Support of Code Migration
Data Modeling and Database Security
Tuning of PL/SQL Codes
[vi]
Client : British Council of London, UK.
Project : SWANSEA COUNCIL
Position: Sr. Oracle DBA / Apps DBA
Employer: Cap Gemini Consulting
Duration: May'2007 - Jan'2008
Environment: RHEL AS4, Oracle 10g, Developer Suite 10g. Linux
x86, Ebusiness Suite11i
10g Discoverer, PCP, Load Balancing
Responsibilities: Financial and Costing Module Implementation
Development support for Oracle Projects Module
Building TEST / DEV environments
Integration of 10g discoverer with E-Business Suite.
Creation and administration of EULs
Configuration of Business Layers
for Development Team
Migration of EULs from Dev to Test
and to Production
User and responsibility administration for Dev Team
Troubleshoot reporting issues with
Discoverer
Implementation of Legacy settings
systems analysis and troubleshooting
Support and maintenance of
Instances
UK HRMS CU2 implementation
Deployment of Financial Codes
Performance Tuning
Application Tuning [Concurrent
Managers/Programs]
Implementation of HRMS /Vertex /
Oracle Inventory / Order Management
[vii]
Client Name Sempra Energy, Los Angeles, USA
Position: Sr. Oracle Apps DBA
Employer: InfoTech Enterprises
Duration: May'2003 - Apr'2007
Environment: Oracle 8/9i/10g Database with Custom Application,
SUN OS 5.8
Responsibilities: Production Database support for multiple Oracle
Databases
Data Patching, Service Requests.
Data Replication status on daily basis &
Performance Tuning.
Administration and monitoring using OEM and TOAD
administration
Tuning of multiple databases up to 1 TB in size
within mission-critical,
24x7 production environments
Backup and Recovery, Database Tuning, SQL Tuning
Maintenance schema objects, Database Objects
Implementation and Scheduling of Shell
scripts for purging the old data
Migrating schemas from development to
test and test to production databases.
Refreshing data from production to test
and development.
Improved response time by tuning SQL
statements within Queries and Codes
[viii]
Client: InfoTech America Inc, USA
Position: Oracle DBA
Employer: Infotech Enterprises Ltd
Duration: Nov'2002 - Apr'2003
Environment: Oracle 8/9i Database with AutoCAD Map, Micro
station, Arc Info, MapInfo,
Small World, Staad, ProE, Sybase
ASE 12.x
Responsibilities: Development /Production Database support for
multiple Oracle Databases
General Daily Database admin Tasks
Monitored and maintained Database storage.
Created Users, Granted privileges and profiles.
SQL and performance tuning, index rebuilding process
Created indexes and tables with proper storage parameters.
Involved in taking Backup of Database using Logical (Export
& Import) &
Physical (Online & Offline) Backup.
Migration of Sybase 12.x to Oracle 9.2.0.4 using SwissSQL
Migration tool
Wrote scripts for database monitoring and backup.
PL/SQL programming and Tuning
Database complete and incomplete recovery.
Data loading using SQL*Loader as and when required
Contact this candidate