Nick Mcalpin

Nick Mcalpin Email and Phone Number

Senior Data Engineer @ The Shipyard
Nick Mcalpin's Location
Antelope, California, United States, United States
Nick Mcalpin's Contact Details
About Nick Mcalpin

• Highly experienced with relational databases such as SQL Server, Oracle, and MySQL• Strong emphasis on database performance, reliability, and development• Extensive experience with full stack system engineering/administration• Self-motivated and driven to improve data solutions• Deep fault analysis/diagnostic capabilities• Exposure to NoSQL / MongoDB• Strong ability to perceive issues from the perspective of the client; advocate for the user experience• Experience with PII, PHI, banking, credit unions, healthcare, laboratory informatics (including chemical inventory management, regulatory reporting, and GMP), biometrics, and marketing

Nick Mcalpin's Current Company Details
The Shipyard

The Shipyard

View
Senior Data Engineer
Nick Mcalpin Work Experience Details
  • The Shipyard
    Senior Data Engineer
    The Shipyard Aug 2024 - Present
    Columbus, Ohio, Us
    View
  • Safe Credit Union
    Senior Data Engineer
    Safe Credit Union Apr 2021 - Aug 2024
    Folsom, California, Us
    Principal project: custom integration of banking data between Fiserv DNA (bank core platform) and Fiserv Informent (data warehouse).• Reverse engineer legacy Informent data warehouse and legacy Fiserv Spectrum core• Identify and document existing Informent data ingestion requirements for loading Spectrum data• Develop transformations to structure DNA data as faux Spectrum data for ingestion into Informent• Develop processes and infrastructure for automated daily loading of DNA data into Informent• Develop additional transformations for loading Fiserv CCM (credit card) data into Informent• Oracle RDBMS / MS SQL Server / GitHub / Jira / SSRS / Power BI / HP IMAGE / IBM Cognos Powerhouse
    View
  • Alluma
    Lead Database Performance Engineer
    Alluma Jan 2019 - Apr 2021
    Principal project: Health-e-Arizona• Identify database performance improvement opportunities via monitoring and analysis of database servers (DMV's, extended events, Query Store, etc.)• Diagnose critical performance issues in production database environments (blocking, contention, bad execution plans, issues with statistics, etc.)• Maintain and improve database reliability via guidance and continual improvement• Provide guidance in schema design, efficient SQL/T-SQL, index strategies, set based logic, etc. from a performance perspective• Refactor database objects to improve performance• Evaluate proposed changes to database objects• Microsoft SQL Server / Team Foundation Server (TFS) / Visual Studio / Redgate / New Relic / Spotlight
  • Nec Corporation Of America
    Database Engineer
    Nec Corporation Of America Jun 2018 - Jan 2019
    Irving, Texas, Us
    Contract position in the Advanced Recognition Systems biometrics division.• Diagnose complex database faults in Oracle (PL/SQL, data conditions, etc.)• Provide solutions to code issues (PL/SQL, Java)• Provide solutions to data issues (PL/SQL, DML)• Diagnose faults across full stack (Linux / Wildfly / Java; Windows / IIS)• Install, configure, and diagnose Nagios monitoring (NRPE, Python monitoring scripts, NSClient++)
    View
  • Wire Stone, Part Of Accenture Interactive
    Database Administrator
    Wire Stone, Part Of Accenture Interactive Jun 2014 - May 2018
    Principal project: HP Sales CentralDatabase administration encompassing performance, development, engineering, and architecture. • Performance tuning (indexing, query optimization, etc.) • Development and maintenance of mission-critical 24/7 Extract-Transform-Load (ETL) process • Establish and maintain DB synchronization via transaction replication • Migration of all data storage systems and processes to the cloud (Azure) • Develop T-SQL for new application features/functionality • Design new data models • Reporting • Microsoft SQL Server / Git / Visual Studio / Jira / Agile
  • Biovia - A Dassault Systèmes Company
    Advisory Database Administrator
    Biovia - A Dassault Systèmes Company Sep 2013 - Jun 2014
    Vélizy-Villacoublay, Fr
    ChemSW was acquired by Accelrys in September of 2013, and Accelrys was acquired by Dassault Systèmes in April of 2014. The Accelrys acquisition was subsequently rebranded as BIOVIA.During my time under the BIOVIA/Accelrys banners, I continued in the DBA and DevOps roles I held with ChemSW. Additionally, I also took on responsibility for migrating data from legacy ChemSW systems into Accelrys systems.
    View
  • Chemsw
    Database Administor / Devops
    Chemsw Jul 1998 - Sep 2013
    ChemSW was an small, agile software company that developed solutions for managing chemical inventory in regulated environments. During my 15+ years with ChemSW, I performed many roles, including:• Database administration (incl. architecture & engineering) for internal and client facing solutions• Software & database development; management of a complete SDLC for a successful product• Design solutions for various regulatory compliance challenges• Consulting and engineering support to internal and external clients• Management of internal IT systems, including servers, VOIP telephony, disaster recovery, etc.During my time with ChemSW, I was able to effect significant improvements to the quality of projects I worked on; reductions in support load were realized which increased profitability.ChemSW was acquired by Accelrys in September of 2013, and Accelrys was acquired by Dassault Systèmes in April of 2014.
    View

Nick Mcalpin Skills

Databases Microsoft Sql Server Software Development Oracle Sql Pl/sql Stored Procedures T Sql Testing Mongodb Database Administration Windows Server Web Applications Database Design T Sql Stored Procedures Iis Performance Tuning Project Management Vmware Workstation Network Administration Relational Databases Sql Tuning Oracle Rdbms Database Triggers Vmware Esx N Tier Web Development Laboratory Informatics Wireshark Performance Improvement Debugging Code Asp Wireless Networking Cisco Ios Cisco Voip Process Monitor Process Explorer Soldering Test Equipment Chemical Inventory Gmp Troubleshooting Hardware Diagnostics Debugging Disaster Recovery Assembly Language Agile Methodologies

Nick Mcalpin Education Details

  • Oregon Institute Of Technology
    Oregon Institute Of Technology
    Computer Engineering Technology

Frequently Asked Questions about Nick Mcalpin

What company does Nick Mcalpin work for?

Nick Mcalpin works for The Shipyard

What is Nick Mcalpin's role at the current company?

Nick Mcalpin's current role is Senior Data Engineer.

What is Nick Mcalpin's email address?

Nick Mcalpin's email address is ni****@****one.com

What is Nick Mcalpin's direct phone number?

Nick Mcalpin's direct phone number is +191644*****

What schools did Nick Mcalpin attend?

Nick Mcalpin attended Oregon Institute Of Technology.

What are some of Nick Mcalpin's interests?

Nick Mcalpin has interest in Vintage Technologies, Aviation, Learning, Diy Projects, Linux, Fixing Anything That Is Broken, Reading, Digital Photography, Sound Reproduction, Engine Management Systems.

What skills is Nick Mcalpin known for?

Nick Mcalpin has skills like Databases, Microsoft Sql Server, Software Development, Oracle, Sql, Pl/sql, Stored Procedures, T Sql, Testing, Mongodb, Database Administration, Windows Server.

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.