Job Description:
• Engage two senior-level, on-shore SQL Server developers to address performance and data optimization needs in our SQL Server environment, starting immediately, to accelerate improvements without slowing down our existing internal DBA.
Scope of Work:
• Stored Procedure Optimization (Phase 1 Priority)
• Identify and optimize the top priority stored procedures based on execution time and frequency.
• Implement and validate changes in QA/UAT before production rollout.
• Reporting Views Optimization After stored procedures, target high-impact views used in reporting that require significant performance improvements.
• CRM Sync Process Optimization Improve performance and reliability of the sync process between transactional databases and the CRM system.
Workflow Expectations:
• Both developers will work in parallel on separate tasks to maximize efficiency.
• All changes must include documented before/after performance metrics.
• All work must follow the Dev → QA → UAT → Prod deployment process.
• Twice-weekly status updates to review progress, blockers, and upcoming priorities.
• Review Process
• All SQL optimizations will be submitted to the Software Development Manager and Team Lead for quality and consistency review.
• The internal DBA will not be involved in day-to-day vendor work to maintain their focus on other critical activities.
• All stored procedures optimized.
• Associated performance gains.
• Recommendations for next steps.
• Documentation of all changes stored in our GitHub/Azure DevOps repositories.
Key Requirements:
• Two senior-level, on-shore SQL Server developers with experience in:
• Performance tuning and query optimization.
• Working in enterprise-scale SQL Server environments hosted in AWS.
• Collaborating with internal teams using structured review and deployment processes.
Axiom is a global information technology, consulting and outsourcing company and services provider. Our IT solutions empower organizations and individuals throughout the world to maximize value and quality to succeed in today's challenging business environment. As a fast-growing new economy company, we focus our strengths to offer world-class solutions and services through the convergence of technology, innovation, expertise and experience. We provide software consulting, development and IT-enabled services to clients across the globe. We work towards delivering sustained value creation for customers, employees, industries and society at large. Core offerings include data warehousing, middleware development, product development and web-enablement of legacy applications in verticals like telecom, finance, healthcare, manufacturing, energy & utilities, retail & distribution, enablement of legacy Relentless exploration of technology horizons and a Global Delivery Model that is a judicious combination of onsite, offsite and offshore development, offer a complete range of high-ROI business solutions spanning the consulting, technology, operations and process outsourcing value chain.
Please mention you found this job on AI Jobs. It helps us get more startups to hire on our site. Thanks and good luck!
Be the first to apply. Receive an email whenever similar jobs are posted.
Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.
Developer Q&A's