SUMMARY

• Over 9 years of experience as an Oracle Database Administrator.
• Having 5 years of experience in handling RAC databases.
• 5 years of experience handling Exadata Machines X3.8,4.2,4.8,5.2 .
• Supporting for Exalogic machines .
• Good knowledge on Oracle Apps 11i & R12, Oracle Database 7.x, 8,8i, 9i, 10g,11g and 12c.
• Expertise on Installation, Upgradation, maintenance and administration of single and RAC Oracle Database of 11gR1, 10gR2 and 9iR2.
• Supporting for Production, development and testing databases for different application teams.
• Expertise in tuning the Exadata Database Machine Hardware and memory level .
• Supported for 100 TB databases.
• Expertise in installing different versions of Oracle on Linux and Solaris.
• Installed & configured 2 - NodeRAC using OCFS as cluster file system and ASM lib.
• Good knowledge on Oracle advanced Technology RAC, Data guard, OEM, Grid Control, ASM and Replication using Materialized Views, Oracle 10gR2 Streams and site scope .
• 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
• Providing High Levels of security and firewall for Oracle databases .
• 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 Solaris, Solaris to AIX and 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.
• Strong understanding of internal architecture of Siebel Databases .
• Proficiency in creating business and technical project documentation .
• Expertise is working with distributed and global project teams
• Excellent communication skills .

TECHNICAL SKILLS

Databases: Exadata, Oracle 9i, 10g, 11g,12c .

Operating Systems: OEM 12c,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++,HTML,XML, UNIX Shell Scripting, JAVA,.Net

Tools: & Utilities: EXADATA,RAC, VM Ware, Golden Gate,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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle DBA

Environment: Software Database: 10g,11g,12c, Exadata X4.2,4.8,5.2 O/s: Linux, Solaris, Aix, Oracle Golden Gate, OEM 11g, 12c

Responsibilities:

• Supporting for Exadata machines and Golden Gate, Site scope.
• Supporting for RAC environments on OVM nodes.
• Supporting for different versions of Exadata for Full and half rac .
• Experience in closely work with oracle support to resolve the Exadata issues and bug fixes .
• Expertise in Installing, configuring and Weblogic Server on Exalogic servers.
• Experienced on Weblogic cluster configuration and administration .
• Supporting for oracle 12c OEM and databases .
• Working closely with storage team to fix the Exadata issues.
• Upgraded database and OEM from 11g to 12C .
• 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, Charlotte, NC

Sr. Oracle DBA

Environment: Software Database: 10g,11g and 12c, Exadata . O/s: Linux, Solaris, Aix, VM Ware

Responsibilities:

• Supporting for Exadata machines and Golden gate.
• Supporting for Exadata X3.8,4.2 .
• Patching and upgrading to 11g.
• Good Exposure on Exadata Scan technology .
• Expert in deployment of different applications for Exadata databases.
• 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.
• 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 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.
• Trying to ensure 100% availability of the DB’s.
• Cloning of single instance database from 2 Node RAC database;
• Implemented RMAN backup strategy for RAC database.
• 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 at database level.
• 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, KY

Oracle DBA

Environment: Software Database: 9i,10g and 11g Application: oracle R12 O/s: Linux, Solaris, Aix and Windows

Responsibilities:

• 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: Software Database: 9i,10g and 11g O/s: 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: Software Database: 8,9i,10g and 11g O/s: 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.