Database Architect

T and T Consulting Services Inc; Falmouth (MA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

401(k) Plan

Training Programs

PTO

Paid Holidays

Job summary

T and T Consulting Services Inc in Falmouth, MA is seeking a senior Database Architect to design scalable data models for NOAA Fisheries and build centralized data stores with API access for React-based applications.

The role requires 6+ years in RDMS/BI/OLTP/OLAP, cloud and on-prem systems, and strong leadership in database modernization. Join a team delivering standardized data solutions across regional offices.

Qualifications

• BA or BS degree in a technical field
• 6+ years of experience architecting and modernizing legacy databases
• Experience with RDMS, BI, OLTP, OLAP and multi-DBMS environments
• Proven ability to design production-ready schemas and optimize data stores
• Strong knowledge of cloud and on-premises database technologies
• Experience with RESTful endpoints and SOA environments

Responsibilities

• Exhibit strong leadership in modern database design and architectural principles
• Scale a common validation model for multiple applications
• Enhance storage and database design for efficiency
• Reengineer architecture introducing innovative technologies
• Implement API architecture for data communication
• Create detailed documentation and diagrams
• Collaborate with application, infrastructure, and leadership teams
• Develop holistic database solutions rather than quick fixes
• Prototype cloud and modern databases and tools
• Contribute to roadmap for data technology architecture

Skills

Data architecture

Leadership

Agile experience

Data modeling

API development

Education

BA or BS degree

Tools

SQL Server

Oracle

MongoDB

Snowflake

PostgreSQL

MySQL

Azure Cloud

AWS Glue

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Database Architect

Full Time DOC NOAA IMS NEFSC, Falmouth, MA, US

Salary Range: $120,000.00 To $160,000.00 Annually

Project Overview:

T&T is in search of a talented senior Data Architect and Data Modeler to join our team in developing a scalable data models for the NOAA Fisheries. This position will span different projects across multiple Regional Offices (e.g. SERO) and Fisheries Science Centers (e.g. NEFSC), creating a unified data and validation models to support regional and science missions across Fishery applications and data initiatives.The candidates will work closely with Regional Offices to design and implement a centralized data store, develop scalable APIs for seamless integration with React applications and PWAs, drive the standardization and efficiency application modernization by consolidating data in to database, and enhance reporting capabilities across applications and databases.

Primary Responsibilities:

• Exhibit strong leadership in modern database design, architectural principles, and technological modernization.
• Assist in scaling a common validation model that can be utilized for the applications
• Enhance existing database and storage design for optimal efficiency.
• Reengineer database architecture and system design, introducing innovative technologies.
• Implement API architecture for seamless data communication within applications.
• Create detailed documentation and diagrams.
• Collaborate effectively with the application team, infrastructure team, leadership, and other contractors.
• Develop holistic database solutions rather than temporary fixes.
• Prototype new technology solutions in the cloud and other modern databases, tools, and designs.
• Participate in defining target state applications and data technology architecture roadmaps.
• Contribute to T&T proposal activities and other duties as assigned by T&T managers/supervisors.

Required Skills & Qualifications:

• BA or BS degree
• 6+ years of experience building, architecting, designing, and modernizing legacy database systems and building new target state architecture
• Organizational experience in an agile operating model
• Established work in proof of concepts and technology.
• The ability to architect and model mission critical RDMS, BI, OLTP, OLAP, and solutions leveraging multiple DBMS technologies is required; Ability to create new schemas on how production databases run, tune, and maintain in a production environment
• Program systems, scripts, and queries in conjunction with SQL Server, Oracle databases, NoSQL databases (Like MongoDB), Snowflake, on both on-prem and cloud environments with DB such as. Amazon RDS, AWS Glue, PostgreSQL, MySQL, DynamoDB, Elasticsearch; Microsoft Azure cloud data services (or equivalent) utilizing Functions, Data Factory, Managed Instances
• Extensive experience with Data Analysis, Data Profiling, Data Flows, and Data Modeling is required
• Experience in a Service Oriented Architecture

Desired Skills & Qualifications:

• Knowledge of Government operations and NOAA missions
• Experience programming and requesting information from RESTful endpoints
• Experience architecting big data solutions using Data Lake, Data Modeling , Data Products
• Experience with MongoDB, Tubleau, Apache Cassandra, Snowflakes
• Experience with Cloud native DB design
• Expertise in architecting and developing database solutions
• Experience with No SQL and GraphQL technologies
• Experience programming in an object-oriented language
• 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
• Provide rational analysis of data and means to improve structure and integrity.

Benefits: Competitive benefits package including: health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

Equal Opportunity Employer/Veterans/Disabled