SUMMARY:

• Over 7 Years experience as Oracle Database Administrator. Oracle 11g RAC/10g RAC/9i/8i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning,Backup Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g 11g with experience within very large scale database environment and mission critical OLTP and OLAP systems.
• Excellent experience in Migrating the Databases.
• Worked on Software like My sql and TOAD.
• Experience working on LUW and AIX Platforms.
• Experience with IBM LUW DB2 v9
• Having hands on experience on working with Large OLTP databases like 5 Tb.
• Fulfilled DBA daily activities including user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc. , space management, and monitoring
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases VLDB .
• Hands On Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC
• Experienced at using Oracle Enterprise Manager/Grid Control OEM/GRID CONTROL
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support,Cloning,Backups and Recovery Manager, Performance Tuning, Capacity Planningand documentation.
• Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated databases from Windows to Linux, Sun Solaris to AIX.
• Troubleshoot Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.
• Experienced in using Oracle's Transportable Table space TTS feature allows users to quickly move a user Table space across Oracle databases.
• Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g RAC environments using the OEM GridControl tools.
• Have extensive experience in performance and tuning of OLTP and Datawarehouse applications.
• Data transferring with Export, Import, Data Pump and SQL Loader utilities.
• Database backup concepts and options such as user-managed backup, RMAN-managed backupwith or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Refresh/Cloning of Database and applications for development and testing purpose.
• On call 24x7 Production Support Worked beyond regular hours.
• Dealing with database security and auditing.
• Have extensive knowledge Oracle Application Server Administration web logic
• Excellent communication, interpersonal and strong analytical skills, Documentation Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Knows Perl scripting
• Worked As a DBA for Web Application Projects
• Knowledge on Sybase working on the comprehensive set of database management software technologies that provide the crucial foundation for the Unwired Enterprise and enable you to manage and mobilize information from data centers to the point of action.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Applied CPU patches
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Developed PL/SQL scripts for Extraction, Transporting Transforming ETL data from Production databases to Data Warehouse Databases.
• Writing and modifying UNIX shell scripts, Perl scriptsto manage Oracle environments and for Backend Oracle Processes.
• Automated the nightly RMAN backups
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• RMAN Incremental backups
• Logical and Physical Database Design
• Capacity Planning and bench marking
• Partitioning of the tables for better performance and manageability
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and automatic session history.
• Cloning databases using scripts as well as RMAN.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Strong Knowledge on writing Sql/DBA queries
• Monitoring the database storage and day-to-day activities.
• Have knowledge on RF Mobility and done website reports
• Table partitioning for better performance.
• Worked on exadata environment
• Have good knowledge on Google Mapping ability to tie in graphical reports
• Knowledge on Sybase working on the comprehensive set of database management software technologies
• Golden Gate installation and configuration.
• Replication using Golden Gate.

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, ERWIN, Data pump

CONFIDENTIAL, Role: Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Wrote various shell scripts to automate tasks.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Documented instructionsfor migrating upgrading databases.
• Replication using Oracle Streams.
• Installed and implemented Golden gate to replicate data between databases.
• Migrated upgraded databases from Oracle 10g to oracle 11g
• Setup and configure Standby database for high availability by using Data Guard.
• Implemented Data Guard for Disaster recovery
• Creating PL/SQL procedures for Extraction, Transformation and Loading of data
• Worked on PostgreSQL
• Created schema tables, Indexes, views, sequences, synonyms, packages .
• Setup database auditing, granted privileges to users through system/object roles.
• Implement and maintain database security.
• Created db link for inserting large tables directly without taking export.
• Online index rebuilds
• Created PL/SQL Procedures, Functions, Triggers.
• Taking Hot and cold backups.
• Modified Data Using Perl Scripting
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using STATSPACK, AWR, ADDM
• Increasedperformance of sql queries by creating materialized views and by enabling query re-write.
• Perform decommission of a database operation

Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, ERWIN, Data Pump

CONFIDENTIAL, Role: Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Load data into Oracle using SQL Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges.
• Performance monitoring and tuning using Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM
• Automated the Replication process using Materialized Views for reporting databases.
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: locking, corruption, disk spaces andPerformance issues.
• Cloning of production database to the test environment using Recovery Manager RMAN .
• Created Standby databases for Disaster Recovery, using Data Guard.
• Load data using SQL Loader
• Backup and Recovery
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, Data Pump

CONFIDENTIAL, Role: Oracle DBA

Responsibilities:

• 24x7 on-callproduction database support
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Performed backup and recovery activities.
• Daily database administration tasks including backup and recovery using RMAN, Import/Export.
• Designed the database schema and created any necessary database objects.
• Applied patches, upgraded databases
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• 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.
• Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 10g RAC, Oracle 9i, IBM AIX, Windows, RedHat Linux, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, Data Pump

CONFIDENTIAL

Role: Oracle DBA

Responsibilities:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot Cold Backups, Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL Loader, Data Pump