*Mail me plz: [EMAIL PROTECTED] *SR. Oracle DBA*
*Location:* Rhode Island *Duration:* 1 year *Description:* Bachelors Degree in Computer Science Masters Degree in Computer Science (preferred) Oracle Certified Professional 10g (preferred) Minimum of 7 years of Oracle database experience with at least 2 years of the 5 years on Oracle 10g *Database installation:* Install, patch and upgrade existing and new database servers with Oracle 10g on Windows and Linux. *Database configuration:* Create database, listener, tnsnames, init.ora parameters, formatting datafiles and creating tablespaces. Optimize init.ora parameters for OLTP and DSS environments. Fix database error encountered on database creation. *Database maintenance:* Understand and query V$ tables for performance and system tables for database objects. *Replication:* Design, implement, maintain and reconcile master to master replication for real time data distribution across production database servers. Identify and resolve replication issues encountered in specific applications. Gracefully bring down replication nodes, add new replication objects and start replication. *Back up (RMAN):* Plan, conduct and test hot and cold Oracle back ups. Support application team with rollback of OLTP tables. Back up of database objects ranging from kilobytes to terabytes. *Database performance and monitoring:* Understand performance bottlenecks at CPU, memory and I/O level and how it pertains to Oracle. Resolving locked sessions and hung session. Use OEM to monitor database objects and over health of database. Practical experience with Oracle specific 1) joins including hash, nested loop and merge; 2) indexes including b-tree and bit map; 3) partitioning including list, range, hash and sub-partitioning; 4) optimize performance of BLOB, CLOB, LOB for data storage; 5) storage of XML in database. *SQL and PL/SQL writing and tuning:* Ability to write advanced SQL and PL/SQL to support web based applications, data mining and data loading. Skills to include practical knowledge of triggers, analytical functions, stored procedures, SQL*Plus, sequences, parallel processing, partitioning, indexing, hints, indexes, views, dblinks and synonyms. *Database architecture:* Design and implement database environment used by 12,000 intranet users and 40 analysts. Constantly review and forecast growth in storage, CPU, memory and scale out. *Data modeling:* Document entity relationship diagram of database tables for applications and data warehouse. Use strict data normalization forms to create star schemas. *Metadata creation and maintenance:* Create and maintain database objects and documentation of their use. *Data loading and unloading:* Experience with SQL Loader, external tables, data pump and spooling files to transfer terabytes of data in and out of database. *Data transformation:* Work with content experts to develop business rule for data transformation. Combine disparate data sources into common data structure by understanding data content and format. *OLTP database design, implementation and testing:* Work with web developers to design, implement, test and move in to production web based applications. Optimize OLTP table to meet SLA requirements for application performance. *DSS database design, implementation and testing: *Maintain multi-terabyte data warehouse environment and support 40 plus analyst with the development of analytic cubes and data summaries. *Operating systems:* Working knowledge of Windows 2003 Server Enterprise and Datacenter Editions. Understand how Windows interacts with Oracle processes and services. Protect database during Windows patching. *Database shutdown and restart: *Ability to bring down database in abort, immediate and transaction modes and restart database from Oracle Enterprise Manager and command line. *Andy* Resource Manager *West Coast Consulting* <http://www.westcoastllc.com/> 9233 Research Drive, Irvine, CA 92618, USA *Work:* 949-743-0065 Ext. 208 *Fax:* 714 844 9091 *Email:* [EMAIL PROTECTED] *IM:* andy_westcoastll (Yahoo) *Professional Profile <http://www.linkedin.com/pub/4/2bb/917>* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP-User" 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-User?hl=en http://idsale.blogspot.com -~----------~----~----~----~------~----~------~--~---
