SQL Server Consultant

Position – SQL Database Architect

Location – Union, NJ / Germantown, MD

Duration – Full-Time

Job Description:

Job Summary: The SQL Database Architect will be responsible for analyzing, designing, and implementing a scalable and high-performance database solution. The ideal candidate should have extensive experience with SQL Server, performance tuning, and designing scalable database architectures that support microservices-based applications and AI-driven systems.

Key Responsibilities:

• Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability.
• Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems.
• Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB.
• Work closely with application developers to ensure database design aligns with the microservices architecture.
• Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning.
• Develop and implement best practices for database design, partitioning, indexing, and data archiving.
• Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system.
• Collaborate with DevOps teams to automate deployment, backup, and monitoring processes.
• Implement data security measures and ensure compliance with industry standards.
• Provide technical guidance and mentorship to the development and operations teams.
• Stay up-to-date with the latest SQL Server technologies and industry trends.

Required Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• 8 years of experience in SQL Server database design, development, and administration.
• Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one.
• Strong understanding of database scalability techniques such as sharding, partitioning, and indexing.
• Experience in handling large-volume databases (100TB ) and implementing efficient archival strategies.
• Proficiency in performance tuning, query optimization, and troubleshooting database issues.
• Experience with self-hosted SQL Server databases on virtual machines (VMs).
• Hands-on experience with database migration, backup, and recovery processes.
• Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner.
• Strong knowledge of T-SQL, stored procedures, and triggers.
• Experience with microservices architecture and integrating databases within distributed systems.
• Excellent problem-solving skills and the ability to work in a fast-paced environment.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Tolling Experience is strong plus
• Prefer GC/Citizen
• Any relevant SQL Server certification is preferred.
• Experience with NoSQL databases and hybrid database solutions.
• Knowledge of AI-driven database optimization and predictive analytics.
• Knowledge of ETL processes and data warehousing concepts.

Benefits:

• Opportunities for professional development and certifications.
• Competitive salary and benefits package.
• Opportunity to work on innovative, high-impact software systems.
• A collaborative and supportive team environment.
• Career growth and development opportunities.
• The chance to contribute to cutting edge technology stack including GenAI and Agentic AI.