Oracle Dba Resume
Herndon, VA
SUMMARY
- Overall 8 years of IT experience including 4 years as Oracle Database Administrator
- Monitoring of Database - Health/Performance (Database, I/O, Memory, Processes, parameters), Database/Data-files/Tablespaces Growth Pattern, Space Utilization, Backups/Recovery, Security/User Management
- Installation and Configuration of Oracle Instances(9i, 10g and 11g) on Unix/Linux environments
- Oracle Software patching
- Managing Database security: Users, Roles, Privileges, Profiles etc.
- Managing Tablespaces, Segments, Extents and Indexes; Procedures and Triggers & Views
- Database Backup and Recovery using RMAN
- Database Clone using Hot/Cold Backup
- Storage Management (RAID/ASM)
- Performance Tuning
- Standby/Data Guard Configuration
- Managing Real Application Cluster (RAC) Databases
- Oracle Database Replication - materialized views
TECHNIALS SKILLS
RDBMS: ORACLE 9i, ORACLE 10g & 11g R2
OPERATING SYSTEM: UNIX, LINUX, SOLARIS-10
REMOTE ACCESS TOOL: Putty, VNC
UTILITIES: Opatch, Export/Import utility, Net Manager & Oracle Enterprise Manager, TOAD, SRVCTL, CRSCTL
PROFESSIONAL WORK EXPERIENCE
Confidential, Herndon, VA
Oracle DBA
RESPONSBILITIES:-
- Working on 24x7 production support.
- Managing more TEMPthan 16 production, testing business critical databases
- Managing Oracle 10g/11g releases RAC (2 Nodes) databases in production and development environment.
- Worked on Recovery manager (RMAN) for backup and recovery.
- Handful experience in Upgrading oracle databases from Versions 10g to 11g.
- Involved in Installing and configuring of 11g Oracle Real Application Clusters (RAC) in Linux.
- Rebuilding of Indexes for better performance, maintenance of Oracle Database
- Oracle binaries installation, patching and upgrade
- Managing Schema/Table level refreshes
- Managing production deployments
- Experience on implementing Datagurd Switchover and failover.
- Database cloning from production Database.
Environment: Oracle 11gASM/11g RAC/10g, Flashback, Data Pump, Grid Control (OEM), Enterprise Manager Console, SQL*Loader, SQL PLUS, SQL Developer, Putty.
Confidential, Parsippany, NJ
Oracle DBA
RESPONSBILITIES:-
- Working on 24x7 production support.
- Monitoring Database Alerts and making report of some Critical Database’s Daily Growth size and Tables growth size and Top SQL events and Database Cluster’s Node Activity.
- Managing RMAN Backups
- Oracle binaries installation, patching and upgrade
- Managing production deployments
- Monitoring Growth of tablespaces and undertaking necessary re-organization of database
- Create and manage Oracle users wif appropriate grants and privileges
- Rebuilding of Indexes for better performance, maintenance of Oracle Database
- Creating Knowledge Base Documents for Oracle Database
- Installation and Configuration and Managing 2 nodes RAC database
- Cloning production database on development servers.
- Set up and maintain the listener.ora, tnsnames.ora and ORATAB file as per Security requirements
- Full Database, Tables and Schemas refresh using logical backups
- Handling Request for Schema change, modifying TNSNAMES.ORA & Parameter files, Database backup, Database Startup, Database Shutdown and Bounce
- Create Accounts and Tablespaces
- Monitoring of Cluster’s node of RAC database
Environment: Oracle 10g and 11gR1/R2, OEM, RMAN, RAC, Data Guard, ASM, Explain plan, AWR, SQL* Plus, PL/SQL, SQL* Loader, AIX 6.1, Red Hat Linux 5.0 and Windows MSCS 2003, TOAD 10.0
Confidential
Junior Oracle DBA
Responsibilities:
- 24x7 Oracle Production Database Administrations.
- Installation, Configuration, Upgrade, patching of Oracle RDBMS.
- Refresh/Cloning of Database for development, testing
- Create table spaces, tables, and users for custom applications.
- Maintain user security.
- Assist Programmers and Developers wif Oracle problems.
- Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
- Implementing range, list partitions, hash partitions.
- Creating and refreshing materialized views.
Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM,Pl/Sql.