Jonathan Knapp
Mentor
Rising Codementor
US$8.00
For every 15 mins
ABOUT ME
Senior SQL developer with 12+ years of experience.
Senior SQL developer with 12+ years of experience.
Hi,
I can help you design, build and troubleshoot database solutions with SQL Server and SQLite. Whether the goal is to simply get started building a simple project or to create, debug or tune an advanced more complex database system, I look forward to discussing your needs and goals.
Eastern Time (US & Canada) (-05:00)
Joined November 2024
EXPERTISE
12 years experience
Designing database solutions to solve business problems. Extensive experience with Triggers and advanced Stored Procedures. An expert a...
Designing database solutions to solve business problems. Extensive experience with Triggers and advanced Stored Procedures. An expert at design, building, troubleshooting and tuning database solutions
15 years experience
Designing database SQLite solutions to solve business problems. Extensive experience with advanced application of Triggers to do impleme...
Designing database SQLite solutions to solve business problems. Extensive experience with advanced application of Triggers to do implement many of the same capabilities that normally require Stored Procedures in other versions of SQL. An expert at design, building, troubleshooting and tuning database solutions and mobile applications of SQLite.
15 years experience
Extensive experience designing, building, troubleshooting, & tuning SQL Databases
Extensive experience designing, building, troubleshooting, & tuning SQL Databases
REVIEWS FROM CLIENTS
Jonathan's profile has been carefully vetted and approved as a Codementor. Connect with Jonathan now, and leave a review for them once you're done!
EMPLOYMENTS
CTO
Simply Reliable Inc.
2012-01-01-Present
Developed and built a SaaS application that provides Inventory Control, Proposal Generation, Invoicing, Purchasing, Payroll time tracking...
Developed and built a SaaS application that provides Inventory Control, Proposal Generation, Invoicing, Purchasing, Payroll time tracking, Accounting Integration, Automated Workflow, Project Management and Engineering to companies that do sales, installation and service.
Designed SQL Server backend with sophisticated Stored Procedures and Triggers to implement business logic.
Designed and built a iOS / Android application that uses a local SQLite database that syncs with SQL Server in the cloud, allowing most functions in the app to work offline and then sync to server when internet is available.
Developed a desktop application that uses a rules based AI approach to create complex, large sheet, multi-page drawings automatically with minimal user input. In 2014 this algorithm was awarded Patent number: 8719758, Methods and apparatus for automated wiring diagram generation.
C#
SQLite
Xamarin
View more
C#
SQLite
Xamarin
Azure SQL Server
View more
PROJECTS
Mobile Database with Sync to Cloud
Simply Reliable
2019
This project created a SQLite database replica of data from cloud based SQL Server database. Having local data allows users to perform m...
This project created a SQLite database replica of data from cloud based SQL Server database. Having local data allows users to perform most functions when offline knowing that their work will sync to the cloud when internet becomes available.
This involved using Triggers in SQL to perform like stored procedures, allowing business logic to be implemented in the database and simplifying app design.
SQLite
Design
Logging
View more
SQLite
Design
Logging
Xamarin
Troubleshooting
Database Tuning
Trigger
.NET Core
Problem solving
Azure SQL Server
View more