Mirziyod is available for hire

Mirziyod Pulatov

Verified Expert in Engineering

Database Developer

Tashkent, Tashkent Province, Uzbekistan

Toptal member since April 6, 2022

Expertise

SQL Data Science Database CSS JavaScript Excel Development Oracle Development PostgreSQL

Bio

Mirziyod is a software developer who began his career as a front-end specialist and now focuses on database development. He excels in creating rules for the automated cleansing, categorizing, and filling of missing data, building database views with different complexity for Power BI, and designing database objects such as tables, procedures, jobs, and corresponding constraints for business logic and reporting. Mirziyod enjoys problem-solving and work that requires in-depth analysis.

Portfolio

Realsoft LLC

PostgreSQL, Databases, Oracle Database Tuning, Query Optimization, Query Plan...

Dagocar Automotive Services GmbH

Databases, Microsoft Power BI, Microsoft SQL Server, Database Design...

Fido-Biznes LLC

HTML, CSS, JavaScript, jQuery, Jakarta Server Pages (JSP), SQL, Oracle, PL/SQL...

Experience

SQL - 8 years
SQL Server 2017 - 4 years
Oracle - 3 years
PL/SQL - 3 years
PostgreSQL - 2 years
PHP - 1 year
Python - 1 year
Machine Learning - 1 year

Availability

Full-time

Preferred Environment

PL/SQL, Visual Studio Code (VS Code), SQL Server 2017, Yii 2

The most amazing...

...tool I've delivered was the structure (procedures, tables, and business logic) for the automation of uncategorized, raw data to increase value for Power BI.

Work Experience

Database Architect

2022 - PRESENT

Realsoft LLC

Tuned several live PostgreSQL databases for better performance as DBA (shared buffer, WAL buffer, max_parallel_workers, maintenance_work_mem, etc.).
Optimized slow queries using optimizing query writing style, like correct usage of the group by refactoring selects, joins, and subqueries, and indexing found by the pg_stat_statements. Thus, reducing the query time of slower queries by 100 times.
Mentored other employees in accurately writing complex queries, designing tables, functions, procedures, etc.

Technologies: PostgreSQL, Databases, Oracle Database Tuning, Query Optimization, Query Plan, Database Administration (DBA), Database Architecture, SQL DML, Performance Tuning, SQL Performance, Data Queries, SQL Triggers, SQL Stored Procedures, Database Replication

Database Developer

2018 - 2022

Dagocar Automotive Services GmbH

Designed, altered, and maintained database objects such as tables, procedures, jobs, and corresponding constraints for business logic and reporting.
Developed a large amount of database views with different complexity for further development in Power BI.
Worked with data and created rules and routines for automated cleansing, categorizing, and filling of missing data.

Technologies: Databases, Microsoft Power BI, Microsoft SQL Server, Database Design, Relational Databases, Data Cleaning, Data Cleansing, Database Modeling, Database Backups, Microsoft Excel, T-SQL (Transact-SQL), CSV, Data Manipulation, Database Architecture, SQL DML, SQL Performance, Data Queries, SQL Triggers, SQL Stored Procedures

Programmer

2014 - 2018

Fido-Biznes LLC

Contributed to front-end design and the integration with server codes using HTML, XML, JavaScript, CSS, JSON, and Ajax.
Expanded expertise and switched to back-end development using SQL (in Oracle RDMS), PL/SQL, Java, JSP, J2EE, JSON, Ajax, and SOAP.
Worked for further development as a team member in loan management system for banks.
Contributed as a software developer to the “International Plastic Card Services TIETO” project that used MasterCard, Visa, and UnionPay systems for banks. Learned and used the TIETO workflow.
Served as a back-end developer on the “Plastic Card Services GlobUz” system for banks project. This is the national alternative for Visa and MasterCard.

Technologies: HTML, CSS, JavaScript, jQuery, Jakarta Server Pages (JSP), SQL, Oracle, PL/SQL, JSON, Ajax, XML, Database Design, Relational Databases, Database Modeling, Oracle Database, Oracle PL/SQL, PL/SQL Developer, Microsoft Excel, CSV, Data Manipulation, Database Architecture, SQL DML, SQL Triggers, MySQL Server

Experience

Evaluation of Sensor-based Recognition of Grazing and Drinking Behavior in Dairy Cattle

The Python-based framework reads sensor data located on the neck of the cows and helps to find the best models by learning, testing, and defining the most suitable sensor arguments for predicting behaviors such as walking, drinking, grazing, lying, etc. Thus helping farmers gather data and monitor their dairy cattle's wellbeing in real-time.

Education

2018 - 2021

Master's Degree in Software Engineering

University of Bamberg - Bamberg, Germany

2013 - 2017

Bachelor's Degree in Computer Engineering

Tashkent University of Information Technologies - Tashkent, Uzbekistan

Certifications

APRIL 2022 - PRESENT

DevOps , CI/CD (Continuous Integration/Delivery for Beginners)

Udemy

Skills

Libraries/APIs

jQuery

Tools

Microsoft Excel, Query Plan, Microsoft Power BI, Oracle Application Express (APEX), Microsoft Access

Languages

SQL, HTML, CSS, JavaScript, T-SQL (Transact-SQL), SQL DML, Python, Haskell, XML, Web Services Description Language (WSDL), PHP, C++

Paradigms

Database Design, DevOps

Storage

Relational Databases, Databases, PL/SQL, PostgreSQL, Microsoft SQL Server, Database Modeling, Oracle PL/SQL, PL/SQL Developer, Database Architecture, SQL Performance, SQL Triggers, SQL Stored Procedures, NoSQL, JSON, Google Cloud, SQL Server 2017, MySQL, Graph Databases, Database Backups, Database Administration (DBA), Oracle Database Tuning, MySQL Server, Database Replication

Platforms

Oracle, Oracle Database, Android, Java EE, Docker, Kubernetes, Visual Studio Code (VS Code)

Frameworks

Jakarta Server Pages (JSP), gRPC, Yii 2

Other

Data Cleaning, Data Cleansing, Data Modeling, CSV, Data Manipulation, Query Optimization, Performance Tuning, Data Queries, Machine Learning, Distributed Systems, Ajax, Apache Cassandra, SOAP, Sensor Data, CI/CD Pipelines, Geospatial Data

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring