[xrecnet] Sr. Data Modeler in Canonsburg, PA

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: rathnav@usmsystems.com 

Phone: 703-349-2660 

--
To post a job send email to: xrecnet@googlegroups.com.
To unsubscribe send email to: xrecnet+unsubscribe@googlegroups.com
___________________________________________________________________
Visit http://xrecnet.blogspot.com for IT Recruitment News, Articles, Recruiting Tools & Resources
---
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.