SUMMARY

Results oriented Database Administrator with 10 plus years of multi-platform experience in Windows, Linux, and Unix Operating systems. Seeking career in Oracle Database Administration, Multi platform environments and Managing Oracle Databases on Clusters.Experienced in the maintenance and administration of relational databases with RAC, Dataguard, and business applications.

Highlights

• 10 years of experience with large scale Database and High Availability Cluster Environments.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Backup and Recovery, Performance Tuning, Capacity Planning, Shell Scripting, PL/SQL, and Documentation.
• Configured and managed standby database in maximum protection/maximum availability/maximum performance mode in Oracle 10g/11g Data Guard.
• Installed, configured, and maintenance of Oracle 10g/11g RAC and Data Guard on Windows, Linux, and Solaris.
• Configured and Maintained Oracle RMAN Backups and Recoveries.
• Installed and configured Oracle Fusion Middleware WebLogic, Oarcle Forms and Reports, Oracle Business Intelligence, OID, OAM, and OSSO.
• Excellent experience in Migrating and Upgrading Databases.
• Team Player: self-motivated team player, great positive attitude, helps other team members accomplish positive results.

Technical Skills:

Professional Experience

Confidential

Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installed, configured, and Maintained Oracle Databases in Development, Test, and Production environment.
• Setup 2 nodes Oracle 11g RAC in Development, Test, and Production.
• Involved in Cross-Platform Databases Migration from HPUX Tru64 to Solaris.
• Upgraded Oracle RDBMS and Databases from Oracle 10g to 11g 64 bits.
• Splited Database Objects from one schema to another schema for reorganizing user Applications.
• Applied PSU/CPU patches quarterly on Grid Control Infrastructure and RDBMS homes.
• Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions.
• Fulfilled DBA daily activities such as user management creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences , space allocation, and monitoring.
• Installed, Configured, and Managed WebLogic Applications Servers.
• Configured and managed Admin Server and Managed servers in WebLogic.
• Installed, configured and managed Oracle Business Intelligence Publisher 11.1.1.x.
• Installed, configured and managed Oracle Forms and Reports 11.1.1.x and WebLogic.
• Installed, configured and managed Oracle Internet Directory OID and Oracle Single Sign On OSSO .
• Created Fusion Middleware Application Schemas using Repository Creation Utility RCU .
• Tuned Weblogic Server to optimize performance.
• Hands on Experience in Installing, Configuring, and Managing Oracle 10/11g RAC.
• Managed disks, disk groups in ASM and ASM instances as well.
• Database cloning, renaming, and refresh for development and Test Environments.
• Developed shell scripts for tracing Oracle errors, free space in the tablespaces and free disk space in Archive destination for production database.
• Having Experience with Tablespace Database Re-organization.
• Excellent expertise in data loading using SQL Loader and TOAD Import Table Data.
• Performed Database Backup and recovery using RMAN/traditional user-managed hot/cold backups.
• Successfully implemented Physical Standby Database using Oracle DataGuard feature for High availability configuration.
• Logical Backup/Restoration strategy using Expdp/ Impdp Data Pump utility.
• Detected corrupted blocks by using DBVERIFY utility and repair corrupted blocks in Tables and Indexes by using DBMS REPAIR utility.
• Optimized the SQL's for optimum performance by using Explain Plan, Tkprof, Statspack, Trace Analyzer, AWR, and ADDM.
• Planned and scheduled for the backup of databases information using UNIX shell scripts and Crontab jobs.
• Involved with the development teams to write Stored Procedures, Functions, Packages, Handling Exceptions, Triggers using SQL and PL/SQL.
• Configured Listener.ora and Tnsnames.ora manually as well as using NetMgr and NetCA utilities.
• Provided support with very low response time and turnaround time.
• Managed Instances, redo log files, Tablespaces, Data files, storage structures, Undo segments, Temporary segments, Indexes.
• Diagramed the database schema using ERwin and Database Schema Tools.

Environment: Oracle 10g/11g, RAC, RMAN, Oracle Fusion Middleware WebLogic, Oracle Forms and Reports, Oracle Business Intelligence, OSSO, OID, OAM , Solaris, HPUX, Linux Red hat ,ERwin,TOAD, Database schema.

Confidential

Oracle DBA

Responsibilities:

• Monitored and maintained primary and standby databases to ensure 24x7 continuous operation.
• Installed and setup Oracle Software on Windows, Linux, and Solaris.
• Installed, configured, upgraded, and patched Oracle RDBMS and associated utilities and software.
• Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions.
• Installed Oracle Software on Linux, Solaris, and Windows 2008 64 bits Servers.
• Upgraded the Oracle Binary and databases from 10g to 11g 64bits.
• Database cloning, renaming, and refresh for development and Test Environments.
• Developed shell scripts for tracing Oracle errors, free space in the tablespaces and free disk space in Archive destination for production database.
• Having Experience with Tablespace Database Re-organization.
• Database and application performance monitoring and tuning.
• Monitor and manage space allocation.
• Evolved a good backup strategy for the production databases using RMAN and also created standby database for minimal down time.
• Tuning OS and resolving I/O and contention issues.
• Configuring parameter file to fix sizes of SGA components in conformity to available resources.
• Security Administration and Creation of Users, Managing their roles and privileges.
• Complete and incomplete database recovery and assisting development and QA teams technically.
• Involved working with developers to design and build new structures to support future enhancements to the applications.
• Configured and Maintained RMAN Backup and recovery.
• same Server and Creating a Physical Standby Database on a Remote DR Site Servers.
• Expert on Data guard configuration on Creating a Physical Standby Database on the
• schema using Expdp/Impdp Data Pump utility.
• Copy database objects from one database to another database and one schema to another
• Logical Backup/Restoration strategy using Expdp/ Impdp Data Pump utility.
• Performance Monitoring and tuning with Explain Plan,Tkprof,Statspack,Awr and ADDM.
• Hands on Experience on RAC Installation and Administration on Oracle 10g/11g environment.
• Involved with the development teams to write Stored Procedures, Functions, Packages, Handling Exceptions, creating database Triggers using SQL and PL/SQL in Oracle and Tuning the SQL.
• Assign users appropriate rights and tables access through roles.
• Created Disk Groups and maintain ASM instances.
• Setup 2 nodes cluster failover in Test and Production environments.

Environment: Oracle 10g/11g, RAC, RMAN, Solaris, Windows 2008, Linux Red hat ,ERwin,TOAD, Database schema.

Confidential

Oracle DBA

Responsibilities:

• Managed and supported mission critical databases running 24x7 Oracle 10g Production environment.
• Managed multiple database environments such as production, development, test, and training.
• Database administration tasks involving installation, performance tuning, space management, user management, backup recovery strategy planning.
• Monitored the performance and proactively identify issues that may occur in Oracle using monitoring software and database administration scripts.
• Table Partitioning, Created Index, Organized Tables, Created Locally managed Tablespaces.
• Performance tuning for optimized results using tools EXPLAIN PLAN, TKPROF, and STATSPACK, AWR.
• Installed and configured Oracle Application Server OAS and Apache Web Server.
• Installed, configured and maintained instance on Oracle 10g Real Application Clusters RAC .
• Supported customers to install the developed application on different operating system Windows, UNIX of all flavors on Oracle Database 9i, 10g .
• Security Management: Creating Users, Roles, profile, Database Triggers.
• Developed all database objects including tables, indexes, views, triggers, packages, and procedures. Assists with impact analysis of any changes made to the database objects.
• Planned, Configured and managed Standby database for Disaster Recovery Data Guard .
• Supported Oracle Database backups online/offline , logical backups.
• Upgraded the existing Oracle databases from 9i to 10g.
• Implemented Backup process and Disaster Recovery plan, copy databases in different locations and modified profile, control files, datafiles and logfiles.
• Moved datafiles, controlfiles, logfiles, and tablespace from one location to another location to solve I/O contention issues.
• Deployed Java Web Application Ear files and War files thru Oracle Application Server.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Tuning database and helping developers tune Application.
• Monitoring and tuning RAC environments.
• Implemented full and partial backup by using Expdp/Impdp DataPump .

Environment: Oracle 10g/9i, RAC, RMAN, Solaris, Windows 2003, ERwin

Confidential

Oracle DBA

Responsibilities:

• Responsible for 24x7 supports for large 9i 10g databases for production Environments.
• Installed, upgraded, patched of Oracle Binary and utilities software.
• Created databases manually and decided the naming conventions of controlfiles, redolog files, datafiles, and tablespaces.
• Database Cloning on Test servers from OffLine/Cold and OnLine/Hot Backups of Production Database.
• Monitored OS level processes, regarding CPU Utilization, Load Average and Memory Utilization and taking necessary actions to keep databases up and running.
• Configured and maintained RMAN backups and recovery.
• Performed SQL Statement Tuning, using SQL TRACE, Explain Plan,TKPROF, and STATSPACK.
• Maintained data integrity and tune database for optimum performance and availability.
• Capacity Planning, Storage Allocation and Space Monitoring and Management Monitoring Lock and various sessions using OEM TOAD.
• Created schemas and refreshed the production data to test and development servers.
• Extensive Database Administration Oracle 9i/10g experiences that includes creation and management of users and their roles and profiles.
• Analyzed Tables and schemas, Collected System statistics, Reorganized Tables and Rebuilt Indexes, Monitored and elimination of Row migration and Row Chaining Backing up of Archive Log files.
• Created database Links to multiple databases.
• Experience on Backup tasks - using Hot and cold backup procedures and software specific backups.
• Oracle backups, generally through Export Import utilities, Full, User, Table , recovery manager, Strategies development for the backups.
• Involved with the development team to write Stored Procedures, Functions, Packages, Handling Exceptions, creating database Triggers using SQL and PL/SQL in Oracle and Tuning the SQL.
• Addressing refresh Jobs/Schema refresh Re-org the database using Export and Import utility Tuning the Databases for optimization using STATSPACK and Explain Plans, Estimating Table Index Size Backup/Restoration, scheduling Backups, taking Logical Backups.
• Backup and Recovery procedures for the Oracle 10g database, which includes documenting the process Addressing DR Tests and prepare documentation Addressing weekly/Daily analyze jobs connectivity and troubleshooting of connectivity problems between databases and client computers.

Environment: Oracle 10g/9i, RAC, RMAN, Solaris, Linux, ERwin