Michael B.
Batumi, Georgia
100%
Job Success
SQL Server, query optimization, BI, Power BI, SSAS, TSQL, ETL
$40.00/hr
• Database developer and architect with over 10 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Strong hands-on experience using Microsoft SQL Server databases and related tools.
• Cloud (Azure or AWS) and on-prem environment
• Experience in Extraction, Transformation and Load (ETL) strategy, design, and implementation.
• Experience in DWH and Reporting systems development and maintenance
• Design and implementation of normalized data structures, de-normalized structures, and dimensional structures
• Business logic development in SQL language
• SQL stored procedures and functions
• Design, build and maintain SQL scripts and complex queries for data processing
• Management and implementation of database models, data flow diagrams, database schemas, DB scripts and DTD schemas
• Database performance tuning and SQL query optimization
• Experience in design, build and deployment effective SSIS packages.
• Using SSIS to move, load, and transform data.
• Experience with logging and error handling in SSIS Packages.
• Building/publishing/sharing dashboards/reports in SSRS and Power BI
Technical Skills
• Databases: MS SQL Server, PostgreSQL, Google Spanner, Google BigQuery, MySQL, Oracle
• Microsoft BI Tools: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Power BI
• BI/Reporting Tools: Oracle-Hyperion BI, SAP BI, Oracle BI, DOMO
• Programming languages: SQL (TSQL, PLPGSQL, etc.), MDX, Python, R, C, C++, Pascal (Turbo Pascal, Object Pascal)
• Modeling: IDEF0, IDEF1, IDEF1X, IDEF3, DFD, UML (BpWin/ErWin, Rational Rose).
Work history
Work history
Postgres Optimization
5.00
Jul 9, 2023
-
Mar 17, 2025
Private earnings
ER models, relational models, SQL, databases
5.00
Mar 4, 2025
-
Mar 6, 2025
"good"
Private earnings
SQL Server developer needed for database and stored procedure support and maintenance
4.00
Jun 7, 2022
-
Sep 25, 2024
Private earnings
Port DB from Microsoft SQL Server to Babelfish for PostgreSQL or Babelfish for AWS Aurora PostgreSQL
5.00
May 25, 2022
-
May 13, 2024
Private earnings
60 minute consultation
5.00
Oct 22, 2023
-
Oct 26, 2023
"I recently consulted with Michael and was thoroughly impressed. Michael provided practical advice and demonstrated a genuine commitment to problem solving. I wouldn't hesitate to recommend him for any well-suited…
Private earnings
Convert function written in MS Access to work in MS SQL Server
5.00
Dec 10, 2022
-
Jan 5, 2023
"Michael delivered great work with great responsiveness and work was completed quickly. Everything I could have asked for!"
Private earnings
PostgreSQL recursive query
5.00
Dec 3, 2022
-
Dec 12, 2022
Private earnings
SQL Server 2017: Troubleshoot and fix slow performing query
5.00
Apr 28, 2022
-
Jul 22, 2022
Private earnings
1. On original trigger, make it work if multiple records upated. 2. Brand New Stored Proc
5.00
Jul 12, 2022
-
Jul 19, 2022
"Accurate.
Great solutions. Not just the easy solution. But, efficient solutions.
Timely.
Easy to work with.
Understands the need very quickly."
Private earnings
PostgreSQL query optimization
5.00
May 5, 2022
-
May 9, 2022
"Very experienced, a master of SQL query optimization. I highly recommend."
Private earnings
MS SQL Server tutoring / SP improvements/tuning
Jun 13, 2023
-
Present
Job in progress
Private earnings
SQL Developer for Postgres SQL Transformations
Mar 3, 2023
-
Present
Job in progress
Private earnings
Create trigger to add rows to another table
Jul 12, 2022
-
Present
Job in progress
Private earnings
Import Data
Jan 12, 2022
-
Present
Job in progress
Private earnings
I need a multi level running sum sql in Access
Jul 8, 2021
-
Present
Job in progress
Private earnings
SSIS Package Lookup Transformation
Oct 14, 2020
-
Present
Job in progress
Private earnings
SQL Server Transact SQL
Jan 19, 2020
-
Present
Job in progress
Private earnings
sql server- TSQL script optimization
Dec 24, 2019
-
Present
Job in progress
Private earnings
Run through of SQL-database
Sep 24, 2018
-
Present
Job in progress
Private earnings
Need help writing SQL queries for ecommerce dataset
Aug 1, 2018
-
Present
Job in progress
Private earnings
Michael B. has more jobs. Create an account to review them
Skills
Skills
- Performance Optimization
- Database Architecture
- SQL Programming
- Transact-SQL
- PostgreSQL Programming
- Microsoft SQL Server
- Database Optimization
- Query Tuning
Project catalog
Get started working with Michael quickly with these predefined projects.
Get started working with Michael quickly with these predefined projects.
You will get expert level consulting on Microsoft SQL query optimisation
From $100
1 day delivery