Database Architect

Project Overview:

T&T is in search of a talented Data Architect and Data Modeler to join our team in developing a scalable data model for the National Fisheries Logbook. This pivotal project will span multiple Regional Offices, creating a unified data and validation model to support various headless applications for vessel logging.

The candidate 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 of vessel log tracking by consolidating data into a national database, and enhance reporting capabilities across client Regional Offices.

Objective: Transition from isolated vessel log tracking systems to a centralized national database to improve standardization, reporting, and efficiency across our client’s Regional Offices.  This is one of the first pilot programs of its kind to take a holistic platform and data model approach.  The positions responsibilities and growth may expand to incorporate other application types moving forward. 

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
• 5 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: 

• Python
• 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