Hi, ** **
Please send suitable profiles ASAP.**** * * *Sr. Data Architect/Database Developer with Fixed Income Experience.* *Location: Pasadena, CA* *Duration: 6-12 months* ** ** Phone interviews and possible SKYPE final interview.**** ** ** *Senior Data Architect/Database Developer* ** ** *JOB DESCRIPTION*: **** ** ** The Senior Data Architect/Database 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 within a dynamic asset management firm. 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 the risk management team. He/she will also work closely with the project lead, system architect, quant/SAS developers, QA engineer, and business analyst throughout the project lifecycle under minimum supervision of the project manager. **** * * *RESPONSIBILITIES/DUTIES*: **** - Work with quantitative/SAS developer, business analyst, DBA, system administrator, and QA engineer to architect data model, design and implement database as well as write ETL related programs.**** - Produce sound logical data model and build efficient physical database. **** - Propose proper database features for best design, customization, and user experience. Oracle 11g, MS SQL 2008 R2, and Sybase 15 experience preferred.**** - Design and develop efficient SQL queries, PL/SQL programs, Stored Procedures, and UNIX scripts to support various data operations.**** - Optimize performance by analyzing query patterns and building appropriate indexing and partition mechanisms.**** - Manage database artifacts in source code management system and deploy to DEV, QA, and Production environments.**** - Analyze issues & fix defects during SDLC, troubleshoot production issues, and respond to business users data inquiries.**** - Produce database design documents, test plans, and system requirements. **** - Understand complex data requirements such as Terms and Conditions, market, position and price data of vast fixed income and derivative securities. **** * * *COMPETENCIES*:* ***** *TECHNICAL*:**** - Minimum 8 years hands-on data modeling and database design experience for enterprise applications.**** - Minimum 7 years of intensive database programming experience such as SQL, PL/SQL, and stored procedures.**** - Minimum 4 years of experience with database performance optimization – query, indexing, partitioning etc.**** - Familiar with ETL development using various tools and Ab Initio is preferred.**** - Familiar with Oracle 11g and MS SQL 2008 new features. Sybase 15 is a plus. **** - Familiar with UNIX and Windows and various scripting languages such as UNIX Shell scripts, Perl, and Autosys.**** - Familiar with source code management and deployment tools such as SVN, CVS, Ant, and Ant Hill Pro.**** - Familiar with IT SDLC methodology and best practices.**** * * *BUSINESS KNOWLEDGE*:**** - Minimum 3 years data modeling experience in Fixed Income domain and understand data fields for various fixed income products including Structured Products, Options, Swaps and other derivatives.**** - Minimum 2 year hands on system experience with risk management domain and understand various risk terminologies and concepts. **** * * *GENERAL*:**** - Strong communication and documentation skills.**** - Highly self-motivated, results oriented, and capable of independent and critical thinking and problem solving.**** * * *ACADEMIC QUALIFICATIONS (MINIMUM REQUIREMENTS)**: * B.S. or equivalent education in computer science or engineering is required. Advanced degree is preferred.**** ** ** ** ** *Thanks & Regards,*** * * *Vardhan* *Globaltek Systems, LLC.*** *PH: 732-984-4091* *Email: [email protected]** * *www.globalteksystems.com** *** ** ** -- You received this message because you are subscribed to the Google Groups "SureIT" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sureITlife?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
