What are the responsibilities and job description for the SQL Dataverse Developer position at Kellton?
Job Description
Mandatory Skills: MS SQL Server, MS Dataverse, Cloud based SQL, database design and development, relationship diagrams, database normalization, create database tables/primary keys/relationships, develop maintenance documentation
Design and develop database interfaces to process data from data sources and storing data in Microsoft SQL Database
- Experience with MS SQL Server and MS Dataverse; Cloud based SQL
- Database design and development for GRC data warehouse
- Support effort to gather and document requirements and define the informational needs of the organization so that a database can be designed to meet those needs.
- Identify data file formats and transmission mechanisms to ingest data (i.e., csv, json, api, etc.)
- Develop initial entity relationship diagram that shows the tables, fields, and primary keys of the database, and how tables are related (linked) to one another.
- Lead the normalization process and resolve any problems associated with the database design so that the data can be accessed quickly and efficiently.
- Create the tables, fields, and primary keys
- Create relationships between the tables
- Create the transmission mechanisms to ingest data (i.e., csv, json, api, etc.)
- Review entity relationship diagram in detail with larger team
- Documentation that will allow the Client DDS to take over the maintenance and monitoring of the deployed database
Salary : $38 - $42
Full Stack Sr Developer (MS .NET, Angular/React, MS SQL/NoSQL)
Orion Innovation -
Montvale, NJ
UI Developer
HAYS -
Florida, NY
Dotnet Developer
The Computer Merchant, LTD (TCM) -
Montvale, NJ
