We’re looking for talented professionals to join us in bringing smart money management and payment solutions to everyone’s fingertips.
This position is classified as structured hybrid, with an expectation of a minimum of three (3) days per week working in the office and flexibility to work remotely on the remaining days. On-site expectations may evolve over time to support business needs, with clear communication provided in advance.
> > > > > > > > > >
JOB DESCRIPTION
Location Requirement
This position is open only to candidates who currently reside in one of the following approved locations:
Remote / Hybrid – Must have flexibility to travel for 1-2 weeks to either Miami or Northern California
About Green Dot
Financial technology company and bank holding company
Green Dot Bank is regulated by the OCC and FDIC
Runs prepaid, debit, banking-as-a-service (BaaS), and money-processing platforms
Operates mission-critical, high-volume transactional systems
Treats reliability, data integrity, and security as non-negotiable
Position Summary
Technical authority on SQL Server internals, performance engineering, and scalability
Hands-on, high-impact role supporting our highest-volume financial transaction databases
Diagnoses and fixes hot spots, latch/lock contention, blocking, plan regressions, and I/O bottlenecks
Designs durable fixes: partitioning, indexing standards, query redesign, and HA/DR architecture
Works with application engineering, SRE, architecture, and security teams
Mentors the internal DBA team and serves as the escalation point
Driving outcomes: Owns results end to end, from diagnosis to measurable improvement in latency, stability, and scalability, with clear accountability and follow-through
Key Responsibilities
Apply deep knowledge of SQL Server internals (storage engine, query optimizer, SQLOS, memory, transaction log, tempdb) to diagnose complex production issues
Perform root-cause analysis using wait statistics, DMVs, Extended Events, Query Store, and PerfMon counters
Have strong knowledge of Stored Procedure design and optimization skills. Should have ability to read code and provide feedback to optimize the code.
Analyze execution plans at the operator level: cardinality estimation, memory grants, spills, parallelism, and row goals
Advise on engine configuration: MAXDOP, cost threshold for parallelism, compatibility levels, database-scoped configurations, and trace flags
Own end-to-end performance tuning for latency-sensitive OLTP workloads (authorization, ledger, payments, account services)
Resolve parameter sniffing, plan regressions, implicit conversions, and non-SARGable predicates
Use Query Store and Intelligent Query Processing features for baselining, plan forcing, and regression control
Govern indexing and statistics strategy: clustered key design, covering and filtered indexes, columnstore, and maintenance
Troubleshoot and resolve hot spots, including last-page insert contention (PAGELATCH_EX), tempdb contention, and spinlock contention
Resolve blocking chains, deadlocks, lock escalation, and isolation-level issues, recommending RCSI or snapshot isolation where appropriate
Write, refactor, and review complex high-performance T-SQL, including stored procedures, set-based logic, window functions, and dynamic SQL written to be safe from SQL injection
Review developer and ORM-generated (e.g., Entity Framework) SQL, and publish coding standards and anti-pattern guidance
Design batched large data changes (purges, backfills, archival) that are safe to run online
Design and operate table and index partitioning for multi-billion-row financial tables, including sliding-window patterns (SWITCH, SPLIT, MERGE)
Support data lifecycle, archival, compression, and retention that meet regulatory requirements
Design, implement, and troubleshoot Always On Availability Groups (sync/async commit, readable secondaries, distributed AGs, WSFC quorum)
Diagnose AG redo lag, log send queue growth, HADR_SYNC_COMMIT waits, and…