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)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)