Database Architect Expert

HBITS-(phone number removed) - Database Architect Expert 40% REMOTE Albany, NY

Agency Name : Department of Taxation and Finance

Project / Program Name : STAR / Real Property Tax Systems

Provide a 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.

Provide a complete list of the 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.

Job Title : Database Architect

Skill Level : Expert

Target Start Date : 11 / 8 / 2024

Engagement Length in Months : 30

Is this a Full or Part-Time Position : Full-Time

What are the daily work hours : M-F 8 : 30-5 : 00

Where is the Home Base Region? 1

Where is the physical work office located : Harriman Campus, Bldg 2, Albany, NY

Is telecommuting allowed for this position : Yes

If YES, note if negotiable or list the percentage allowed / number of days allowed per week : 40% each 2-week period

What is the format of the Candidate interview : In-person

What type of software is typically used by the Agency : Agency is an IBM shop

What type of hardware is typically used by the Agency : Agency is an IBM shop

Position MANDATORY Qualification :

Position Job Title : Database Architect

Position Job Title Description : 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.

Position Skill Level : Expert

Position Skill Level Description : 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.

List all the Position REQUESTED 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 database containing 1000 + tables.

84 months of experience in performance tuning applications interacting with databases such as DB2, Oracle and Sybase.

Are there additional security requirements for the Authorized User : Yes

If YES, include the additional security requirements : Security Provisions Form-DTF-202

Will additional training potentially be required during the Engagement : No

What type and / or manner, of knowledge transfer is requested during the Engagement : Documentation required throughout the engagement

Is travel anticipated during the Engagement : No