Systems Consultant

Remote; San Francisco (CA); Presencial; USD 110.000 - 160.000; Jornada completa

Descripción de la vacante

CCT is seeking a Systems Consultant to design, deploy, and maintain Casino Insight environments for major casino clients from our Tulsa office. You will stand up Windows, SQL Server, and data-bridge components, manage security and access, and troubleshoot complex inter-system integrations across MSSQL, Oracle, and other databases.

Travel is limited to under 10% with a hybrid path possible as you gain seniority.

Formación

• Bachelor's degree in a technical field or equivalent practical experience.
• Hands-on proficiency with MS SQL Server, Windows Server, Active Directory and IIS.
• Working knowledge of TCP/IP networking and VPN concepts, DNS, certificates, and port troubleshooting.
• Ability to explain technical requirements to clients and document solutions clearly.
• Experience owning multiple client projects and meeting deadlines without daily management.

Responsabilidades

• Stand up application and database servers for new implementations and ensure health post go-live.
• Configure and maintain network access, VPN tunnels, firewalls, and secure remote access.
• Run upgrades, diagnose production issues, and monitor environment health and patch levels.
• Lead client IT kickoff calls, document configurations, and author knowledge-base articles.
• Provide hands-on guidance to client teams and support escalation with internal teams.

Conocimientos

MS SQL Server

Windows Server

Active Directory

IIS

TCP/IP networking

Scripting (PowerShell)

Educación

Bachelor's degree in a technical field

Herramientas

MS SQL Server

Windows Server

IIS

Active Directory

AWS VPC / VPN

FortiGate/Palo Alto/Cisco ASA knowledge

Descripción del empleo

About CCT

Founded in 2012, CCT pioneered revenue audit automation for land-based casinos, eliminating manual reconciliation and improving financial visibility. Our flagship platform, Casino Insight, provides a detailed, audit-ready view of cash transactions across the casino floor — supporting compliance, operational efficiency, and fraud prevention. Today CCT serves over 300 casinos across the United States, Canada, and the Caribbean.

The Role

Systems Consultants build and maintain the infrastructure that Casino Insight runs on. When a casino buys CCT, a Systems Consultant stands up the environment: Windows and SQL Server, the application and message-queue tiers, remote access, and the linkedserver connections that pull data out of the property's slot, table, cage, and sportsbook systems. After go-live, the same Systems Consultant owns that environment's health and is the escalation point when something breaks.

It is a genuine consulting role. Most client IT departments are small, and many have never integrated a system like ours. You are the expert in the room — advising on architecture, negotiating firewall and access changes, and enabling the client's team to support their side of the deployment after handoff.

You do this work from our Tulsa office, not from the casino floor. Nearly every environment build, upgrade, and troubleshooting session happens remotely over screen shares with client IT, so travel is under 10% — occasional go-live support, a client visit, or an industry event. Sitting with the team matters early on: this is a role you learn by overhearing how the person next to you talks a client's network admin through a firewall change. Systems Consultants who are established in the role have the opportunity to move to a hybrid schedule.

What You'll Actually Do

Build client environments (largest share of the role)

• Stand up application and database servers for new Insight Cash and Insight Analytics implementations — Windows Server, IIS, MS SQL Server, TLS certificates, service accounts, scheduled jobs

• Deploy and configure CCT's Data Bridge tier for single-site and multi-property clients

• Configure linked servers and third‑party data connections across MSSQL, Oracle, AS400/DB2, and PostgreSQL — slot systems, ticketing, kiosks and recyclers, table games, sportsbook

• Set up employee Active Directory sync, report distribution, backups Cove, and training‑environment refreshes from production

Own the network and access layer

• Work with client IT to troubleshoot network issues between servers and workstations

• Establish AWS site-to-site VPN tunnels against client firewalls FortiGate, Palo Alto, Cisco ASA, pfSense, and others). If you've done this before, great — if you haven't, we'll teach you. Solid TCP/IP fundamentals matter more here than prior AWS experience.

• Configure and maintain SecureLink remote access, including gatekeeper setup and audit review

• Support on‑prem to AWS replication for hybrid client architectures

Run upgrades and keep environments healthy

• Execute CAS push upgrades and MQ upgrades across the client base

• Diagnose and resolve escalated production issues — service failures, blocked ports, failed jobs, disk and performance problems, broken integrations

• Monitor environment health and patch levels; act on alerts before clients notice

Consult and document

• Lead client IT kickoff calls: walk their team through requirements, architecture, and their responsibilities

• Produce clear technical documentation — configuration guides, environment records in Passportal, and knowledge‑base articles the rest of the team relies on Support internal CCT IT and end‑user requests as part of a shared rotation

Tools you'll use: MS SQL Server / SSMS, Windows Server, Hyper‑V, IIS, Active Directory, AWS VPC, VPN, EC2, S3, IAM, CloudWatch), SecureLink, Passportal, N Central, SentinelOne, Cove, Freshdesk, Mavenlink, Notion, GitHub, Slack.

What Success Looks Like

First 30 days: Local and lab environments built; oriented on the CCT stack; handling internal IT and enablement tickets with review

First 60 days: Completing a full server environment build in lab independently; running Data Bridge deployments and upgrades in client environments with light supervision

First 90 days: Owning a client environment build end‑to‑end, leading a client IT kickoff call, and handling standard support tickets without review

New Systems Consultants work through a structured 90‑day plan with a defined milestone checklist, shadowing time with each member of the team, and a specialty track chosen with your manager (networking, database, integrations, or internal IT.

How We Expect You to Think

This is the part of the job we care most about, and it's the part that's hardest to teach.

Our documentation is good, and you will use it. However, a runbook cannot tell you why step 6 exists, what it assumes about the client's network, or what to do when the environment in front of you doesn't match the one the runbook was written against. Working through the steps without understanding the mechanism behind them is how a build passes every checkbox and still fails at go‑live.

What that looks like day to day:

Understand the why before the how. You should be able to explain what a linked server actually does, why a VPN tunnel needs matching phase‑2 selectors, or why a service account failed after a password policy change — not just recall the fix that worked last time.

Diagnose, don't guess. Read the error. Check the log. Form a hypothesis, test the one thing that would disprove it, and narrow from there. Restarting services and re‑running the installer until something changes is not troubleshooting.

Know when you're outside what you understand. Being unsure is fine and expected — this stack is deep. Pretending otherwise in front of a client's IT director is not. Ask, elevate, or go read, then come back with an answer you can defend.

Improve the process you inherited. When you find a gap, an undocumented step, or a step that exists only because someone once did it that way, say so and fix it. We would rather hear "this instruction is wrong and here's why" than watch it get followed for another two years.

Be genuinely curious. The people who do well here take apart systems they've never seen because they want to know how they work, not because a ticket forced them to.

Qualifications

Required

• Bachelor's degree in a technical field (Computer Science, MIS, Computer Engineering, etc.), or equivalent practical experience

• Hands‑on proficiency with MS SQL Server (backup/restore, scheduled jobs, linked servers, permissions), Windows Server, Active Directory, and IIS

• Working knowledge of TCP/IP networking — firewalls, NAT, VPN concepts, DNS, certificates, port troubleshooting

• Excellent written and verbal communication; able to explain a technical requirement to a client's IT director and to write documentation someone else can follow

• Demonstrated troubleshooting discipline — a structured method for isolating a problem, and the ability to walk us through the reasoning behind a hard issue you solved, not just the outcome (see "How We Expect You to Think")

• Comfortable owning multiple client projects at once and driving them to a deadline without being managed day to day

• Ability to pass stringent background investigations and obtain gaming licensure/registration where required by client jurisdictions

Preferred

• 3+ years in systems administration, infrastructure engineering, implementation consulting, or a comparable technical role

• AWS experience, especially VPC networking and site‑to‑site VPN — a real advantage, but something we're prepared to train

• Virtualization (Hyper‑V, VMware) and cloud or hybrid infrastructure

• Exposure to Oracle, DB2/AS400, or PostgreSQL

• Scripting for automation (PowerShell, T SQL)

• Gaming, hospitality, or another regulated industry

• Relevant certifications (AWS, Microsoft, CompTIA Network+/Security+)

Working Conditions

• Our team works on‑site in the Tulsa, OK office, collaborating daily with client IT over calls and shared remote sessions. Hybrid flexibility opens up once you're established in the role.

• Travel under 10%

• Casinos operate 24/7, so cutovers, upgrades, and go‑lives are occasionally scheduled outside standard hours or on weekends. This is planned in advance, not routine.

• On‑call duty rotates weekly among the SC team, covering escalated production issues

Work Authorization

This position is not eligible for employer-sponsored work authorization or visa sponsorship (including initial, transfer, or extension). Candidates must be authorized to work in the United States at the time of application and remain authorized for the duration of employment without the need for sponsorship.