PROFESSIONAL SUMMARY

• Extensive 9 years of experience in Oracle 9i/10g/11g Architecture, RMAN backups, Crash Recovery, Optimization, Performance Tuning, Troubleshooting in Production, Test and Development Instance environment with very large scale database and mission critical large OLTP and OLAP systems ranging from 40gb to 22TB
• Diverse industry experience including Banking and Finance, Pharmacy, Insurance.
• Designed and developed plans to achieve high availability, scalability, recoverability of the Oracle RDBMS servers.
• Experience as On-Call 24x7 and day-to-day support production DBA support, application/development DBA.
• Experience in working with Large Tables and VLDBs
• Involved with installation and maintenance of ORACLE 10g RAC 4 node and adding a node to this cluster database for high availability.
• Experience in a variety of hardware and software platforms including UNIX/Linux, Sun Solaris, HP-UX and RHEL.
• Configuring Oracle Golden Gate for replications.
• Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQLTrace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Setup Oracle Enterprise Manager OEM 10g Grid Control 11g for database monitoring/performance/diagnostics.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN .
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g 11g.
• Worked extensively on Oracle Migrations.
• Exposed to Data Warehouse assignments in various domains like Medical services, Sales, Insurance, Financial Bank, Inventory Distribution, and Production Data warehouses
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN / Network File Storage NFS
• Tune the new databases for Maximum performance
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM .
• Experienced in loading data from flat files into database tables using SQL Loader and ETL Tools like Informatica.
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments .
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHINICAL SKILLS:

Work Experience:

Confidential

Role: Oracle DBA Developer

Responsibilities:

• Installed, configured, and maintained Oracle 9i,10g 11g RAC and NON-RAC databases on SUSE Linux Enterprise server Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering ASM Storage Components, Parameter Management, Configuring High Availability and load balancing features for RAC. Created new Raw Device at OS level logical volume management and partitioned the disk with fdisk and added the new partitioned disk to the diskgroup and rebalanced the disks.
• Primary DBA for multiple mission-critical Oracle 9i,10g,11g databases supporting both traditional and business applications operating in a high availability 24x7 environment.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Configured Oracle Dataguard for Oracle Disaster recovery. Involved in rebuilding the standby databases due to huge archive log gaps and synchronized all with primary production databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• CPU Critical Patch Update , PSU Patch Set Update and One-off Patch Apply and rollback in Single instance/RAC.
• Worked on RAC database migration from non-ASM to ASM.
• Oracle SQL LOADER, Oracle Datapump Export/Import Tools and utilities. Supported different Databases like Production, Development, Testing, and Data warehouse.
• Used TOAD to Optimize and test SQLs, PL-SQL statements and resolving complex stored procedure compilation issues, fix errors due to object grants/dependencies developed by the Development Team.
• Monitoring informational/error logs for messages specific to system operation share responsibility for monitoring with Systems Administration and Production Control .
• Production archive log Maintenance through Shell Scripting and managing all databases issues through OEM alerts and Scheduling jobs using ESP and COMM VAULT for backup storage. Scheduling and maintaining level 0 and level 1 RMAN Recovery Manager backups. Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker DGMDRL .Configured Physical Standby databases for ACTIVE DATA GUARD.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups. Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Implemented Change Control process for the Production Databases as and when required.
• Raise and follow up Metalink Technical Assistance Request for resolving Critical issues.
• Involved in designing logical and physical data models using Erwin.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Created indexes to facilitate easy user interface implementation and tuning.
• Performed Full Database and Schema level refreshes of database on Weekly basis and on customer request.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Designed and created schema objects like Database tables, synonyms, indexes, views, Fast and complete mviews and replicating data using materialized views etc. Proficient in refreshing the materialized views using DBMS MVIEW package.
• Develop and maintain build standards and procedures for the database environment
• Creating and maintaining new schemas for Informatica projects ETL and replicating the schema objects from one schema to another by using data pump utility.
• Worked closely with Informatica Team ETL on monitoring the performance issues by providing them TOP SQL'S AWR reports. As well monitoring the CPU spikes on Informatica bulk data loads.
• Involved actively in By-Monthly release cycles worked with Data Admins and Data modelers' on various code build deployments and aligned the projects from DEV to post productions installs. Worked on a on-call rotation basis once in a five weeks.
• Used Report Conversion Tool to convert Business Objects and Desktop Intelligence reports to Web Intelligence reports.
• Trouble shooting of various database performances by proper diagnosis at all levels like OEM Production alerts, SQL, PL/SQL, database design, database tables, indexes, instance, memory, operating system and java calls
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs change requests for future reference.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM Grid Control , RMAN, RAC and Active Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, , BO XI r3 CMC, CMS, CCM, Designer, Deski, WebI , Toad, Informatica, Comm Vault, cognos, Materialized views, ERWIN, Sql Loader.

Confidential

Role: Oracle DBA

Responsibilities:

• Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 8i, 9i ,10g, 11g in HP-Linux environments. Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Work with system administrator to build a brand new server from scratch and configured all the parameters and installed RAC 10g/11g database on Linux-x86 RedHat 5.3 with 3 nodes
• Create cron jobs for automatic RMAN backup, RMAN purge backup, clean listener logs, clean sqlnet.ora logs and clean alert logs
• Use sqlldr to upgrade database data.
• Involved in upgrading databases from 10g to 11g VERSION. Installed and configured RAC databases 10g and 11g.
• Implementation of daily, weekly, and monthly DBA checklists for each environment.
• Maintain terabyte Data warehouse Oracle database in 24x7 Production Environment.
• Install and administer OEM Grid Console. Implemented Active Data Guard for disaster recovery. Refresh and Clone Databases as per customer requirements.
• Ensuring successful and periodical Backup, Restoration Tuning of databases.
• Implemented backup and recovery using RMAN in development environment. Documented the process for Implementation in production and staging environments.
• Tuned PL/SQL and UNIX shell scripts to automate database functions.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Used oracle configuration assistants like DBCA Database Configuration Assistant for Creating databases, DBUA Database Upgrade Assistant for Upgrading databases and NETCA Network Configuration Assistant for creating a Client-Server environment using Listener, TNS names etc.,
• Configured and implemented Oracle Golden Gate replication.
• Also configured database cloning using RMAN.
• Monitoring of Oracle Instances, Users, Tables, Memory Structures, Rollback Segments, Redo Logs, Archive Logs and Alerts.
• Applying latest releases of the patches from Oracle to the instance to resolve few applications issues.
• Deploying scripts to dev/test/prod successfully by following steps in Master Implementation Plan driven by release Management.
• Translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Applied Interim patches and Patch set as per recommended updates from Oracle support Meta Link.
• Works directly with software developers to develop and enhance applications and data conversions.
• Provide Business Intelligence support to Crystal Enterprise 10 users. Responsible for design, maintenance from development, QA to production environments.
• Monitoring of the queries with high response time and high disk reads per execution Top SQL and tuning the same using TKPROF, Explain plan, Auto trace.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Used Automatic Workload Repository AWR for analyzing the database performance.
• Used TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Debugging, and execution of Crystal Reports in Development and Production Environments.
• Provide on-call support in adherence to specific business and customer Service Level Agreements.
• Managing Database Locks and blocking sessions.
• Supported as primary DBA for data warehousing environment's DEV,QA, PROD.
• Worked with Informatica Team in resolving performance issues on high load sql statements using partitioned tables and creating local and global Index's and maintaining the consistency between databases QA, PROD by applying the retrofits using PPM PACKAGES for migrating database objects one environment to another environment.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, ASM, CRS, OEM Grid Control , RMAN, RAC and Active Data Guard, Explain Plan, Oracle Support, SQL Developer, pl/sql developer, Data Pump, Crystal Reports, Putty, Toad, Informatica, VERITAS Net Backup,cognos, Materialized views, Oracle Golden Gate.

Confidential

Role: Oracle Database Administrator

Responsibilities:

Maintenance of installed Oracle database and supporting multiple production, development and test instances of varied complexity including multiple tier and RAC environments.

Create High Availability 11g RAC Linux clusters ranging from 2 to 4 nodes utilizing Data Guard in compliance with Oracle's Maximum Availability Architecture MAA .

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts.

• Responsible for installing, upgrading and configuring the Oracle databases.
• Supported Oracle 10g,11g and Oracle 9i Databases of Production, Testing, Staging and Training
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of upgradation and migration.
• Applying RDBMS Oracle Critical Patches CPU on Test, Development and Production databases.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases
• Providing Support through DR Demand Request and CR Change Request for Developer PPM request.
• Performed Oracle flashback recovery, flashback query and flashback tables.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Created database links that are required for databases.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Upgraded databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Managing the existing Golden Gate replication process and setting up new Golden Gate replication for ETL processes.
• Disk Space Monitoring.
• Configured RMAN and performed daily backups.
• Create public/private database links for cloned/recreated databases/instances
• Create constraints, public/private synonyms, triggers and sequences to auto populate columns.
• Modified table structures, PL SQL stored procedures and database triggers to implement business rules.
• Performed automated backups and scheduling using scripting.
• Data refresh from production to Test and Development Environments using Rman Duplicate Command
• Communicated with Oracle support via the Metalink in order to troubleshoot important issues
• Involved in monitoring and managing of Oracle instances using Enterprise Manager Grid Control OEM Grid and attending the alerts from OMS service.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances
• Extensively compressed large tables in Data warehouse Environment to reduce space usage.
• Worked with Datapump to take the logical backups of databases.
• Working Experience with Latest TOAD having new features PLSQL SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.

Environment: Oracle 10G 11g, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, OEM, STATSPACK, TKPROF, Informatica, Pl/sql,Toad,Business objects XI, Toad, Pl/sql developer, Data guard, RAC, Golden Gate.

Confidential

Role : ORACLE DBA

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment 8i,9i,10G by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Worked on Automatic Storage Management ASM with SAN Storage for managing data in EMC Symmetrix.
• Scheduled Oracle Jobs in the database server.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• Performed a proof-of-concept of Oracle10g and Oracle11g databases on single RAC Cluster 11g.
• Handling large database environments Data warehouse using Oracle Enterprise Manager OEM on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem. Recognition and resolution of database issues.
• Generated canned and adhoc Reports using Crystal reports and Business objectsXI.
• Devised Implemented backup strategies using hot, cold and exports based on the business requirements. Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Proactively managed the databases by setting up alarms for managing any exceptions in day to day management of the databases and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Worked closely with Business Intelligence group in tuning adhoc reports using Cognos
• Implemented Oracle database backup recovery solutions using RMAN.
• Applying RDBMS Oracle Critical Patches CPU and Oracle Patch set Update PSU on Test, Development and Production databa
• Raised service request for production issues and worked with Oracle support resolving bugs issues.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Involved in creation of materialized views from different data sources and refreshed the materialized view using DBMS MVIEW package.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

Environment: Oracle 10g/9i Rac, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, Rman, OEM, STATSPACK, and TKPROF,Toad,Pl/sql Developer, Informatica, Business objects, Pl/sql developer.