I will optimize database queries, fix indexing, or migrate mysql postgresql mongodb


About this gig
Is your website or application suffering from slow database queries, high server load, connection issues, or an inefficient database structure?
I can analyze, optimize, troubleshoot, or migrate your database to improve the performance and reliability of your application.
What I Can Help With:
- Optimize slow SQL and NoSQL queries
- Identify database performance bottlenecks
- Fix N+1 query problems
- Create and optimize database indexes
- Improve schema and table structures
- Resolve connection and timeout issues
- Reduce unnecessary database workload
- Migrate MySQL, PostgreSQL, or MongoDB databases
- Move databases between servers or environments
- Plan backups and safer migration procedures
- Troubleshoot PHP, Node.js, Express, or Python database connections
Supported Technologies:
MySQL, PostgreSQL, MongoDB, Redis, SQLite, PHP, Node.js, Express, Python, AWS Lightsail, CyberPanel & phpMyAdmin.
My goal is to deliver a faster, cleaner, and more reliable database setup while minimizing migration risk and application downtime.
Please contact me with your database type, issue, and available logs before ordering.
Get to know GihanMadushanka
Founder CEO at PREWIX GLOBAL PVT LTD
- FromSri Lanka
- Member sinceAug 2026
Languages
Sinhala, English
My Portfolio
FAQ
What databases do you work with?
I work with MySQL, PostgreSQL, MongoDB, Redis, and SQLite. I can help with optimization, troubleshooting, indexing, migrations, and application database connections.
Can you optimize slow database queries?
Yes. I can analyze slow SQL or NoSQL queries, identify bottlenecks, improve indexes, reduce unnecessary database operations, and optimize query performance.
Can you migrate my database to another server or environment?
Yes. I can migrate MySQL, PostgreSQL, or MongoDB databases between supported servers or environments while following backup and safer migration procedures.
Can you fix database connection and timeout issues?
Yes. I can troubleshoot database connection errors, timeout issues, configuration problems, and application-to-database connectivity for supported technologies.
Can you optimize MongoDB databases?
Yes. I can review MongoDB queries, indexes, collections, application connections, and common performance bottlenecks.
Do you work with Node.js, Express, PHP, and Python applications?
Yes. I can troubleshoot and optimize database integrations used by Node.js, Express, PHP, and Python applications.
Will you create a backup before migrating my database?
When appropriate and access allows it, I can include or help configure a backup before migration. The exact backup and migration procedure depends on your database, hosting environment, and project scope.
Can you guarantee zero downtime or zero data loss during migration?
No absolute guarantee can be made for every environment. I use careful backup, migration, and testing procedures to minimize downtime and migration risk wherever possible.
What information do you need before starting?
Please provide your database type, approximate database size, current issue or migration goal, relevant error logs, application technology, and available server/database access details.
Should I contact you before placing an order?
Yes, especially for migrations, large databases, production systems, or complex performance issues. I can review the requirements first and recommend the most suitable package or custom offer.

