We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Summary

  • 7 Years of experience as Oracle DBA (11g/10g/9i/8i) on different HP-UX, Sun Solaris, Linux, AIX, and Windows 2000/NT environment.
  • Experience in full life cycle of database administration. Worked both as a development and a 24x7 Production Support DBA.
  • Prevent & Pre-empt issues and reduced the problem tickets by proactively designing the systems and processes for monitoring the databases.
  • Installation and Configuration of Oracle 10g Real Application Clusters (RAC) on 4 nodes with Automatic Storage Management (ASM).
  • Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
  • Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
  • Installed and configured Oracle 11g (11.2.0.1) Database on HP-UX and Linux advance Server on Development, Test and Production boxes.
  • Involved in disaster recovery planning, detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
  • Hot and cold backups were used. Also used RMAN, methods like PITR and full/ partial export/import and Data Pump. Experience of using Oracle utilities SQL trace, Export and Import.
  • Experience of installing, upgrading, patches, TAR support. Duties included database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
  • Configured and Maintained Physical Data Guard for High Availability and offline reporting.
  • Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
  • Used PL/SQL (Stored procedures, triggers, packages (DBMS_*, UTL_*)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
  • Experience in Performance Tuning (I/O, Memory & SQL/PLSQL Tuning of Multi-Terabyte Database) using EXPLAIN PLAN, TKPROF, and STATSPACK.
  • Experience in full Software Development Life Cycle (SDLC) of database administration.
  • Monitoring and Management of various Database Components (Logical & Physical) like Table spaces and Segments. Experience with Data Transfers/Sharing using Flat Files, DB Links, Web Services
  • Experience in job Oracle 9i, forms, Reports, SQL reports, Discoverer, SQL* Loader, export, import and such oracle tools.
  • Experience in support of VLDB.
  • Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
  • Creating high level and detail design for applications. Creating and execution of test cases/test plans. Executing test cases and test scripts for data validations.
  • Experience in Operational data store, data cleansing, backup and restoration strategies.
  • Highly motivated individual and good team player.
  • Excellent communication and interpersonal skills.

Education :
B. Tech

Technical Skills :

Operating System : HP-Unix (11i), AIX 5.2, Solaris 10 & Linux RHEL servers, Windows NT/2000/2003 Server.
Database : Oracle 11g, Oracle 10g, Oracle 10 RAC, Oracle 9i, 9iRAC , Oracle 8i, Performance Tuning, Backup and Recovery using Cold , Hot, and RMAN and Other Utilities.
Tools & Utilities : OEM (Oracle Enterprise Manager), RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus,SQL Trace, MS Project Management, TOAD, Data Guard, Putty, DB Designer, Rational Rose98, Oracle Migration Workbench, Stats pack.
Programming Languages : PL/SQL, Pro*C, SQL*Plus, C, C++, Shell Scripting. Exposure to Java.
Domain Experience: : Financial Services, Telecom.

Client: Confidential, HOUSTON, TX. Feb. 2010 to till date
Sr. Oracle DBA
Roles and Responsibilities:
  • Worked as an Oracle Production DBA (10g&11g) on HP-Unix 11.x and Red hat Linux 5 servers.
  • Involved in Real Application Cluster (RAC) 4-node architecture for 11g database.
  • Production support for Oracle11g RAC environment taking appropriate steps.
  • Provided database support, including on-call responsibility and unscheduled off-hour support.
  • Responsible for upgrading database from Oracle 10g to 11g.
  • Installation and configuration of Oracle 10g/11g databases. Administering Oracle 9i/10g/11g databases, environments, Agents, instances and schemas.
  • Upgraded several UAT and PRODUCTION databases to oracle 11.2.0.1
  • Improve recovery process using Replication, Backup/Recovery (operating system and RMAN) and Data Guard (Physical Standby Database)
  • Performed Tuning, coding and Monitored Oracle Real Application Clusters (RAC) nodes and OEM.
  • Designed and implemented backup and Disaster recovery strategies with RMAN.
  • Perform Logical backup using and full/partial export/import and Data Pump.
  • Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day to day management of the databases.
  • Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Implemented the Oracle Retail RMS, Oracle Retail WMS & Oracle Retail SIM
  • Involved in Oracle partitioned tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
  • Maintained and Supported VLDB in the client Environment.
  • Performed SQL tuning for Multi-Terabyte Database for better performance.
  • Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
  • Implemented stand-alone database using Oracle Data Guard feature for High availability configuration. Implemented Oracle Enterprise Manager Grid Control and configured agents.
Database administration activities including Tablespaces allocation, user enrollments and database re-organization.
  • Re-linking the binary files after cloning when binary level issued occurred.
  • Identified heavy resource consuming transactions/jobs to all request, developers to tune the components OEM Automatic Workload Repository Snapshots.
  • Ensuring that adequate recovery procedures are in place, based on: Database backups being done and verified.

Environment: Oracle 11g/10g/9i, HP-Unix 11i v3, Linux 5.5, AIX 5.2, RAC, RMAN, OEM.

Client:Confidential, ILLINOIS, CHICAGO. June. 2008 to Jan. 2010
Sr. Oracle DBA
Roles and Responsibilities:

  • Providing 24x7 supports on RAC clusters and 30+ single instances for prod/dev/test/dss databases.
  • Part of a 4 member DBA team which was involved in the maintenance of the Oracle 9i/10g/11g database for the Production as well as the development environments.
  • Setup and configured 3 node Oracle 10g RAC with ASM.
  • Implemented Data Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Windows and Linux environments.
  • Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
  • Migrated Oracle 9i and 10g databases to 11gr2. Platforms include Windows, Linux and Solaris.
  • Responsibility of Cluster running smoothly with 24*7 bases.
  • Managed and monitored the Oracle Real Application Cluster (3 nodes RAC) running on VERITAS storage.
  • Created a script to check the status of running database.
  • Improved a number of monitoring sprits that improve database performance and disk space utilization.
  • On the results of Index monitoring scripts, dropped unused Indexes and moved couple of Indexes to new table space.
  • Managed the Oracle Retail RMS, Oracle Retail WMS & Oracle Retail SIM.
  • Developed a script to sort the most I/O i.e. read and write operations performed by the Data files.
  • Modified and updated the Performance tuning scripts.
  • Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
  • Performed Logical backup using and full/partial export/import and Data Pump.
  • Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.
  • Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation..
  • Tuning SQL statements using Explain Plan and STATSPACK. Optimized SQL statements for maximum performance by using TKPROF and EXPLAIN PLAN.
  • Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.

Environment: Oracle 10g/9i, Red hat Linux5.5, AIX 5.2, RAC and TOAD.

Client: Confidential, CA Nov. 2006 to Apr. 2008 Sr. Oracle DBA
Roles and Responsibilities:

  • Worked as Oracle DBA (10g) on HP-UX 11i v3.
  • Installed and configured Oracle Database Software 10g.
  • Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on 2 nodes (HP-UX v3.0) with Automatic Storage Management (ASM).
  • Installed and Configured Oracle 9.2.0.1 (9i) database to Oracle 10g.
  • Maintained & monitored the Real Application Cluster (RAC) set up and stand alone Database using OEM and TOAD.
  • Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).
  • Designed and implemented backup and Disaster recovery strategies with RMAN.
  • Worked in advanced recovery methods like PITR. Logical backup using and full/ partial export/import and Data Pump.
  • Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
  • Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
  • Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
  • Used SQL* loader to move data from legacy systems.
  • Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
  • Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
Environment: Oracle 10g/9i, HP-UX 11i v3,Linux, RAC.

Client: Confidential, India. Oct. 2005 to Sep. 2006
Role and Responsibilities:

  • Installation and configuration of Oracle Database Software 10g.
  • Oracle 9i, 8i, OEM, SQL * plus, SQL * Navigator, DBA studio, imp/exp, RMAN, SQL, PL/SQL, SQL* loader, Net8, TKPROF, Oracle Tuning pack, Diagnostic pack, Red Hat Linux, and Windows 2000.
  • Upgrading database from Oracle version 9i to 10g and migration of data.
  • Involved in the project implementing and configuring Real Application Clusters (RAC) 2 nodes on Oracle 10g with Automatic Storage Management (ASM).
  • Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle.
  • Involved in logical backup using and full/ partial export/import and Data Pump.
  • Data modeling with extensive normalization activity.
  • Installation and configuration of Statspack and analysis of Statspack. Performance report and subsequent tuning, monitoring of production database.
  • Data Migration (from 9.2.0.5 to 10.2.0.1) on AIX 5.1, which is made on a Linux Advance Server.
  • Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
  • Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
  • Using RMAN for backup and recovery.
  • Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
  • Installing and troubleshooting Red Hat Enterprise Linux 5.0 for Oracle 9i and 10g and RAC setup.

Environment: ORACLE 10g, Red Hat Linux Enterprise Server, AIX 5L 5.1, OEM, Window 2000 Server.

Client:Confidential, India. July. 2004 to Sep. 2005
Oracle DBA

Roles and Responsibilities:

  • Installed and configured Oracle 9i (9.2.0.1.0) Database on AIX 5L v5.1 and Linux advance Server on Development, Test and Production Systems.
  • Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
  • Migrated Databases from 8.2.7.4 to Oracle 9i.
  • Partitioned appropriate tables to optimize performance and simplified maintenance work.
  • Administered database using Oracle Enterprise Manager.
  • Team member of Backup and Recovery Group (consist of 4 DBAs) responsible for Disaster recovery and Standby Database. Full/partial export/import.
  • Created and executed various database queries.
  • Performed RMAN and backups like hot /cold backups.
  • Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
  • Implemented security protocols for the database.
  • Performed database cloning to create Test and Development environments from Production.
  • Scheduled jobs to run on daily/weekly/monthly basis.
  • Involved in design physical and logical models of the database.
  • Provided 24x7 on-call supports. Willingness and flexibility to work beyond regular hours based on business demands.

Environment: Oracle 9i/8i, LINUX (RED HAT Advance Server), AIX 5L 5.1, RMAN Restoring and Recovery, Data Loading, Data pumps.

Hire Now