Database Architect

2 weeks ago

Hamilton, United States New York Technology Partners Full time

Job title: Database Architect

Location: Plaza Hamilton, NJ

Position: Long term contract


Note: Hybrid role 3 days onsite in a week.


Interview: In-Person


Job Description:

  • 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
  • Work closely with software developers, system administrators to ensure that databases meet performance and scalability requirements.
  • Analyzing an organization's data needs, identifying the most appropriate database systems, designing and implementing database structures, and ensuring data security and integrity.
  • Analyst should have experience in Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development, and performance tuning with the Reporting tool Microsoft Power BI Stack experience Required
  • Experience in DB migration project (Oracle to SQL) with Understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options for SQL Server Required
  • Design the DB deployment strategy, DB maintenance across the environments Required
  • Experience with Windows server, including Active Directory.
  • Should be able to manage users, user access strategies integrated with the application Required
  • Focus on designing and maintaining data warehouses, with large-scale repositories of data used for analysis and reporting.
  • Work closely with data analysts and business intelligence professionals to design data models and create efficient queries for extracting data.
  • Associate should have experience in designing and implementing solutions for managing data in the cloud.
  • Experience in working on AWS RDS will be an advantage Nice to have
  • Ensuring data security and integrity, associate should be able to ensure that the data is secure and protected from unauthorized access or modification.
  • Able to implement security protocols such as encryption, access controls, and data backup and recovery procedures.
  • Also ensure that the data is accurate, consistent, and up-to-date by implementing data quality and data validation rules.
  • Automate regular processes, track issues, and document changes Nice to have


Skill Required / Desired

  • Ensure databases are production-ready with rigorous testing, performance validation, and best practices for high availability and disaster recovery
  • Work independently, with minimal support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance.
  • Design and develop database systems that are efficient, scalable, and secure.
  • Hands-on experience in building new relational data models, tables, views
  • Design the DB deployment strategy, DB maintenance of all environments
  • DB migration project (Oracle to SQL Server) with understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options
  • Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development
  • Knowledge/Experience in developing, hosting & managing databases on AWS RDS.
  • Implements security protocols such as encryption, access controls, and data backup and recovery procedures.
  • Experience with Windows server, including Active Directory.
  • Should be able to manage users, user access strategies integrated with the application
  • Designing schema, access patterns, locking strategy, SQL development, and tuning.
  • Should be able to develop these independently.
  • Design DB deployment strategy across the environments, experience with version control systems and CI/CD pipelines for DB changes

  • Database Architect

    1 week ago

    Hamilton Township, United States New York Technology Partners Full time

    Job title: Database ArchitectLocation: Plaza Hamilton, NJPosition: Long term contractNote: Hybrid role 3 days onsite in a week.Interview: In-PersonJob Description: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...

  • Database Architect

    1 week ago

    Hamilton Twp, United States New York Technology Partners Full time

    Job title: Database ArchitectLocation: Plaza Hamilton, NJPosition: Long term contractNote: Hybrid role 3 days onsite in a week.Interview: In-PersonJob Description: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...

  • Database Architect

    2 weeks ago

    Township of Hamilton, United States Infologitech Full time

    Hi, Hope you are doing great!! Please find the below job description and let me know your Interest. **MUST BE LOCAL TO NEW JERSEY** **IN PERSON INTERVIEW** **Position : Database Architect** **Location : Hamilton, NJ (Onsite)** **Duration : 6 months** **Job ID : H1B, GC, GCEAD and USC** - Ensure databases are production-ready with rigorous testing,...

  • Database Architect

    2 weeks ago

    Township of Hamilton, United States Datasys Consulting & Software Inc Full time

    **Title: Database Architect** **Location: Hamilton, NJ(Hybrid)** **Job Type: Contract (C2C & W2)** - 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,...

  • Contract - Database Architect

    2 weeks ago

    Township of Hamilton, United States Datasys Consulting & Software Inc Full time

    **Title**: Database Architect **Location**: Hamilton, NJ(Hybrid) **Job Type**:Contract - 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,...

  • Database Architect

    2 weeks ago

    Hamilton Twp, United States LanceSoft Full time

    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. Work closely with software developers, system...

  • Solutions Architect

    1 month ago

    Hamilton, United States SAIC Full time

    Description SAIC is looking for a Solution Architect responsible for supporting one or more solution delivery areas and/or core capabilities within a large government organization. This is a hybrid position supporting our CBP customer. Onsite requirements for this role can fluctuate, but a minimum of 2-4 days per month onsite is anticipated. The Solution...

  • Enterprise Architect

    4 weeks ago

    Hamilton, United States AnaVation LLC Full time

    Be Challenged and Make a Difference In a world of technology, people make the difference. We believe if we invest in great people, then great things will happen. At AnaVation, we provide unmatched value to our customers and employees through innovative solutions and an engaging culture. Job Description: This AnaVation program supports our federal customer...

  • Senior Enterprise Architect

    1 month ago

    Hamilton, United States AnaVation LLC Full time

    Be Challenged and Make a Difference In a world of technology, people make the difference. We believe if we invest in great people, then great things will happen. At AnaVation, we provide unmatched value to our customers and employees through innovative solutions and an engaging culture. This program supports our federal customer who plays a key role in...

  • Senior Consultant

    1 month ago

    Hamilton Twp, United States ALLTECH CONSULTING SVC INC Full time

    About the Company: Our Company is a leading independent financial services firm offering global family office, wealth management, asset management and strategic advisory to ultra-high-net-worth individuals, families, institutions, and corporations. The firm oversees approximately $85 billion in client assets. Our firm is built upon the 139-year history of...

  • Senior Consultant

    2 weeks ago

    Hamilton Twp, United States ALLTECH CONSULTING SVC INC Full time

    About the Company: Our Company is a leading independent financial services firm offering global family office, wealth management, asset management and strategic advisory to ultra-high-net-worth individuals, families, institutions, and corporations. The firm oversees approximately $85 billion in client assets. Our firm is built upon the 139-year history of...

  • Java Software Developer

    2 weeks ago

    Hamilton, United States Ennoble First, Inc. Full time

    Title : Java Software Developer Location: Denver, Colorado, United States of America St. Louis, Missouri, United States of America Required Clearance: TS/SCI (TS/SCI CI Poly preferred) Employment Type: Full-Time Regular Shift: Day Travel: No Relocation Assistance: YesWe are Ennoble First. The people supporting and securing some of the most complex...

  • Data Engineer

    2 weeks ago

    Hamilton, United States RxAnte Full time

    Data Engineer, Data Services Company Overview Over the next ten years, there will be at least 4.6 million hospitalizations from the misuse of prescription drugs in people 65 or older, resulting in $528 billion in annual avoidable costs. RxAnte is on a mission to improve people's health by helping them get more from medicines. A rapidly growing,...

  • Estimator (Civil / Concrete)

    2 weeks ago

    Hamilton, United States The Christman Company Full time

    Build More with Your Career at Christman With projects throughout the greater Midwest, Christman Building Innovation Group is a great place to begin, continue or grow your career. We are searching for the next generation of innovative minds who want to shape the world and live to build. We are looking for Estimator candidates with specialty concrete and...