SUMMARY:

• Over 7 years of experience in managing Core Oracle Database Administration.
• Upgraded the Databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.3/ 12 c and applied patches according to the client requirement.
• Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
• Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
• ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw devices for Oracle RAC.
• Installed and Monitored Oracle 11g/10 g/12c Rac software and experienced on Performance Tuning on RAC.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role - based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard) Implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11Gr2/12c on two node RAC.
• Handling Tools such as Toad, SSH, SQL Navigator, and OEM. Worked on 12c Multitenant databases.
• Setup unidirectional replication using Oracle Golden Gate
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• 24x7 production database support.
• Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
• Proficient in documenting the processes.
• Good communication and Interpersonal skills.
• Worked with storage team for ASM disk and RAID levels
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Confidential for technical support, new products and releases, technical discussion/support.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c, MS SQL Server 2000/2005

DB Management Tools: Oracle Enterprise Manager-Database Control, Grid Control, RAC and Data guard, ASM, Import Export, Data pump, SQL*Loader, Stats pack, AWR, ADDM, Oracle Scheduler, Tkprof, Data Pump, Shell Script, PERL Scripts RMAN, AWR, Toad, Cron jobs.

Operating System: RHEL Sun Solaris, HP-UX, IBM AIX, UNIX

Languages: C, C++, PERL, SQL, PL/SQL, UNIX Shell, T-SQL

Other Software: Understanding of Networking

Web Server/Tools: IIS, Websphere

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

• Designed, configured and installed Oracle Real Application Clusters on a 3 node Cluster.
• Performed backup and recovery activities on the RAC databases
• Planning, implementing various versions of Oracle Databases to 9i, 11G R2, 12c, installation and upgrade.
• Served in an administrative role regarding database privileges, security, Worked on 12c Multitenant databases.
• Setup unidirectional replication using Oracle GoldenGate
• Implementing High Availability Oracle Golden Gate from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11Grr2 RAC Environments
• Experience in taking backup of OCR.
• Experience in adding and removal of nodes in a RAC environment.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers
• Added nodes to the RAC cluster for the increased load balancing and removed it.
• Applied patches or upgrades to the database as needed.
• Created number of LINUX shell scripts for various tasks.
• Worked on Oracle Metaling in case of problems.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Setup physical standby database to protect mission critical from any failures, errors or corruptions·
• Configured ASM for RAC setup and non RAC databases.
• Worked closely with application developers and system administrators to ensure all database needs are being met.

Confidential, IL

Oracle DBA

Responsibilities:

• Created 3 production physical standby databases and 9 non-production physical standby databases.
• Worked with Real Application Cluster (RAC) databases.
• Installed, created and 10g / 11g to 12c databases and Clients.
• Install and configure Oracle software.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Formulate optimal application SQL using Grid Control and v$queries.
• Ensured database security is implemented to safeguard the data.
• Work closely with developers and system administrators to ensure all database needs are being met.
• Applied patches or upgrades to the database as needed.
• Used SRVCTL utility for managing multiple instances and nodes.
• Responsible for having multiple OCFS locations in RAC environment.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Perform Backup and Recovery thru RMAN.
• Written RMAN scripts for purging out applied logs at standby databases.
• Performance Tuning of database, SQL tuning for Application
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan
• Mapping of old data fields to new model data fields for data migration
• Estimate System/Database performance.
• Worked very closely with development team
• Application Database connectivity using ODBC and Oracle Net configuration.
• Created number of UNIX shell scripts for various tasks.
• Performed various UNIX Administration tasks.
• Automated various tasks thru crontab.
• Written Backup and Recovery scripts using RMAN
• Performed Export/Import of Oracle 8i/9i and 10g Databases thru command line as well as performed import export interactively.
• Performed Export/Import thru Data Pump.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments

Confidential, IL

Oracle DBA

Responsibilities:

• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Setup physical standby database to protect mission critical from any failures, errors or corruptions·
• Configured ASM for RAC setup and non RAC databases.
• Worked closely with application developers and system administrators to ensure all database needs are being met.
• Managed databases with size more than 2 TB.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with ORACLE for Data Guard implementation and other major issues.