SQL Server Database Architect - Union, NJ

SQL Server Database Architect - Union, NJSQL Server Database Architect - Union, NJ

3 days ago Be among the first 25 applicants

Direct message the job poster from Process

Q Inc

Please find below Job description and send me your Updated resume,

SQL Server Database Architect

Union, NJ

Onsite

About Us:

We are a leading SaaS company built on the Microsoft Technology stack, delivering high-performance applications to our clients. As our business scales, we are undertaking a major database transformation to ensure our systems can process up to 5 million transactions per day, compared to our current capability of 1 million transactions. We are seeking a highly skilled Software Architect with prior experience in redesigning databases to contribute from day one.

Our Back Office System is cloud-agnostic and databases are self-hosted on virtual machines (VMs).

Job Summary:

The Software 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 Dev Ops 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 Power Designer.

· 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

· Any relevant SQL Server certification is preferred.

· Experience with No

SQL databases and hybrid database solutions.

· Knowledge of AI-driven database optimization and predictive analytics.

· Knowledge of ETL processes and data warehousing concepts.

Seniority level

• Seniority level
  
  Mid-Senior level

Employment type

• Employment type
  
  Contract

Job function

• Job function
  
  Management and Manufacturing
• Industries
  
  IT Services and IT Consulting

Referrals increase your chances of interviewing at Process

Q Inc by 2x

Get notified about new Server jobs in Union, NJ.

Server - TAO Downtown Restaurant New YorkEWR Server Assistant at EWR Airport Terminal AServer - TAO Downtown Nightclub New York

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr