Role: Database Architect (Hybrid) - Location: Hamilton, NJ (In-Person Interview) - 100% Only locals (NJ) with valid DL Copy.

Job Title: Database Architect (Hybrid)

Location: Hamilton, NJ

Job Type: Contract (Long-Term)
Work Model: Hybrid (3 days onsite / 2 days remote)

Job Overview

We are seeking an experienced Database Architect to design, develop, and implement highly complex, reliable, and scalable database solutions. This role requires strong expertise in SQL Server, database architecture, data migration, and performance optimization.

The ideal candidate will work independently, contribute to system architecture decisions, and provide technical leadership in database design and implementation.

Key Responsibilities

1. Database Architecture & Design

• Design and implement SQL Server database architecture
• Develop normalized schemas across multiple databases
• Design data partitioning strategies for large datasets
• Implement database security architecture
• Create audit trails and history tracking mechanisms
• Establish backup and recovery strategies
• Design high availability and disaster recovery solutions

2. Data Migration

• Develop and execute large-scale data migration strategies
• Build ETL processes for data migration
• Perform data validation, cleansing, and quality checks
• Ensure data integrity and zero data loss
• Create data mapping and transformation documentation
• Develop rollback and recovery procedures
• Automate migration scripts and workflows
• Validate referential integrity and data relationships

3. Performance Optimization

• Design indexing strategies for optimal performance
• Optimize queries for high efficiency
• Tune stored procedures, functions, and queries
• Monitor and resolve performance bottlenecks
• Implement caching and batch optimization techniques
• Conduct performance testing and benchmarking
• Configure SQL Server for optimal performance

4. Database Administration

• Install, configure, and maintain SQL Server instances
• Manage users, roles, and permissions
• Monitor database health and performance
• Implement backup, recovery, and maintenance plans
• Handle capacity planning and database growth
• Troubleshoot database-related issues
• Implement monitoring and alerting systems

5. High Availability & Disaster Recovery

• Implement Always On Availability Groups
• Configure replication, log shipping, and clustering
• Design and test disaster recovery procedures
• Implement automated failover mechanisms
• Conduct DR testing and validation
• Document DR processes and runbooks

Required Qualifications

Technical Skills

• 8+ years of SQL Server administration experience
• Strong expertise in SQL Server (2019/2022 preferred)
• Advanced T-SQL programming (stored procedures, functions, triggers, views)
• Database design and normalization (1NF 5NF)
• Query optimization and execution plan analysis
• Index design and performance tuning
• SQL Server security, backup, and recovery
• SQL Server Agent and job scheduling

High Availability & DR

• Always On Availability Groups
• Database mirroring, replication, and log shipping
• Failover clustering
• Backup and restore strategies
• Disaster recovery planning and testing

Performance Tuning

• Query and index optimization.
• Execution plan and wait statistics analysis.
• Deadlock and blocking resolution.
• CPU, memory, and I/O optimization.
• Performance monitoring tools (Profiler, Extended Events, DMVs).

Cloud & Data Technologies

• Experience with cloud databases (AWS RDS or Azure SQL).
• Cloud security, monitoring, and backup strategies..
• ETL tools (SSIS, Azure Data Factory, AWS DMS).
• Experience with large-scale data migration (500GB+).

Scripting & Automation

• PowerShell and T-SQL scripting.
• CI/CD pipelines for database deployments.
• Source control tools (e.g., GitHub)..
• Automation and testing frameworks.

Professional Experience

• 10+ years of database administration experience.
• Experience with high-transaction and mission-critical systems..
• Experience in database modernization and migration projects.
• Experience working in Agile/Scrum environments.

Core Competencies

• Strong analytical and problem-solving skills.
• Ability to work independently with minimal supervision.
• Experience designing scalable and secure database systems.
• Strong understanding of data architecture and integration.
• Knowledge of data warehousing and dimensional modelling.

Preferred / Nice to Have

• Experience with Oracle to SQL Server migration
• Knowledge of Windows Server and Active Directory
• Experience with version control and CI/CD pipelines
• Experience managing database security and access controls