* Please send resumes to [email protected] <[email protected]> Yahoo! IM: premreddyg DB2 DBA Consultant Location: Addison, TX Duration: Long Term Job Description: · Works under close supervision to perform low-level database management tasks such as adding users, managing space etc. · Participates in testing back-ups, ensuring maximum up-time and maximum performance of database. · Familiarity with basic administrative commands is expected at this level. Front-line interaction with users to assist with low-level trouble-shooting requirements. · A fully contributing team member who performs database management tasks such as meeting user access requirements and resolving their problems. · Responsible for ensuring that storage, archiving, backup and recovery procedures are functioning correctly. · Writes database documentation, including data standards, procedures and definitions for the data dictionary with some general supervision. · Front-line interaction with users to assist with escalated trouble-shooting requirements. Skill and Experience Details: · Knowledge of HA (High Availability - RAC / Cluster / Replication / Data Gaurd/ Standby / Database Failover strategy · Database DR Strategy / Flashback) How is it setup and configured What happens during a fail-over What 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 · Good Knowledge in Performance Tuning (Understanding SQL Server profiler and 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. -->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 Frequency of Data changes, how quickly the recovery needs to be done, identify which backup solution to use, storage needs.(RMAN / Native Tools) -->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 -->Oracle Admin(L2)-Understand New Features in 10G. Generate Explain Plan, Interpreting TKPROF Output. Interpret Stats pack 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 cold backup, Hot Backup & Export/import. Maintain Standby database. · Manage Oracle Streams. Troubleshoot CPU Load and resolve it. Generate Statistics for the tables, Partitioned tables, Sub partitioned Tables & troubleshoot issues related to Statistics. Troubleshoot issues like Database hanging, issues with undo table spaces, segments. Be able to Tune SQL, SGA. Perform hot backup, Cold Backup. Export, Import Recover under Various Scenarios (like recovery a corrupted database when the db runs in archive log mode, Recovery a tables data when a user accidently drops it, etc). -->Database Admin(L1)-Entry level position. · Works under close supervision to perform low-level database 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. -->English Language (L1)- 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 - 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. Skill3 - English Language (L1) NONE Skill4 - Golden Gate (L3) · Should be proficient with ETL concepts and have the ability to convert requirements into design. · Should have proficiency in at least one database tool. · Should understand the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization. · Should have working experience on an ETL tool. · Should have knowledge in designing the mapping and end-to-end data flow in a mapping. · Should be up-to-date on the upgrade options, enhancements, add-ons and features in the ETL tool with a view to improving the productivity. Ability to lead a team of developers. Best Regards, G Prem Cloudeeva, Inc. Direct: 732-226-3459 104 Windsor Center Drive, Suite 300, East Windsor, NJ 08520. Email: [email protected] <[email protected]> Web: http://www.cloudeeva.com <https://mail.bgsl.co/owa/redir.aspx?C=7d63065af218416a87bfb76b95304e5b&URL=http%3a%2f%2fwww.cloudeeva.com%2f> [image: cid:[email protected]] <https://twitter.com/cloudeeva>[image: cid:[email protected]] <https://www.facebook.com/pages/Cloudeeva-Inc/121003204638957?ref=tn_tnmn>[image: cid:[email protected]] <http://www.linkedin.com/company/36717?trk=tyah>[image: cid:[email protected]] <https://plus.google.com/b/104975130351914332553/104975130351914332553/about/p/pub> [image: cid:[email protected]] *
-- You received this message because you are subscribed to the Google Groups "Exact Match" 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/exact-match. For more options, visit https://groups.google.com/groups/opt_out.
