Database Engineer

Insight Global
McLean, VA, United States
1 day ago
Apply on dejobs.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Databases Relational Databases Database Encryption Database Security Key Management PostgreSQL Microsoft SQL Server MySQL Operational Databases Oracle (Applications) PostGIS
+10 more
SQL Databases Data Logging Pinecone Snowflake Database Performance Database Migration Amazon Relational Database Service Pgvector Data Management OpenSearch

Job description

Position Overview: Cross-program Database Engineer responsible for establishing database standards across federal programs. They solve difficult database problems and ensure environments are secure, recoverable, scalable, and compatible with federal authorization requirements.

Day-to-Day : * Establish database standards that multiple federal programs follow. * Determine PostgreSQL/RDS topology, replication, parameters, backup, and recovery strategies. * Troubleshoot difficult database performance problems. * Analyze query plans using EXPLAIN ANALYZE. * Help teams execute zero-downtime production database migrations. * Conduct recovery drills with program teams. * Validate actual RPO/RTO capabilities. * Establish database encryption, access, key-management, and audit-logging standards. * Partner with Platform Engineering around infrastructure. * Review schema and migration designs. * Stop unsafe database changes when necessary. * Discuss data residency, retention, encryption, and access with federal customers. * Help establish a centralized database engineering practice as the federal portfolio grows

Requirements

Must Haves : * Degree requirements: Bachelors (not a hard requirement) * Years of Experience: 7+ years of production database engineering at scale.

Experience should be on major relational database engine. PostgreSQL is preferred, but deep MySQL, Oracle, or SQL Server experience is acceptable. * Certifications: N/A * Tools/Technologies: * PostgreSQL preferred * AWS RDS * SQL/query execution plans * Strong Query plan literacy - ability to explain, analyze and reason * Database migrations * Backup and recovery * RPO/RTO * Database security * FedRAMP * ATO / continuous monitoring * Snowflake or equivalent analytics platform Candidates need experience completing zero-downtime migrations against live production traffic. Plusses : * GovCloud experience * Deep Snowflake expertise * PostgreSQL logical replication * AWS DMS * CDC * pgvector * OpenSearch k-NN * Pinecone * TDE * Vault * AWS KMS with customer-managed keys * PostGIS * Experience establishing a central DBRE or DBA organization

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dejobs.org
Prepare application

Good distractions

Loading talks and stories from around this role…