| Name: | Rakesh K - Certified Oracle DBA | | Primary Skills: | Oracle 10g, 9i, RAC, Red Hat Enterprise Linux 4.0, SUN SOLARIS, UNIX, OEM, Explain Plan, SQL Trace, Tkprof, STATSPACK, Korn Scripting, Metalink, Opatch, PL/SQL, Data Pump, TOAD 9.6, WinSCP, ERWIN DM, SQL Developer | | Summary: | CERTIFICATIONS
Oracle Introduction 9i: SQL
Oracle Database Administrator 10g Certified Professional from Oracle Educational Center
Summary
Over 8 years of experience in Oracle Database Administration, which include the following: providing client support, analysis, design, development, testing, migration, implementation, maintenance, documentation, tuning, backup & recovery using ORACLE 10g RAC, 9i RAC, 8i as a database platform
Installed, migrated and maintained 9i RAC to 10g RAC of ~3TB database with ASM & OCFS2 file systems on LINUX, UNIX & SUN SOLARIS platforms
Installed and maintained Oracle 10gR2 RAC with 4 Nodes on Datamart database servers (RHEL- 4.0, 64-bit Processor) with SAN storage
Installed and maintained Oracle RDBMS on various flavors of UNIX, Linux, SUN SOLARIS & windows platforms
Upgraded the oracle database from 9.2.0.1 to 10.2.0.2 using DBUA & with applying suitable patches by OPATCH
Installed Oracle Data Guard for oracle disaster recovery, high availability and data protection
Implemented Recovery Manager (RMAN) backup, recovery, cloning and duplicating the database.
Performed complete and incomplete recovery of database in events of a database crash, disk/media failure, etc.
Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance
Performed database tuning - tuning involved I/O, memory, CPU utilization, SQL tuning, SGA tuning, shared pool tuning, buffers and disk I/O tuning using Oracle’s regular performance tuning tools like explain plan, Stats pack, SQL*Trace, Tkprof
Used TOAD tool for advanced features like ASM Manager, audit objects, diagnose extents, health check, log miner, segment advisor, database monitor, server stat’s, session browser, SGA Trace, top session filter, HTML Schema Doc Generator, query builder.
Experience in writing shell scripts
Experience in PL/SQL PACKAGES, FUNCTIONS, PROCEDURES, DBA ROUTINES & SQL Programming
Worked with ERWIN DATA MODELER r7 tool for taking physical & logical data models for different schemas in the database using the technology called reverse engineering
Performance tuning of test and production database, monitoring system. tuning and diagnosing of database performance by query optimization and trace facility monitoring users, free spaces, table spaces and indexes
Expertise in tuning applications, memory, disk usage, space utilization, oracle security.
Knowledge on features of Oracle 11g
Expertise in writing backend procedures, functions, packages and triggers using PL/SQL.
Worked with Oracle Enterprise Manager (OEM) which is used to manage the Oracle environment
Used TOAD Tool for application development for building, testing & debugging PL/SQL packages
Expertise in working with the concepts of PARTIONING
Used the Utility SQL*Loader for high performance data loads
24*7 production database support with support to developers & end-users
Implemented backup of databases both logical (Data pump import & data pump export, conventional import & export) and physical (hot and cold) procedures
Performed routine DBA functions like space management, rollback segments, and undo segments
Familiar with EMC storage technologies, split mirroring, snap & RAID concepts
Comprehensive and in depth experience using the System Development Life Cycle (SDLC)
Created users, roles and profiles, privilege management with role-based security
Expertise in creating primary database storage structures (Tablespaces), primary objects (Tables, Views and Indexes)
Used oracle support and MetaLink to troubleshoot the problems and issues.
Effectively handled multiple tasks simultaneously
Good academic record. Good communication, interpersonal skills & ability to work independently and highly motivated & organized with good analytical abilities and presentation skills & commitment to team work
SKILLS
Languages: SQL, PL/SQL, C, C++, Core JAVA, UNIX shell Programming.
Operating Systems: Red Hat Linux 2.1,3.x,4.x, AIX ,4.3.3,5.1,5.2, Sun Solaris 5.x, HP-UX 10.x,11.x,Ms-Dos, Windows 95/98/NT/2000/2003/XP, UNIX.
Databases: Oracle 8i, 9i RAC, 10g RAC, 11g RAC.
Tools & Utilities: Data Pump Export/Import, SQL*Loader, OEM, Toad, Export/Import, SQL*PLUS, STATSPACK, RMAN, HTML, Java Script, MS ACCESS, MS EXCEL, Enterprise Manager, TKPROF, OEM Database Control, DBCA, OUI, Procedure-Builder, Data Guard Working Analysis, ERWIN DM, Winscp, PLSQL Developer, Business Intelligence SQL Profiler ,SQL Developer.
| | | Rate: $60/hr, Total Exp: 8.5 Yrs, US Exp: 5 Yrs, Available: 1-2 Weeks, Current Location: Tampa, FL. Relocation: Anywhere in US | | Goto Top | Receive Resume by EMail | |
| Name: | Selva S - Oracle 10g/OWB Developer, Sr. | | Primary Skills: | Oracle 10g/9i/8i, RAC, Oracle 10g Warehouse Builder, ERwin, PL/SQL Stored Packages/Procedures, SQL Plus, Toad, Windows XP and UNIX Korn Shell Scripts, Pro *C, Oracle Forms 6.0, Designer2000 | | Summary: | Ten years of experience in software development using Oracle Technologies.
Strong experience in back-end programming with Oracle PL/SQL Plus and SQL
Excellent experience in oracle upgrade and data migration form Oracle 8i to 9iApplication
Server (OAS);
Excellent experience in Oracle Developer 2000 , Designer 2000 and Database Administration.
Excellent Experience in Business Analyst
Developed PL/SQL programs as Database Triggers, Stored Procedures and Functions
Experience in application performance and tuning (PL/SQL)
Experience in Tables, Indexes Creation. Roles, Users Setup and Security.
Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies
Proven expertise in all phases of Software Development Life Cycle (SDLC) of various projects.
Extensive experience in Requirement Capturing, System Analysis, Software Design (Data Modeling) and Architecture, Development and Implementation of Software Applications.
Proficient in Data Modeling (Logical and Physical Design of Databases) using Designer 2000 writing server side stored procedures/ triggers.
Expert in Database Administration operated by multiple users and multiple Databases
?Extensive experience in Client/Server architecture and application development using Oracle Forms 4.5/5.0/6.0/6i.
Experience in Dynamic SQL, Records, Arrays and Exception Handling.
Sound in Report Generation using Oracle Reports 2.5/3.0/6.0/6i.and developed custom graphics using graphics 3.0/6.0/6I
Exposure in doing Business Process Re-engineering (BPR)
Holds Masters Degree in Computer Applications and Brain bench Certified Oracle Developer 2000 Professional.
| | | Rate: $70/hr, Total Exp: 10+ Yrs, US Exp: 9 yrs, Available: 2 Week Notice, Current Location: Los Angeles, CA. Relocation: Anywhere in US | | Goto Top | Receive Resume by EMail | |
0 comments:
Post a Comment