Database Architect - i-Link Solutions Inc
Albany, NY
About the Job
Job Title: Database Architect – Expert
Task ID: HBITS-06-13590
Position Duration: 30 Months
Client: State of NY
Agency: Department of Taxation and Finance
Interview Mode: In-Person
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at nysreqs@ilinksolutions.com
Description
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:
Mandatory Qualifications
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Task ID: HBITS-06-13590
Position Duration: 30 Months
Client: State of NY
Agency: Department of Taxation and Finance
Interview Mode: In-Person
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at nysreqs@ilinksolutions.com
Description
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;
Mandatory Qualifications
1 | 84 months experience working for a government organization. |
2 | 84 months experience in UNIX script writing. |
3 | 84 months experience in writing queries (SQL statements) involving joins and sub-queries of tables. |
4 | 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) |
5 | 84 months experience with Sybase working with relational database containing 1000 + tables. |
6 | 84 months of experience in performance tuning applications interacting with databases such as DB2, Oracle and Sybase. |
Required Documentation | • Résumé • Copy of Candidate Identification (i.e., driver's license and/or passport and Visa if applicable) • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) |
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Source : i-Link Solutions Inc