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

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

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.