SUMMARY

• 9+ 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, EXADATA and even single instance database.
• Experience in designing and implementing Disaster Recovery(DR) plan using DataGuard and Golden Gate
• 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 GateSQL*loader, Datapump(Export/Import), RAC, ASH, AWRADDM, Statspack, TKprof, Oracle Forms & Report,AblnitioInformatica, Data Stage,Putty

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

Sr. Oracle DBA

Responsibilities:

• Maintaining Production, Development & Test databases and applications which are in exadata, RAC, single instance servers
• Supported for Quarter and monthly releases.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Rebuilding of Indexes for better performance of Oracle database.
• Applying patches whenever required in exadata, RAC and standalone servers
• Involved in implementing and using SHAREPLEX.
• Involved in EDW support for OLTP and OLAP data ware house application.
• Experience in working in RAC environment databases.
• Experience in working with EXADATA with for OLTP and OLAP Databases.
• Data Refresh from production to Test and Development environments using RMAN Duplicate Databases.
• Load balancing in RAC, Databases/Schema/Table Re-organization for faster performance using export/import and move procedures.
• Recovery of Databases(Recovering from Media Failure, Recovering tables dropped accidently, Recovering data files, Recovering from block corruption).
• Worked along with the teams supporting various applications relating to data warehouse.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Monitor database performance using OEM Grid Control and run ADDM, ASH, AWR reports
• Space management which includes tablespace creation, adding new datafiles
• Experienced with monitoring the database security issues and resolving them on timely basis.

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, 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.
• Implemented Oracle Streams for Replication.
• 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.
• Installed Oracle GoldenGate and configured heterogeneous replication.
• 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.
• Experience in setting up and managing of Replication models like Snapshot and Transactional.
• 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

Responsibilities:

• 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.
• Involved in Knowledge Transfer of Golden Gate Product and Installed Golden Gate(10.4/11.1)
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication, Golden Gate.
• Install Oracle 11g RAC with 4 node on RHEL platform with ASM.
• Replication using Golden Gate
• 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.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• 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.
• Configuring Oracle GoldenGate for replications and troubleshooting it's issues

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)

Responsibilities:

• 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.
• Knowledge on Oracle Golden Gate.
• Implemented basic replication through Materialized Views.
• 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