Database Engineer

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