DistantJob

• Design, build, and optimize complex SQL Server solutions, emphasizing performance tuning, indexing, and data modeling. • Manage relational and semi-structured data, including JSON stored in SQL Server and multi-dimensional datasets. • Query and transform JSON using native SQL Server tools, such as OPENJSON and JSON_VALUE. • Use PowerShell, SQL Server tools, and scripting to automate processes. • Enhance functionalities by integrating with APIs and external systems. • Address problems comprehensively, focusing on end-to-end solutions beyond the database layer. • Operate within a complex, multi-system application environment, avoiding isolated reporting or analytics tasks. • Explore and implement LLM-driven workflows, including prompting and structured outputs. • Continuously enhance efficiency by replacing manual processes with automation.

• Design, develop, and maintain full-stack features across backend services, APIs, frontend, and database layers • Work primarily on backend systems (~80%) with some frontend responsibilities (~20%) • Contribute to and modernize legacy VB.NET MVC applications while supporting the migration to .NET Core • Build and integrate AI-assisted development workflows using tools such as ChatGPT, Claude, or similar technologies • Collaborate directly with clients to gather requirements, deliver enhancements, and provide technical solutions • Write and optimize SQL queries, stored procedures, and database interactions in SQL Server • Participate in Agile development processes using tools like JIRA and Git/TFS

• Provide remote technical support via phone, ticketing systems, and remote tools. • Troubleshoot and resolve issues across networks, servers, endpoints, and cloud environments. • Design and implement solutions to improve security, uptime, and performance. • Manage and support Windows Server, Active Directory, and Microsoft 365 environments. • Administer virtualization platforms (VMware, Hyper-V). • Support and maintain cloud infrastructure (Azure and/or AWS). • Configure and manage firewalls (SonicWall, Sophos, Fortinet, Cisco, etc.). • Monitor systems using RMM tools and maintain clear documentation in ticketing systems. • Perform network, server, and security assessments following best practices. • Communicate clearly and proactively with clients and internal teams.

• Build full-funnel paid search and social strategies aligned with pipeline, CAC, and LTV targets • Size opportunities and forecast ROI for campaign initiatives • Create effective account structures and roadmaps for performance improvement • Launch, monitor, and A/B test campaigns across Google, Microsoft, and emerging platforms • Drive continuous improvement in CTR, CVR, ROAS, and impression share • Optimize budget allocation and implement new platform features • Use GA4 and Looker to identify performance trends and actionable insights • Translate complex data into compelling narratives for senior leadership • Develop reporting that highlights key metrics and opportunities • Partner with Creative on ad copy and visual concepts • Coach junior team members on PPC best practices • Recommend new tools, betas, and channels worth piloting

• The Consultant will own the end-to-end delivery of focused, high-value MVPs and automations across 2–3-week sprints, with structured demos and knowledge transfer at each cycle. • Work will span: • Building a Trust Engagement Database leveraging tools such as Notion, SharePoint, or equivalent platforms. • Developing Power Automate workflows and Copilot Agent assets — covering prompt libraries, lightweight agent frameworks, automated SLA reminders, email and Teams-based triggers, tracking dashboards, and recurring or on-demand reporting. • Prototyping LLM-assisted Adverse Event (AE) triage workflows (non-PHI), encompassing classification and summarization logic, intelligent routing, and retrieval from approved content sources. • Wrapping up solutions as reusable, well-documented components: data models, deployment runbooks, and step-by-step how-to guides. • Working hand-in-hand with Project Managers and Operations to make sure every solution lands well and can scale. • Contributing to the client's AI-driven Digital Transformation initiatives.

• Deploy and configure Proxmox VE clusters across multiple data center locations • Plan and execute virtual machine migrations with minimal service interruption • Configure and optimize Ceph storage and network infrastructure • Build automation workflows using Terraform, Ansible, and API integrations • Leverage AI tools to optimize your workflow • Performance monitoring • Collaborate with the infrastructure team on testing, validation, and documentation • Troubleshoot and resolve issues during migration phases

• Architect and implement scalable test automation solutions using modern technologies, particularly Playwright (primary focus) and Selenium with C# • Oversee and support nine QAs across multiple Scrum teams • Collaborate with four automation engineers to align testing strategies and frameworks • Drive quality assurance best practices through leadership and mentorship • Automate test cases within sprints using modern tools including Claude AI and Playwright • Orchestrate end-to-end testing strategies, including functional, regression, and performance testing • Champion continuous integration practices by integrating automated testing into CI/CD pipelines • Foster collaboration between development, product, and QA teams to ensure optimal test coverage • Analyze test results, document issues, and coordinate resolution efforts • Establish and track key quality metrics to drive continuous improvement • Participate in code reviews and provide feedback to improve test automation quality