T-SQL MSSQL Database SSRS AWS EC2 Management SSRS Reporting SSIS Administrator (   Requirement id 120840 Job title Administrator Job location in Mercer County, NJ Skills required Data Modeling, Database Design, T-SQL, MSSQL Database SSRS AWS EC2 Management S Open Date 11-Dec-2021 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Administrator: Data Modeling, Database Design, T-SQL, MSSQL Database SSRS AWS EC2 Management S Start Date :12/20/2021 End Date :06/30/2022 Submission Deadline :12/16/2021 Client Info : DHS - Division Of Family Development Note : * Agency Interview Type: In Person Only Description : Please note - this is a role where onsite/hybrid work will be required. Candidates should plan on working onsite at the client address 2-3 days per week at manager discretion. Candidates that apply that require relocation should also elaborate on the reason why they are interested in relocating to the area. Position Summary 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. • Visual Studio .NET, VB, ASPX, DAX, C#, VBA, etc. • SQL scripting and programming in various platforms, detailed analysis and design (Oracle and SQL). • 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). • Crystal reports, SSRS report development, PowerBI. • 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: 120840 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),    Data Modeling job openings in other states Jobs List VDOT Program Manager - Business Data Management (728400) Create date: 01-Feb-2024 Hybrid Start date :01/29/2024 End Date : 06/30/2024 Submission deadline : 2/6/2024 Client Info : VDOT Description : ------------------------------------------------------ **Long-Term position requires occasional onsite at 1401 East Broad Street, Richmond VA to be determined by mgr Data Architect Business Analyst Jobs in VA Richmond Manager - (in Richmond, VA)) Business Intel Data Modeler III - 125057 Create date: 01-Dec-2023 Start date : 01/15/2024 End date : 06/30/2024 Submission deadline : Friday, December 8th at 4:00PM CST. Client info : DCF Note : * INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be .... (This job is for - job Jobs in WI Madison Modeler - (in Madison, WI)) Data Warehouse Architect 3 - 124057 Create date: 03-Nov-2023 Start date : 11/28/2023 End Date : 06/30/2024 Submission deadline : 11/10/23 at 10am EST Client Info : MSP Note : * Interview Process: Interviews will be held in person - candidates must be able to attend an in-person interview. * Duration: Through 6/30/2024 - Extension likely ETL Jobs in MI Dimondale Architect - (in Dimondale, MI)) ITSAC 537400558 Enterprise Architect 3 -SP Create date: 26-Jul-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000007KklAAE/537400558 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 755 hours Note: RTR form must be signed by the candidate Submission Deadline: 7/31/2023 5:00 PM CT Start Date: 9/1/2023 End Dat.... (This job is for - job Jobs in TX Austin Architect - (in Austin, TX)) ITSAC 4552321312 Business Analyst 3 -SP Create date: 05-Jun-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000007AWnAAM/4552321312 Note: Online Submission Note: RTR form must be signed by the candidate Note: Total estimated hours per Candidate shall not exceed 320 hours Submission Deadline: 6/12/2023 5:00 PM CT Start Date: 7/10/2023 End D.... (This job is for - Business Analyst Jobs in TX Austin Analyst - (in Austin, TX))    Data Modeling job openings in NJ Jobs List NJAOC SC 1-PEGA SSA (717131) Create date: 02-Aug-2023 Start date :08/20/2023 End Date :09/27/2023 Submission deadline :8/7/2023 Client Info :Judiciary Note: Hybrid Description : Position is remote or hybrid depending on candidates location.. Local candidates will be asked to come into the office for meetings each month. This will b.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJAOC Senior Consultant 1-PEGA SSA- UI/UX (714353) Create date: 27-Jul-2023 Hybrid Start date :07/30/2023 End Date :06/29/2024 Submission deadline :8/2/2023 Client Info :Judiciary Description : ------------------------------------------------------ Note:This is a Hybrid role requiring 2 Days / Week Onsite with the team. MINIMUM of 5 years Post PEGA.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJ DOL - App Systems Analysis(702623) Create date: 20-Jan-2023 Job Title : NJ DOL - App Systems Analysis/Programming Mgr 3 - Jr. Oracle Developer (702623) start date : 02/06/2023 End date : 02/05/2024 submission deadline : 1/25/2023 client info : LWD - Information Technology Note : * Hybrid * Interview Type : Either iLinc Web Cam or .... (This job is for - job Jobs in NJ Trenton Analyst - (in Trenton, NJ)) NJAOC Senior Consultant 1 PEGA SSA (697896) Create date: 15-Nov-2022 Remote Start date :11/27/2022 End Date :01/27/2023 Submission deadline :11/17/2022 Client Info :Judiciary Description : --------------------------------------------- PEGA Certified Senior System Architect WITH A MINIMUM OF 5 YEARS WORKING EXPERIENCE after Pega SSA certification. Pleas.... (This job is for - Reporting Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJ DOL - App Systems Analysis/Programming Mgr 3 (693019) Create date: 09-Nov-2022 Hybrid Start date :10/01/2022 End Date :09/30/2023 Submission deadline :11/11/2022 Client Info :LWD - Information Technology Description : --------------------------------------------- The Jr. Oracle Developer will be responsible for Creating Load Jobs, Aggregations and Views for the .... (This job is for - job Jobs in NJ Trenton Analyst - (in Trenton, NJ)) (Administrator: Data Modeling, Database Design, T-SQL, MSSQL Database SSRS AWS EC2 Management S in Mercer County, NJ)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)