HBITS-06-13590 - Database Architect Expert - 40% REMOTE - Albany, NYAgency Name: Department of Taxation and FinanceProject/Program Name: STAR/Real Property Tax SystemsProvide 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 ArchitectSkill Level: ExpertTarget Start Date: 11/8/2024Engagement Length in Months: 30Is this a Full or Part-Time Position: Full-TimeWhat are the daily work hours: M-F 8:30-5:00Where is the Home Base Region? 1Where is the physical work office located: Harriman Campus, Bldg 2, Albany, NYIs telecommuting allowed for this position: YesIf YES, note if negotiable or list the percentage allowed/number of days allowed per week: 40% each 2-week periodWhat is the format of the Candidate interview: In-personWhat type of software is typically used by the Agency: Agency is an IBM shopWhat type of hardware is typically used by the Agency: Agency is an IBM shopPosition MANDATORY Qualification:Position Job Title: Database ArchitectPosition 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: ExpertPosition 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: YesIf YES, include the additional security requirements: Security Provisions Form-DTF-202Will additional training potentially be required during the Engagement: NoWhat type and/or manner, of knowledge transfer is requested during the Engagement: Documentation required throughout the engagementIs travel anticipated during the Engagement: No