Client: State of NJ
In-person interview needed. Onsite from day 1
Location: Trenton, NJ
Duration: 12+ months
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.
Skills Needed
Database modeling, architecture design, development, backup & recovery, and administration. Required 5 Years
SQL Server scripting and programming in various platforms, detailed analysis and design. Required 5 Years
Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes. Required 5 Years
SQL development (SSMS), Microsoft Power BI Stack (SSIS, SSAS, SSRS) Required 5 Years
Fix any issues related to database performance and provide corrective measures. Required 5 Years
Familiarity with developing Restful APIs for database layer, and web application architecture. Required 5 Years
Create, modify, and optimize SQL Server Agent jobs and maintenance plans. Required 5 Years
Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner. Required 5 Years
Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams. Required 5 Years
Scripting and programming under Oracle using PL/SQL Nice to have 1 Years
Knowledge/Experience in developing, hosting & managing databases on AWS RDS. Nice to have 1 Years
Knowledge/Experience implementing database designs, transactions for microservice architecture. Nice to have 1 Years
Experience in application modernization and migrating legacy platform's data models (Mainframes or similar). Nice to have 1 Years
Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services. Nice to have 1 Years
Question 1 If the candidate resides more than 1 hour from the client site, will the candidate relocate for the position?
Question 2 Please confirm that candidate is ok working in the office 3 days minimum at the client site. There is no 100% remote option.
Question 3 Please confirm that candidate can come for a round-one, in-person technical interview.
Thanks
Neeraj Singh
•
Receive real-time job alerts and never miss the right job again
United States - NJ - NJ - Fort Lee
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Nutley
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Howell
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Clifton
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - West New York
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Mays Landing
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Montclair
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Bayonne
July 1, 2024
Vivian is looking for Travel Physical Therapist Therapys in Bayonne, New Jersey paying up to $2,625/week • At Vivian, we ensure your next step is a step forward. That's why we built a jobs marketplace that serves healthcare professionals first. It's easy to get started: • Create a profile - Build...
United States - NJ - NJ - Princeton
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - East Brunswick
June 7, 2024
Overview • "It makes me feel good knowing that we make the residents' lives better. We laugh with them, cry with them, sing and dance with them - we brighten their day. Working here is an unbelievable privilege and it will be something I carry with me for the rest of my life!" • Sunrise Team Member...
GHR Healthcare Travel Division
United States - NJ - NJ - Camden
July 1, 2024
GHR Healthcare - Travel Division is seeking a travel nurse RN Med Surg / Telemetry for a travel nursing job in Camden, New Jersey. & Requirements • Specialty: Med Surg / Telemetry • Discipline: RN • Start Date: 07/15/2024 • Duration: 13 weeks • 36 hours per week • Shift: 12 hours, days, nights •...
United States - NJ - NJ - Brick
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Neptune
July 1, 2024
Vivian is looking for Travel ED - Emergency Department RNs in Neptune, New Jersey paying up to $2,502/week • At Vivian, we ensure your next step is a step forward. That's why we built a jobs marketplace that serves healthcare professionals first. It's easy to get started: • Create a profile - Build...
United States - NJ - NJ - Orange
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Garfield
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Middletown
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Bridgeton
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Riverside
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Medford
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Vineland
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Bayonne
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Hoboken
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Williamstown
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Neptune
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...
United States - NJ - NJ - Camden
July 1, 2024
Vivian is looking for Travel Med Surg / Telemetry RNs in Camden, New Jersey paying up to $3,039/week • At Vivian, we ensure your next step is a step forward. That's why we built a jobs marketplace that serves healthcare professionals first. It's easy to get started: • Create a profile - Build your...
United States - NJ - NJ - Passaic
July 1, 2024
Vivian is looking for Travel Cath Lab Technologist Allied Health Professionals in Passaic, New Jersey paying up to $3,223/week • At Vivian, we ensure your next step is a step forward. That's why we built a jobs marketplace that serves healthcare professionals first. It's easy to get started: •...
United States - NJ - NJ - Sicklerville
May 6, 2024
Idaho National Laboratory is hiring an Electrical Engineer to work remote. • Our team works a 9x80 schedule remote with every other Friday off. • You will report to the manager over National Security Solutions. • Perform the role of lead Electrical Engineer for Architectural Engineering design...