SUMMARY

• Over 8 years of experience as an Oracle Database Administrator.
• Good knowledge on Oracle Apps 11i & R12, Oracle Database 8i, 9i, 10g and 11g.
• Expertise on Installation, Upgradation, maintenance and administration of Oracle 9i, 10g RAC, 11g RAC Database.
• Supporting for Exadata machines
• Expertise on implementation golden gate for replication.
• Expertise in installing different versions of Oracle on Linux and Solaris.
• Good knowledge on Oracle advanced Technology RAC, Data guard, OEM, Grid Control, ASM and Replication using Materialized Views, Oracle Streams.
• Good in Migrating databases
• Good knowledge on VERITAS, NetApp Backup’s, BCV and EMC Storage Backups.
• Configured Golden Gate.
• Upgraded the database from 9.2.0.1 to 10.2.0.1 and 10g to 11g.
• Installed oracle 11g client and server software.
• Having experience in database cloning using RMAN,HOT,COLD backups
• Working in 24X7 on - call production database support and maintenance including remote database support.
• Experienced in development and production on Stand Alone and RAC
• Extensive knowledge in Oracle standalone, RAC database architecture.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Having experience in applying patches for database and applications.
• Capable of troubleshooting the troublesome sql statements.
• Generated ADDM for taking the advisories of a database performance.
• Configured Data guard and tested for failover and switchover
• Monitoring index usage and Performed Rebuilding of Indexes.
• Performed table and table space level defragmentation.
• Having experience in cloning and migrating database from Linux to windows.
• Applied latest patches and bug fixes for 11g .
• Experienced in taking regular off-line, online and logical Backups.
• Good Knowledge on languages C, Java, SQL, PL/SQL, UNIX Shell and Perl.
• Experienced in taking an RMAN backups to tape and disk.
• Experienced in assigning user level issues.
• Good Exposure on Performance Tuning and database design.
• Proficiency in creating business and technical project documentation
• Expertise is working with distributed and global project teams
• Project Resource planning and allocation
• Ability to work as a strong team leader to ensure quality and timely project execution

TECHNICAL SKILLS

Databases: Exadata, Oracle 9i, 10g RAC, 11g RAC, 12c, MS Sql Server.

Operating Systems: OEL, RHEL 2.1, 3.x, 4.x, 5.x, 6.x, Sun Solaris 9.0/10.0, HP 10.x, 11.x, AIX 5.3, 5.2, 5.1 and Windows200X/NT/98.

Programming& Scripting Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, JAVA

Tools: & Utilities: EXADATA,RAC, Golden Gate, Shareplex, OEM, Toad, Tidal, Site Scope, SQL Navigator, SQL* Loader, ASM, SQL Server,Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data Guard, VERITAS Net Backup, VMware, Logminer, CronTab, Remedy, Client ticketing systems

Tuning Tools: ADDM, AWR, TKPROF, EXPLAIN PLAN, STATSPACK

Terminal Emulation: Putty, Telnet, FTP

Applications: Oracle applications R12

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle DBA

Environment: 10g and 11g with RAC, Exadata Linux, Solaris, Aix, Golden Gate, Oracle applications R12.

Responsibilities:

• Supporting for Exadata machines and Golden Gate.
• Supporting for oracle application R12.
• Installation, Configuration and administration of Oracle 11g/10g database on Red Hat Enterprise Linux (RHEL) and also Upgradation from Oracle 10g to 11g.
• Configured 3-node Real Application Cluster (RAC) and monitored RAC instance with Oracle Enterprise Manager Grid Control.
• Installed and Configured Oracle Enterprise Manager Grid Control 11g.
• Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3-node RAC environment.
• Migration of database from one server to another server with zero downtime.
• Migration of Application Databases from SQL to Oracle.
• Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Confidential, Charovelott, NC

Sr. Oracle DBA

Environment: 10g and 11g, Exadata, Linux, Solaris, Aix, Golden Gate, shareplex, Oracle applications .

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, testing, QA and development databases.
• Installation, configuration and administration of Oracle RAC and Standby Databases (DataGuard) for High Availability and Disaster Recovery.
• Supporting for Exadata machines and Golden gate.
• Patching and upgrading to 11g
• Monitoring and maintaining cluster DB’s for their Optimal Performance and
• Trying to ensure 100% availability of the DB’s.
• Implemented 4-Node RAC with raw devices and ASM Library Interface.
• Allocating and reorganization of tablespaces.
• Incorporating user’s requests as per Emails.
• Job scheduling using dbms job and crontab.
• Backup database using export/import.
• Taking backups using RMAN.
• Performed Database Cloning from Production to Test environment.
• Performance monitoring and tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM..
• Maintenance of Database and Listener.
• Moving data between databases using utilities like Import, Export, SQL loader and Transportable Table spaces.
• Checking Alert log, trace files, listener log and other database job logs.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Implemented RMAN backup strategy.
• Administered the RAC database by using srvctl & crsctl utilities
• Moving data between databases using utilities like Import, Export, SQL loader and Transportable Table spaces
• Preparing scripts to automate the jobs.
• Housekeeping of arch files and trace files.
• Taking the online and offline backups according to the manager approval.
• Preparing AWR report for database health checkup and for performance improvement.
• Creating DB links, resizing of table spaces, allocating quota for users.
• Decommissioning of Schemas as per approved requests.
• Consistently interacted with client and team in resolving the queries.
• Working on Tickets to handle the sev 1/2/3/4 issues.

Confidential

Oracle DBA

Environment: 9i,10g and 11g,oracle R12 Linux, Solaris, Aix and Windows

Responsibilities:

• 24x7 Production database and applications support
• Managing multiple production, testing, QA and development databases.
• Installation, configuration and administration of Oracle RAC and Standby Databases (DataGuard) for High Availability and Disaster Recovery.
• Supported for both oracle databases and applications.
• Providing *24/7 Support on production instances
• Configuration Recovery Manager (RMAN), Dataguard, Distributed Database
• Database version Upgrades from 10.2.0.1 to 10.2.0.4
• Moving the Database across the platforms
• Cloning databases through RMAN with Auxiliary
• Configured the Clone databases from Production to reporting databases
• DBA support for Production, QA and Development teams.
• Perform regular database activities like space management, database health check-up etc. Troubleshooting and resolving numerous production issues.
• Implementation of Scheduled Change Control requests on Productions.
• Involved in migration of database from 9i to 10g.
• Allocating system storage and planning future storage requirements for the database system.
• Refreshing test database with production database when required.
• Administered databases remotely.
• Monitoring Alert log & System log files.
• Created users & privileges with appropriate roles and levels of security.
• Troubleshooting Oracle connectivity issues.
• Implementation of Backup and Recovery Strategies.
• Planning & performing hot and cold backups.
• Moving data between databases using utilities like Import, Export, SQL loader and Transportable Table spaces.
• Installed & configured 2-Node RAC using OCFS as cluster file system and ASM lib.
• Configured high availability services for Transparent Application Failover(TAF)
• Taking backups using RMAN
• Performed Node Eviction issues
• Patched and upgraded 10.2.0.1 databases to 10.2.0.4.
• Performed Database Cloning from Production to Test environment
• Monitoring and maintaining cluster DB’s for their Optimal Performance and

Confidential

Jr. Oracle DBA

Environment: 9i,10g and 11g Linux, Solaris, Aix and Windows

Responsibilities:

• Monitoring and maintaining cluster DB’s for their Optimal Performance and
• Trying to ensure 100% availability of the DB’s.
• Allocating and reorganization of tablespaces.
• Incorporating user’s requests as per mails.
• Job scheduling using dbms job and crontab.
• Backup database using export/import.
• Taking backups using RMAN.
• Creation of DB LINKS.
• Performed Database Cloning from Production to Test environment.
• Monitoring and optimizing the performance of the Database through Stats pack/AWR.
• Maintenance of Database and Listener.
• Moving data between databases using utilities like Import, Export, SQL loader and Transportable Tablespaces.
• Checking Alert log, trace files, listener log and other database job logs.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Decommissioning of Schemas as per approved requests.
• Resolving user’s day-to-day issues.
• Consistently interacted with client and team in resolving the queries.
• Working on Tickets to handle the sev 2/3/4 issues.

Confidential

Associate Oracle DBA

Environment: 8,9i,10g and 11g Linux, Solaris, Aix and Windows

Responsibilities:

• Providing *24/7 Support on production instances
• DBA support for Production, QA and Development teams.
• Perform regular database activities like space management, database health check-up etc.
• Troubleshooting and resolving production issues.
• Refreshing UAT & QA with Production Database.
• Implementation of Scheduled Change Control requests on Productions.
• Involved in upgradation of database from 9i to 10g.
• Administered databases remotely.
• Monitoring Alert log & System log files.
• Created users & privileges with appropriate roles and levels of security.
• Managing privileges and roles to ensure database security.
• Troubleshooting Oracle connectivity issues.
• Implementation of Backup and Recovery Strategies using RMAN.
• Planning & performing hot and cold backups.