I will design and optimize postgresql and tsql databases
Data Wrangling And Statistical Modeling Specialist
About this Gig
Stop losing time and money on slow queries and poorly designed databases.
Hello! I am a Data Science specialist with deep expertise in Database Architecture and Optimization. If your application is scaling and your database is lagging, or if you need to extract complex business logic without crashing your server, you are in the right place.
I don't just write SQL; I build robust, scalable, and mathematically sound data ecosystems.
My core services include:
- Advanced Query Optimization: Refactoring slow queries using Window Functions, CTEs, and execution plan analysis.
- Database Architecture: Professional Schema design (Normalization/Denormalization strategies).
- Server-Side Logic: Creation of complex Views, Triggers, and Stored Procedures (PL/pgSQL, T-SQL).
- Concurrency & Reliability: Setup of strict isolation levels to prevent data anomalies in critical financial or operational transactions.
Please message me before placing an order so we can discuss your specific technical needs and align on the scope.
I provide support in both English and Spanish to ensure full understanding of your project requirements
Database type:
Relational database
Platform:
PostgreSQL
•
SQL Server
Expertise:
Design
•
Query optimization

