Database Engineer with Security Clearance
Why This Role Stands Out
This hybrid Database Engineer role offers significant opportunities for professional growth and skill development within a reputable company known for cutting-edge technology, perfect for a mid-senior professional with a Secret clearance seeking to impact large-scale data projects. You'll leverage your expertise in PostgreSQL, Python, and AWS to optimize data management and pipelines, enjoying a vibrant work environment and competitive compensation.
Quick Overview
Job Description
This is a full-time Hybrid role, 2 days on-site in DC. 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 large-scale Data Architecture and Data Management projects across Federal agencies. Responsibilities: • Database engineers 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 If you are interested in this position, please send me a copy of your latest resume. Also, please let me know what time/number is best to call to discuss this great opportunity. In case you are not interested in this position, or this is not the right fit for you, please feel free to share this opportunity with your friends/networks or anyone you know who may be interested in this position. Thank you! • Availability to start a new job • Best Rates • Contact Regards, Nia Manzoor
Senior Recruitment Professional
Phone: (703) 463-9141
Main: (703) 962-6001 Ext. 648
Email:
Skills
Similar jobs
Software Development Engineer II, SCOT-Inbound, Inventory Routing and Replenishment
Amazon.com Services LLC · Bellevue, United States
51 minutes ago$143.7k - $194.4k/yrNetwork Infrastructure Engineer I, Amazon Dedicated Cloud (NIDD)
Amazon Data Services, Inc. · Culpeper, United States
51 minutes agoElectrical Engineer, Data Center, Colocation Regional Engineering - AMER
Amazon Data Services, Inc. · Mesa, United States
51 minutes agoSenior Product Design Electrical Engineer, Data Center Engineering - Electrical Products and Services (DCE-EPS)
Amazon Data Services, Inc. · Herndon, United States
51 minutes ago$136.6k - $184.8k/yrOptical System Engineer III, Amazon Robotics
Amazon.com Services LLC · North Reading, United States
51 minutes ago$151.2k - $204.6k/yrSoftware Dev Engineer II, Sales Insights and Data Science
Amazon.com Services LLC · Seattle, United States
51 minutes ago$143.7k - $194.4k/yr