Systems & Database Engineer

Company Description: John Galt Solutions is a recognized leader in supply chain planning, leveraging its AI-powered Atlas Planning Platform to accelerate digital transformation and unify data, decisions, and operations on a single platform. With a focus on delivering tangible business outcomes, driving innovation in supply chain planning, and advancing machine learning and AI, John Galt Solutions empowers businesses to unlock effective supply chain strategies. The company collaborates with iconic and innovative brands across various industries and sizes, helping them solve critical operational challenges, reduce risk, and achieve transformational results. Professional Profile Summary A highly versatile technical professional capable of managing the entire lifecycle of server infrastructure, database health, and complex data integrations. This individual is equally comfortable performing hands-on troubleshooting (Help Desk), architecting server migrations (Sysadmin), optimizing database performance (DBA), and building automated data pipelines (Data Engineer). They possess a unique "full-stack" operational mindset, ensuring that the underlying hardware/OS, the database layer, and the business software (CRM/ERP/Helpdesk) all communicate seamlessly. Core Competencies Systems Administration & Infrastructure (Cloud/Hybrid) OS Management: Expert-level knowledge of Windows Server (including migrations to Win2025) and Linux (specifically for sFTP environments).Cloud & Virtualization: Experience managing IaaS (specifically OVHcloud), maintaining "Golden Images" for rapid deployment, and managing server environments across multiple global regions (US, EU, AUS).Lifecycle Management: Ability to design and execute processes for server provisioning (new creation) and decommissioning (customer removal).Monitoring & Observability: Proficiency in infrastructure monitoring tools (Zabbix) and maintaining documentation for complex environments (mRemoteNG).Database Administration (DBA) & Development SQL Server Mastery: Deep knowledge of SQL Server (versions 2022/2025), including installation, maintenance (backups, permissions), and performance tuning (system sizing).Automation & Scripting: Ability to manage complex SQL Agent jobs and write advanced T-SQL (Stored Procedures, Views, and Triggers) to extend system functionality.Capacity Planning: Skill in "Server Tier Sizing"—the ability to analyze resource needs and strategically place customers on hardware to optimize cost and performance.Data Engineering & Integration (ETL) ETL Pipelines: Advanced proficiency in building and maintaining data movement workflows using SSIS (SQL Server Integration Services) and Talend.System Integration: Ability to bridge disparate business platforms (Netsuite, HubSpot, Zendesk, and internal proprietary systems) through custom-built integrations and file-based transfers (sFTP).Data Extraction & Reporting: Capability to perform complex data mining to support business intelligence, such as pulling license info for CRMs or creating customer breakout reports.Security & Identity Management Access Control: Experience managing user lifecycles, specifically migrating users from legacy authentication to SSO (Single Sign-On).Security Compliance: Knowledge of certificate management (SSL/TLS) and performing security audits (e.g., cross-referencing user lists to identify and block inactive/unauthorized accounts). Technical Stack Requirements Databases: Microsoft SQL Server (2022, 2025), T-SQL.ETL Tools: SSIS, Talend.Operating Systems: Windows Server, Linux.Cloud/Hosting: OVHcloud.Monitoring/Management: Zabbix, mRemoteNG.Business Tools: Netsuite (ERP), HubSpot (CRM), Zendesk (Helpdesk), iSpring.Protocols/Security: SSO, sFTP, SSL/TLS, SQL Permissions.Additional Tools: Zendesk, IIS. Soft Skills & Professional Attributes Multitasking/Context Switching: Ability to jump from a high-level migration project to a low-level support ticket without losing focus.Cross-Functional Collaboration: Ability to work with IT, Sales (for demos), and other Teams to determine maintenance windows and system requirements.Analytical Problem Solving: A "builder" mindset—when a tool (like Zendesk reporting) is missing a feature, this person builds a custom solution (SSIS packages) rather than waiting for a vendor update.Global Mindset: Comfortable working within specific time zones (EU) and managing distributed environments (US/EU/AUS).