Company Description
Vichara is a Financial Services focused products and services firm headquartered in NY and building systems for some of the largest i-banks and hedge funds in the world.
Job Description
Short description of the position:
Complex multi-tenancy capable and web-based (thin client) Real Property Tax System (RPSv5) as well as
legislatively mandated STAR relief.
Daily Tasks:
This individual will participate and guide development efforts in the following activities:
The selected candidate will be responsible for supporting the Office of Real Property Tax Services (ORPTS) existing
applications which utilize Sybase as they are modernized to a multi-tiered system. Specific tasks include:
• Maintaining existing Sybase tables;
• Writing and tuning SQL statements;
• Participating in the design of new DB2 and Oracle tables;
• Data mapping;
• Data conversion scripting;
• Production support tasks including analysis or issue, propose and implement solutions;
• Mentoring less experienced staff; and developing technical documentation
Qualifications
84 months experience working for a government organization.
84 months experience in UNIX script writing.
84 months experience in writing queries (SQL statements) involving
joins and sub-queries of tables.
84 months of experience in Oracle and DB2 Data Modeling, creating
logical data models, working with databases and experience with
XML schemas (definition and automated generation)
84 months experience with Sybase working with relational database
containing 1000 + tables.
84 months of experience in performance tuning applications
interacting with databases such as DB2, Oracle and Sybase.
Additional Information
Compensation - $65-$75/h
Top Skills
What We Do
Vichara Technologies is a niche technology services and solutions firm focused on solving complex Capital Markets challenges.
Vichara’s solutions include valuation, analytics and risk management for fixed income asset classes with special focus on structured products (RMBS, CLO, CDO, CMBS/CRE, Whole Loans). vLens, our mortgage data platform allows for analysis of large mortgage data sets. Our philosophy is to provide most granular, accurate and timely analysis. Our clients take advantage of having insights before their competitors. We aim to provide exactly what you want and increase your productivity many folds by streamlining your investment process.
Vichara also provides technology consulting, custom software development, system integration and infrastructure management services. Over the last decade, Vichara has built mission critical enterprise systems for securities trading, portfolio management, asset securitization, trading analytics, modeling, risk management, accounting and financial operations for many of the world’s leading financial institutions across the globe