Database Architect - SQL Sybase Oracle - Vichara
Albany, NY 12203
About the Job
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 DescriptionShort 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
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