Over 8+ years of experience in IT Industry as an Oracle DBA.
Installed and configured Oracle Server 10g, 11g standalones and RAC software on UNIX and Linux platforms.
Configured, implemented 10GR2@ RAC with ASM disk on Linux servers
Duties also included database creation, database tuning/reorganization, SQL statement tuning,
Backup/recovery, general troubleshooting, script development, documentation and end user training.
Established best practices and best procedures for database administration
Manage Backup and Recovery Program for all Oracle Databases Install, implement and configure
RMAN Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
Experience with Oracle RMAN and Veritas Net Backup.
Prepared documentation of Database Operations Standards and Database Backup and Recovery
Experience as a Database Administrator for Oracle 7/8i/9i, 10g, 11g under UNIX, Windows NT
Extensive experience in business analysis, design, development, testing and implementation of Oracle 8i/9i/10g Client/Server Application Development
Proficient in SQL, PL/SQL, database objects like Stored Procedures, Triggers and Packages
Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
Implemented table partitioning to improve performance and data management
Taking Logical Backups with Export/Import and Data Pump (10g)
Expertise in migration/ up gradation of oracle databases (from 9i
Migrated database from Oracle 10.2.0.1 (32 Bit) to Oracle 10.2.0.4 (64 Bit) on windows 2003.
Expertise in configuring Data Guard (9i, 10g) - Physical standby.
Installed and configured Oracle Internet Directory (OID) for service name resolution and setup one way replication.
Experience with Oracle Streams for 10g.
Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage
Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
Strong Troubleshooting, Problem solving, Analytical & Design Skills
Excellent communication and problem solving skills