Database Architect

T and T Consulting Services•Falmouth, MA

About The Position

T&T is seeking a senior Data Architect and Data Modeler to develop scalable data models for NOAA Fisheries. The role supports projects across Regional Offices and Fisheries Science Centers, creating unified data and validation models for regional and scientific missions involving fisheries applications and data initiatives. The position works with Regional Offices to design and implement a centralized data store, develop APIs that integrate with React applications and progressive web applications (PWAs), support application modernization by consolidating data, and improve reporting across applications and databases. The architect will contribute to modern database design, technology modernization, architecture roadmaps, and holistic database solutions, while collaborating with application and infrastructure teams, leadership, and contractors.

Requirements

Bachelor of Arts or Bachelor of Science degree.
At least 6 years of experience building, architecting, designing, and modernizing legacy database systems and developing target-state architectures.
Organizational experience working in an agile operating model.
Demonstrated experience with proof of concepts 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 using SQL Server, Oracle, NoSQL databases such as MongoDB, Snowflake, and databases including Amazon RDS, AWS Glue, PostgreSQL, MySQL, DynamoDB, and Elasticsearch in on-premises and cloud environments.
Experience with Microsoft Azure cloud data services or equivalent, including Functions, Data Factory, and Managed Instances.
Extensive experience with data analysis, data profiling, data flows, and data modeling.
Experience in a service-oriented architecture.

Nice To Haves

Knowledge of government operations and NOAA missions.
Experience programming and requesting information from RESTful endpoints.
Experience architecting big-data solutions using data lakes, data modeling, and data products.
Experience with MongoDB, Tableau, Apache Cassandra, and 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 that interface with large databases.
Ability to analyze 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 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 with 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.