Database Developer/Modeler

Dew Softech Inc
Trenton, NJ Other
POSTED ON 4/11/2023 CLOSED ON 5/31/2023

What are the responsibilities and job description for the Database Developer/Modeler position at Dew Softech Inc?

Job Description

Position: Database Developer/Modeler

Location: Hamilton, NJ Hybrid

Duration: 6 months

Rate: Open

Interview: In Person

3 days in office

2 days remote

This role is a Database developer with some Admin responsibilities.

Please note that this is a hybrid role that requires an in person interview. Position will extend for at least another 12 months from above.

This role is critical for the project success and will be responsible to design, manage and maintain the Relational/SQL databases, data warehouse, and reporting infrastructure for all applications within DFD.

General responsibilities include Design, develop and maintain database solutions and data warehousing to support enterprise application services, reporting and analytics, including architecture design, data modeling, documentation, policies and standards. Analyze system requirements and migration methods for existing data in legacy systems. Plan, architect and optimize the data infrastructure to integrate with future systems. Maintain legacy reporting as well as design and implement new reporting and data, availability models.

Responsibilities:

Design, implement and support data models, databases, and DW solutions to meet the long-term goals for the DHS/DFD office.

Develop and implement OLTP schemas, comprehensive testing plans for validating data transformation and integration, develop key metrics to ensure integrity on data architecture.

Responsible to take the ownership for their assigned tasks and work independently and deliver results in an iterative approach adhering to the sprint deadlines.

Must work collaboratively with the team of developers, Technical Lead, Architect, Business SME's, and Project Managers.

Recognizes problems and responds, systematically gathers information, sorts through complex issues, seeks input from others, addresses root cause of issues, makes timely decisions, can make difficult decisions, uses consensus when possible, communicates decisions to others, and rapidly adapts to change.

Required Skills:

Database modeling, architecture design, development, backup & recovery, and administration.

SQL Server scripting and programming in various platforms, detailed analysis and design. SQL Server is required (Oracle and PL/SQL is a plus).

Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components to support the existing & new development features in an agile environment.

SQL development (SSMS), Microsoft BI Stack (SSIS, SSAS).

Prior experience using various reports including SSRS (required) for report development.

Familiarity with developing Restful APIs for database layer, and web application architecture.

Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams.

Nice to Have:

Knowledge/Experience in developing, hosting & managing databases on AWS RDS.

Knowledge/Experience implementing database designs, transactions for microservice architecture.

Experience in application modernization and migrating legacy platform's data models (Mainframes or similar).

Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services.

Minimum Requirements:

7 years of Database design, SQL/TSQL development, SSMS, SSIS, SSAS & SSRS experience.

1-2 years on AWS RDS.

Bachelor's degree in Computer science or in a related field.

Developer
Wipro Limited -
PRINCETON, NJ
Developer
Vantage -
Hope, PA
Senior Database Administrator II
CGS Federal (Contact Government Services) -
Trenton, NJ

For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the Database Developer/Modeler.

Click the checkbox next to the jobs that you are interested in.

  • Bug/Defect Analysis Skill

    • Income Estimation: $114,313 - $163,687
    • Income Estimation: $120,405 - $154,181
  • Business Requirement Gathering Skill

    • Income Estimation: $129,317 - $164,950
    • Income Estimation: $141,715 - $177,567
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Not the job you're looking for? Here are some other Database Developer/Modeler jobs in the Trenton, NJ area that may be a better fit.

Data Modeler

AppLab Systems, Inc, Princeton, NJ

Database Engineer

Lorven Technologies Inc., Pennington, NJ