Database Architect (Onsite Interview-NJ) at Primesoftinc
Trenton, NJ 08650, USA -
Full Time


Start Date

Immediate

Expiry Date

06 Dec, 25

Salary

60.0

Posted On

07 Sep, 25

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Data Security, Data Models, Data Warehousing, Reporting Tool, Database Systems, Databases, Stored Procedures, Data Integration, Design, Architecture, Database Design, Microsoft Power Bi, Oracle, Sql, Performance Tuning, High Availability, Active Directory, Windows Server

Industry

Information Technology/IT

Description

SKILLS REQUIRED:

  • 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, and indexes Required
  • Work closely with software developer’s 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 required.
  • An 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 of 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. Required
  • 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
Responsibilities

Please refer the Job description for details

Loading...