Oracle Management
Resume:
[pic][pic]
Neha Jadav
Email : abl88u@r.postjobfree.com
Contact : +1-781-***-****
RESUME
Summary
* 8 years of work experience as Oracle DBA
* Oracle 9i Certified Associate
* Oracle 9i Certified Professional
* Oracle 10g Certified Professional DBA (OCP)
* Oracle 11g Certified Professional DBA (OCP)
* Worked on Oracle 8i, 9i, 10g & 11g databases
* Backup & recovery : User Managed & Using RMAN
* Change Controls, SOX Compliance
* Worked on incident management, problem management, escalation processes
* Change Management: TrackWise, Boreland StarTeam
* User management
* Arrange/Coordinate disaster recovery (DR) setups and testing
* Have administration experience with SAP with Oracle databases
* Space management
* Worked for multiple clients on multiple projects
* Setup standalone and RAC environments
* Automation- Perl Scripting & Shell Scripting
* Database patching and upgrades: 9i => 10g, 10g=> 11g
* Oracle Database Upgrades: 8i => 9i ; 8i, 9i =>10g
* Conventional Patching, Hot patching
* 10g Grid Control : Configuration, Setup, Maintenance, Upgrades,
Dashboards, Apps Packs, Performance/Space/Consumption Reporting, Custom
Reports
* Non ASM to ASM conversion projects
* ASM with RAC implementation, management and troubleshooting
* Real Applications Clusters(RAC) 10g, 11g
* Experienced in Software Development Life Cycle Model (SDLC)
* Setup documentation base/wiki for technical and functional specification,
processes and procedures
* Experienced in Oracle Partitioning
* Mentored and trained other DBAs
* Oracle Streams
* Pro-active & Reactive Performance Tuning
* Database Replay
* HA : Standby databases, dataguard, Snapshot Standby database, Oracle
Advance Replication
* Cross platform database migration experience
* Coordinated & Worked with development to resolve development level issues
* Arranging meetings, discussions, planning, coordination etc with customer
and onsite team
* Other skills : Programming in C, .NET and PL/SQL
Scripting / Development / Automation Focus and Experience:
* Developed AutoCloner tool, capable of cloning RDBMS through scripting
* Participated in integration of backend shell/PERL code with Java GUI
for AutoClone with Java Developers
* Designed command line tools and utilities in Shell/PERL
* Designed sysdba_exec a personally developed perl function which can
communicate with database as sysdba user (online functions cannot
login in database as sysdba and DBAs requires superuser login)
* Developed cpatch, a utility for Oracle Apps DBAs to check patches
automatically in apps.ad_bugs table
* Automatic agent bounce scripts for EM 10g, listener bounce scripts in
SHELL/PERL
* Developement, troubleshooting, debugging, enhancing and fixing
shell/PERL Scripts
* Experience in database modules in PERL. Developed sysdba modules in
Shell.
* Design script tree structure and control mechanism
* Develop error handlers
* Set up DEBUG flags while coding to enable and disable detailed logs
* Modular code approach, standard naming conventions for forward
compatibility and maintenance
* Developing reusable libraries/header files in PERL for better code
reusability
Skill Set
Operating Systems
Platforms Sun Solaris Sparc 8/9, AIX 5.3 & above, Linux Advance
Server 3/4, Red Hat, HP UX, Win 2000/XP,Unix
Programming Languages PLSQL, SQL, UNIX Shell Scripting, .Net, VB, C, C++
Relational Database Oracle 11g/10g/9i/8i
Systems
Oracle Utilities and Oracle Enterprise Manager 10g, TOAD, SQL Developer,
Tools SQL*Plus, isqlplus, Data Pump, Export/Import, DBUA, DBCA,
Net Manager, Listener Control, Siebel Helpdesk, CA Service
Desk, ITSM(ticketing system), Netbackup, Veritas,CRS
Other Utilities FTP, winscp, Citrix, SecureCRT
Work Experience
Employer : Shyam LLC of Oklahoma
D signation : Oracle DBA
Duration : Aug 2009 - current
Employer : Oracle Corporation
D signation : Oracle DBA
Duration : Jan 2007 - Aug 2009
Employer : Infosys Technologies (Client Firmenich, Switzerland)
Designation : Oracle DBA
Duration : July 2002 - Jan 2007
Description
Projects and Experience in Shyam LLC
Client: Commerce Insurance (Webster, MA)
* Customized Grid Control 10.2.0.5 for reporting and setup monitoring for
all targets: Grid Installation, setup, configure and upgrade
* Administration of RAC, Non RAC databases
* Worked on performance issues for 11g databases
* Planned and executed 11g upgrades from 11gR1 to 11gR2, 10g => 11g R2
* Creating back out plans for complex changes like upgrades and patchings
* Monthly reports format preparation: Availability, Performance, Space
Usage, Alert History
* Oracle Restart issues follow up with Oracle Product Support after 11g R2
upgrade
* Day to day DBA activities
* RMAN backup configuration and maintenance
* RMAN catalog database creation, migration of control file based backups
to catalog based backups
* RMAN backup scripting/existing script modification for new instances
* Oracle file system housekeeping shell scripts development and deployment
* Automatic Oracle Agent bounce script deployments on hosts
* PSU patching Apr 2010
* Managed ASM and Non ASM databases
* Setup database standards and develop documentation
* Database/schema cloning and refreshes using: RMAN duplicate, expdp/impdp
* Performance Tuning of databases for server parameters/config and query
tuning whenever applicable
* Capacity planning for Grid Control
* Coordinated with Oracle Prod Support via conference, calls, TARs for
resolving complex problems
* Oracle Net - configuration, security, troubleshooting
* Suggestions/Coordination to the development for various PL/SQL related
issues and fixes
* User/Schema and Security Management
* Code migration across instances
* Convert non ASM to ASM databases 10g
* Change Management
* Training sessions and knowledge transfers on projects to team
* Change management practice
* Perl/Shell scripting
Client: Biogen IDEC (Cambridge, MA)
* Routine database maintenance activities added with ticketing and SOX
compliance(TrackWise) on and above 95% SLA
* Configuring dataguard and standby databases with Oracle 10g
* Setup monitoring for Oracle DB, Oracle 11i apps with Grid Control and SQL
Server components
* 10g Grid Control : Installation, Upgrade, Agent
Installation/Configurations, Agent installations on HP Service Guard
configurations for failovers
* Have setup Grid Control Monitoring / Reporting on Enterprise Level with
different severity alerts
* Monthly Reports, Alert Configuration, Siebel Helpdesk integration, Oracle
Apps Monitoring, Dashboards with Grid Control
* Code Migration
* 11g new features analysis and presentations for upgrade
* Transparent Application Failover
* Load balancing - RAC
* Deployment Procedures - Grid Control 10g
* Coordinated with Oracle Prod Support via conference, calls, TARs for
resolving complex problems
* Administering 10g RAC with ASM
* Database security & fine grained auditing implementation
* PL/SQL: Developed procedures, functions, triggers and other code modules
as and when required in project
* Basic administration Microsoft SQL Server
* Performance Tuning with Statspack, AWR, ADDM, TOAD, EM 10g, Customized
Scripts
* Performance Tuning - SQL statements and Server Tuning
* Monitoring - Scripts, TOAD
* Database link creation, maintenance and management
* Maintain Partitioned database-Range, List, Hash, interval (11g)
partitioning
* Oracle Net - configuration, security, troubleshooting
* Database Cloning/Refresh: RMAN duplicate, cold backup, hot backup
* User Management and Security
* Administration of RAC, Non RAC databases
* Compliance with SOX
* Backup Recovery : User Managed as well as RMAN with NetBackup
* Trigger, procedure, function development and troubleshooting
* SQL tuning, PL/SQL, shell & Perl scripting
* Installations : 11g, 10g, 9i
* Upgrades : 9i=>10g, 8i=>10g, 9i,10g => 11g, Grid Control 10.1.x.x to
10.2.0.4, agent upgrades from 10.x.x.x to 10.2.0.5/4
* Patching : Database 9i, 10g, 11g patching
Projects and Experience in Oracle Corporation
Worked in Oracle Corporation - work in 24*7 production support of Oracle
databases and Oracle Applications in i-DBA APAC (Asia-Pacific), part of
Oracle OnDemand, serving more than 30 customers including Vodafone, Canon,
Oracle(Internal Customer), AstraZeneca(R&D), BPCL, Aviva etc. delivers
database as well as applications support to Asia Pacific customers, having
more than 600 Prod instances and nearly 70 Apps instances and have done
activities like setting up monitoring, troubleshooting, ticketing,
patching, upgrades and regular maintenance activities etc.
Clients: Aviva, BPCL(Petro), Air India, AstraZeneca R&D, Canon Australia,
LMW, Maruti Udyog Limited, Unilever, Macquarie Bank Australia, PWC, Tesco &
others
Exposure on Database Technologies:
Clients: BPCL(Petro), Maruti Udyog Limited, LMW, PWC
* Oracle Enterprise Manger 10g Configuration, Management, Installation,
Maintenance
* Monitoring- regular database admin activities like ticket monitoring,
working on CR etc.
* General Technical Troubleshooting - Login problems, connectivity issues,
performance
* Designing Housekeeping Strategies - Purge Workflows, Concurrent Requests
Logs
* Patching & Upgrades (Major and point) - Databases (9i => 10g, 8i => 10g)
* Setup non ASM to ASM databases 10g
* Shell scripting, Perl Scripting
* Installation of Oracle databases, clients on different platforms like
Solaris, IBM AIX, Linux
* Oracle Net - configuration, security, troubleshooting
* Experience in database migration across platforms
o Done migrations through import/export, data pump
o Used transportable tablespaces for migration
(Solaris to Linux, AIX)
o Used RMAN for platform migrations with endian
formats
o Troubleshoot bugs and issues after migration
* Space Management
* User Management and Security
Client: Unilever
* Utilized Oracle Streams to capture, propagate, and apply the transfer of
data, transactions, and events within managed databases
* Tuning, troubleshooting, parallelism of Capture in Oracle Streams
* Setup streams for various databases and monitoring for it
* Setup/Maintain Log Transport Services for Streams
* Troubleshooting Propagation Problems
* Setup/Maintain Apply Mechanism
* Use exp/imp, RMAN, Data pump for backup and recovery
* Maintenance of RAC and Non RAC databases
* Oracle Clusterware installation and troubleshooting
* ASM implementations with 10g RAC databases
* Created and maintained Partitioned database
Client: AstraZeneca R&D
* Setup and managed dataguards and standby databases
* Onsite support for clients - special setups, troubleshooting
* Setup monitoring daemons(shell) for Oracle Databases
* Performance Tuning with Statspack, AWR, ADDM, TOAD, EM 10g, Customized
Scripts
* Performance Tuning - SQL statements and Server Tuning
* Monitoring - Scripts, TOAD
* Database link creation, maintenance and management
* Design & use Backup & Recovery : User Managed, Using RMAN
* Security patching
* Managed databases with ASM
Clients: Tesco
* Installed Oracle 11g
* Installation of Oracle databases, clients on different platforms
* Used database replay for testing
* Upgrade databases to 11g
* configured Oracle 11g ASM
* Setup streams for various databases and monitoring for it
* Utilized Oracle Streams to capture, propagate, and apply the transfer of
data, transactions, and events within managed databases
Clients: Canon Australia, Macquarie Bank Australia, Air India
* Monitoring- regular database admin activities like ticket monitoring,
working on CR etc.
* Logical Backups - import/exports, RMAN, data pump
* Transportable tablespaces
* Used oracle 10g scheduler to run the jobs
* Database cloning/refreshes
* Patching & Upgrades (Major and point) - Databases (9i => 10g, 8i => 10g)
* Performance Tuning with Statspack, AWR, ADDM, TOAD, EM 10g, Customized
Scripts
* Periodic proactive performance tuning
* Periodic mass password change activities
* Re-orgs of tablespaces
* Prepare documents (Power point, Word, Visio, pdf)
* Oracle Advance Replication: Multi master, Snapshot based
Projects and Experience in Infosys
Worked in Infosys - work in 24*7 production support Oracle databases. I
have been a key player in important activities like setting up monitoring,
troubleshooting, ticketing, patching, upgrades and regular maintenance
activities etc.
Exposure on Database Technologies:
Client: Firmenich
* Managed databases for oracle APPS,SAP application
* Managing data security - Implementing hidden triggers trapping sensitive
tables, auditing etc.
* Worked extensively with the development and user teams in solving
performance problems including database wide performance, SQL query
analysis and tuning
* PL/SQL Development for special requirements
* Monitoring
* Oracle Net - configuration, security, troubleshooting
* Design & use Backup & Recovery : User Managed, Using RMAN
* Scripting & Automation - to save time for day to day activities
* Space Management
* General Technical Troubleshooting
* Patching & Upgrades
* Basic monitoring and administration of Microsoft SQL Server databases
* Oracle Enterprise Manger 9i Configuration, Management, Installation,
Maintenance, Advance Alert Mechanism
* Performance Tuning - sql statements, buffer cache, shared pool, slow
performances & sessions etc.
* Proactive Measures - Benchmarking of databases, health check scripts,
performance matrices monitoring
* User Management and Security
Educational Qualification: - Bachelor of Engineering in Computer
Engineering
References Available on request ..
Contact this candidate