Overview
On Site
Hybrid
USD 55.00 per hour
Full Time
Skills
Testing
Hosting
Version Control
Common Lisp
AS/400 Control Language
Continuous Delivery
Supervision
Software Architecture
Conflict Resolution
Problem Solving
Research
Database Architecture
Data Storage
Stored Procedures
Scalability
Data Integration
Dimensional Modeling
Database Design
Extract
Transform
Load
Performance Tuning
Microsoft
Database Migration
Oracle
SQL
High Availability
Disaster Recovery
Microsoft SQL Server
Database
Database Administration
Microsoft Windows Server
Microsoft Operating Systems
Active Directory
FOCUS
Data Warehouse
Reporting
Business Intelligence
Management
Cloud Computing
Amazon Web Services
Remote Desktop Services
Amazon RDS
Data Security
Encryption
Access Control
Backup
Recovery
Data Quality
Data Validation
Job Details
Date Posted: 08/20/2025
Hiring Organization: Rose International
Position Number: 487300
Industry: Government/Staffing
Job Title: Database Architect
Job Location: Hamilton, NJ, USA, 08619
Work Model: Hybrid
Work Model Details: Hybrid - 3 days onsite 2 remote
Shift: General
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 11
Min Hourly Rate($): 55.00
Max Hourly Rate($): 60.00
Must Have Skills/Attributes: Data Warehouse, Design, ETL, Oracle, SQL Server
Experience Desired: Automate regular processes, track issues, and document changes (1 yrs)
**C2C is not available**
Job Description
***Only qualified Database Architect candidates located at the Hamilton, NJ area to be considered due to the position requiring an onsite presence***
Required Skills:
Ensure databases are production- Required ready with rigorous testing, performance validation, and best practices for high availability and disaster (5 Years)
Work independently, with minimal Required support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance (5 Years)
Designand develop database systems that are efficient, scalable, and secure.Hands-on experience in building new relational data models, tables, views (5 Years)
Design the DB deployment strategy, DB maintenance of all environments (5 Years)
DB migration project (Oracle to SQLSerrver) with understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options (5 Months)
Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development (5 Years)
Knowledge/Experience in developing, hosting & managing databases on AWS RDS (5 Years)
Implements security protocols such as encryption, access controls, and data backup and recovery procedures (5 Years)
Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application (5 Years)
Design DB deployment strategy across the environments, experience with version control systems and Cl/CD pipelines for DB changes (5 Years)
Summary: The Database Architect is responsible for designing, developing, and implementing infrastructure to provide highly-complex, reliable, and scalable databases to meet the organization's objectives and requirements. Familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks with minimal or no direct supervision. Assists in defining system and application architecture and provides vision, problem anticipation, and problem-solving ability to an organization. Consults with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.
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
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 Bl Stack experience
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
Design the DB deployment strategy, DB maintenance across the environments
Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application
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
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 upto-date by implementing data quality and data validation rules.
Automate regular processes, track issues, and document changes.
***Local candidates preferred, and this is a Hybrid position- 3 days onsite 2 remote***
Start Date: 09/01/2025
Location: Hamilton, NJ 08619 (Hybrid)
Interview type: In Person interview only
Note: This position will continue for an extended period of time well beyond the end date
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 487300
Industry: Government/Staffing
Job Title: Database Architect
Job Location: Hamilton, NJ, USA, 08619
Work Model: Hybrid
Work Model Details: Hybrid - 3 days onsite 2 remote
Shift: General
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 11
Min Hourly Rate($): 55.00
Max Hourly Rate($): 60.00
Must Have Skills/Attributes: Data Warehouse, Design, ETL, Oracle, SQL Server
Experience Desired: Automate regular processes, track issues, and document changes (1 yrs)
**C2C is not available**
Job Description
***Only qualified Database Architect candidates located at the Hamilton, NJ area to be considered due to the position requiring an onsite presence***
Required Skills:
Ensure databases are production- Required ready with rigorous testing, performance validation, and best practices for high availability and disaster (5 Years)
Work independently, with minimal Required support on the DB issues pertaining to development of the Stored Procedures, Functions and DB maintenance (5 Years)
Designand develop database systems that are efficient, scalable, and secure.Hands-on experience in building new relational data models, tables, views (5 Years)
Design the DB deployment strategy, DB maintenance of all environments (5 Years)
DB migration project (Oracle to SQLSerrver) with understanding in designing and maintaining High Availability (HA) and Disaster Recovery (DR) options (5 Months)
Back-end data integration and architecture including dimensional data modeling(partitioning), database design, data warehousing, ETL development (5 Years)
Knowledge/Experience in developing, hosting & managing databases on AWS RDS (5 Years)
Implements security protocols such as encryption, access controls, and data backup and recovery procedures (5 Years)
Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application (5 Years)
Design DB deployment strategy across the environments, experience with version control systems and Cl/CD pipelines for DB changes (5 Years)
Summary: The Database Architect is responsible for designing, developing, and implementing infrastructure to provide highly-complex, reliable, and scalable databases to meet the organization's objectives and requirements. Familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks with minimal or no direct supervision. Assists in defining system and application architecture and provides vision, problem anticipation, and problem-solving ability to an organization. Consults with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.
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
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 Bl Stack experience
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
Design the DB deployment strategy, DB maintenance across the environments
Experience with Windows server, including Active Directory. Should be able to manage users, user access strategies integrated with the application
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
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 upto-date by implementing data quality and data validation rules.
Automate regular processes, track issues, and document changes.
***Local candidates preferred, and this is a Hybrid position- 3 days onsite 2 remote***
Start Date: 09/01/2025
Location: Hamilton, NJ 08619 (Hybrid)
Interview type: In Person interview only
Note: This position will continue for an extended period of time well beyond the end date
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.