Sr. Database Architect / Database Modeler Developer (Hybrid) - Location: Hamilton, NJ (In-person) - 100% Only locals with valid DL copy.

Job Title: Database Architect / Database Modeler Developer
Location: Hamilton, NJ
Duration: Long Term Contract.

Job Description:
We are seeking a highly skilled Database Architect to design, develop, and implement complex, reliable, and scalable database systems that align with organizational objectives and requirements. This role involves hands-on database modeling, architecture design, and collaboration with development and infrastructure teams to ensure high performance, scalability, and security of databases.

The ideal candidate will have extensive experience with a variety of database technologies and the ability to independently manage all phases of database design, development, and maintenance. This position requires strong problem-solving skills, architectural vision, and the ability to consult with stakeholders to analyze needs and recommend appropriate solutions.

Key Responsibilities:

1. Design and develop efficient, scalable, and secure database systems, including relational data models, tables, views, stored procedures, triggers, and indexes.
2. Collaborate closely with software developers and system administrators to meet database performance and scalability requirements.
3. Perform backend data integration and architecture tasks including dimensional data modeling, database design, data warehousing, ETL development, and performance tuning.
4. Lead database migration projects (e.g., Oracle to SQL Server) and design/maintain High Availability (HA) and Disaster Recovery (DR) strategies.
5. Develop and implement database deployment strategies and perform maintenance across multiple environments.
6. Manage user access and security policies integrated with applications, including Active Directory on Windows Server environments.
7. Design and maintain large-scale data warehouses supporting analytics and reporting, working closely with data analysts and BI teams.
8. Design and implement cloud database solutions, preferably with experience in AWS RDS.
9. Ensure data security and integrity by implementing encryption, access controls, backup and recovery, and data validation protocols.
10. Automate routine database processes, track issues, and maintain thorough documentation.

Required Skills and Experience:

• Minimum 5 years of experience in database design, development, and administration with proven hands-on skills.
• Strong knowledge of relational database modeling, stored procedures, functions, and database maintenance.
• Experience in database migration projects, specifically Oracle to SQL Server, with HA and DR expertise.
• Expertise in backend data integration, dimensional modeling, data warehousing, and ETL development.
• Proficiency with AWS RDS or other cloud database services is highly desirable.
• Ability to implement robust security protocols including encryption and access control.
• Experience managing Windows Server environments and Active Directory for user and access management.
• Familiarity with version control systems and CI/CD pipelines for database changes.
• Strong problem-solving skills, ability to work independently with minimal supervision.

Preferred Qualifications:

• Experience with automation of database tasks and issue tracking.
• Familiarity with database performance tuning and optimization techniques.
• Knowledge of best practices for data security, backup, and disaster recovery.

Interview:
Candidates must be available for Round 1, in-person interviews only.