Database Architect

---

Job description

Job Title: Database Architect - Expert

Task ID: HBITS-(phone number removed)

Position Duration: 30 Months

Client: State of NY

Agency: Department of Taxation and Finance

Interview Mode: In-Person

Please call (phone number removed) (phone number removed) (phone number removed) or email at

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;

Mentoring less experienced staff; and developing technical documentation.

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

<!– job description page –>