Kris Magat Email & Phone Number

Sacramento, California, United States

Developed dynamic stored procedures to provide custom functionality and database maintenance that simplified SQL agent job setup minimizing errors and reducing initial setup time by at least 50%.Refactored failing SQL agent jobs and associated stored procedures improving run-time efficiency and eliminating errors.Deployed Ansible architecture on Linux VM and authored playbooks in YAML to handle orchestration and automation of tasks for Windows and Linux platforms concerning… Show more Developed dynamic stored procedures to provide custom functionality and database maintenance that simplified SQL agent job setup minimizing errors and reducing initial setup time by at least 50%.Refactored failing SQL agent jobs and associated stored procedures improving run-time efficiency and eliminating errors.Deployed Ansible architecture on Linux VM and authored playbooks in YAML to handle orchestration and automation of tasks for Windows and Linux platforms concerning system security, maintenance, and optimization.Configured Oracle Cloud integration with on-premise systems and created Powershell automation scripts to handle database cloud backups for 50+ SQL servers resulting in increased resource availability and cost-savings.Managed JIRA for the DBA team to ensure all issues/tickets are handled according to department standards and SLA’s. Show less

Rewrote the Node.js server to interact with both PostgreSQL and MySQL databases, expanding consumer support to 80% of existing databases and ensuring accuracy in creating JSON objects for front-end consumption.Designed and implemented custom React and React Flow components to revamp the ERD visualization UI, resulting in improved design and stability, five new features, and a 50% reduction in front-end UI code.Refactored 100% of the codebase using TypeScript to create decoupled… Show more Rewrote the Node.js server to interact with both PostgreSQL and MySQL databases, expanding consumer support to 80% of existing databases and ensuring accuracy in creating JSON objects for front-end consumption.Designed and implemented custom React and React Flow components to revamp the ERD visualization UI, resulting in improved design and stability, five new features, and a 50% reduction in front-end UI code.Refactored 100% of the codebase using TypeScript to create decoupled functions with simplified logic and removed unused dependencies, resulting in increased code quality, faster development, and easier maintenance.Engineered a global state-handling architecture using Zustand, reducing boilerplate code and simplifying access to state, resulting in a 30% decrease in developer time spent on state management. Show less

Deployed a Loan Operating System (LOS) solution, including development of algorithms used in automated underwriting and API integration for 20+ software vendors, resulting in a modernized UI, digitized workflows, and streamlined processes.Administered the LOS specifically with content creation, user management, vendor interface, product updates, and automated underwriting systems to ensure compliance with company regulations, policies and industry guidelines. Conducted training… Show more Deployed a Loan Operating System (LOS) solution, including development of algorithms used in automated underwriting and API integration for 20+ software vendors, resulting in a modernized UI, digitized workflows, and streamlined processes.Administered the LOS specifically with content creation, user management, vendor interface, product updates, and automated underwriting systems to ensure compliance with company regulations, policies and industry guidelines. Conducted training for new and existing staff regarding Loan Operating Systems, internal process flows, and best practices.Honored with the President's award for displaying outstanding qualities of Teamwork, Integrity, Professionalism, and Service. Show less