ProcessQ ยท 4 hours ago
SQL Developer
Union, NJ
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expProcessQ is a leading SaaS company built on the Microsoft Technology stack, delivering high-performance applications to clients. They are seeking a highly skilled Software Architect to analyze, design, and implement a scalable database solution that can handle a significant increase in transaction load.
AnalyticsConsultingSecurity
Hiring Manager
ThejaK M
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
Qualification
Required
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
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
Company
ProcessQ
Process Q provides consulting services and technology solutions, including data extraction and batch processing.
501-1000 employees
H1B Sponsorship
ProcessQ has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
Funding
Current Stage
Late StageCompany data provided by crunchbase