Job Title: IT Consultant - Engineering Database Design, Integration, and Implementation

Location: New York City Area

**Must be a U.S. Citizen
**

**Part-time as needed, on occasions may need to be in office on-site in Freeport, NY
**

Consultant tasks for Application Management/Maintenance may include, but are not limited to, the following:

Engineering Database Design, Integration, and Implementation
a. Architect and develop database solutions to organize, query, and report complex engineering information, including data/document repositories.
b. Provide full life-cycle design support services, including business analysis, conceptual database design, database prototype development, physical database design, implementation, network deployment, maintenance, and training. Preferred database development environment is Microsoft SQL 2014/2016/2019, Azure SQL services, Azure SQL Managed Instance.
c. Involvement in data modeling, data integration using ETL, preferred in Microsoft SQL Server Integration Services.
d. Maintain and enhance and customized data repository/data warehouse solution integrating all engineering capital project design and delivery databases.

II. HARDWARE AND SOFTWARE
Below is a sample list, but is not limited to, the Authority's Hardware and Software:
A. Desktop Software:
1. MS Windows 10/11
2. MS Office Professional Suite
3. MS Office 365
4. Edge, Chrome, Firefox
5. Adobe Acrobat Pro/Reader
6. Bluebeam Revu
7. Bentley multi discipline applications
8. Lecia Cyclone Enterprise
B. Technical Software:
1. Microsoft Project/Visio/Access
2. Autodesk AEC suite
3. Autodesk API
4. Autodesk Construction Cloud (ACC)
5. EQuiS Professional
6. EQuiS Chemistry
7. EQuiS Geology
8. EQuiS Discharge Monitoring
9. EQuiS Arcview Interface
10. Esri ArcGIS Pro and Extensions
11. Esri Apps
12. Maximo 7.5 and above
13. Canon DirectPrint

C. Networking Operating Systems:
1. MS Windows Server 2012 and above

D. Relational Database Management Software:
1. MS SQL Server 2014 and above
2. Oracle RDBMS
3. MS Access 2007 and above

E. Azure Cloud Environment
1. Azure Virtual Machines
2. Azure App Services
3. Azure SQL Services, SQL Managed Instance
4. Azure Storage solutions
5. Azure Data Lake and Synapse
6. Azure Network, Firewall and Security

F. Electronic Document Management Environment:
1. Open Text Content Server, version 16 and above
2. Cardiff eForms Management
3. MS SharePoint Online

G. Software Development Environment and Tools:
1. Visual Studio Pro
2. Visual Studio Test Pro
3. MS .NET Framework 4.x and above
4. MS .NET Core 3.0 and above
5. React and Redux
6. Node.js
7. Bootstrap
8. Azure DevOps with Git
9. MS SQL Management Studio (SSMS)
10. MS SQL Server Integration Services (SSIS)
11. MS SQL Server Reporting Services (SSRS)
12. MS Power Platforms (Power BI/Power App/Power Automate/Power Page)
13. MS Office suite
14. MS SharePoint Framework
15. Infowise Solutions for SharePoint
16. Plamsail Microsoft365 and SharePoint Tools
17. Esri ArcGIS Enterprise and Online
18. NearMap
19. VertiGIS
20. OpenText Global Cents Power Tools
21. eBuilder
22. Aspose Suite
23. Autodesk Revit API
24. Bluebeam Studio Prime

H. Software Development Language:
1. C#
2. SQL Script
3. JavaScript
4. jQuery
5. AJAX
6. HTML, XHTML
7. XML
8. Extensible Stylesheet Language (XSL)
9. Cascading Style Sheets (CSS)
10. PowerShell Script
11. MS Command Script
12. Python
13. Visual Basic
14. TypeScript
15. Java

I. Web Server Environment:
1. Microsoft IIS, version 7.x and above

J. Graphics:
1. Visio
2. Miro
3. Adobe Photoshop
4. Adobe Illustrator