Dear Folk,
Please share good resource for below mention position; *Please share resume at **nitin.kash...@techwiresol.com*<nitin.kash...@techwiresol.com> * * * * *Job Title*: *Oracle Data Architect* *Relevant Experience (Yrs)*: 6+ Yrs *Location:* Oaks, PA * * *Primary Role:* - Interact with business for gathering specifications and requirements. - Creating logical data model using ER Studio - Database design and implementation of Database objects. - Creating technical specification documents for the requests. - Preparing the Impact Analysis document and High-level design for the requirements - Performance tuning using AWR ,Explain Plan, SQL*Trace, TKPROF - PL/SQL code reviews, Data load automations and job scheduling - Support migration activities, Export/import of data. - Resolving deadlocks & contention issues. - Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes - Handle the Onsite coordination of enhancements to applications *Required Skills:* - Experience in *Oracle* Database *Designing*. - Experience in RDBMS concepts and *Database Modeling* using ER-Studio , TOAD, ERWIN - Experience in Performance Tuning using *TKPROF, AWR, SQL Profiler, *Explain plan, SQL Trace. - Experience in Oracle *AWR report* generation. - Experience in Oracle *PLSQL programming *language. - Experience in creating packages/Procedures/Views/Functions/Triggers - Experience in installing, maintaining ,upgrading and patching Oracle versions 11g/10g/9i/8i - A minimum of 2 years experience in the investment management &/or transaction processing domain. - Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment. *Regards* Nitin Kashyap Techwire Solutions, Inc 101 Hudson St, Suite # 2100, Jersey City, NJ 07302 USA Phone: 201-884-6603 Email: nitin.kash...@techwiresol.com <a...@techwiresol.com> || Web: www.techwiresol.com * * -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
