Spencer Johnston

Spencer Johnston Email and Phone Number

Senior Data Architect | Data Engineer | Db2 LUW | SQL Server | Databricks | ADF @ Duly Health and Care
Union Grove, WI, US
Spencer Johnston's Location
Union Grove, Wisconsin, United States, United States
Spencer Johnston's Contact Details

Spencer Johnston work email

Spencer Johnston personal email

n/a
About Spencer Johnston

I am currently working as a Database Administrator at Uline. I graduated from Loyola University of Chicago with a B.S. in Information Technology with a minor in Management.

Spencer Johnston's Current Company Details
Duly Health and Care

Duly Health And Care

View
Senior Data Architect | Data Engineer | Db2 LUW | SQL Server | Databricks | ADF
Union Grove, WI, US
Employees:
2905
Spencer Johnston Work Experience Details
  • Duly Health And Care
    Duly Health And Care
    Union Grove, Wi, Us
  • Redacted Healthcare Place
    Sr. Data Architect
    Redacted Healthcare Place Jul 2023 - Present
    Migrated data from legacy SQL Server and Oracle databases to DatabricksBuilt out medallion architecture moving data through bronze, silver and goldCreated ETL pipelines and reports to utilize Call Center and Workday data
  • Uline
    Senior Database Administrator
    Uline Dec 2022 - Jul 2023
    Pleasant Prairie, Wi, Us
    Installed and configured MongoDB instances for HCL Sametime 12 Implementations
  • Uline
    Database Administrator
    Uline May 2021 - Dec 2022
    Pleasant Prairie, Wi, Us
    Creating and designing a new database to help improve the offramp efficiency from DB2 LUW and SQL ServerDeveloping ETL processes using SSIS, Attunity and shell scripts utilizing db2 loads and exportsCreating data integration pipelines that bring data from legacy serversManaging data replication in an environment that utilizes HADR and is a PureScale clusterModernizing production scripts to use common library functions that have built in error handling and alertingWorking with project teams in an agile environment to help gather requirements, tune queries, and deploy database changesPatching, installing and upgrading DB2 LUW databases and serversMentoring juniors in our standard practices for deployments and other day to day activities
  • Uline
    Associate Database Administrator
    Uline May 2020 - May 2021
    Pleasant Prairie, Wi, Us
    Installation of DB2 LUW on Red Hat LinuxCreation and management of database objectsScripting routine maintenance and database functions using shell scripting and PERLHands on experience with HADR and various disaster relief activitiesPart of the Uline data migration project to move data off of DB2i AS400 to DB2 LUWWorking with SQL Server 2014 and 2016Maintaining and creating stored procedures and jobsGranting permissionsWorking with SSIS to move data between databases as well as different relational databasesConfiguration and installation of Attunity/Qlik Replicate
  • Biltmore Country Club
    High Honor Caddie
    Biltmore Country Club May 2014 - Oct 2020
    North Barrington, Illinois, Us
    Train 30+ new Caddies per year in the basic caddie skills.Meet with corporate executives on a day to day basis during the golf season to provide them my services.
  • Biltmore Country Club
    Golf Instructor
    Biltmore Country Club Apr 2015 - Aug 2018
    North Barrington, Illinois, Us
    Taught 100+ children per year ranging from the ages of 5-12 the game of golf.Responsible for the safety of the children and to lead various drills.
  • Loyola University Chicago
    Undergraduate Research Assistant
    Loyola University Chicago Aug 2018 - May 2020
    Chicago, Illinois, Us
    Contributed to various research projects among the Computer Science Department.Used various data to determine improvements for the first Object-Oriented Programming Course.Utilized RapidMiner and R to create graphs and relationships between data. Assisting Loyola University Chicago in collaboration with Oklahoma State in research into Phishing and how personality types affect if people click on it.Assisting multiple professors and graduate students in building a miniature autonomous vehicle to run tests to see how humans know if their vehicle has gone rogue.
  • Loyola University Chicago
    Student Instructor
    Loyola University Chicago Aug 2018 - Dec 2018
    Chicago, Illinois, Us
    Helped tutor students both privately after class and in class. Taught students the value of understanding and using the terminal/command prompt for their coding projects and how to navigate between files.
  • Caradvise
    Software Developer Intern
    Caradvise Jun 2017 - Aug 2017
    Chicago, Illinois, Us
    Checked for bugs in applications throughout various mediums including iOS, Android, and a web interface.Used HTML, JavaScript, CSS, and Java to create menu interfaces throughout the app and web interfaces.Utilized AWS to create a long-term database for storage of customer information.Collected numerical data to be stored in Microsoft Excel and presented the data using Microsoft PowerPoint following strict deadlines.

Spencer Johnston Skills

Linux Mongodb Object Oriented Programming Microsoft Sql Server Data Collection Original Research Rapidminer Microsoft Access Java Microsoft Word Sql Server Integration Services Microsoft Excel Erwin Microsoft Project Ubuntu Python Sql Ibm Db2 Problem Solving T Sql Stored Procedures Transact Sql

Spencer Johnston Education Details

  • Loyola University Chicago
    Loyola University Chicago
    Information Technology
  • Loyola Academy
    Loyola Academy
    High School
  • Jesuit High School Portland
    Jesuit High School Portland
    High School

Frequently Asked Questions about Spencer Johnston

What company does Spencer Johnston work for?

Spencer Johnston works for Duly Health And Care

What is Spencer Johnston's role at the current company?

Spencer Johnston's current role is Senior Data Architect | Data Engineer | Db2 LUW | SQL Server | Databricks | ADF.

What is Spencer Johnston's email address?

Spencer Johnston's email address is sj****@****luc.edu

What schools did Spencer Johnston attend?

Spencer Johnston attended Loyola University Chicago, Loyola Academy, Jesuit High School Portland.

What skills is Spencer Johnston known for?

Spencer Johnston has skills like Linux, Mongodb, Object Oriented Programming, Microsoft Sql Server, Data Collection, Original Research, Rapidminer, Microsoft Access, Java, Microsoft Word, Sql Server Integration Services, Microsoft Excel.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.