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 of issues, proposing and implementing solutions;
- Mentoring less experienced staff;
- 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 databases 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