*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 "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.
