The Leaflet logo
The Leaflet

An independent platform for cutting-edge, progressive, legal, and political opinion.

Senior Database Administrator

Database AdministratorDatabase AdministratorFull TimeRemoteSeniorTeam 11-50H1B No SponsorCompany SiteLinkedIn

Location

Florida

Posted

2 days ago

Salary

0

Seniority

Senior

Job Description

Senior Database Administrator

The Leaflet

• Operate and evolve multi-region CockroachDB clusters and PostgreSQL instances across production, staging, and development. • Investigate contention, serialization retries (SQLSTATE 40001), and range hotspots in the transaction paths behind bets, wagers, settlements, and payouts. • Diagnose leaseholder placement, monotonic-key write pressure, and cross-region latency that turn one query into several network round trips. • Trace a slow query to its execution plan, the plan to optimizer behavior, and the behavior to the schema or application call path that caused it. • Catch plan regressions after statistics changes, schema changes, data growth, or releases, then turn the fix into a safer rollout pattern. • Assess schema-change and backfill risk before it reaches large tables: lock behavior, retry pressure, capacity impact, and rollback path. • Plan capacity, scaling events, and version upgrades that customers don't feel. • Build database observability with Prometheus, Grafana, Mimir, Loki, and Snowflake: dashboards backed by real queries, alerting on leading indicators, and SLO tracking. • Connect database symptoms to application behavior and business events so alerts point at causes. • Join the on-call rota for the data layer, lead incident analysis when the database is part of the failure, and drive blameless postmortems toward durable fixes. • Instrument the system to surface degradation before it becomes an incident. • Build Go and Python tools that make incidents easier to understand: log collectors, explain-plan analyzers, migration checks, capacity models, and runbook generators. • Automate provisioning, configuration, backup, and recovery with Terraform and other infrastructure-as-code tools. • Work with platform engineering on CI/CD, deployment safety, and change management for database-touching services. • Use Claude Code, Codex, and similar harnesses in daily work to investigate incidents, generate probes, draft runbooks, and write tooling. • Keep the harness grounded in logs, traces, metrics, and source code, and verify its output against production facts before you ship it. • Implement and audit access controls, authentication, authorization, and encryption in transit and at rest. • Support data-protection, audit-logging, and retention requirements for a regulated gaming platform. • Build a database center of excellence: documentation, standards, and reusable patterns that other teams build against. • Mentor engineers on database fundamentals, distributed-systems behavior, and operational discipline. • Read CockroachDB and PostgreSQL internals when a problem needs a code-level answer, and bring what you learn back to the team.

Job Requirements

  • 5+ years operating production relational databases as a DBA, Database Reliability Engineer, or Data Platform Engineer.
  • Deep production experience with PostgreSQL, CockroachDB, or another relational database management system, with fluency in the tradeoffs behind isolation, consensus, locality, and query planning.
  • You understand how a SQL engine works under the hood: MVCC, the Volcano iterator execution model, and cost-based optimizer frameworks such as Cascades.
  • You apply that knowledge to indexing strategy and to execution plan analysis.
  • Working knowledge of distributed-systems fundamentals: consensus (Raft and Paxos), distributed transactions, consistency models, and failure modes.
  • You write tools and automation in Python or Go, and you can debug and suggest fixes to line-of-business code in Java or a similar language.
  • Experience with infrastructure-as-code and a monitoring and observability stack such as Grafana or Datadog.
  • UNIX/Linux administration with shell scripting, comfort on a cloud platform (AWS preferred, Azure, or GCP welcome), and willingness to join an on-call rota.
  • Clear technical writing and speech. You'll work across teams.

Benefits

  • Competitive pay and benefits
  • Flexible vacation allowance
  • A hybrid / remote working environment
  • Startup culture backed by a secure, global brand
  • Opportunity to build products enjoyed by millions as part of a passionate team
  • Team gatherings around the US and Europe
  • Employer-sponsored training and conference attendance
  • Opportunity to work in an AI-first environment with access to the tools you need to excel at your job

Related Categories

Related Job Pages

More Database Administrator Jobs

Air InfoSec logo

Database Administrator

Air InfoSec

Where mission meets momentum. Veteran-built. Future-focused.

ContractRemoteTeam 1-10Since 2023H1B No Sponsor

• Designs and executes database upgrades from Oracle 19c to Oracle 23ai. • Maintains multiple database environments supporting ETL activities. • Sets up and maintains Grid Infrastructure, including ASM and Clusterware. • Implements high-availability solutions using GoldenGate and Active Data Guard. • Performs performance tuning to improve database processing efficiency. • Monitors database performance and recommends efficiency improvements. • Performs logical and physical data modeling and creates physical data models from logical data models. • Maintains data dictionary standards to ensure uniformity of definitions. • Executes backup, recovery, and disaster recovery procedures for hardware and software failures. • Ensures compliance with security vulnerability requirements and database security standards. • Assists in the installation, analysis, design, and implementation of databases. • Ensures database administration interfaces comply with EIR Accessibility standards.

Texas
$75 - $85 / hour

Role Description The primary responsibility is to design and execute database upgrades from Oracle 19c to Oracle 23ai, and to maintain multiple environments that support ETL activities. - Enters codes to create production database. - Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. - Directs programmers and analysts to make changes to database management system. - Reviews and corrects programs. - Answers user questions. - Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database. - Modifies database programs to increase processing performance (performance tuning). - Specializes in one or more types of database management systems. - Provides assistance in the planning, development, maintenance, and monitoring of integrated database systems. - Ensures that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment. - Evaluates users' requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. - Coordinates the use of data to ensure data integrity and control redundancy. - Loads databases and reorganizes as needed. - Performs data modeling and prototyping. - Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. - Performs security recovery procedures. - Determines and implements database search strategies and storage requirements. - Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. - Monitors database performance and recommends efficiency improvements. - Creates test database environment for applications section, including the creation of necessary libraries and procedures. - Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. - Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems. - Assists with the installation of database software and with analyzing, designing, and implementing databases. - Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security. - Assists in the selection of database management software. - Experience in computer systems analysis or computer programming work. - Knowledge of the principles, practices, and techniques of computer programming and systems design. - Knowledge of computer operations, systems, and procedures. - Knowledge of project control and cost estimating techniques. - Knowledge of computer programming languages, data processing flowcharting techniques, database structures and theories, and current database technologies. - Has working knowledge of EIR Accessibility standards and assistive technologies. - Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards. - Provides support to users in obtaining data/information when EIR Accessibility issues arise. Qualifications - 8 years of experience in infrastructure management with Oracle 19c version or higher. - 8 years of experience in Grid infrastructure (ASM, Clusterware). - 8 years of experience in high-availability (GoldenGate, Active Data Guard). - 8 years of experience in advanced scripting (Linux, SQL). - 4 years of preferred experience working with a public sector organization (Federal, State, or Local Government). - 2 years of preferred experience working with a hosting vendor. - 2 years of preferred experience working with Oracle PeopleSoft products. Requirements - Must have hands-on experience with Grid Infrastructure setup and maintenance. - Must have experience with security vulnerability compliance and performance tuning. - This position requires working outside standard business hours, depending on project activities. - This is a remote position; if it should become hybrid, in-office schedule will be negotiated. - Candidates for this position will be subject to a pre-employment security review to determine employment eligibility. Company Description

United States
Booz Allen Hamilton logo

Database Administrator

Booz Allen Hamilton

Booz Allen Hamilton is an award-winning provider of strategic innovation, management consulting, technology, and engineering services. Founded in 1914, the comp

Title: Database Administrator Location: Arlington, VA Alexandria, VA time type Full time job requisition id R0241998 Database Administrator Job Description: Database Administrator The Opportunity: Your combination of people skills and technical expertise makes you the team hero, solving one problem after another. As a database administrator, you know how to manage and secure database technology. At Booz Allen, you can use those skills to improve the database technology supporting our Army client. On our team, you’ll provide your client with peace of mind as you implement policies and procedures to ensure the security and integrity of the database. You’ll use technology and tools to identify problem areas and opportunities for improvement in a mission-critical database. In this role, you’ll closely impact warfighters with your technical expertise and mentoring. With opportunities to learn new tools and skills, we’ll focus on growing as a team to make the best solutions for our customers. Join us. The world can’t wait. You Have:  - 5+ years of experience with SQL-based database development, building, maintaining, and administering database systems using SQL Server 2012 to 2019, writing scripts and stored procedures, and building complex views - Experience assisting with software releases and working collaboratively with business analysts and application developers - Experience designing and implementing end-to-end data solutions leveraging Azure or AWS services - Experience documenting technical designs, procedures, and guidelines for data engineering processes - Knowledge of conducting performance tuning and optimization of SQL queries and data processing workflows - TS/SCI clearance - Bachelor's degree Nice If You Have:  - Experience supporting data visualization through Power BI - Ability to collaborate with data scientists and analysts to deploy machine learning models and enable advanced analytics - Ability to work independently and prioritize tasks in a fast-paced environment - Microsoft Certified Azure Data Engineer Associate or Microsoft Certified Azure Solutions Architect Expert Certification - AWS Certifications such as AWS Certified Solutions Architect or AWS Certified Developer Certifications - Security+ or CISSP Certification Clearance: Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; TS/SCI clearance is required. Compensation At Booz Allen, we celebrate your contributions, provide you with opportunities and choices, and support your total well-being. Our offerings include health, life, disability, financial, and retirement benefits, as well as paid leave, professional development, tuition assistance, work-life programs, and dependent care. Our recognition awards program acknowledges employees for exceptional performance and superior demonstration of our values. Full-time and part-time employees working at least 20 hours a week on a regular basis are eligible to participate in Booz Allen’s benefit programs. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits. We encourage you to learn more about our total benefits by visiting the Resource page on our Careers site and reviewing Our Employee Benefits page. Salary at Booz Allen is determined by various factors, including but not limited to location, the individual’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements. The projected compensation range for this position is $86,800.00 to $198,000.00 (annualized USD). The estimate displayed represents the typical salary range for this position and is just one component of Booz Allen’s total compensation package for employees. This posting will close within 90 days from the Posting Date. Identity Statement As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud. Candidate AI Usage Policy AI is a part of our daily work at Booz Allen, and we are committed to the responsible and ethical use of AI tools. However, we want to ensure a fair candidate process based on your own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) or other tools to assist with responses during interviews (whether in-person or virtual) is prohibited unless permission is explicitly provided. Work Model Our people-first culture prioritizes the benefits of collaboration, whether it occurs in person or virtually. To support engagement and effective communication, employees working virtually are generally expected to have their cameras on during meetings. - Remote: If this position is listed as remote, there may still be occasions when you are required to work in person at a Booz Allen or customer facility. - Hybrid: If this position is listed as hybrid, you will be expected to work from a Booz Allen facility frequently, in alignment with leadership expectations and the needs of the role. You may also be required to work from or visit a customer facility. - Onsite: If this position is listed as onsite, work will primarily be performed at a Booz Allen office or customer facility, where employees will collaborate directly with colleagues and customers as required by the role. Commitment to Non-Discrimination All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, local, or international law.

Virginia
$86.8K - $198K / year

Provide database administration support, manage Microsoft SQL Server environments, create and maintain databases, and facilitate migration to cloud infrastructure while ensuring optimal performance and security of data systems.

District Of Columbia + 1 moreAll locations: District Of Columbia | Virginia