Title: Oracle Database Engineer/Senior Developer Location: New York City, NY
Duration: 6+months Rate: Open Responsibilities: - Physical architecture of database tables, partitions, load balancing, parallel queries, etc. - Work with our Technical Architecture, Database Engineering and DBA Teams to architect a highly scalable and robust global solution (multi-regional access) - Code packages, functions, stored procedures, views in Oracle PL/SQL - Create Physical Data Models using Enterprise Architecture and ER Studio - Ability to create functional and technical design documents - Liaise with offshore build team and provide specs/directions - Code Review stored procedures and scripts written by other team members - Performance/Tuning of Oracle SQL Technical skills: - Solid understanding of Oracle 10g RAC / 11i from both a DBA and Development perspective - Solid understanding of Data Warehouse and Data Mart concepts with proven experience in both. - PL SQL, data modeling, star schema - physical architecture (partitioning, cluster) - working with large databases multi terabytes (3+ Terabytes) - Knowledge of financial products - Unix skills - Data Modeling tools: ER/Studio, ERWin, Enterprise Architect - Any Netezza or other database appliance experience is a plus - Any BI (Business Intelligence) / OLAP exp is a plus - MQ / Tibco EMS messaging experience is a plus - Java / .Net/C# is a plus - Market Risk, Credit Risk, or Finance domain knowledge is a huge plus Warm Regards, Priya Altech Star, Inc Princeton, NJ 08540 609-520-9000 X 18 Fax: 609-520-9005 <mailto:pr...@altechstar.com> pr...@altechstar.com