About Us

Zapcom is a global Product Engineering and Technology Services company, specializing in bespoke, customer-centric solutions across industries like BFSI, e-commerce, retail, travel, transportation, and hospitality. Headquartered in the US, with a presence in India, Europe, Canada, and MENA, we excel in transforming ideas into tangible outcomes using AI, ML, Cloud solutions, and full-stack development.

At Zapcom, we value accountability, ownership, and equality, empowering you to excel. We listen to your aspirations and provide the support needed to achieve them. Our diverse, collaborative culture ensures every voice is heard, driving innovation and business value. With global opportunities and expansion plans, now is the perfect time to join our team. Work on impactful projects that shape the future. Apply today and be part of something extraordinary!

• Responsible for delivering more performant MSQL database solutions along with implementation plan at enterprise level.
• Ability to monitor database performance and optimize it through tuning and indexing
• Review existing stored procedures, identify bottle necks and optimize them
• Ensure data integrity, security and recovery processes
• Trouble shoot database issues and perform timely resolutions
• Ability to work with hybrid MSQL databases (on-prem and cloud)
• Verify batch jobs and their performance impact on databases and think out of box solutions
• Assist developers with query tuning and schema refinement
  
  

Requirements

• Strong proven knowledge in tuning SQL queries
• Strong in writing MSQL stored procedures (TSQL)
• Review Database schema designs and provide suggestions from performance angle
• Helps the team in identifying key indexes and how they should be structured based on schema and frequent query patterns
• Identify run away queries and provide quick solutions
• Monitor system's health and performance using tools like Datadog.
• Analyze, solve, and correct issues in real time