Oracle DBA

Summary:

7 Years of experience in Oracle Data Base Administrator worked on Linux RedHat Linux, Oracle Enterprise Linux , Unix HP-UX, Sun Solaris, IBM AIX and windows platforms, which involves Designing, Installing, Migrating, Updating, Configuring, Exporting, Importing, Backup, Recovery, Monitoring and Tuning the Databases

Extensive Experience, Performance Tuning, Backups, Recoveries, RMAN backups.

Excellent experience in providing 24/7 Production support

Experience in supporting Oracle Databases 8i/9i/10g RAC/11g RAC

Experience in Installation, configuration of Oracle RAC and Standby Database Active Data Guard for High Availability, Disaster Recovery and Reporting purpose. Installed, configured and maintained RAC and single instance databases. Migrated single instance databases to multimode RAC environment for high availability and load balancing.

Experience in applying critical patches and patch sets whenever required.

Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN.

• Experience in writing complex SQL Queries, created materialized views.

Extensive experience in developing SQL, PL/SQL Stored Procedures, Functions, Packages and Triggers.

Experience in UNIX shell scripting.

Creating users, assigning Roles, Grants and creating profiles and password management.

Good experience in data warehousing, data modeling, database management.

Good Experienced in database performance tuning, query optimization, data integrity and statistics

• Excellent working knowledge in logical backups, Hot/Cold Backup, RMAN Incremental backups , Recovery and Cloning of databases.
• Shell Scripting, Partitioning, Indexes, Data modeling, Logical and Physical database design.
• Experience in Data warehousing and Extraction Transformation Loading ETL .
• Experience in Database Security and Auditing.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, Tuning by Indexes, SQL Tuning.
• Involved in Tuning process as SQL Profiling, SQL Access Advisor, SQL Tuning sets.
• Identifying bottlenecks, lock contentions , deadlocks from the Automatic Workload Repository AWR reports and performing self tuning purposes from the views and recommendation by Automatic Database Diagnostic Monitor ADDM

Implemented Export and Import using original Export/Import method and Data pump in Oracle 11g Databases.

Successfully implementing failover / switchover standby databases

Experience in replication and integration of database objects between databases using Oracle Streams, Golden Gate.

Excellent writing and Communications skills, Critical Thinking Skills, leadership qualities and Expert level manageability skills and Team leader abilities dedicated to any work environment.

TECHNICAL SKILLS

Operating Systems : UNIX HP-UX, Sun Solaris, IBM AIX , Linux RedHat Linux, Oracle Enterprise Linux , Windows

Databases : Oracle 8i/9i/10g RAC/11g RAC, MS Access, SQL Server

Tools : SQL Loader, SQL Plus, OEM/GridControl, RMAN, ASM, DBCA, DBUA, Data Pump, Toad, Data Guard, Export / Import, TOAD, SQL Developer, Golden Gate. ERWIN

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR/ADDM/ASH

Languages : SQL, PL/SQL, C, C , UNIX Shell Scripting, JAVA, PHP, XML, HTML,

PROFESSIONAL EXPERIENCE

Confidential

Role : Senior Oracle DBA

• Configuring and Maintaining the Data Guard to ensure high availability and data protection.
• Implementing and monitoring the databases in the Oracle 11g Data Guard Environment.
• Installation, configuration and maintaining the Oracle 11g RAC with Data Guarded databases.
• Writing shell scripts to actively monitor the data guard databases status, create standbys, rebuild data guard broker etc. , Data guard services, Data guard protection modes.
• Monitoring the databases while performing switchover operation FSFO and bystander .
• Involved in creation, monitoring and managing of data guard broker configurations.
• Involved in manual creation of the standby databases and loading data using SQL Loader.
• Logical and physical design of the databases for the new servers.
• Migration of databases from Non ASM to ASM platform and vice versa.
• Migration of databases from IBM AIX to HP-UX using logical exports/imports and Data Pump.
• Creating new schemas, roles, profiles and grant privileges according to the requirements.
• Writing scripts to restore, recover databases using RMAN for all the data guarded databases.
• Performed complete database recovery, tablespaces recovery, particular datafile recovery using RMAN.
• Performed Point In Time recovery for databases using flashback.
• Applying patches PSU, CPU patches to update the oracle version and fixing the bugs using OPatch utility.
• Updating OPatch version to apply the newly released quarterly patches.
• Performance tuning of databases, SQL Tuning and generating reports using AWR, ADDM for the complete statistics.
• Create refresh groups and materialized view to refresh the data at the regular intervals.
• Writing cursors, stored procedures, functions in the packages.

Environment: Oracle 11g RAC, Oracle 10g ,11g Data Guard ,HP-UX, IBM AIX, Windows, SQL Developer, TOAD, RMAN, ASM, Data Pump

Confidential

Role : Senior Oracle DBA

• 24 X 7 Production database administration, support

Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.

Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database Active Data Guard , Replication.

• Refresh/Cloning of Database and applications for development and testing purpose.
• Maintenance and monitoring of oracle 11g/10g databases
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases

Creating users, assigning Roles, Grants and creating profiles and password management.

• Involved in PL/SQL coding using cursors, triggers, stored procedures, functions and packages.
• Assisted developers in tuning SQL statements in the applications.
• Written Shell Scripts for backups, cloning and custom monitoring.

Export and Import Operations using Data Pump.

Experience in UNIX shell scripting

• Management of Users, Roles and Privileges.
• Performing Backup/Recovery of all the Oracle databases using RMAN involving both hot and cold backups.
• Creation of database links from different oracle and SQL server databases for data loading.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability..
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.

Maintain Physical Standby database and performing switchover/failover when required.

Replicating the tables, schemas and database using the replicating tool Golden Gate.

Environment: Oracle 11g RAC, 10g RAC, 9i, RedHat Linux, HP-UX, IBM AIX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, Golden Gate, ERWIN.

Confidential

Role : Oracle DBA

• 24 X 7 Production database administration, support

Installation, Configuration and Administration of Oracle 10g RAC.

Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard , Replication.

• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Oracle 10g to 11g
• Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN.
• Cloning/Data Refresh from production environment to setup test and development environments.
• Performed database cloning to setup test and development database
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Involved in developing logical and physical modeling of the database using Erwin
• Optimized data loading using SQL Loader to load different types of data from flat files to the Oracle server.
• Creating and sizing of database objects tablespaces, tables, and indexes .
• Database Backup and crash/Recovery.
• Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability..
• Tuning of I/O includes separating data files and redoing log files on different locations, separating of data files and index files on different locations, reducing disk contentions
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability
• Experience in installing Oracle patches. Applying critical patches whenever required

Actively involved in Backup Management of Disaster Crash recovery supporting 24x7 assurances.

Environment: Oracle 11g, 10g RAC, 9i, RedHat Linux, Sun Solaris, IBM AIX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN

Confidential

Role : Oracle DBA

• 2x7 Production database administration support

Installation, Configuration and Administration of Oracle 10g RAC.

Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard , Replication.

• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Upgrade/Migration of Databases from Oracle 8i,9i to 10g
• Worked closely with users in understanding the requirements and coordinated between the users and the development team.
• Involved in writing and executing stored procedures, functions, packages and triggers.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS
• Create table spaces, tables, and users for custom applications.

Security administration such as privileges, roles and assigning passwords on the tables, stored procedures, and Firing triggers and constraints objects depending on role.

Proficient in all DBA responsibilities such as Instance tuning, user management, space management, and monitoring.

Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.

Hands on experience in UNIX shell scripting.

• Implementing range, list partitions, hash partitions.
• Creating and refreshing materialized views.
• Loaded data using SQL Loader
• Created and running the shell scripts to run the Processes at time schedule according to business rules.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery TSPITR .
• Migrated databases from Windows to Linux.
• Performed Point-In-Time Recovery.
• Cloned databases using RMAN Duplicate and cold hot backups.
• Performed Backup and Recoveries using RMAN
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability.

Environment: 10g RAC, 9i, Sun Solaris, RedHat Linux, HP-UX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN

Confidential

Role : Oracle DBA

Maintaining production, development test databases and applications.

• Upgraded database from Oracle 9i to Oracle 10g.
• Design normalized logical database models ERDs to support application development, and create physical objects within the Oracle database.
• Describe and explain how programs should access data in Oracle databases to application developers.
• Troubleshoot and resolve database problems.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Wrote PL/SQL procedures, functions and triggers for insert, update, and delete transactions.
• Created the indexes to optimize the performance of the data retrieval process.
• Conceptual data modeling logical and physical data modeling.
• Involved in cloning the databases and Patching.
• Good understanding in data modeling, entity-relationship modeling.
• Database Tuning using init parameters, optimizing rollback segments, redo log configuration, and I/O distribution.
• Scheduling jobs through Oracle job Scheduler.
• Monitoring diskspace usage at the OS level and tablespace level.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Analyzing workload of group and recommend improvements. Continually enhances the Group's skills around client satisfaction

Environment: 10g RAC, 9i,8i, IBM AIX, Sun Solaris, RedHat Linux, Windows, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN