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 Business Intelligence Developer-Data Analytics Strategy Lead Create date: 18-Dec-2024 No of Submissions: 2 Start date : 1/27/2025 End date : 01/23/2026 Submission deadline : 01/03/2025 Client info: CT DAS Note: * Position Location: Remote * Max Rate for this Position is USD 102.50 Per Hour Description: About the Role T.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Database Analyst - Cloud Solution Analyst Create date: 12-Dec-2024 * Bill Rate: USD 75.00 Per Hour * Max Rate: USD 91.00 Per Hour No of Submissions : 1 Start date : 02/01/2025 End Date : 01/31/2026 Submission deadline : 12/17/2024 Client Info : CO CDPHE Note: * Position Location: Hybrid * Candidate Must Be Lo.... (This job is for - MS SQL Server Jobs in CO Denver Analyst - (in Denver, CO)) SOFTWARE ARCHITECT - CONSULTANT-11434-1 Create date: 29-Oct-2024 No of Submissions : 2 start date : 12/07/2024 submission deadline : 11/5/2024 client info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) A video conference interview or in-person interview may be con.... (This job is for - JQuery Jobs in SC Columbia Architect - (in Columbia, SC)) DRC-Programmer 4/ PR 4Replacements (748107) Create date: 30-Sep-2024 No of Submissions : 2 start date :11/11/2024 End date :06/30/2025 submission deadline : 10/03/2024 client info : DRC Note: * AM: Shalaka * A more senior developer is responsible for planning, processing and performing all jobs in an efficient manner with little or no su.... (This job is for - NET FRAMEWORK Jobs in OH Columbus Consultant - (in Columbus, OH)) NC FAST Integration Engineer (743614) Create date: 19-Aug-2024 Hybrid No of Submissions : 1 start date :09/16/2024 End date :09/12/2025 submission deadline : 08/26/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person Description : .... (This job is for - JSON Jobs in NC Durham Engineer - (in Durham, NC))    Data Modeling job openings in NJ Jobs List NJAOC SC 1-PEGA SSA (739560) Create date: 06-Jun-2024 * Hybrid No of submissions : 1 Start date :06/30/2024 End date :08/14/2024 Submission deadline :6/11/2024 Client info : Judiciary Note: * Position is Hybrid. Local candidates will be asked to come into the office 1-2 Days / Week. * Position will be extended u.... (This job is for - job Jobs in NJ Trenton Consultant - (in Trenton, NJ)) 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)) (Administrator: Data Modeling, Database Design, T-SQL, MSSQL Database SSRS AWS EC2 Management S 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)