Database Architect

Job description

Roles and Responsibilities

Administer and monitor database and address data security solutions as applicable Design and develop efficient techniques for fast, optimized data access and transfer of distributed or networked database systems Design, implement and test novel data structures, data search, query and retrieval solutions to enable access to and processing of the multimodal data types Design, implement and test new and update data indexing mechanisms and architecture designs to allow access to and processing of the data types Research, design, implement and test SQL and NoSQL mechanisms to allow access to data across different scales and complex datasets Design, implement and test frameworks to Integrate algorithms and tools to accommodate analytics on multimodal structured and unstructured data sets. APIs for data access, query and retrieval Integrate algorithms and tools to accommodate processing of small and massive data sets of structured and unstructured compositions to support research activities

Desired Candidate Profile

Medium level of proficiency in procedural, object-oriented, and scripted programming languages such as Java, Perl and Python Required experience with relational, graph and/or unstructured data technologies such as PostgreSQL, SQL Server, Azure SQL, Azure Data Lake, HD Insights, MongoDB, MySQL, Neo4j, Cassandra, Couchbase Experience with data ingestion technologies such as Aspera, MoveIT, Azure Data Factory, SSIS, Pentaho, Alteryx

Key Skills database architecture Azure Data Factory python java Azure Data Lake MongoDB SQL Server SSIS sdlc