SQL Developer/DBA Architect.

Processq

Union (NJ)

On-site

USD 140,000 - 190,000

Full time

10 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Processq in New Jersey seeks a Software Architect to design, build, and tune a scalable SQL Server database for AI-driven microservices. You will shape architecture, perform performance tuning, and drive archival strategies for 100TB+.

The role emphasizes collaboration with dev, cloud/DevOps, and data teams, with a focus on reliability and security. The ideal candidate has 10+ years of SQL Server experience, strong modeling skills, and a proven ability to deliver from day one in a fast-paced

Qualifications

  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • 10+ years of experience in SQL Server database design, development, and administration.
  • Proven experience 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.

Responsibilities

  • Assess the current SQL Server database architecture for scalability, performance, and maintainability.
  • Design and implement a high-performance database architecture to support 5M daily transactions and AI-driven systems.
  • Develop an archival strategy for 100TB of data across cold, warm, and hot storage.
  • Ensure alignment between database design and microservices architecture.
  • Optimize performance by tuning indexing, queries, and bottlenecks.
  • Establish best practices for partitioning, indexing, and data archiving.
  • Plan for high availability and DR with near-zero RPO and RTO across multi-agency data.
  • Collaborate with DevOps to automate deployment, backup, and monitoring.
  • Implement data security measures and regulatory compliance.
  • Provide technical guidance and mentorship to development and operations teams.
  • Stay current with latest SQL Server technologies and industry trends.

Skills

SQL Server architecture
Performance tuning
Partitioning
Sharding
NoSQL databases
T-SQL / stored procedures
Data modeling (ERwin/PowerDesigner)
Microservices integration
AI-driven optimization
VM-based SQL Server
Security/compliance
Leadership / mentorship
Communication skills

Education

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field

Tools

ERwin
PowerDesigner
Virtual Machines

Job description

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 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.
  • 10+ 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
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL Database Administrator
Senior SQL Database Administrator

Verra Mobility • Mesa (AZ)

On-site
USD 100,000 - 130,000
Database Architect / Database Administrator / Data Engineer
Database Architect / Database Administrator / Data Engineer

Compunnel Inc. • New York (NY)

On-site
USD 140,000 - 190,000
Database Architect
Database Architect

Mbi Llc • Hamilton (NJ)

On-site
USD 100,000 - 130,000
SQL Developer — Data Architect & Performance Optimizer
SQL Developer — Data Architect & Performance Optimizer

ADP WFN Test Company 1 • California

On-site
USD 120,000 - 180,000
Associate Data Architect
Associate Data Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 120,000 - 160,000
Senior Database Engineer
Senior Database Engineer

MeridianLink, Inc. • United States

On-site
USD 110,000 - 170,000
Senior Database Architect & Data Platform Engineer
Senior Database Architect & Data Platform Engineer

Compunnel Inc. • New York (NY)

On-site
USD 140,000 - 190,000
Oracle Database Architect
Oracle Database Architect

Intellectt Inc • Atlanta (GA)

On-site
USD 140,000 - 170,000
Database Administrator
Database Administrator

ICE Clear Europe Limited • Georgia

Hybrid
USD 120,000 - 170,000
Senior Database Architect SQL Server / AWS
Senior Database Architect SQL Server / AWS

HIGH BRIDGE CONSULTING LLC • United States

Remote
USD 120,000 - 190,000