Jayson Gary

DataOps Engineer@ OneOK

Oklahoma City Metropolitan Area

About

I am a MySQL Database Administrator with a BBA in Management Information Systems from the University of Oklahoma. I've been working at Paycom, a leading provider of payroll and HR solutions, since April 2022, and I've been promoted twice in less than a year. At Paycom, I support the production environment databases, develop and maintain internal webpages for scheduling tasks, train new DBA resources, and set up the infrastructure for new database instances and clusters. I also manage the MySQL access and permissions on test and live environments, and ensure high availability and security. I enjoy automating processes and solving problems, and I'm always eager to learn new skills and technologies.

Experience

  • DataOps Engineer II at ONEOK
    Nov 2024 - Present · 1 yr 9 mos

  • Paycom (Full-time · 2 yrs 7 mos)
    • Database Administrator II
      Oct 2023 - Oct 2024 · 1 yr 1 mo

      Orchestrated a 3-phase overhaul of user access management protocols, implementing role-based access controls and strong password authentication, reducing unauthorized access attempts and enhancing data security measures. Managed the end-to-end execution of a MySQL upgrade initiative, fostering collaboration with interdepartmental teams and achieving a 40% improvement in database efficiency and data processing speed. Orchestrated the setup of new production and test database instances, implementing automated scripts that reduced deployment time and minimized errors, resulting in a seamless transition for the team.

    • Database Administrator I
      Jan 2023 - Oct 2023 · 10 mos

      Supervised over 1500 Production and DR database instances during business hours and after hours through a 24/7 on call rotation. Engineered Powershell and Python scripts to automate testing procedures to reduce after hours work and increase Trained new DBA employees in all aspects of database administration.

    • Database Administration Analyst
      Apr 2022 - Jan 2023 · 10 mos

      Supervised over 800 TEST Environment databases between the DEV/QA/STG environments. Executed weekly schema rebuilds and schema reapplication on lower environments for DEV/QA usage and testing. Architected and enforced stringent MySQL access control measures on TEST environments, enhancing data security and minimizing unauthorized access risks. Engineered infrastructure for new database instances, aligning server provisioning across diverse environments; streamlined operations and reduced infrastructure setup time by 50%, enhancing system reliability and performance across the board. Implemented traditional and group replication clusters to ensure uninterrupted operation of TEST environments, resulting in a 40% reduction in system downtime and a 25% increase in testing efficiency.

  • Billing Specialist at 180 Medical
    May 2021 - Apr 2022 · 1 yr

    • Filed claims to patients insurance company in a timely manner • Utilized problem solving skills in order to solve issues with insurance companies denying claims. • Collaborated with insurance companies and patients to resolve any billing discrepancies • Provided excellent customer service to patients by addressing any concerns they had with their bill. • Consistently scored well on all internal audits of my work

  • Best Buy (Moore, Oklahoma)
    • Customer Service Specialist
      Jan 2020 - Mar 2021 · 1 yr 3 mos

      · Developed monthly one on one’s for all front-end employees. · Conducted interviews and hired new employees. · Managed the supplies expense and kept the store on budget. · Coached front-end employees and made sure they knew what was expected of them. · Counted the registers and the safe each morning to ensure we maintained accuracy.

    • Keyholder
      Oct 2019 - Jan 2020 · 4 mos

      Opened the store and made sure all employees were on task. Kept the building secure throughout all overnight shifts. Made weekly task lists for the merchandising team

    • Merchandise Specialist
      May 2019 - Jan 2020 · 9 mos