*Hello Folks,* *Kindly find the job description and confirm me with your available candidates on my email id*
[email protected] *Title :Oracle DBA* *Location: Cumberland ,RI* *Duration:6+Months* Skill1 - Database Admin (L1) Entry level position. Works under close supervision to perform low-leveldatabase management tasks such as adding users, managing space etc.Participates in testing back-ups, ensuring maximum up-time and maximumperformance of database. Familiarity with basic administrative commands isexpected at this level. Front-line interaction with users to assist with lowlevel trouble-shooting requirements. Skill2 - Database Admin (L2) A fully contributing team member who performs database management tasks suchas meeting user access requirements and resolving their problems. Responsiblefor ensuring that storage, archiving, backup and recovery procedures arefunctioning correctly. Writes database documentation, including data standards,procedures and definitions for the data dictionary with some generalsupervision. Front-line interaction with users to assist with escalatedtrouble-shooting requirements. Skill3 - Database High Availability (L3) Knowledge of HA (High Availability - RAC / Cluster / Replication / DataGaurd/ Standby / Database Failover strategy ?Database DR strategy / Flashback)How is it setup and configured What happens during a fail-overWhat happens during fail-back? When is it typically done?What are the steps a DBA should perform in the event of a fail-over and fail-ba Skill4 - Database Performance Tuning (L3) Good Knowledge in Performance Tuning (Understanding SQL Server profilerand performance monitor. Understand Performance counters.Understanding Query execution plans.Handling fragmentation, statistics and index related issues.Logical and Physical DB Design) -Planning for Performance in Database Design.Configurations parameter tuning. Skill5 - Database Backup and Recovery (L3) Design, Plan and Implement Backup and Recovery Methods? Developing a backup and recovery strategy? DB2 UDB Advanced Recovery for Multiple Partition Databases Identify type of dFrequency of Data changes,how quickly the recovery needs to be done,identify which backup solution to use,storage needs.(RMAN / Native Tools) Skill6 - Infra Storage Administration (L1) Basic knowledge of Storage devices,RAID, Storage device connectivity,Networked Storage topologies,Storage protocols, Storage management,File Systems, Data Management, Data backup and Data protection Essential Skill(s) Skill1 - Oracle Admin (L2) Understand New Features in 10G. Generate Explain Plan, Interpreting TKPROFOutput. Interpret Statspack report. Familiar with init.ora parameters Create,Rename a database Partition Tables and Indexes Move databases between servers,plan and size databases. Re-org of Database. Refresh Database using coldbackup, Hot Backup & Export/import. Maintain Standby database. Manage OracleStreams. Troubleshoot CPU Load and resolve it. Generate Statistics for thetables, Partitioned tables, Subpartitioned Tables & troubleshoot issues relatedto Statistics. Troubleshoot issues like Database hanging, issues with undotablespaces, segments. Be able to Tune SQL, SGA. Perform Hot backup, ColdBackup. Export, Import Recover under Various Scenarious (like recovery acorrupted database when the db runs in archive log mode, Recovery a tables datawhen a user accidently drops it, etc). Additional Skill(s) Skill1 - NA NA Skill2 - English Language (L1) NONE Skill3 - Unix Shell Scripting (L3) [Maintenance of Shell scripts] - Maintenance and enhancements of shell scripts- Debugging and trouble shooting the shell scripts - Ability to develop scriptsinterfacing with databases - Ability to handle large scripts that in-turn usemultiple executables and external scripts - Error logging [Debugging] -Enablingdebugging - Syntax Checking Shell Tracing - Using echo -Using Standard Error -Options for Debugging - Script Tracing - Conditional Debugging Thanks & Regards Andy Druse Sr. Manager *Gain America * | www.gainam.com <http://gainam.com/> Ph. 917-338-6314| Fax: 917.475.8362 183 Broadway, Suite 202, Hicksville, New York - 11801 -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/groups/opt_out.
