Database Engineer
Posted 1hrs ago
Employment Information
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%).










