B4Corp - Reston, VA

posted 13 days ago

Full-time - Senior
Reston, VA
11-50 employees
Executive, Legislative, and Other General Government Support

About the position

The Database Engineer at B4Corp will be responsible for high-level database engineering and management tasks, including data design, schema definition, and database optimization. This role requires a Top Secret (TS/SCI) clearance and involves working closely with the API Services Team to maintain and enhance database performance, particularly in an AWS environment.

Responsibilities

  • Serve as the high side DB Engineer / Administrator for the API Services Team
  • Responsible for ongoing maintenance of existing DB (AWS RDS)
  • Identify performance bottlenecks in current DB and implement fixes (short term and long term)
  • Optimize all DB queries and updates within microservices and identify best solution for implementation (e.g., stored procedure)
  • Define a migration path from the current database to the 'to be' database to optimize for workload encountered in production
  • Coordinate with Low side team(s) to develop changes in the low side development and test environments and package them to be deployed to the high side environments
  • Responsible for performing ETL development activities including parser development and deployment, data flow management, implementing data lifecycle policies, troubleshooting data access issues, and developing data models.

Requirements

  • Experience applying expert domain knowledge of database management systems and SQL optimization
  • Experience with Dynamo and SQL based DBs
  • 5+ years' experience with Postgres, Oracle, MySQL, or other commercial database management system
  • Extensive knowledge in writing and optimizing complex SQL statements and stored procedures
  • Extensive experience developing extract, load, and transfer software operations for data sets in an AWS environment utilizing NiFi flows
  • Experience negotiating complex scenarios and challenges and devising courses of action to resolve situations with predictable outcomes
  • Experience leading critical objectives where decision making is of utmost concern to the outcome
  • Bachelor's degree with 8-12 years of prior relevant experience or a Master's with 6-10 years of prior relevant experience.

Nice-to-haves

  • Experience with AWS/C2S services including RDS
  • Demonstrated experience using Spring, Kafka, Elasticsearch, and NiFi.

Benefits

  • Outstanding Salaries
  • Full Vanguard 401k Plan with 100% employer matched contribution up to 6%
  • Employees receive B4Corp phantom stock each year (2-year vesting period)
  • Medical, Dental, and Vision insurance options
  • Short-term and long-term disability insurance
  • Life insurance coverage
  • Employee Referral Bonus of $3,000 per year for each referred employee
  • Seven weeks of paid time off per year including federal holidays
  • Flexible work schedule with comp time
  • Free online training accounts for IT courses and certifications
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service