Open Data Jobs

Open Data Jobs

Open Data Jobs connects high-potential data professionals with essential roles in the Federal sector, facilitating the recruitment process for Federal Chief Data Officers, contractors, and other stakeholders to address critical job openings in the data...

Professional Services

Description

  • Design and implement logical and physical data models for new application features.
  • Author and review stored procedures, functions, views, triggers, and complex SQL queries across relational databases.
  • Collaborate with software engineers through the full development lifecycle to align database design with application requirements and performance targets.
  • Define and enforce database coding standards, naming conventions, and schema change management practices.
  • Build and maintain schema migration scripts and manage versioned deployments through CI/CD pipelines.
  • Profile and tune slow queries, identify missing indexes, and resolve locking and blocking issues.
  • Analyze execution plans and implement query rewrites, index strategies, and statistics management to meet SLA requirements.
  • Establish performance baselines and monitor database health metrics to proactively address bottlenecks.
  • Support cloud-hosted database environments and assist with migrations from on-premises platforms to the cloud.
  • Partner with DBAs, data engineers, and solution architects on broader data platform and enterprise architecture initiatives.

Requirements

  • Expert-level SQL proficiency across at least one major RDBMS such as SQL Server, PostgreSQL, Oracle, or MySQL/MariaDB.
  • Working knowledge of a second relational database platform is strongly preferred.
  • Hands-on experience with database performance tuning, including query analysis, index design, statistics, and execution plan interpretation.
  • Experience with schema versioning and database migration tooling such as Flyway, Liquibase, Alembic, or similar.
  • Proficiency in Python and terminal scripting such as PowerShell or Bash for automation, data loading, and operational tasks.
  • Working knowledge of cloud-managed database services such as Amazon RDS or Aurora.
  • Solid understanding of relational data modeling theory and schema design patterns for OLTP systems.
  • Familiarity with DevSecOps practices, including Git, branching strategies, CI/CD integration, and environment promotion workflows.
  • Bachelor’s degree required; Computer Science, Information Systems, or a related technical field strongly preferred.
  • 5+ years of experience in a development DBA, database developer, or data engineering role with strong SQL development responsibilities.
  • Experience supporting both OLTP and analytical workloads; exposure to data warehousing patterns such as star schema and slowly changing dimensions is a plus.
  • Prior consulting or client-services experience is preferred.
  • U.S. citizenship and the ability to obtain a Public Trust suitability determination are required.
  • Experience in federal data environments, government IT modernization, or regulated industries with data governance requirements is preferred.
  • Strong written and oral communication skills, with the ability to explain technical trade-offs to engineering and non-technical stakeholders.

Benefits

  • Full health coverage for medical, dental, and vision, with 100% of employee premiums covered.
  • Life and disability insurance fully covered by the company.
  • 401(k) retirement plan with 100% match on contributions up to 4% of salary and immediate vesting.
  • Unlimited Paid Time Off (PTO).
  • Remote work with greater Washington, DC area preferred for hybrid engagement.
  • Sponsored database certification training.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

SQL Server Operations DBA

qode Internet Software & Services

Lead SQL Server Operations DBA for a Bangalore-based role at Microsoft SQL Server environments, focused on database operations, performance, security, migrations, and integration support.

C# Git MongoDB PowerShell SQL Server SVN
2 hours, 5 minutes ago

Finance Systems Administrator

Media.Monks 5K-10K Media

Finance Systems Specialist at Monks overseeing the LucaNet environment and supporting NetSuite ERP to keep global finance systems stable, compliant, and audit-ready.

ERP NetSuite
4 hours, 24 minutes ago

Senior Database Reliability Engineer

Rithum Internet Software & Services

Rithum is hiring a Senior Database Reliability Engineer to manage and improve the availability, reliability, observability, and security of its large-scale hybrid database environment.

AWS CI/CD DynamoDB Elasticsearch MongoDB MySQL PostgreSQL PowerShell Python Redis SQL Server
4 hours, 24 minutes ago

Graph DBA

Worth AI Internet Software & Services

Worth AI is seeking a Graph Database Administrator to own the company’s core data platform, powering entity resolution, knowledge graph services, and real-time risk decisioning for internal teams and external partners.

Apache Airflow Apache Spark AWS CI/CD Databricks Docker Flink Go GraphQL Java Kafka Kubernetes Machine Learning Neo4j Python REST API Rust Snowflake Terraform
5 hours, 24 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers