Database Architect

T and T Consulting Services Inc•Falmouth, MA

10h•$120,000 - $160,000

About The Position

T&T is seeking a senior Data Architect and Data Modeler to develop scalable data models for NOAA Fisheries. The role spans projects across multiple Regional Offices and Fisheries Science Centers, creating unified data and validation models to support regional and science missions across fishery applications and data initiatives. The position works closely with Regional Offices to design and implement a centralized data store, develop scalable APIs that integrate with React applications and PWAs, support application modernization by consolidating data into databases, and enhance reporting across applications and databases. The architect will contribute to database modernization, target-state architecture, cloud and database technology prototyping, and collaboration across application, infrastructure, leadership, and contractor teams.

Requirements

Bachelor of Arts or Bachelor of Science degree.
At least 6 years of experience building, architecting, designing, and modernizing legacy database systems and building target-state architecture.
Organizational experience in an agile operating model.
Established experience with proof-of-concept work and technology.
Ability to architect and model mission-critical RDBMS, BI, OLTP, and OLAP solutions using multiple DBMS technologies.
Ability to create schemas and operate, tune, and maintain production databases.
Ability to program systems, scripts, and queries with SQL Server, Oracle, NoSQL databases such as MongoDB, Snowflake, and databases including Amazon RDS, AWS Glue, PostgreSQL, MySQL, DynamoDB, and Elasticsearch, across on-premises and cloud environments.
Experience with Microsoft Azure cloud data services or equivalent, including Functions, Data Factory, and Managed Instances.
Extensive experience in data analysis, data profiling, data flows, and data modeling.
Experience with service-oriented architecture.

Nice To Haves

Knowledge of government operations and NOAA missions.
Experience programming and retrieving information from RESTful endpoints.
Experience architecting big data solutions using data lakes, data modeling, and data products.
Experience with MongoDB, Tableau, Apache Cassandra, or Snowflake.
Experience with cloud-native database design.
Expertise in architecting and developing database solutions.
Experience with NoSQL and GraphQL technologies.
Experience programming in an object-oriented language.
Ability to design ERDs and produce high-quality engineering design documents.
Willingness and ability to apply complex business logic to programs, scripts, and queries interfacing with large databases.
Ability to provide rational analysis of data and identify ways to improve its structure and integrity.

Responsibilities

Provide leadership in modern database design, architectural principles, and technology modernization.
Help scale a common validation model for applications.
Improve existing database and storage designs for efficiency.
Reengineer database architecture and system design, introducing new technologies.
Implement API architecture for seamless data communication within applications.
Create detailed documentation and diagrams.
Collaborate with application teams, infrastructure teams, leadership, and other contractors.
Develop holistic database solutions rather than temporary fixes.
Prototype technology solutions in cloud environments and modern databases, tools, and designs.
Participate in defining target-state application and data technology architecture roadmaps.
Contribute to T&T proposal activities and perform other duties assigned by T&T managers or supervisors.
Design and implement a centralized data store and scalable APIs supporting React applications and PWAs.
Support application modernization by consolidating data into databases and improving reporting capabilities.