You will get Database Design and optimized database after Database audit and tuning

Nasir Z.
Nasir Z. Nasir Z.
4.8
Top Rated

Let a pro handle the details

Buy Database Optimization & Design services from Nasir, priced and ready to go.

You will get Database Design and optimized database after Database audit and tuning

Nasir Z.
Nasir Z. Nasir Z.
4.8
Top Rated

Let a pro handle the details

Buy Database Optimization & Design services from Nasir, priced and ready to go.

Project details

you will get an optimized database with improved performance. I am Certified Database Administrator, Certified Database Developer, DB Architect, and an experienced Performance Tuning expert. I have extensively worked on PostgreSQL, MySQL, AWS Aurora, AWS RDS, MS SQL Server, Azure SQL DB, Azure Cosmos DB, MariaDB, and Oracle.

With 15+ year experience as DB admin/ architect/ developer and performance tuning expert, I excel in DB design and audit for optimal performance. I can configure appropriate monitors and alarms such as CPU usage, memory usage, session count monitors etc. for better monitoring and proactively controlling any performance hiccup.

I will audit/ analyze your database to identify and fix slow queries and provide and recommendations for improving DB architecture to achieve optimal performance. I have completed many performance tuning jobs and one of the job involved tuning tables with more than 1.6 billion of records.

I possess exceptional skills in SQL, ETL, backup & recovery, indexing, partitioning, writing complex queries/ Stored Procedures, rewriting queries which are creating deadlocks/ bottlenecks to ensure optimal performance.
Database Type
MySQL, MS SQL, MS Access, Oracle, SQLite, PostgreSQL
What's included
Service Tiers Starter
$75
Standard
$150
Advanced
$400
Delivery Time 1 day 2 days 5 days
Number of Revisions
111
Number of Tables Added
111
Schema Diagram
Permissions Setup
Import/Export Data
Admin Panel Setup

Frequently asked questions

4.8
64 reviews
91% Complete
6% Complete
2% Complete
2% Complete
1% Complete
(0)
Rating breakdown
Availability
4.9
Deadlines
4.8
Skills
4.8
Cooperation
4.8
Quality
4.8
Communication
4.8

JL

John L.
5.00
May 22, 2023
I was extremely impressed with Nasir's exceptional ability to comprehend and fulfill our requirements. His outstanding performance in understanding our needs and executing the project was truly remarkable.
Nasir Z.

About Nasir

Nasir Z.
Database Administrator | Filemaker Developer | Data Engineer
97% Job Success
4.8  (64 reviews)
Lahore, Pakistan - 4:37 am local time
💡I am experienced in Database development, Performance Tuning, Database and System Administration, Webserver Administration, Database Warehousing, Business Intelligence, and Data Engineering. With a strong focus on ETL processes, I specialize in designing and implementing robust data pipelines that ensure efficient data flow and transformation across various platforms.

🥇I have more than 𝟴𝟳𝟬𝟬 𝗽𝗹𝘂𝘀 𝗵𝗼𝘂𝗿𝘀​ of Database Development, Webserver, and System administration work on 𝗨𝗽𝘄𝗼𝗿𝗸. Managed Postgresql, Oracle, MS SQL Server, MySQL, and FileMaker databases on Windows and Linux platforms. My area of specialization is Performance Tuning and High Availability.

👉I am an 𝗢𝗿𝗮𝗰𝗹𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 OCP in both Development and Administration. Provided training on FileMaker, Oracle, MS SQL Server, MySQL, and PostgreSQL development and administration. Also, I have extensive knowledge in the areas of software design, analysis, coding and integration for web-based applications, which ensures seamless data integration and maximum performance.


👉I also hold the 𝗖𝗹𝗮𝗿𝗶𝘀 𝗙𝗶𝗹𝗲𝗠𝗮𝗸𝗲𝗿 𝗣𝗿𝗼 Expert certification, issued by Claris and verified through Credly.com. This certification reflects my expertise in developing applications on the Claris FileMaker platform, including designing custom workflows, optimizing databases, and integrating third-party solutions for enhanced productivity.

We’re proud to announce that we are now an 𝗢𝗳𝗳𝗶𝗰𝗶𝗮𝗹 𝗖𝗹𝗮𝗿𝗶𝘀 𝗣𝗮𝗿𝘁𝗻𝗲𝗿 empowering innovation with certified expertise!

🤝My goal is to meet business requirements with respect to quality, functionality, performance, availability, and on-time delivery. I have a solid understanding of Software Engineering, and the Software SDLC has allowed me to deliver high-quality software on time. Data Engineering and ETL expertise allow me to handle complex data transformations, making data more useful and accessible for business decisions.

Steps for completing your project

After purchasing the project, send requirements so Nasir can start the project.

Delivery time starts when Nasir receives requirements from you.

Nasir works on your project following the steps below.

Revisions may occur after the delivery date.

Access to required DB server

I need db credentials and ssh access to server.

DB Audit

Audit and analyze DB to find root cause of slow performance

Review the work, release payment, and leave feedback to Nasir.