SUMMARY

• 8+ years of experience in Oracle Database Administration, tuning, development, analysis, design, Installation, patches, upgrades, migrations, configuration, space management, data modeling, cloning, backup and recovery, auditing, database security, SQL, PL/SQL, troubleshooting and documentation.
• Experience in Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC database with ASM and even single instance database.
• Experience in designing and implementing Disaster Recovery(DR) plan using DataGuard.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace,
• Experience in Supporting EDW with OLTP and OLAP Data ware House applications.
• Upgraded database from 9i, 10g to 11g and Migrated databases across different servers & platforms.
• Experience in database full Backup (hot and cold), DataPump Export/Import, SQL Backtrack and Restore and Recovery procedures using RMAN.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM).
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Back - end programming, database Triggers, stored Procedures and Functions using PL/SQL.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage, resolving ORA-errors and network management.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator, TOAD and Opatch Utility.
• Expertise knowledge of Oracle Architecture, SGA and PGA
• Proficient in SQL, SQL*Plus, SQL*Loader, TOAD Quest and Tuning of SQL Queries.
• Resolved database network problems using Oracle Net Configuration Assistant(NETCA) and Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i/8i, RAC11g/10g, SQL Server

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting

Operating System: Red Hat Linux, HP Unix, Solaris, AIX, Windows 2000/2003

Tools: / Utilities: Oracle10g/11g Data Guard, Oracle Enterprise Manager, Oracle 10g Grid Control, RMAN, TOAD, Golden Gate, SQL*loader, Datapump(Export/Import), RAC, ASH, AWR, ADDM, Statspack, TKprof, Oracle Forms & Report, Ablnitio, Informatica, Data Stage,Putty

PROFESSIONAL EXPERIENCE

Confidential, Cleveland OH

Sr.Oracle DBA

Responsibilities:

• Installed and configured Oracle 12c/11g/10g RAC database.
• Developed and implementing Disaster Recovery(DR) plan using DataGuard.
• Maintaining production, development & test databases.
• Monitored the Applications and Database using OEM as well as command prompt.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Configured ASM and suggested feasible workarounds for ASM Metadata corruption and configured user log on load balancing and failover on RAC database.
• Generate performance report of server and Oracle database using AWR, ADDM and ASH reports.
• Shell scripting and job scheduling using crontab.
• Involved in EDW support for OLTP and OLAP Data warehouse application.
• Rebuilding of Indexes for better performance of Oracle database.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Database up-gradation from Oracle 10g to Oracle 11g.
• Patching and bug-fixing of Oracle database 10g and 11g.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and gathering schema stats and monitoring the index usage.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Worked on import/export, export data pump/import data pump and SQL-loader.
• Involved in Capacity Planning and worked with IT managers and application developers to ensure database integrity, high availability and security.

Environment: Oracle 9i/10g/11g/12c, Oracle 12c/11g RAC, ASM, RHEL 6,5.8,5.4,Sun Solaris, TOAD, SQL, PL/SQL, DataGuard, OEM, RMAN, SQL*Loader.

Confidential, Parsippany, NJ

Database Administrator

Responsibilites:

• Developed RMAN and logical export backup scripts and scheduled from OEM 10g Grid Control.
• Performed Upgrade of Oracle 9i, 10gR2 to Oracle 11gR2 and Migrate from Sun Solaris to Linux platforms.
• Install Oracle 11g RAC with 4 node on RHEL platform with ASM.
• Monitor database performance using OEM Grid Control and run ADDM, ASH, AWR reports.
• Experience with Unix Shell scripting, SQL, PL/SQL and upload data using SQL*Loader.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace for best performance.
• Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.
• Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.
• Administer RAC Database servers using SRVCTL, VIPCA, OEM Grid control, V$/GV$ views and System wide tuning using UTLBSTAT and UTLESTAT.
• Using RMAN for Backup, Restore and Recovery of database.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.
• Oracle Documentation and knowledge transfer.

Environment: Oracle 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 5.8,5.6, Sun Solaris, TOAD, SQL, PL/SQL, DataGuard, OEM, RMAN, SQL*Loader, Putty

Confidential, Dallas,TX

Consultant(DBA)

Responsibilies:

• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Involved in setting up of data guard for standby.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Experience in Supporting Teradata for Data Warehouses and analytical applications.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Involved in the matters of performance issues and auditing the required down time.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, sizing table space, create database, scripts, monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with AWR, ADDM, ASH to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating AWR and ADDM reports for Database tuning and also database Partitioning.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules).
• Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.

Environment: Oracle 9i/10g/11g, Oracle 10g/11g RAC, ASM, Unix, RedHat, Sun Solaris, TOAD, SQL, PL/SQL, DataGuard, OEM, RMAN, SQL*Loader.

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Supported data ware houses using Teradata .
• Worked on OLTP and OLAP database systems.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g DataGuard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used export/import and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, and schemas.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN, running Cron jobs and write UNIX shell Scripts for job automation.

Environment: Oracle 9i/10g/11g, Oracle10g/11g RAC, ASM, AIX, RedHat 5.4, Sun Solaris, Windows2003, TOAD, SQL, PL/SQL, DataGuard, OEM, RMAN, SQL*Loader.

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Installed Oracle 8i/9i/10g on AIX and RHEL creating database for production, development and test environments and provided 24*7 production database supports.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database
• Upgrade of database from 8i/9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using Explain Plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations and data striping and Periodically uploading data from flat files using SQL*Loader.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.
• Monitoring production systems to establish status and conduct proactive maintenance

Environment: Oracle 8i/9i/10g, HP-Unix, AIX, RHEL, Sun Solaris, SQL, PL/SQL, OEM, RMAN, SQL*Loader.

Confidential, San Jose, CA

Oracle Developer/DBA

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Perform capacity planning required to create and maintain the database environment.
• Implementing Oracle New features like spfile, Shared Servers, locally managed Temporary tablespace, UNDO tablespace and RMAN.
• Involved in gathering the requirements for creating data models for data analysis and reporting.
• Designing Tables, Constraints, Views and indexes etc. in coordination with the application development team.
• Developed Packages and customized functions and triggers based upon the business logics.
• Assisted in installing Application server, Report server and Database server.
• Involved in importing the production data to lower environments for testing purpose.

Environment: Oracle 8i/9i/10g, HP-Unix, TOAD, SQL, PL/SQL, RMAN