Database Engineer

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Database Engineer supporting government-owned systems to fight fraud against the federal government. Involves database management, ETL processes, and data structure improvements.

Responsibilities:

  • Take ownership of several production databases across multiple architectures, including PostgreSQL, AWS Redshift, AWS Aurora, and AWS DynamoDB.
  • Use SQL & Python to establish ETL & regular monitoring processes that ensure database integrity and accuracy, and that alert the responsible parties of any issues that arise.
  • Redesign existing production database tables & schemas, and migrate the existing data to the new structures, with no downtime.
  • Document database architectures, with an emphasis on ease & efficiency of querying, and on the explanation of the substantive meaning and correct interpretation of the datapoints.

Requirements:

  • 3 years of relevant experience required; 10 years preferred.
  • U.S. citizenship required.
  • Fluency in SQL and especially the linguistic variants that apply to PostgreSQL and AWS Redshift.
  • Fluency with PL/pgSQL and its advanced uses such as variables, conditionals, loops, and error-handling.
  • Familiarity with the concepts of data normalization, i.e. “tidy” data.
  • Experience administering databases containing terabytes of data.
  • Familiarity with relational database table attributes such as multi-column indexes, primary & foreign keys, arbitrary constraints, sequence generation.
  • Familiarity with SQL database user permissioning, i.e. GRANT commands, and ALTER commands as they relate to permissioning.
  • Familiarity with AWS Glue insofar as it relates to database administration, i.e. external tables, ETL jobs, and stored connections.
  • Familiarity with user-defined functions in PostgreSQL & Redshift, including those that consist of AWS Lambda functions.
  • Familiarity with noSQL databases such as AWS DynamoDB or MongoDB, and with their data-loading & querying capabilities & syntax.
  • Experience working within highly secure systems, such as government systems with FedRAMP-high ratings, or corporate systems with SOC-2.

Benefits:

  • Paid time off – 11 holidays plus vacation and sick time.
  • Health & Dental Insurance, voluntary employee-paid Vision Insurance.
  • 401k – Our 401k plan matches up to 3.5% of your income (SIMPLE IRA capped at 3%).