Jonathan Durda
Cuyahoga County Juvenile Court
Berea,OH
17
years of professional experience
Knowledgeable Database Administrator with solid background in database development, delivering efficient and reliable database solutions. Proven ability to design, implement, and optimize databases to enhance system performance and data integrity. Demonstrated expertise in SQL and database management, ensuring seamless data operations and supporting business objectives.
Work History
Database Developer
2 Years 5 Months- Managed entire database for the entire court for the Juvenile Court Division of the Cuyahoga County Court of Common Pleas, the second oldest and one of the largest Juvenile Courts in the country. Handled data requests from Judges and Magistrates to correct clerk and Jurist data mistakes, create SSRS reports and handle data requests in a database with tens of millions of rows.
- Improved the efficiency of the database by monitoring Performance Dashboard in SSMS and identified expensive queries, missing indexes and unused indexes slowing down the database. Created an Audit in the database and customized the Audit to monitor for any suspicious activity in the database.
- Enhanced accuracy and reduced data issues with Form D report submitted monthly to Ohio Supreme Court, saving court employees time by minimizing the need for corrections.
- Optimized database performance by monitoring Performance Dashboard in SSMS, identifying expensive and unused queries, and implementing a customized Audit to track suspicious database activity.
- Learned JailTracker software to create reports for Detention Center staff.
- Currently working with Journal Technologies to transfer Court software over to the new third party vendor, who will begin serving as the Court’s software provider sometime in late 2027.
Applications Programmer III
13 Years 10 Months- Designed, developed, and modified web pages in ASP.NET and C# in Visual Studio 2019/2022 IDE based on business needs.
- Created and modified SQL queries, views, triggers, cursors, and stored procedures in SQL Server Management Studio to manage budgeted costs for active contracts.
- Fluent in creating and modifying reports in SSRS and Microsoft Reporting Services and IBM Cognos.
- Developed intranet site integrated with Windows SharePoint to enhance internal communication and resource sharing.
- Strong knowledge of Deltek’s Costpoint and Cobra software utilizing both the front end and back end to load project budget data into the system.
Associate
9 Months- Processed up to 50 orders daily, achieving 100% customer satisfaction
- Managed daily operations to ensure efficient food preparation and service.
- Trained and mentored new associates on company policies and customer service standards.
- Implemented inventory control measures to reduce waste and optimize stock levels.
Education
Master of Business Administration - Computer and Information Sciences
Graduation Date: December2015
Bachelor of Business Administration - Computer and Information Sciences
Graduation date: December 2008
Skills
SSMS
TSQL
Stored Procedures
Views
Triggers
Cursors
Clustered and Nonclustered Indexes
User Defined Functions
Database Mail
Data imports
User role management
Database audit management
Performance analysis
Query optimization
Visual Studio 2017/2019/2022 IDE
Languages: C#
ASP.NET
JavaScript
SSRS report management
Windows Services
Team Foundation Server
Microsoft Sharepoint 2017
Microsoft Excel
iOS application development
Ohio Supreme Form D Reporting
Ohio Courts Network (OCN) Integration
Deltek Costpoint
IPhone Apps (Limited Experience
self-taught)
Problem Solving at a High Level
IBM Cognos Report Creation and Modification
Problem Solving at a High Level
Other Skills
- Grand Slam Picks (Sports Prediction System)
- 8/2015-1/2026
- Designed, developed and successfully created from scratch, on my own time, a prediction modeling system to predict the results of Major League baseball, National Basketball Association and National Football League games. Began officially predicting game outcomes in 2019, with predictions published on Grand Slam Picks X and Facebook pages, with results tracked daily and weekly for NFL.
- Created my own way to rank individual athletes in each sport, daily, based on personal experience and data driven approach
- Created a simple AI model that simulates past game outcomes millions of time in an effort to find the most likely method to correctly predict future game outcomes
- Developed a Windows Service in Visual Studio C# to run for each sport that runs 24 hours a day, constantly looking for game results, prediction results and updating daily game results and giving players a daily rating using methods that I have been refining since 2015 to weight statistical categories that best predict game outcomes.
- Also developed an iPhone app in Visual Studio 2022 to send app alerts with a JSON payload to my personal iPhone to inform me of starting lineups and whether there is a game selection for each game once starting lineups have been, finalized, to ensure data accuracy and correct output to end users reading my work.
- Have enjoyed success of 10 full seasons of profitable outcomes with a combination of game selections and game point total selections. Continual improvement always being made to improve profitability and consistency of selections.
Timeline
Database Developer
Cuyahoga County Juvenile Court
04.2024 - CurrentRead More
Applications Programmer III
Zin Technologies
06.2010 - 04.2024Read More
Associate
Panera Bread Company
08.2009 - 05.2010Read More
Cleveland State University
Bachelor of Business Administration from Computer and Information Sciences
Read More
Cleveland State University
Master of Business Administration from Computer and Information Sciences
Read More