Database Engineer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Database Engineer
Job Description:
As a Database Engineer, you will play a crucial role in developing, optimizing, and managing data management applications, data pipelines comprising data from multiple disparate sources for a large-scale Data Architecture and Data Management projects across Federal agencies.
Responsibilities:
- Database Engineer will develop applications and data pipelines using PostgreSQL, Python and AWS.
- Design, develop, and maintain PostgreSQL database architecture for enterprise backend applications.
- Lead schema design, database migrations, versioning, and ensure backward compatibility.
- Optimize SQL queries, indexing strategies, execution plans, and overall database performance.
- Assist in identifying performance bottlenecks in PostgreSQL RDS. Apply basic performance tuning techniques like reviewing query execution plans, adding missing indexes, and recommending parameter adjustments.
- Monitor ETL workflows and data pipelines for errors, performance bottlenecks, and processing delays. Troubleshoot and resolve issues to ensure reliable and timely data movement.
- Provide support for data related issues and participate in root cause analysis.
- Configure and manage database backup and recovery strategies to ensure data integrity and availability in case of failures or data loss.
- Analyze database query performance and collaborate with developers to optimize SQL queries and schemas.
- Participate in continuous improvement initiatives to enhance the reliability, scalability, and performance of cloud databases.
- Assist in the design and optimization of database schemas for cloud environments.
Skills:
- Familiarity with data pipeline concepts and technologies such as Kafka Connect, and ETL frameworks.
- Strong understanding of Amazon Glue, Redshift and S3.
- Exposure to Apache Spark for data processing.
- Basic understanding of Apache Airflow for workflow orchestration.
- Strong SQL scripting skills for querying and data manipulation.
- Strong experience with scripting languages (e.g., Python, Bash).
- Having "AWS Certified Database - Specialty'' certification is a plus.
Experience and Qualifications:
- Bachelor's degree in computer science, Information Technology, or a related field.
- 5-8 years of experience in Data Engineering, with a focus on AWS Glue, Python and PostgreSQL.
- 2-4 years of hands-on experience with PostgreSQL RDS
Job Type: Full-time
Clearance: Confidential
Benefits:
- 401(k)
- Health insurance
- Dental insurance
- Vision insurance
- Paid time off
- Paid holidays
Schedule:
- 9 AM to 5 PM EST, Monday to Friday
- Two days working on site in Reston, VA and 3 days working remotely
Pay: $110,000.00 - $125,000.00 per year
Benefits:
401(k)
Dental insurance
Flexible schedule
Health insurance
Paid time off
Vision insurance
Application Question(s):
Are you eligible for a Public Trust?
Security clearance:
Confidential (Preferred)
Ability to Commute:
Reston, VA 20190 (Required)
Work Location: Hybrid remote in Reston, VA 20190