Tenders Are Invited For Providing Support For The Optimization Of It Systems Of The Ordering Party

The Subject Of The Order Is The Provision Of Support Services In The Field Of Optimization Of The Ordering Partys It Systems.1. Within The Scope Of The Basic Order, The Contractor Will Be Obliged To: 1) Analyze Sql Query Logs In Order To Identify And Evaluate Long-Running Queries, Optimize The Sql Code; 2) Optimize Existing Queries By Improving The Sql Structure, Avoiding Subqueries, Using Joins Instead Of Nested Queries, Identifying Bottlenecks In Queries And Their Optimization;3) Analyzing And Creating Appropriate Indexes Based On The Application Needs In Order To Speed Up Access To Data;4) Adding, Deleting And Reorganizing Indexes To Ensure Their Effectiveness;5) Analyzing Query Execution Plans (Explain Plan) To Identify Ineffective Operations And Suggesting Corrections;6) Reviewing And Optimizing The Database Structure, Normalizing Or Denormalizing Data, Partitioning Tables;7) Managing Data Structure, Designing Database Schemas Including The Principles Of Normalization And Denormalization, Optimization Of Tables And Relations, Operations On Large Data Sets;8) Analysis Of Business Requirements In Order To Design The Data Structure;9) Analysis Of Logs And Database Load Indicators.10) Transaction Management, Handling Of Lock Mechanisms And Isolation Of Transactions;11) Monitoring, Analysis And Diagnosis Of Performance Problems: Identification Of The Source Of Problems, Analysis Of Load Trends And Proactive Resource Planning;12) Verification Of The Impact Of Recommendations On The Assessment Of The Performance Of The Analyzed Systems;13) Analysis Of The Items Of The Contract Indicated By The Ordering Party In Terms Of The Technical Solutions Used ;14) Participation In Meetings Indicated By The Ordering Party In The Field Of System Solution Architecture And Performance.2. Within The Scope Of The Contract Covered By The Renewal, The Contractor Will Be Obliged To: 1) Analyze Sql Query Logs In Order To Identify And Evaluate Long-Running Queries, Optimize The Sql Code; 2) Optimize Existing Queries By Improving The Sql Structure, Avoiding Subqueries, Using Joins Instead Of Nested Queries, Identifying Bottlenecks In Queries And Their Optimization;3) Analysis And Creation Of Appropriate Indexes Based On Application Needs In Order To Speed Up Access To Data;4) Adding, Deleting And Reorganizing Indexes To Ensure Their Effectiveness;5) Analysis Of Query Execution Plans (Explain Plan) To Identify Ineffective Operations And Suggestions For Corrections;6) Review And Optimization Of Database Structure, Normalization Or Denormalization Of Data, Table Partitioning;7) Data Structure Management, Design Database Schemas, Including The Principles Of Normalization And Denormalization, Optimization Of Tables And Relations, Operations On Large Data Sets;8) Analysis Of Business Requirements To Design The Data Structure;9) Analysis Of Logs And Database Load Indicators.10) Management Transactions, Handling Locking Mechanisms And Transaction Isolation;11) Monitoring, Analys

Refer document

FileName	File Description
Global Tender Document	Tender Notice