Database Architect (UNIX script writing; Writing queries; Oracle/DB2 Data Modeling; Sybase)

HBITS-(phone number removed)

Day-to-day tasks to be performed by the Selected Candidate:

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.

Database Architect: STAR/Real Property Tax Systems project

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

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.

Re sume

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.)