We provide IT Staff Augmentation Services!

Oracle Database Administrator/system Admin Resume

IL

PROFESSIONAL SUMMARY:

  • Around 7+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (9i, 10g, 11g) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform.
  • Experience in Configuring 10g/11gR2,12c Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM) and Data guard.
  • Experience with very large scale database environments and mission critical OLTP systems.
  • Experienced inInstallation,Cloning, and Upgrade of Oracle Databases.
  • Experiencedin Backup&Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
  • Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
  • Provided 24x7 production support
  • Experience in working with Grid Controland Oracle Enterprise Manager (OEM).
  • Experience in maintaining Oracle Data Guard&Standby Database and providing critical solutionwith strategic disaster recovery plans with different recovery procedures and methods.
  • Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
  • Cloned Database from Production to Test and Development.
  • Experience in migration of oracle databases and installing patches.
  • Exporting and Importing of dumps using expdp and impdp.
  • Install Oracle Software 11gR2 and Create Database on Exadata Server Machine with ASM Storage in Linux Operating Server.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Exploring Oracle Golden Gate.
  • Install Microsoft SQL Server 2008,2009,2011 on windows platform and working through Microsoft visual studio
  • Configure Bugzilla on Install MySql database on AWS EC2 Server in Linux Operating Server.
  • Firewall rule experience and Palo Alto
  • Open Firewall support Request by Requester.

TECHNICAL SKILLS:

OPERATING SYSTEMS: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 4/5, SUSE 10.0 and Windows NT/ 2000/2003/2008.

RDBMS: Oracle 9i/10g/11g, Oracle 10g/11g Real Application Clusters (RAC), Oracle EBS Suits R12, Oracle Application server10g,Oracle Middleware Fusion11g

LANGUAGES: SQL,sqlplus

SOFTWARE/ APPLICATIONS TOOLS: OEM, DATAGUARD, Recovery Manager (RMAN), Datapump, STATSPACK, AWR,ADDM,Clusters, VERITAS Backup, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Oracle Database Administrator/System admin

Responsibilities:

  • Configure and Install Oracle Database 11g R2 in EC2 Server AWS and using ASM fILE System
  • Migration Oracle Database R2 to RDS Server AWS Through EXPDP/IMPDP
  • Configuration, Installation and maintenance of Oracle 11gR2RACdatabases including Grid Infrastructure.
  • Involved in setting up of data guard
  • Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete)
  • Proficient in managing Oracle Instance, database storage structure, schema objects.
  • Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
  • Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production supports.
  • Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co - coordinating with on-site counterpart as well as Clients and understanding requirements.
  • Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
  • Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
  • Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.
  • Deploy Bugzilla Software with Using MYSQL Database in AWS EC2 Servers.
  • Firewall rule experience and Palo Alto
  • Open Firewall support Request by Requester.

Confidential, MI

Oracle Database Administrator

Responsibilities:

  • Migrating applications from non-clustered oracle 8i/9i databases to new 10g RAC Database environments.
  • Monitoring and supporting Applications using OEM 9i Grid Control.
  • Configured and Manage two node Oracle 11g RAC cluster..
  • Implemented schema level, table level and bidirectional oracle streams.
  • Registering Databases to RMAN Catalog.
  • Planning and scheduling Backups, RMAN, taking Logical Backups.
  • Experience in Export/Import and Datapump.
  • Oracle Enterprise Manager 12C Grid Control monitoring and administration of 500+ Databases
  • Monitoring and fixe problem of Backup issue. adding space and requesting Space of ASM.
  • L3 Support of Oracle Database Platform 24 by 7 Support.
  • Manage incident calls of 24 by 7 Support.
  • Configure and rebuild Oracle Data guard 11g (active Data Guard)
  • Monitoring Oracle Backup Report and fixe Issue.
  • Managing Oracle Tablespace Adding Data Files.

Confidential, IL

Sr. Oracle DBA

Responsibilities:

  • Successfully implemented oracle 11g grid control and Install OEM Agent in Each Database Server.
  • Installed and applied patches for oracle 11g and 10g databases for supporting applications.
  • Up-gradation and Migration of Database from 10.2.0.4 to 11.2.0.3 and applying patches whenever required.
  • Applying upgrade patches, maintenance and interim patches on all the databases.
  • Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
  • Involved in 24x7 support for production databases with on-call pager .
  • Installation of database software and with analyzing, designing, and implementing databases.
  • Used Oracle Real Application Testing for performing tests in QA environment.
  • Data Refresh from Production to Test and Development environments using RMAN and expdp/impdp.
  • Experienced in handling database issues using OEM as well as command prompt.
  • Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.
  • I along with team implemented physical standy database using Datagaurd.
  • Daily Health Check Up of the Database using staspack, AWR, ADDM
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database.
  • Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
  • Maintaining security of databases and users.
  • Reading Alert Log and User trace Files and Diagnosing the Problem.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Installation and configuration of Oracle Client software and Tools.
  • Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
  • Space Management which includes table space creation, adding new datafiles.
  • Oracle EBS Suite cloning to set target Server. and Installations OF Oracle R12.
  • Oracle Fusion Middleware Forms and report Installation and configurations weblogic server through Oracle fusion middleware 11g.
  • Installed, configured and maintained Oracle 11g ASM on Oracle Enterprise Linux in Exadata Machine.
  • Exadata monitoring into our existing Databases 11g monitoring. Provide and implement performance and tuning recommendations of all components in the Exadata machines
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

Environment: Red Hat Linux, HP -UX 11.31, Solaris,, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Confidential, NJ

Oracle Database Administrator/ System Admin

Responsibilities:

  • Configuration, Installation and maintenance of Oracle 11gR2 RACdatabases including Grid Infrastructure.
  • Performed upgrades from Oracle 10g to 11g and applied patches.
  • Involved in setting up of data guard for 2-node standby.
  • Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
  • Proficient in managing Oracle Instance, database storage structure, schema objects.
  • Experienced with SRVCTL, OCR and Voting Disk of 10g,11g RAC.
  • Experience in SQL Server and databases.
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
  • Skilled with AWR, ADDM to check health of database & hardware.
  • Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
  • Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
  • Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
  • Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
  • Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
  • Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.
  • Knowledge of Linux operating system and Linux system administration: OS installation, monitoring, etc.

Environment: Operating Systems: Redhat Linux 5,6 (RHEL) and Oracle Enterprise Linux (OEL)

RDBMS: Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL

Confidential, Dallas,TX

Oracle Database Administrator

Responsibilities:

  • Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Have worked on different environments like test, development and production databases.
  • Have worked on backup/recovery, performance tuning.
  • Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
  • Experience in handling GUI software and OS.
  • Database Restore using RMAN, Cold Backup and Export.
  • Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
  • Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
  • Used impdp /expdp and SQL- loader to load data into tables.
  • Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas..
  • Installation and configuration of DATABASE.

Environment: Operating Systems: Redhat Linux 5,6 (RHEL) and Oracle Enterprise Linux (OEL) Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Hire Now