Database Engineer
Redhorse Corporation2 months ago
Chantilly, VA, USASenior
Base Salary
$150k - $225k/yr
Responsibilities
- Design, build, and maintain application database management systems in AWS, including logical and physical data models, relational architecture, and metadata repositories.
- Model request lifecycles and workflow states as structured, queryable data.
- Implement role- and attribute-based access control, row- and column-level security, encryption, least-privilege accounts, retention, purge, and immutable audit controls.
- Analyze legacy systems and execute source analysis, data mapping, transformation, and migration planning.
- Evaluate, size, and select relational, NoSQL, and AWS database and storage components.
- Write, review, and tune SQL queries, stored procedures, indexes, and data-access patterns.
- Implement and test backup, recovery, replication, and RPO/RTO solutions.
- Manage schema changes, migration scripts, versioning, and database configuration controls.
- Prepare data for rules-based validation, AI-assisted error detection, reporting, and leadership metrics.
- Monitor database health, capacity, and performance and resolve production data issues.
- Prepare system requirements, data dictionaries, and design documentation.
Requirements
- Active TS/SCI clearance with polygraph is required.
- Bachelor's degree in a relevant field and 5+ years of relevant experience, or a master's degree and 3+ years of relevant experience; equivalent experience may substitute for a degree.
- At least 5 years of experience designing, building, and administering relational databases.
- Expert SQL skills, including query writing, performance tuning, indexing, and stored procedures or functions.
- Experience with conceptual, logical, and physical data modeling and relational database design.
- Hands-on experience with AWS database and storage services, preferably on classified systems.
- Experience implementing database security, access control, encryption, auditing, backup, recovery, replication, and data migration.
- Scripting experience with Python, Bash, or PowerShell.
- Preferred qualifications include a relevant master's degree, classified-system application development experience, AWS certification, NoSQL experience, regulated-data experience, workflow or case-management modeling, schema-change tooling, Infrastructure as Code, containers, ETL/ELT, event-driven AWS services, AI/ML data preparation, and Jira or Confluence experience.
Benefits
- Eligible employees may participate in comprehensive benefits programs and may be eligible for performance-based or other incentive compensation.
- Redhorse Corporation is an equal opportunity employer and provides reasonable accommodation upon request.
Tech Stack
Amazon DynamoDBAWSBashDockerFlywayKubernetesMicrosoft SQL ServerMongoDBMySQLPostgreSQLPowerShellPythonSQLTerraform
Categories
About Redhorse Corporation
Redhorse Corporation provides data analytics, AI, and digital transformation consulting to U.S. government agencies, especially in national security, infrastructure, and environmental programs. It delivers technology-agnostic solutions, systems integration, and data engineering to help the Department of Defense and civilian agencies improve decision-making and operations under professional services contracts. Founded in 2008 and headquartered in Arlington, Virginia, the company is privately held.