We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume Profile

2.00/5 (Submit Your Rating)

NY

Hire Now

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.

KEY SKILLS

  • Usage of Data Dictionary Views
  • Implementation of oracle security by creating roles, privileges and profiles
  • Able to manage Partitioning, table spaces, segments, users, security
  • Block Recovery
  • Bulk loads and data migrations Data pump, IMP/EXP
  • Database Cloning Refresh from Hot/Cold Backup
  • Database Backup and Recovery using Flashback
  • Database Backup and Recovery using RMAN, TSPITR
  • Installation and Configuration of Oracle Instances 9i 10g on Windows/Unix/Linux environments
  • Having fundamental knowledge of Oracle Database Architecture
  • Sound understanding of Process and delegate escalations in 24x7 mission-critical Banking insurance environments.
  • 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

SUMMARY OF PROFESSIONAL WORK EXPERIENCE

Confidential

Senior ORACLE DBA

JOB 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 appl ication team if they want any changes in database. Work directly with them.

Confidential

Senior ORACLE DBA

JOB 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
  • Maintenance and tuning of databases: 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

RESPONSBILITIES

  • 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

Role: 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.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship