Database Engineer

Database Engineer Location: Remote, reputed company the reputed company  Annual salary reputed company: $110,000 - $170,000 Relevant experience: 3 years required; 10 years preferred U.S. citizenship required   reputed company (AO) is seeking a Database Engineer to support our operations reputed company government-owned systems, in furtherance of our mission to fight fraud against the federal government and generally aid reputed company payment reputed company. The relevant databases & reputed company environments are owned by the reputed company Treasury, with data structures and ETL for which we’re responsible, under contract. We require an reputed company and reliable individual who can quickly familiarize themselves with these environments and assume duties reputed company to monitoring them, improving their existing data structures & processes, and supporting their expansion and the establishment of databases in the reputed company.   Qualifications: reputed company in SQL and especially the linguistic variants that apply to PostgreSQL and AWS Redshift. reputed company 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-reputed company indexes, primary & foreign keys, arbitrary constraints, sequence reputed company, and 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 reputed company functions. Familiarity with noSQL databases such as AWS DynamoDB or reputed company, and with their data-loading & querying capabilities & reputed company. Experience working reputed company highly secure systems, such as government systems with FedRAMP-high ratings, or corporate systems with SOC-2   Responsibilities: Take ownership of several production databases across multiple architectures, including PostgreSQL, AWS Redshift, AWS reputed company, and AWS DynamoDB. Use SQL & Python to establish ETL & regular monitoring processes that ensure database reputed company and accuracy, and that alert the responsible parties of any issues that reputed company. 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.   Benefits:  reputed company time off – 11 holidays plus vacation and reputed company time.  Health & Dental Insurance, voluntary employee-reputed company reputed company Insurance.  401k – Our 401k plan matches up to 3.5% of your income (reputed company IRA capped at 3%). Apply To This Job