We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

OBJECTIVE:

Seeking career in Oracle Database Administration in Multi platform UNIX environment and Managing Oracle Applications on Clusters in a world - class organization that would provide competitive and challenging work environment to exploit my potential and augment my skills.

SUMMARY:

  • Sound understanding of Process and delegate escalations in 24x7 mission-critical Banking & insurance environments.
  • Having fundamental knowledge of Oracle Database Architecture
  • Installation and Configuration of Oracle Instances(9i & 10g) on Windows/Unix/Linux environments
  • Database Backup and Recovery using RMAN, TSPITR
  • Database Backup and Recovery using Flashback
  • Database Cloning & Refresh from Hot/Cold Backup
  • Bulk loads and data migrations (Data pump, IMP/EXP)
  • Block Recovery
  • Able to manage Partitioning, table spaces, segments, users, security
  • Implementation of oracle security by creating roles, privileges and profiles
  • Usage of Data Dictionary Views
  • Generating & analyzing PT related Reports(AWR, ADDM, stats pack etc)
  • Real Application Cluster ( RAC ) Installation and configuration & Administration on 10G .
  • Add New Nodes on Oracle RAC 10g Cluster on Linux.
  • Working knowledge on 11gr1
  • Upgrade standalone databases from 10g to 11g manually & using DBCA
  • TSPITR

PROFESSIONAL WORK EXPERIENCE:

Confidential

Senior ORACLE DBA

Responsibilities:

  • Implementation of Dataguard. Switching over the database in planned activity. Failover the databases.
  • Refreshes using exp/imp, EXPDP/IMPDP, using RMAN
  • Clonning: - Using RMAN & Manually.
  • RAC:- Implemented RAC on 10g, implemented service (TAF)Performance tuning issues using SQL advisor/OEM
  • Patching:- SPU/PSU on cluster level, binaries level and database level.
  • Daily health check:- Alert log file, tablespaces, Filesystem mount point.
  • ASM:- Configure ASM, adding disk, dropping disk, created disk group.
  • Agent installation and de-installation.
  • Database creation,User creation, table creation, index creation.
  • Meeting with client & application team if they want any changes in database. Work directly with them.

Confidential

Senior ORACLE DBA

Database: Oracle 8i,9i,10g,11g

Environment: Linux, IBM AIX, HP - Unix, Windows

Responsibilities:

  • Working with ITIL Process (Incidents, Change, Patch and problem Managements etc)
  • Installation and monitoring oracle 10G Real Application Cluster on Linux platforms and IBM AIX
  • Implementation of dataguards on oracle 9i and 10g
  • Has done switchover and failover on dataguards (oracle 9i & 10g)
  • Experienced in 10g/11G New features (ASM, Datapump, AWR, ADDM, ASH)
  • Configuration of databases in RMAN for backup and recovery
  • Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).
  • Assistance in restoration exercises & recovery of database.
  • Applying maintenance patches, quarterly CPU patches, PSU & upgradation.
  • Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Unix Server, Linux Red Hat, IBM AIX Monitoring production and development environment
  • Disk I/O optimization through table, index, differentiating table data and indexes in separate tablespaces in separate disks.
  • Monitoring and appropriate sizing of logical structures viz. tablespaces, tables, indexes through appropriate parameters such as pctused, pctfree, initial and next extent values balancing both I/O and space usage.
  • Interactions with application developers extensively to maintain and tune performance of Oracle server on IBM AIX, LINUX, Windows Platforms

Confidential

Senior ORACLE DBA

Database: Oracle 8i,9i,10g,11g

Environment: Linux, IBM AIX, HP - Unix, Windows

Responsibilities:

  • Obtain and Maintain DBMS Software & Patches
  • Install Oracle Security Patches
  • Set up and maintain the listener.ora, tnsnames.ora and ORATAB file as per Security requirements
  • Set up Links for init.ora file and spfile.ora
  • Remove audit logs older than 30 days, ($ORACLE HOME/rdbms/audit/*.aud)
  • Create password file & OFA Directory Structure
  • Backup Tnsnames.ora, listener.ora, sqlnet.ora, oratab
  • Regular monitoring the status of standby databases, space on ASM.
  • Backup and recovery (RMAN Catalog).
  • Database Cloning using RMAN.
  • Refresh database using exp/imp and Datapump.
  • Using Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Working on RAC administration.
  • Install and maintain DBMS Client software on Unix Server.
  • Block Recovery using RMAN.

Confidential

Engineer Oracle Database

Responsibilities:

  • Copying production backup to DEV/UAT boxes.
  • Full Database, Table and Schema refresh from Export Backup
  • Full Database, Table and Schema refresh from Cold/Hot Backup
  • Hot/Cold Backup Restore
  • Handling Change Request for Schema change, modifying TNSNAMES.ORA & Parameter files, Database backup, Database Startup, Database Shutdown and Bounce.
  • Production Break Fix- Users connectivity issues, running out of connection, KILL Sessions.
  • Undo and Temp Tablespaces management.
  • Create Accounts and Tablespaces.
  • Configure Database/Parameter.
  • Run ad-hoc user supplied SQL scripts
  • Monitoring of Cluster’s node of RAC database.
  • Managing real application clustered database.

Engineer Oracle Database

Confidential

Responsibilities:

  • Managing Tablespaces, datafiles, segments.
  • Analyze tables
  • Creating and Rebuild Indexes
  • Creating Users, constraints, profiles, roles.
  • Block recovery.
  • Modifying Instance with SGA parameters.
  • Configuring network using listener and tnsnames/hostnames.
  • Running Statspack, Explain Plan, tkprof.
  • Daily check the space.
  • Maintain the Archive Log Files.
  • Daily basis maintain the hot backup.
  • Weekly Restore the Database.
  • Logical Backup exp/imp.
  • Running the SQL-Loaders.
  • Monitor performance using dynamic views.

Confidential

Oracle Database Administrator (DBA)

Responsibilities:

  • Managing tablespaces, datafiles, segments.
  • Creating users, constraints, profiles, roles.
  • Creating and Rebuilding Indexes.
  • Modifying Instance with SGA Parameters.
  • Backup using export/import.
  • Configuring network using listener and tnsnames/hostnames.
  • Monitor performance using dynamic views.
  • Running statspack, explain plan, tkprof.

Hire Now