Hello, Please find our Oracle DBA for your requirements. please revert back to [EMAIL PROTECTED]
Location: MI relocation: Open *Summary:* · *6 years* of experience in IT industry, which includes experience as DBA on *Oracle 10g, 9i, 8i, versions*. · Installation of *Oracle, RAC on Linux, HP-UX, UNIX & Windows, sun Solaris*. · Experience in implementing* dataguard and Standby physical databases.* - Creating primary database storage structures (Tablespaces), primary objects (Tables, Views and Indexes). - Creating Users, Roles and Profiles, Privilege management with role-based security. - Typically involved in database *Designing, Creation and Maintenance*, * cloning*. - Complete and Incomplete *Recovery* of database in case of database crash, disk/media failure, etc. - *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. - Routine DBA functions like space management, Rollback segments, Undo segments and Invalid objects. - Experience in installing, configuring and managing ASM - Familiar with one-off / interim patches using *OPatch.* - Expertise in *PL/SQL*, *SQL* and *UNIX* Scripting. - Also involved in exporting and importing of data using utilities like * Export*, Import, *Data Pump* *Export* and *Data Pump Import*. - Writing backend * Procedures, Functions, Packages and Triggers *using PL/SQL - *Installation*, *Up gradation* and *Maintenance* of Oracle *RDBMS* on * Linux* & *Windows platforms*. - *Backup* of database Logical and Physical (hot and cold) using Backup script procedures and also using *RMAN*.** - Maintaining* Real Application Cluster Database* and configuring the raw disks for* Oracle RAC.* - Managing and monitoring production and development databases* using grid control.* - Expertise in *Tuning* Applications, *Memory*, Disk usage, *Space utilization*, *Oracle Security*. - Knowledge of tuning hardware as well as application using Oracle standard tools and utilities like *STATSPACK, TKPROF*, Session Tracing, Plan table, AWR and ADDM. - Expertise in concepts like Data mart, Data warehousing, Data mining. - Experience using *TOAD & SQL*Loader* skills. - 24*7 production database support. - A self-motivated, responsible and reliable team player with a set of strong technical skills. - Excellent analytical, interpersonal and communication skills. * * * * *Educational Qualification**:* Bachelor of Technology in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, India.** *Technical Skills* Languages : SQL, PL/SQL, C, C++, Core JAVA, Unix shell Programming, Bash & Korn Scripting, PERL Scripting. Operating Systems : Red Hat Linux, HP –UX 10.x., Ms-Dos, Windows 95/98/NT/2000/XP, UNIX, AIX (4.3,5L) , Sun Solaris. Databases : Oracle 8i, 9i, 10g RAC. Tools & Utilities : Data Pump Export/Import, SQL*Loader, OEM, RAC, Toad, Export/Import, SQL*PLUS, STATSPACK, RMAN, HTML, Java Script, MS ACCESS, MS EXCEL, Enterprise Manager, TKPROF, Enterprise Manager Database Control, Knowledge of Oracle Internet Application Server, DBCA, OUI, Procedure-Builder, Data Guard Working Analysis. * * * * *ORACLE DBA **Feb '07 – present* *The Northwestern Mutual, Milwaukee, WI** **Company Profile:* Northwestern Mutual is the largest direct provider of life insurance. It pays more in total individual life insurance dividends to policy owners than any other company in the industry. The company has positioned itself on the quality platform. It has developed a strong corporate governance model based on the core values of excellence, honesty, knowledge, caring, integrity and teamwork. * * *Responsibilities:*** - 24x7 *Production* Database *Administration* and support. - Assisted in configuring optimal *Oracle RAC architecture*.Performance tuning for Oracle *Application Clusters*. - The work involves overall maintenance of ORACLE database, *performance*, *tuning*, *backup*, *recoveries* and other database related activities. Also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc. Taking Backups on scheduled time and monitoring scheduled Backups. - Creating and dropping of users, granting and revoking rights as and when required. - Day to day *performance monitoring* and *tuning* of database. Monitoring of database objects like rollback segments, temp segments and tablespaces. Diagnose and troubleshoot Database problems and failures. - Creating, implementing and *Document Backup and Recovery* *strategies*and procedures after evaluating various options including *RMAN*. - Involved in the *Design (Logical & Physical)* of Databases. - Preparing *Backup* and *Recovery* plan. · Involved in administering Oracle database running on *UNIX* and * Windows* Machines to support Oracle database. Involved in the installation of Oracle 9i on *Windows NT* and *Linux*. ** · Handling day-to day activities in Creation and maintenance of database.** · Storage and *Space management* including table spaces and data files. Management of table space growth, monitoring data files additions, extent growth.** · Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing *Alert log files* & *Trace files* . - Defined backup procedures using daily hot backups and weekly cold backup. · Using *TKPROF*, *EXPLAIN PLAN* for the Better performance. · Setting up and maintaining user accounts and profiles. · Ensuring proper *online *and *offline* backup. Periodical reading and checking of backups taken. · Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments) * * *Environment: *Oracle /*10g*/9i/ *RAC*, Red Hat Linux AS4, Sun Solaris 9.** * * -- Alex Berg Regional Manager NexGen Solutions, Inc. 20853, Farmington Rd Suite 105, Farmington Hills MI. 48336| 248.888.9064(o) | 248.504.5466 (toll free) | 248.888.9066(f) | [EMAIL PROTECTED] | www.ngsiusa.net | Disclaimer: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, employee, or agent responsible to deliver it to the intended recipient, you are hereby notified that reading, disseminating, distributing or copying this communication is Strictly prohibited. If you have received this communication in error, Please notify us immediately by e-mail at [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/SAP-ABAP -~----------~----~----~----~------~----~------~--~---
