Hi,


Hope you are doing great! I have an urgent position , Please find below the
job description , I would really appreciate if you kindly send me updated
resume with the rate expectation and the following details



Please reply to [email protected]



Full Name                            :

Visa Status                          :

Current Location              :

Availability                          :

Rate/hr                                :

Contact details                  :

Relevant Experience      :

Total Experience              :

Skill Set                                 :





*Job Detail:*

Position Title: Sr. Oracle Database Admin

Location: New York, NY

Duration: 8 months contract (on W2 all inclusive)



*Requirements: *

*Must: *

   - Deep Oracle RAC (Real Application Clusters) know-how (trained)
   - Experience from large systems

*Good working knowledge: *

   - DB maintenance tasks (DB installation, upgrades, schema changes,
   backup)
   - DB optimization

*Plus: *

   - DB design
   - Oracle streams
   - Backup and archiving (with Veritas NetBackup agents)

*Detailed list of tasks: *

- Troubleshooting (any kind) – 7/24

- DB monitoring

   - Status of RAC nodes
   - Alert files and other log files
   - Recovery times / MTTR (after node crash)
   - Disk space
   - Status of batch/cron jobs
   - Streaming conflicts
   - Backup errors
   - Gathering/exporting statistics
   - Audit trail
   - Tools: SQL Plus, Enterprise

- Space management:

   - DB partitioning
   - Purging of old data (listener, alert log…)
   - Shrinking database objects (compact, release)
   - Estimations of data volumes / capacity planning

- Backup and recovery

   - Backups
   - Disaster recovery (full, from data files, from table spaces, block
   recovery)
   - Tools: RMAN + Veritas NetBackup

- Archive and restore (historical data)

   - Swap out to tapes
   - Restore from tapes
   - Tool: Veritas Netbackup

- Performance tuning

   - SGA tuning
   - Database & application tuning
   - Main tool: Enterprise
   - 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

   - /roles/permissions managements
   - Oracle Virtual Directory
   - Table encryption
   - Key management

- Lifecycle management

   - Installation
   - Startup/shutdown
   - Upgrades (minor / major versions)
   - CPUs (security)
   - Patches / patchsets
   - Data migration (from one version to another)

- Change management

   - Schema updates
   - Approve production schema changes
   - Data reorganization
   - Refreshes
   - Imports/exports
   - Update of constrains, triggers
   - New materialized views
   - Manage networking aspects (tnsnames)
   - Tools: Toad, SQL Developer, SQL Plus, PACIS Configurator

- Development

   - /SQL scripts
   - Batch jobs
   - Implement stored procedures
   - DoDB.bat (installation scripts)

- Documentation of all changes

   - ER diagrams
   - Config changes
   - Script changes
   - Tools: wiki, ClearCase, Word -DBDD









--

Thanks & Regards



Vishnu, Centrifuge LLC
(T)443 320 2000,(F)(866) 825-9220

[email protected]
www.centrifugecorp.com

-- 
You received this message because you are subscribed to the Google Groups 
"KNOW.IT" 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/know_it_az?hl=en.

Reply via email to