Jason Josephson Email & Phone Number

Remote

Canada

Ready to share the DBA magic, I launched Data Meeple Consulting to provide remote-source, cost-effective database management solutions. From designing server infrastructure to scalable support, I offer flexible consulting engagements and hands-on, longer-term project partnerships to ensure you get the solution you need. My services span:𝗗𝗲𝘀𝗶𝗴𝗻 &.

Remote

Contracted through Data Meeple Consulting to assist with asset management, ITIL processes, and operational efficiency.✔️ Data Centre Migration: Investigated Production infrastructure and mapped out environment, from the Customers that work with Gemstone, to the URLs that those customers use, to the applications and servers they connect to, right down to.

• Contracted through Data Meeple Consulting to enhance operational efficiency, security, and availability of IT assets. Assess infrastructure and repair issues with configuration, backups, and maintenance plans. Oversee.
• Initiated investigation of SQL server estate to ensure all servers are accounted for and included in queries, improving monitoring across all servers and enabling growth metrics to be tracked and pulled from central.
• Installed updates on 170 SQL servers with minimal downtime or disruption.✔️ Petroleum Separation: Lead the DBA team tasked with separating Petroleum SQL Servers from Enterprise BHP SQL Servers.
• Created over 100 pages of documentation outlining common practices, accountibilities, and tasks for managing the Petroleum Estate.
• Supplimented documentation with 15 hours of recorded video going through the documentation.
• Designed the end-to-end process for migrating databases to new servers.

Saskatoon, Saskatchewan, Canada

• Turned around performance at poorly documented Potash environment which encompassed 12 individual unmonitored servers. Conducted swift assessment to prioritize outstanding issues and led mission critical updates and.
• Saved $200,000 in annual licensing fees by reducing server footprint (slashed core count from 72 to 32).
• Maintained high availability for all applications with zero unplanned outages from 2015 to end of tenure in 2021.✔️ SQL Management System: Designed and built system based on SQL Server and tSQL code to inventory.
• Harnessed extensive feature set, including daily checks for common issues, weekly data capture of database inventory, automated restore testing, and maintenance job windowing and alerting.
• Responded to issues with speed and precision, receiving outage, issue, and growth alerts within 30-minute windows. ✔️ SQL Consolidation Project: Hand-selected to set up a Database as a Service (DaaS), working.
• Developed high and low-level documentation for DaaS environments, such as Dev, Test, QA, and Production environments with standalone and high availability options.

Saskatchewan, Canada

• Supported business applications through production implementations, infrastructure activities, and disaster recovery exercises. Collaborated with a cross-disciplinary team to solve complex puzzles and develop.
• Migrated or decommissioned 56 application databases on a single SQL 2000 server to 2 new SQL 2008 R2 servers, completing the entire project in under 4 months with no unplanned outages.✔️ Gaming Data Ingestion: Reviewed.
• Re-wrote extract, transform, load (ETL) scripts to reduce data ingestion time from 3-4 hours to under 1 hour.
• Created an ETL script to capture and analyze missing time-based data, improving accuracy of player data and rankings.✔️ Kiosk System Project: Architected database structure for new kiosk system (providing automated.
• Built a highly flexible and customizable system hailed as one of the most complex in the industry at the time.

Saskatchewan, Canada

• ✔️ SQL Server Upgrade and Consolidation project
• Created an HP Polyserve SQL Failover Cluster (now known as DxEnterprise)
• Migrated and upgraded existing SQL 2000 servers to SQL 2005 and 2008
• Designed new maintenance plans and recovery strategies✔️ Programming Standards and Code Stewardship
• Drove creation of coding standards for Visual Basic 6, VB for Apps and tSQL
• Embedded process for code reviews, cleanup and modernization

Saskatchewan, Canada

• ✔️ End User Support
• Provided support for 1800+ students, staff and faculty
• Supported Service Desk providing in-person troubleshooting
• Performed PC image testing and deployment across entire fleet on annual basis✔️ Training
• Taught five sections of Comm 110 Introductory Computer Skills course annually
• Provided instruction on use of Microsoft Office products, basic web page design and computer skills

Saskatchewan, Canada

As the Regional Coordinator, I did the following:- Designed and developed the Saskatchewan CAP website- Designed and developed the Saskatchewan CAP Training manual- Provided hands-on training to CAP Youth workers