We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume Profile

Professional Summary:

  • over 8 years of working experience in database administration, design, development, performance tuning, and high availability solutions. Database management skills with extensive experience in managing Oracle implementations, upgrades, data replication, database security, PL/SQL development, backup and recovery, space management, disaster recovery solutions, and patch management in a UNIX/Linux and Windows environment. Good experience of setup configuration, implementation of Oracle 11gR2 RAC two-node on Linux with ASM
  • Oracle DBA, providing 24/7 support for both development and production databases on various platforms. Responsible for round-the-clock database operations and offering solutions for Production/Development of database applications.
  • Exposure to several industry sectors Finance/Mortgage, Internet/Web advertising, Telecom, State, Retail, Power, Banking/Credit card processing, Federal and Manufacturing.
  • Installation, Configuration and Maintenance of Oracle 9i/10g/11g RAC on two node and four node configurations.
  • Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management ASM in RAC environment.
  • Installation and configuration of 10g Oracle Enterprise Manager OEM grid control for Performance, Administration and Maintenance of Databases. Deployed agents on various targets.
  • Expertise in Migration and Up gradation of Oracle databases.
  • Experienced in applying patches including PatchsetsandCPU/PSU,One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
  • Configured and administered replication using Oracle StreamsandOracleGoldenGate technology.
  • Proficient in working withData Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
  • Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions
  • Proficient in Exalogic maintenance/support//backup/recovery.
  • Experienced in system Monitoring and Database Performance Tuning using Explainplan, SQL Trace,Statspack,TKPROF, AWR,ADDM and ASH.
  • Experience in Upgrade of Oracle E-Business Suite EBS to 11.5.0.2.
  • Proficient in maintenance of Production, Testing, Development, RAC, Standby databases/ DataGuard for OLTP and DATAWAREHOUSEand experienced in Data Modeling.
  • Proficient in flashback technology and other features such as logminer, Automatic StorageManagement ASM .
  • Provided primary database administrative and Architect support for DB2 databases.
  • Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjoband implemented VERITAS NetBackupto perform daily backups.
  • Performed full, incremental and cumulative backups using RMAN. Expert in performing manual recovery using RMAN with and without catalogue.
  • Installed, configured, and maintained Oracle Fusion Middleware with SOA, OBPM Suite and WebLogic Server.
  • Expertise in working with the tools like OEM, TOAD, Export/ Import,SQL Loader, SQL Analyzer and managed system events and jobs using OEM.
  • Performed Data Archiving whenever required for moving data to a separate storage device.
  • Skilled in performing Logical backupusingTraditional export/import and Data pump export/import.
  • Experienced in Space Management, Resource management and Capacity Planning.
  • Extensively worked with NETSTAT,NET Manager and PingUtilityto resolve network problems.
  • Setup and Management ofAuditing, Oracle Securityand SQL Navigator.Job scheduling using cron utility and Shell Scripting for automating DBA tasks. Experienced in SQL/PLSQL programming.
  • Refreshing the Production over the Dev, UAT and keeping the Test Instances in sync with other instances
  • Expert in Cloning and Manual creation of Oracle Databases.
  • Generated Materialized views to cache data that was frequently needed, to improve performance.
  • Good experience in Creation and Maintenance of Database Objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views and Indexes.Monitoring and managinglocal table partitioning.
  • Excellent communication, analytical and interpersonal skills.Good team player and a highly motivated individual strong commitment to quality and customer service.

Technical Skills

Database Utilities

DBCA, DBUA, Recovery Manager RMAN , Oracle Enterprise Manager OEM , OEM Grid Control, Oracle Data Guard, Oracle Management Service OMS , Real Application Clusters RAC , ASM, SQL Navigator, Erwin, TOAD, Data Pump expdp, impdp , Autosys, Query Analyzer, VERITAS NetBackup, Developer 2000, SQL Plus, SQL Loader, GoldenGate, Commvault, Toad, SQL Developer

Databases

Oracle 8i, 9i, 10g RAC, 11gR1 RAC,11gR2 grid control RAC.

Tool/Utilities

TKPROF, STATSPACK, Explain Plan, OEM.

Operating Systems

Windows NT/2000/2003/XP, RHEL, Solaris 8/9/10/11, AIX, HP-UX.

Others

AD Utilities, SQL Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer.

Professional Experience:

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Primarily responsible for administering and monitoring 200 mission critical Oracle 12c/11g/10g/9i OLTP production databases.
  • Installed and configuredOracle 10g 11gr1/r2 databases on Linux 5,HP-Unix 11.X.
  • Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database from 10.2.0.3 to 11.2.0.2 .
  • Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster RAC databases running on Cluster File system.
  • Applied Critical Patch Updates and Patch Set Update CPU/PSU on various platforms using Universal Installer and OPatch Utility.
  • 24x7 Production Oracle Applications Administration.
  • Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.Performed replication using Oracle Streams and GoldenGate Technology.
  • Involved in data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
  • Implemented Data Guard with maximum protection and maximum performance configurations and worked with Data Guard fail over and switch over cases.
  • Installed Oracle Discoverer and Integrated with EBS.
  • Installed, Configured and Managed11g Oracle Enterprise Manager OEM grid control for Performance, Administration and Maintenance of Databases.Successfully maintained multiple databases.Experienced in working with tools like TOAD.
  • Upgraded Oracle 10.2.0.3 Applications Database 11i on Linux.
  • Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR,ADDM andASH.
  • Designed and implemented backup and Disaster recovery strategies with RMAN.Performed logical backup usingtraditional export/ import and DataPump.
  • Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
  • Remodeling the existing system using ER/Studio for logical/Physical data modeling.
  • Reorganized databases and Sizing of database objects for effective space management and optimal performance.
  • Modify database structures as required by developers due to business or application requirements, clonedevelopment databases for testing and training
  • Partitioning tables by determining the suitable methodology to improve performanceand manageability.
  • Created Materialized views, groups for performing SQL Loader jobs for data loading and used data pump jobs for loading the subscriber and history related data at replicated site.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
  • Upgraded EBS Database to 11g 11.2.0.3 RAC in both TEST and PRODUCTION environment.
  • EBS upgrade from 11.5.10.2 to 12.1.3
  • Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
  • Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
  • Managed and monitoredgrants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.
  • Assisted developers in getting database connection from the client using SQL net.
  • Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files
  • Implement Stored Procedures and Triggers based on business plans using PL/SQL.
  • Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for product integration with client's applications.
  • Installed and configured one to one GoldenGate replication and resolved out of sync issues.
  • Regular DBA activities like database auditing, space management, database issues, locking, managing user groups, tuning, re-organization, re-building of Indexes.
  • Provided 24x7on call production support.

Environment: Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 10gR2, Oracle 9i, Linux, HP-UNIX Windows,DBCA, OEM Grid Control, Exadata, HP Data Protector, SOA Suite 11.1.1.3, Oracle Streams Data Guard, TOAD,Oracle JDeveloper 11.1.3/4,Solaris 11, GoldenGate, Endeca, Oracle E-Business Suite EBS , VERITAS Net Backup, Data Pump, Tuning, SQL Loader

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Supported 100 databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
  • Primary DBA for 1GB - 2.5TB database for 24/7 support.
  • Installed and configured Oracle 10g databases on HP-Unix 10.x and AIX 5.2.
  • Installed and configured Oracle RDBMS on UNIX and Windows environments. Createdprimary databasestorage structures tablespacesetc. .
  • Create and maintain Fusion, Oracle EBS Suite environments, DB templates, RAC environments,
  • Involved in database administration including 10g RACDatabase cloning, tuning, patching and monitoring concurrent manager processing.
  • Creating data modeling for new developments using Erwin modeler.
  • Initiated 10g new feature implementations such as Automatic Storage Management,Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
  • Integrating Oracle Applications R12/11i with OID/SSO.
  • Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • Created Dimensional and Relational Physical logical data modeling fact and dimensional tables using Erwin.
  • Handling GoldenGate replication issues which are responsible for out of sync in Test environment.
  • Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
  • Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
  • Migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
  • Setup and configure Standby database Physical Logical for high availability.
  • Integrating Oracle Utilities Applications with Spatial GIS database.
  • Oracle Database and Oracle Applications cloning/refresh.
  • Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Create and troubleshoot DB Link's issues in Oracle for communicating with external databases.
  • Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Managedundo segments, processes, memory, online redo log files, data files.
  • Installed and Configured Oracle Applications 11i e-business suite using Rapid Install.
  • Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
  • Configured and installed one to one replication using GoldenGate between heterogeneous environments.
  • Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
  • Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: HP-UNIX, AIX, Windows,RAC, DBCA, OEM Grid Control, Exadata, Data Guard, TOAD, SOA Suite 11.1.1.3,ASM, VERITAS Net Backup, RMAN, Solaris 10, Oracle E-Business Suite EBS , GoldenGate, STATSPACK, SQL Loader, SQL/PLSQL

Confidential

Oracle Database Administrator

Responsibilities:

  • Installed and configuredOracle Database Software 10g on Sun Solaris and Linux-4x,5x.
  • Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database.
  • Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
  • Installed,configured and managedOEM Oracle Enterprise Manager for routine administration, database monitoring, replication process and performance tuning.
  • Configured initial and incremental load using GoldenGate.
  • Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios using RMAN.
  • Involved in NoSQL and relational data modeling.
  • Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 9.
  • Worked with database export import scripts to backupdatabase structures and automation procedures.
  • Monitored and troubleshot top CPU/memory consuming processes.
  • Scheduling Automatic scripts for GoldenGate reboot.
  • Performed Table space Management and Rollback table space Management.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Converting single instance database to Real Application Cluster RAC .
  • Created Dimensional and Relational Physical logical data modeling fact and dimensional tables using Erwin.
  • Transaction Management and Security Management.
  • Plan, coordinate, and implement network security measures.
  • Supported Developers and end-users in troubleshooting issues.
  • Provided System support for both development and 24 7production environments.

Environment: Sun Solaris 9, Linux-4x,5x, Windows, RAC, OEM, Oracle Streams, GoldenGate, RMAN, StatsPack, Export/Import, SQL Loader,SQL/PLSQL

Confidential

Oracle Database Administrator

Responsibilities:

  • Installed, Configured andManaged Oracle9i on HP-UX and IBM-AIX environmentsfor production, testand development.
  • Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
  • Involved in creation of Data Warehouse database Physical Model, Logical Model using Erwin data modeling tool.
  • Involved in logical backup using full/ partial export/import and Data Pump.
  • Supported and troubleshoot databases on VERITAS Cluster on top of Solaris 8.
  • Performing the capacity planning for databases.
  • Cloned/Refreshed Database environments to create patch, test, development and QA environments.
  • Tuned SQLstatements using explain plan and Tkprof. Monitoring and Performance tuning.
  • Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
  • Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
  • Configured and troubleshoot ASM Cluster File System ACFS for Grid/RAC cluster.
  • Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
  • Created and maintainedmaterialized views.
  • Modified and debugged stored procedures and triggers.
  • Interacted with the users and Troubleshooted the problems related to the privileges resources.
  • Monitor database activity and file usage, and ensure necessary resources are present, so that databases function properly by removing or deleting old or obsolete files.
  • Performing all the Database Administration activities like space management in database, user and rolesadministration,schema management, checking alert log of all the databases.
  • Contributed to team effort by accomplishing related results as needed.

Environment: Sun Solaris 8, Linux-4x, 5x, RAC, Windows, OEM, Oracle Streams, RMAN, StatsPack, Export/Import, SQL Loader,SQL/PLSQL

Hire Now