*Sr. Data Modeler* Location: Canonsburg, PA
Duration: 3+ months, extendable Job Summary: • Understand logical *data modeling and convert logical data model to physical data model.* • Understand the application and provide assistance to ETL designers to build an efficient process. • Build, maintain and enhance to all library packages/functions in PL/SQL to support application process. • Manage Security - User and role management. • Analyze existing process/application, indentify bottlenecks and suggest improvements / process tuning and SQL tuning to eliminate performance bottle necks. • Monitor performance, analyze AWR identify top SQLs and continuously improve the system. • Manage and maintain all schema objects and promote to various environments. • Maintain source code for all database objects using SVN. • Package database deployment scripts based on release document and handle deployment errors if any during release. • Support implemented *BI solutions (MicroStrategy reporting), Actimize Surveillance Models and ETL (Informatica) batch process.* Required Skills: • Must be proficient in *Oracle 11g Database and features*. Data Warehousing, Star schema data models, Data partitioning and pruning, Oracle Real Application Cluster, ASM, Resource manager, Oracle Enterprise Grid Control , DBFS, Import/Export, SQL Loader, Oracle supplied packages/API, Oracle Scheduler, SQL, PL/SQL, Oracle timed model statistic, AWR, Oracle MAA, UNIX/ Linux. -- * * *Thanks & Regards* Rathna Kumar | Senior-IT Recruiter | Email: rath...@usmsystems.com Phone: 703-349-2660 -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at http://groups.google.com/group/oradev. For more options, visit https://groups.google.com/groups/opt_out.
