SUMMARY

• Over 9 years of experience as an Oracle Database Administrator.
• Having 6 years of experience in handling RAC databases.
• Supporting for SQL Server databases along with oracle DBs
• Good knowledge on Oracle Apps 11i & R12, Oracle Database 7.x, 8,8i, 9i, 10g and 11g.
• Expertise on Installation, Upgradation, maintenance and administration of single and RAC Oracle Database of 11gR1, 10gR2 and 9iR2.
• Supporting for Exadata machines and HP service Manager.
• Supporting for Physical and logical standby 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.
• Good in Migrating databases with zero downtime
• Good knowledge on VERITAS, NetApp Backup’s, BCV, CommVault and EMC Storage Backups.
• Configured and monitoring shareplex and 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 for SAP.
• 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 Handled for failover and switchover .
• Monitoring index usage and Performed Rebuilding of Indexes.
• 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 Communicating with team and application owners.
• Frequently joining in to team meeting with high level managers.
• 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, 11g,12c, M S 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 .

Tools: & Utilities EXADATA,RAC, HPSM,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, SAP

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle DBA

Environment: Software Database: 10g and 11g, MS Sql Server O/s: Linux, Solaris, Aix, Golden Gate, Oracle applications R12, SAP

Responsibilities:

• Supporting for Exadata machines and Golden Gate, Site scope.
• Supporting for oracle application R12.
• Supporting for SQL Server .
• Closely Follow SAP norms and recommendations . upgraded and maintenance of SAP based systems.
• 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: Software Database: 10g and 11g, SQL Server O/s: Linux, Solaris, Aix, Golden Gate, Oracle applications,SAP .

Responsibilities:

• Supporting for SQL Server databases.
• Develop plan for enhancements and new functionalities in SAP .
• Develop a migration plan for the web, application and data tiers
• Participate in regular SAP meetings with customers an application owners .
• Perform bug and issue management
• Provide technical documents such as interface documentation, use case descriptions, UML diagrams, etc.
• Managing user authentication for MySql databases.
• 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.
• 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.