I will do ms sql server database administration

Pakistan

I speak Urdu, English

61 orders completed

Senior Developer Microsoft Fabric, ASP NET Core, Node JS, SQL, ETL

Data Expert & Tech Specialist Empower your business with my comprehensive skills: Databases: SQL Server, MySQL, Oracle, Postgres SQL Power BI: Reports, Asset Management Integration: APIs, Google Map...
About this Gig

To keep your database up and running at its maximum, I could use my experience to troubleshoot and fix not only current issues but also the ones that could arise in the future by running diagnoses. Applying the tailored fixes that would be beneficial for the short term as well as in the longer terms. Some but not limited services I could offer.


  • Tuning server and database level configurations to gain the maximum out of the existing hardware.
  • Troubleshooting and fixing high CPU, Memory, and I/O usage.
  • Tracking performance of the queries.
  • Restricting user access (permissions, schemas, views).
  • Logs of the system (server, database, and object level).
  • Optimizing complex queries, writing Store Procedures, Views.
  • Using advanced SQL techniques to reduce the number of resources required query used to solve.
  • Automatic Backup & Recovery.
  • Installation of new instance or patching updates to the existing one.

Expertise:

Administrator

Backup & recovery

Permissions

Database type:

Centralized database

Hierarchical database

My Portfolio