Sr. Data Architect - Database Developer
Gorilla Logic, Inc. - Pasadena, CA

This job posting is no longer available on Dice. Find similar jobs:Senior Data Architect jobs - Gorilla Logic jobs

Gorilla Logic is a rapidly growing software consulting company located in the heart of downtown Boulder with additional offices in New York and Bangalore and with large amount of customers across the nation With established expertise in building enterprise apps for web and mobile Gorilla Logic has a hefty portfolio of Fortune 500 and Fortune 100 clients Our 85 person team works with technologies such as Java Flex HTML5 JQuery Android iOS PHP and many more Because of our talented engineers and extreme success across multiple industries we are the industrys GORILLAS We continuously strive to seperate ourselves from our competitors by hiring toptier talent and thats why we are interested in YOU JOB DESCRIPTION The Senior Data ArchitectDatabase Developer will be responsible for database design data modeling configuration and development as well as ETL related work to build a mission critical enterprise risk platform which supports various portfolio and security risk management needs The person will implement tasks required for database design development optimization ETL related implementation and continuing operation of the enterprise risk management system as well as support other databases in risk management team Heshe will also work closely with project lead system architect quantSAS developers QA engineer and business analyst throughout project lifecycle under minimum supervision of project manager RESPONSIBILITIESDUTIES bull Work with quantitativeSAS developer business analyst DBA system administrator and QA engineer to architect data model design and implement database as well as write ETL related programs bull Produce sound logical data model and build efficient physical database bull Propose proper database features for best design customization and user experience Oracle 11g MS SQL 2008 R2 and Sybase 15 experience preferred bull Design and develop efficient SQL queries PLSQL programs Store Procedures and UNIX scripts to support various data operations bull Optimize performance by analyzing query patterns and building appropriate indexing and partition mechanisms bull Manage database artifacts in source code management system and deploy to DEV QA and Production environments bull Analyze issues fix defects during SDLC troubleshoot production issues and respond to business users data inquiries bull Produce database design documents test plans and system requirements bull Understand complex data requirements such as Terms and Conditions market position and price data of vast fixed income and derivative securities COMPETENCIES TECHNICAL bull Minimum 8 years handson data modeling and database design experience for enterprise applications bull Minimum 7 years of intensive database programming experience such as SQL PLSQL and store procedures bull Minimum 4 years experience with database performance optimization – query indexing partitioning etc bull Familiar with ETL development using various tools and Ab Initio is preferred bull Familiar with Oracle 11g and MS SQL 2008 new features Sybase 15 is plus bull Familiar with UNIX and Windows and various scripting languages such as UNIX Shell scripts Perl and Autosys bull Familiar with source code management and deployment tools such as SVN CVS Ant and Ant Hill Pro bull Familiar with IT SDLC methodology and best practices BUSINESS bull Minimum 3 years data modeling experience in Fixed Income domain and understand data fields for various fixed income products including Structured Product Options and Swaps and other derivatives bull Minimum 2 year hands on system experience with risk management domain and understand various risk terminologies and concepts GENERAL bull Strong communication and documentation skills bull Highly selfmotivated results oriented and capable of independent and critical thinking and problem solving ACADEMIC QUALIFICATIONS (MINIMUM REQUIREMENTS) bull BS or equivalent education in computer science or engineering is required Advanced degree is preferred Job is onsite in Pasadena CA No third party recruiters We are unable to host H1b Visas at this time No phone calls about this position Fixed Income SQL ETL Oracle 11g MS SQL 2008 UNIX Windows Perl Autosys