Talent.com
Software Architect

Software Architect

MHK TECH INCJersey City, NJ, United States
30+ days ago
Job type
  • Full-time
Job description

Join to apply for the Software Architect role at MHK TECH INC

22 hours ago Be among the first 25 applicants

Join to apply for the Software Architect role at MHK TECH INC

Get AI-powered advice on this job and more exclusive features.

  • Assess the current SQL Server database architecture and identify areas for improvement in

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
  • 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.

    • Seniority level

    Seniority level

    Mid-Senior level

    Employment type

    Employment type

    Full-time

    Job function

    Job function

    Other

    Industries

    IT Services and IT Consulting

    Referrals increase your chances of interviewing at MHK TECH INC by 2x

    Sign in to set job alerts for Software Architect roles.

    Brooklyn, NY $150,000.00-$200,000.00 2 months ago

    Solutions Architect, Retail, Google Cloud

    New York, NY $147,000.00-$216,000.00 6 days ago

    New York, NY $93,000.00-$151,000.00 1 week ago

    New York, NY $189,000.00-$200,000.00 6 days ago

    New York, NY $250,000.00-$350,000.00 1 week ago

    New York, NY $200,000.00-$250,000.00 2 weeks ago

    New York, NY $150,000.00-$170,000.00 1 week ago

    New York, NY $90,000.00-$120,000.00 6 hours ago

    Whippany, NJ $223,000.00-$230,000.00 6 days ago

    Associate Director : Software Engineering

    Manhattan, NY $172,925.00-$222,300.00 1 week ago

    Software Engineer III | Lead Full Stack Developer

    Holmdel, NJ $125,000.00-$155,000.00 3 weeks ago

    New York, NY $150,000.00-$200,000.00 7 months ago

    New York, NY $150,000.00-$210,000.00 3 weeks ago

    New York, NY $120,000.00-$190,000.00 8 months ago

    New York, NY $120,000.00-$220,000.00 3 weeks ago

    Whippany, NJ $209,639.00-$225,161.00 3 weeks ago

    VP - Lead Software Engineer, Fixed Income - Parametric

    Software Engineer - Electronic Trading - VP - P4

    New York, NY $150,000.00-$210,000.00 1 month ago

    Director, Software Engineer- Fan Identity Platform

    New York, NY $180,000.00-$235,000.00 1 week ago

    Whippany, NJ $209,639.00-$225,161.00 3 weeks ago

    New York, NY $57,000.00-$190,000.00 2 weeks ago

    Whippany, NJ $223,000.00-$230,000.00 6 days ago

    New York, NY $80,000.00-$110,000.00 1 month ago

    Matawan, NJ $126,087.00-$165,761.00 3 weeks ago

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

    #J-18808-Ljbffr

    Create a job alert for this search

    Software Architect • Jersey City, NJ, United States