Job description
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.
