We are seeking an experienced DBA / Database Architect to join a project focused on analyzing, optimizing, and improving an existing MS SQL Server database environment. The database is deployed on-premises and includes complex procedures, triggers, and architectural components. The goal of the project is to review the current database structure, identify areas for performance improvement, and propose solutions for optimization.
responsibilities :
Analyze the current MS SQL Server database architecture (2016 and above).
Review and optimize stored procedures, triggers, and database design.
Identify performance bottlenecks and propose improvements.
Collaborate with the project team to ensure solutions align with business requirements.
Provide guidance on best practices for database architecture and maintenance.
Document findings, recommendations, and implemented changes.
requirements-expected :
Proven experience as a DBA or Database Architect with MS SQL Server 2016+.
Strong knowledge of database architecture, stored procedures, triggers, and query optimization.
Experience with on-premises SQL Server deployments.
Ability to analyze complex databases and identify optimization opportunities.
Excellent problem-solving skills and attention to detail.
Strong communication skills, able to explain technical findings clearly.