G

Green Dot

Fintech bank and prepaid card provider

Senior DBA/DBE Consultant

Database AdministrationConfirmed live in the last 24 hours
Full-time$134.1k - $201.1k /yr

About the Job

Requirements

  • At least 10 years of hands-on SQL Server database administration or database engineering experience.
  • At least 5 years in a senior- or principal-level performance-focused role.
  • Expert knowledge of SQL Server 2016–2022 internals.
  • Proven experience tuning large, high-concurrency online transaction processing systems with thousands of transactions per second and multi-terabyte databases.
  • Experience in financial services, payments, or banking.
  • Demonstrated ability to resolve production hot-spot, latch, lock, and tempdb contention.
  • Advanced Transact-SQL development and execution plan analysis.
  • Hands-on experience designing and operating partitioning at scale.
  • Deep production experience with Always On Availability Groups and SQL Server Replication.
  • Strong proficiency with Query Store, Extended Events, dynamic management views, and wait-statistics methodology.
  • Working knowledge of Windows Server, Windows Server Failover Clustering, SAN/NVMe storage, and virtualization.
  • PowerShell scripting and automation; dbatools is preferred.
  • Experience working under PCI-DSS, SOX, or similar audit controls.
  • Strong written communication, including root-cause analysis reports and executive summaries.
  • Ability to work in the United States without sponsorship.
  • Ability to meet the stated location requirement and currently reside in an approved location.
  • Preferred: experience with Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure/AWS virtual machines.
  • Preferred: cloud performance and cost optimization experience.
  • Preferred: In-Memory OLTP and columnstore for hybrid workloads.
  • Preferred: SQL Server on Linux and containers.
  • Preferred: database DevOps using SSDT, Flyway, or Liquibase, plus CI/CD and automated testing.
  • Preferred: experience with PostgreSQL, Cosmos DB, or Snowflake.
  • Preferred: DP-300 Azure Database Administrator Associate or MCSE/MCM Data Platform certifications.
  • Preferred: community contributions such as blogs, speaking, or open-source tools.

Responsibilities

  • Apply deep knowledge of SQL Server internals—including the storage engine, query optimizer, SQLOS, memory, transaction log, and tempdb—to diagnose complex production issues.
  • Perform root-cause analysis using wait statistics, dynamic management views, Extended Events, Query Store, and PerfMon counters.
  • Use stored procedure design and optimization skills, read code, and provide feedback to optimize it.
  • Analyze execution plans at the operator level, including cardinality estimation, memory grants, spills, parallelism, and row goals.
  • Advise on engine configuration, including MAXDOP, cost threshold for parallelism, compatibility levels, database-scoped configurations, and trace flags.
  • Own end-to-end performance tuning for latency-sensitive OLTP workloads involving authorization, ledger, payments, and 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, including 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 Transact-SQL, including stored procedures, set-based logic, window functions, and dynamic SQL designed to be safe from SQL injection.
  • Review developer- and ORM-generated SQL, including Entity Framework SQL, and publish coding standards and anti-pattern guidance.
  • Design batched large data changes, including purges, backfills, and archival, to run safely online.
  • Design and operate table and index partitioning for multi-billion-row financial tables, including sliding-window SWITCH, SPLIT, and MERGE patterns.
  • Support data lifecycle, archival, compression, and retention in accordance with regulatory requirements.
  • Design, implement, and troubleshoot Always On Availability Groups, including synchronous/asynchronous commit, readable secondaries, distributed AGs, and WSFC quorum.
  • Diagnose AG redo lag, log send queue growth, HADR_SYNC_COMMIT waits, and failover issues.
  • Design, operate, and troubleshoot transactional and peer-to-peer replication, including latency and data consistency issues.
  • Validate high availability and disaster recovery against RTO/RPO targets, and lead disaster recovery tests and failover drills with audit-ready documentation.
  • Enforce least-privilege access and data protection controls, including TDE, Always Encrypted, TLS, and SQL Server Audit.
  • Support audit readiness for PCI-DSS, SOX, GLBA, and FFIEC-aligned controls, and follow CAB change management.
  • Design proactive monitoring and alerting for performance, blocking, AG health, replication, jobs, and capacity.
  • Build idempotent automation with PowerShell (dbatools), Transact-SQL, and CI/CD pipelines.
  • Find opportunities for AI-assisted operations, anomaly detection, and self-healing remediation.
  • Lead or support P1/P2 incidents, and deliver root-cause analysis reports with corrective and preventive actions.
  • Establish performance baselines, SLOs, and capacity models, and quantify every change with before-and-after metrics.
  • Mentor DBAs and developers, and present findings to leadership in terms of risk, cost, and business impact.

Desired Qualifications

  • Experience with Azure SQL Managed Instance, Azure SQL Database, or SQL Server on Azure/AWS virtual machines.
  • Cloud performance and cost optimization experience.
  • In-Memory OLTP and columnstore for hybrid workloads.
  • SQL Server on Linux and containers.
  • Database DevOps using SSDT, Flyway, or Liquibase, plus CI/CD and automated testing.
  • Experience with additional platforms such as PostgreSQL, Cosmos DB, or Snowflake.
  • Certifications such as DP-300 Azure Database Administrator Associate or MCSE/MCM Data Platform.
  • Community contributions such as blogs, speaking, or open-source tools.

About the Company

Green Dot

Fintech bank and prepaid card provider

Green Dot provides financial technology services by offering accessible banking products such as prepaid debit cards, checking accounts, and money management tools for individuals, small businesses, and enterprises. Its platform leverages technology to deliver user-friendly financial services, enabling customers to manage money digitally and on the go. Revenue comes from card transaction fees, account maintenance charges, and partnerships with other financial institutions. Unlike traditional banks, Green Dot emphasizes inclusive, easy-to-use banking and leverages partnerships to expand its offerings across diverse customer segments. The company aims to make banking more inclusive and efficient by reimagining how people interact with money.

Company size
1,001-5,000
Company stage
IPO
Headquarters
Provo, UT
Founded
1999

Recently Posted Jobs

Explore more opportunities at Green Dot

See more jobs