Oracle Dba Resume
3.00/5 (Submit Your Rating)
New Jersey, NJ
SUMMARY
- Experience in Oracle Database Administration encompassing Installation, Configuration, Data Guard, Grid Control, Patch Installation, Migration, Upgrades, Backup and Recovery, Replication, Database Security, Memory Management, Performance tuning .
- Installation and administration of Oracle 11g/10gon OEL, RHEL, Windows, Unix and Sun Solaris in OLTP environment
- Performed Migration and Upgrade of 30+ databases to 11g and 10g
- Experience on oracle 11g/ASM/RAC and standalone databases to 11g RAC environment
- Configuration of Automatic Storage Management (ASM)
- Configuration and Management of Data Guard on RHEL, OEL
- Vast Knowledge in installation and implementing OEM and setup of Oracle Grid Control
- Experience on Data Replication using Snapshot, Materialized views, import/export.
- Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g
- Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
- Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, Datapump export/import.
- Implementation of Flashback Technology Up gradation of databases applying patches, patch sets and critical patch updates downloaded from METALINK
- Extensive experience using SQL* Loader, External Tables
- 24*7 on-call production database support and maintenance including remote database support
- Possess technical ability and self-initiative to learn and implement new concepts in short duration
- Ability to work in a team as well as to take individual responsibility
EDUCATION
Associate in Applied Science
Bachelor of Science, Computer Science
TECHNICAL SKILLS
Programming Languages: C++, SQL,PL/SQL, JAVA
Operating Systems: Windows XP professional, Windows 2003 Server, UNIX, Solaris, Linux.
Databases: Oracle 11g
Oracle Products: Oracle10g (Grid Control), OEM (Oracle Enterprise Manager),RMAN, SQL*Loader, Import and Export, DATA PUMP,ASM.
Other Tools: Oracle Enterprise Manager (OEM), Putty, WinSCP
PROFESSIONAL EXPERIENCE
Responsibilities:
- Install and upgrade and manage Oracle RAC databases with ASM as required on Linux and Solaris Operating systems.
- Install, Upgrade and manage Oracle Grid Control
- Troubleshoot and resolve RAC clustering issues in all database environments
- Performs all Oracle Database Administration related activities for major projects independently with minimal supervision.
- Strong capability and ability to resolve highly technical and complex database and infrastructure related issues on their own before they impact production and business.
- Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning and monitoring.
- Assures quality of database analysis and design across projects, thus enabling company-wide data reusability.
- Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities.
- Schedules and coordinates database maintenance activities.
- Coordinates and/or participates in database stress tests, analyzes results, and makes recommendations for design or coding changes based upon those results.
- Participates in on-call, overnight off-hour production problem resolution activities.
- Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows IT software development processes.
- Researches, evaluates, and tests new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
- Monitors current DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required.
- Identifies and supports quality improvement initiatives.
- Performs other assignments to comply with the IT corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive.
- Complies with all IT security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access.
Environment:Oracle 11g, Oracle 10g, AIX, Linux,Windows 2003 ,Oracle GRID Control ,ASM, Oracle RAC, Oracle RAC, Oracle RMAN Standby databases, Oracle Sql developer, AWR, Sun Solaris.