Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SQL SSMS Tools SSIS SSAS Restful Api Web Application Architecture Administrator
 
Requirement id 137756
Job title Administrator
Job location in Mercer County, NJ
Skills required Database Modeling, Architecture Design, SQL Server, SSMS Tools SSIS SSAS Restful Api Web App
Open Date 29-Nov-2022
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Administrator: Database Modeling, Architecture Design, SQL Server, SSMS Tools SSIS SSAS Restful Api Web App

start date : 12/19/2022

End date : 06/30/2023

submission deadline : 12/2/2022

client info : DHS - Division Of Family Development

Note :

* Hybrid

*Interview Type - In Person Only

Description :

-------------------------------------------

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 SMEs, 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 platforms 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.
Bachelors degree in Computer science or in a related field.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 137756 while calling.
 
Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1),
 
 Database Modeling job openings in other states
Jobs List

NC FAST Reports Developer (723575)
Create date: 03-Nov-2023
Hybrid

Start date :12/01/2023

End date :11/30/2024

Submission deadline :11/09/2023

Client info :NCDHHS-NCFAST

Description :

The NC Department of Health and Human Services seeks a contractor to assist with implementation and maintenance.... (This job is for - job Jobs in NC Durham Developer - (in Durham, NC))

IDOPL Database Architect 4 (697028)
Create date: 07-Nov-2022
Start date :11/14/2022

End Date :12/31/2023

Submission deadline :11/10/2022

Client Info :
Division of Occupational and Professional Licenses - Admin - IT

Description :
---------------------------------------------
The Idaho Division of Occupational and Professional licenses (DOPL) is an org.... (This job is for - job Jobs in ID Boise Architect - (in Boise, ID))

Java Architect - 4794
Create date: 15-Apr-2021
Description:

Day-to-Day Tasks include, but not limited to:

Design/develop Relational Database models.
Develop database queries to retrieve, update and delete data.
Develop database objects, procedures, and triggers.
Design, implement and maintain Java web applications throughout the System Develo.... (This job is for - SDLC Java Jobs in NY Schenectady Architect - (in SCHENECTADY, NY))

Access Database Administrator - 4494
Create date: 07-Jan-2021
client info : Department of Health


Description:

Day-to-Day Tasks include, but not limited to:

Monitor functionality of the upload of new linked data from Vital Statistics and new hospital records from the Statewide Planning and Research Cooperative System.

Design and implementation of modi.... (This job is for - job Jobs in NY Albany Administrator - (in Albany, NY))

ITS63 EOLWD Senior Technical Developer -SP
Create date: 26-Nov-2019
Bid Number: BD-20-1043-DAO01-32500-46282
Note: Email Submission

Interview: Initial contact by phone, interview may be in person.

Note: vendors may submit no more than (10) Resource resumes
Note: EOLWD is requesting to fill (1) position

Submission Deadline: 12/31/2019 03:00:00 PM EST
Start Date: 1/10/2.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA))
 
 Database Modeling job openings in NJ
Jobs List

NJDHS-DFD Database Manager/Administrator 4 (717408)
Create date: 28-Nov-2023
Hybrid

Start date :08/31/2023

End date :06/30/2024

Submission deadline :11/30/2023

Client info :DHS - Division Of Family Development

Description :

Please note that this is a hybrid role that requires an in person interview.

.... (This job is for - job Jobs in NJ Trenton Administrator - (in Trenton, NJ))

NJDHS-DFD DBMA - Database Developer/Modeler (708404)
Create date: 11-Apr-2023
start date : 05/01/2023

End date : 06/30/2023

submission deadline : 4/14/2023

client info : DHS - Division Of Family Development

Note :

* Hybrid

Description :

This role is critical for the project success and will be responsi.... (This job is for - job Jobs in NJ Trenton Developer - (in Trenton, NJ))
(Administrator: Database Modeling, Architecture Design, SQL Server, SSMS Tools SSIS SSAS Restful Api Web App in Mercer County, NJ)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us