Database Administrator

2 weeks ago

Hamilton Twp, NJ, United States Nanosoft Consulting Full time

About the job Database Administrator

Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems.

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

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.

  • Database Manager/Administrator

    1 week ago

    Hamilton Twp, NJ, United States Hudson Data Full time

    Job Title: Database Manager/Administrator Location: Hamilton Township, NJ Duration: Long Term 40 Hrs Job Description: Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems. Please note that this is a hybrid role that requires an in person interview. This role is...

  • Database Manager/Administrator

    2 weeks ago

    Hamilton Twp, NJ, United States Hudson Data Full time

    Job Title: Database Manager/Administrator Location: Hamilton Township, NJ Duration: Long Term 40 Hrs Job Description: Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems. Please note that this is a hybrid role that requires an in person interview. This role is...

  • Database Architect

    2 weeks ago

    Hamilton Twp, NJ, United States Apollo ITS Full time

    Role: Database Architect Location: Hamilton NJ Duration: 12+ month (extendable)Hybrid Role (3 days Onsite, 2 days Remote)Job Description: We are seeking a Database Architect to design and develop efficient, scalable, and secure database systems. This is a full-time hybrid position located onsite. The role requires hands-on experience in building new...

  • Database Developer

    2 weeks ago

    Hamilton Twp, NJ, United States InterSources Full time

    Responsibilities Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes Required. 2Work closely with...

  • Database Developer

    1 week ago

    Hamilton Twp, NJ, United States InterSources Full time

    Responsibilities Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes Required. 2Work closely with...

  • Sr. SQL Database Administrator

    17 hours ago

    Ewing Twp, NJ, United States Insight Global Full time

    Insight Global is seeking a Sr. SQL DBA to join their IT team. The SQL Database Administrator (DBA) will be responsible for maintaining and ensuring the ongoing availability of SQL Server systems, both on-premises and in the cloud (AWS SQL Server and Azure SQL). The DBA will take ownership of the complete understanding and optimization of multiple database...

  • NJDHS-DFD ASAPM3

    2 weeks ago

    Hamilton Twp, NJ, United States Global Pharma Tek Full time

    Job Title: Database modeler/developer Location: Hamilton, NJ (Hybrid) Duration: 6 months Short Description: This is a development position for a .Database modeler/developer PLEASE note: This position will continue for an extended period of time well beyond the end date. Only submit candidates that will interview round one in person only. Complete...

  • NJDHS-DFD ASAPM3

    2 weeks ago

    Hamilton Twp, NJ, United States CapLeo Global Full time

    Job Title: Database modeler/developer Location: Hamilton, NJ (Hybrid) Duration: 6 months Short Description: This is a development position for a .Database modeler/developer PLEASE note: This position will continue for an extended period of time well beyond the end date. Only submit candidates that will interview round one in person only. Complete...

  • Manager, Database Administration

    4 days ago

    Edgewater Park Twp, NJ, United States Burlington Stores Full time

    Position Overview The Manager, Infrastructure Database Services is responsible for leading and optimizing Burlington's enterprise database environment, ensuring reliability, performance, and scalability across corporate, distribution, and store systems. This hands-on leadership role oversees Oracle and Microsoft SQL Server platforms and manages delivery...

  • Manager, Database Administration

    1 week ago

    Edgewater Park Twp, NJ, United States Burlington Stores Full time

    Position Overview The Manager, Infrastructure Database Services is responsible for leading and optimizing Burlington's enterprise database environment, ensuring reliability, performance, and scalability across corporate, distribution, and store systems. This hands-on leadership role oversees Oracle and Microsoft SQL Server platforms and manages delivery...