Freelance · Data & AI
Database Design & Optimization
When an application slows down, the database is often why. I design schemas for relational and time-series data, and track down slow queries in PostgreSQL, TimescaleDB, SQL Server and MySQL.
- PostgreSQL
- TimescaleDB
- MSSQL
- MySQL
- NoSQL
- SQL
What I can help with
Database / performance — what's included
- 01
Schema design
Data models that fit how the application actually reads and writes.
- 02
Time-series architecture
Storing and querying large volumes of sensor or event data with TimescaleDB.
- 03
Query optimization
Finding slow queries and making them fast.
- 04
API + database tuning
Optimizing the endpoint and the query together, not in isolation.
- 05
Data processing
Aggregations and computations over time-series data.
Relevant experience
Built on real work
Database & time-series work
IST TechnologiesPostgreSQL / MSSQL, TimescaleDB, time-series data processing and database optimization.
SmartEco
IST TechnologiesTime-series architecture for real-time sensor data and AQI computation.
A good fit if…
- Pages or reports have become slow as data grew
- You're storing sensor, event or metrics data
- You're starting a new product and want the data model right
Remote · based in Hyderabad, India
How we'll work
A clear process, even when the problem isn't
I don't need to know everything before I start — I need to know how to figure it out.
01
Understand
Break down the problem and understand the system.
02
Explore
Research technologies and possible approaches.
03
Build
Create a practical working implementation.
04
Debug
Find bottlenecks, failures, and edge cases.
05
Improve
Optimize performance, reliability, scalability, and usability.
06
Ship
Deploy, monitor, support, and iterate.
Contact
Have a problem worth solving?
Whether you're building a product, solving a technical challenge, or exploring an interesting idea, I'd be happy to connect.
Remote · based in Hyderabad, India