Hi Friends, Please send me resumes to mah...@cigniti.com Here is the job description.
location: New York rate: 50$/hr face to face o Deep Oracle RAC (Real Application Clusters) know-how (trained) o Experience from large systems - Good working knowledge: o DB maintenance tasks (DB installation, upgrades, schema changes, backup) o DB optimization - Plus: o DB design o Oracle streams o Backup and archiving (with Veritas NetBackup agents) Detailed list of tasks: - Troubleshooting (any kind) – 7/24 - DB monitoring o Status of RAC nodes o Alert files and other log files o Recovery times / MTTR (after node crash) o Disk space o Status of batch/cron jobs o Streaming conflicts o Backup errors o Gathering/exporting statistics o Audit trail o Tools: SQL Plus, Enterprise Manager - Space management: o DB partitioning o Purging of old data (listener, alert log…) o Shrinking database objects (compact, release) o Estimations of data volumes / capacity planning - Backup and recovery o Backups o Disaster recovery (full, from data files, from table spaces, block recovery) o Tools: RMAN + Veritas NetBackup - Archive and restore (historical data) o Swap out to tapes o Restore from tapes o Tool: Veritas Netbackup - Performance tuning o SGA tuning o Database & application tuning o Main tool: Enterprise Manager o Other possible tools: SQL Trace, TKPROF, Analyze, AUTOTRACE, DBMS_Trace, SQL Tuning Advisor, SQL Access Advisor, Memory Advisor, Explain Plan, BSTAT/ESTAT, Statspack - DB protection / Data security o User/roles/permissions managements o Oracle Virtual Directory o Table encryption o Key management - Lifecycle management o Installation o Startup/shutdown o Upgrades (minor / major versions) o CPUs (security) o Patches / patchsets o Data migration (from one version to another) - Change management o Schema updates Approve production§ schema changes o Data reorganization o Refreshes o Imports/exports o Update of constrains, triggers o New materialized views o Manage networking aspects (tnsnames) o Tools: Toad, SQL Developer, SQL Plus, PACIS Configurator - Development o P/SQL scripts o Batch jobs o Implement stored procedures o DoDB.bat (installation scripts) - Documentation of all changes o ER diagrams o Config changes o Script changes o Tools: wiki, ClearCase, Word -? DBDD -- Thanks & Regards Mahesh Atreyapurapu Cigniti Inc ® ** ** *| *972-756-0622 Ext:207*| *mah...@cigniti.com Email *|* *|* www.cigniti.com Website* **|* mahesh21_cigniti Yahoo IM *|* -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To post to this group, send email to oracled2k@googlegroups.com. To unsubscribe from this group, send email to oracled2k+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracled2k?hl=en.
