Oracle Database Administrator Resume
EXPERIENCE SUMMARY:
I am associated with Confidential for the last 6+ years. My main area of experience has been ORACLE DBA. My role is production support DBA and deployment for Oracle databases and App. Server hosted on AIX and Windows platforms for Client Confidential.
TECHNOLOGY:
Operating System: Oracle 9i, 10g, 11g database & App.Server, SQL, PL/SQL, Linux,AIX,Windows.
Technology: Pl/Sql developer, Sql - Plus, OEM, Toad, Grid Control,OUI
Tools: IBM AIX6.1, HP-UX,NT
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Database Administrator
Responsibilities:
- Team Lead of team size 15
- Creation of standalone, RAC database in UNIX platform.
- Monitor and manages database backups using RMAN utility and Data pump, export/import hosted in Windows and AIX servers
- Oracle binaries installation on AIX,Linux servers
- Monitoring the size of Table space size growth & Checking database performance with respect to locks/blocking sessions
- Applying Patches/changes to database objects
- Troubleshooting and resolving daily database issues.
- Cloning or refreshing of existing data instances.
- Knowledge for creation of Standby DB setup using Dataguard.
- Tuning SGA,Query Tuning
- Trace and troubleshoot database issues using various utilities like explain plan,tkprof,oradebug,index rebuilt, analyze
- Understanding the database issues using event tracing
Confidential
Team Member
Solution Environment:AIX6.1, Oracle 10gR2 Database and Application Server, J2EE based application with MVC2 Architecture
Tools: SQL Plus,OEM,PL/SQLDeveloper,DBCA
Responsibilities:
- Manage various activities within the organization efficiently through Work list.
- Monitor personnel performance in an organization through Dashboard.
- Store various documents in a secure and efficient way through Files Room.
- Process, Move and Monitor various applications in an organization.
- Print Reports with complete and accurate user details.
- All the departmental Applications can be seen through the Applications.
Confidential
Oracle Database Administrator
Responsibilities:
- Team Lead of team size 10
- Creation of standalone, RAC database in Windows / UNIX platform.
- Monitor and manages database backups using RMAN utility and Data pump, export/import hosted in Windows and HP-UX servers
- Monitoring the size of Table space size growth & Checking database performance with respect to locks/blocking sessions.
- Applying Patches/changes to database objects
- Troubleshooting and resolving daily database issues.
- Cloning or refreshing of existing data instances.
- Business User support
- Tuning SGA,Query Tuning, Tuning the code written in PL/SQL
- Provide assistance to applications developers and users regarding database access and data query development. Provide troubleshooting assistance as required.
Confidential
Team Member
Solution Environment: HP-UX, Oracle 10gR2 Database and Application Server,J2EE based application with MVC2 Architecture
Tools: SQL Plus,OEM,PL/SQLDeveloper,DBCA
Responsibilities:
- Monitor and manages database backups using RMAN utility and Data pump, export/import hosted in Windows and HP-UX servers
- Monitoring the size of Table space size growth & Checking database performance with respect to locks/blocking sessions.
- Applying Patches/changes to database objects
- Troubleshooting and resolving daily database issues.
- Cloning or refreshing of existing data instances.
- Business User support