*Subject : Oracle / UNIX Engineer Location : NYC, NY Duration : 18 Months JOB Description: * This is a Oracle database and UNIX infrastructure and performance engineering technical lead role in the application architecture and development job family. Main responsibilities include hands-on design, development and performance tuning for the PCDW, a large scale, global data warehouse that consists of an Oracle 11g RAC implementation, Unix-based batch and intraday job streams that source data from various systems, a custom .NET C# & C++ middleware that enables ad hoc user queries, and several Excel-based and web-based front-end applications including Oracle Business Intelligence. Oracle database performance Unix/Linux performance Infrastructure/Architecture mapping/powerpoints Liaison with System Admins, Oracle DBAs Performance Engg - End and End review of Application stack for performance and scalability issues and recommend areas of improvement
Database design – Interact with data modelers and middleware team to review design of physical facts and dimensions of the star-schema data model for high performance. Conduct peer design reviews. ETL design – Participate in Design processes that transform and load data sources into fact and dimension tables according to best practices. Conduct peer design reviews. Development – Implement database objects and ETL programs according to design and coding standards. Conduct peer code reviews. Testing – Plan, execute, and document testing of database objects and ETL programs. *Required* •Oracle 11g PL/SQL programming •Unix shell programming •Informatica development •Database indexing and partitioning best practices •Multi-terabyte data warehousing •Visio, Excel an Powerpoint presentation skills •Desired •TKPROF analysis •Near Real Time ETL •Active / Volatile Data Warehousing *Thanks & Regards, -- Ranadheer Technical recruiter Sriven Technologies LLC .., E-Mail: ranadh...@sriventech.com Web: www.sriventech.com Ph: 703-842-4812 ext 303 Fax: 1866 725-2860 * -- You received this message because you are subscribed to the Google Groups "REQSRESUMES" group. To post to this group, send email to reqsresumes@googlegroups.com. To unsubscribe from this group, send email to reqsresumes+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reqsresumes?hl=en.
