Database Engineer (MongoDB, Aurora PostgreSQL, AWS)
About The Position
Peraton is seeking an experienced Database Engineer to provide database expertise and technical guidance to a development team supporting enterprise applications for a Federal Agency customer. The role designs and implements data infrastructure, ETL pipelines, and integration solutions, and supports the Data Architect with database design, performance tuning, optimization, and data pipeline development. It calls for hands-on expertise with MongoDB, Oracle, Databricks, and relational database technologies. The position is onsite in Lanham, Maryland, with a stated schedule of 8 a.m. to 5 p.m. Eastern Standard Time. The engineer supports database environments and ETL platforms for large-scale databases exceeding 5 TB, helping ensure scalability, reliability, performance, and availability.
Requirements
- Bachelor’s degree and 5 years of professional experience, or a high school diploma/equivalent and 9 years of professional experience.
- Must be a U.S. citizen and able to obtain and maintain the required Public Trust level clearance.
- At least 5 years of demonstrated database ETL experience.
- Strong hands-on expertise with MongoDB, Aurora PostgreSQL, RDS, and relational database technologies, including Oracle.
- Strong experience with ETL tools such as Informatica and AWS Glue.
- Demonstrated experience supporting databases larger than 5 TB and optimizing enterprise database environments for performance, scalability, reliability, and availability.
- Ability to provide technical expertise and guidance on database architecture, design, implementation, and operational support.
Nice To Haves
- Active IRS MBI Clearance.
- Experience with Databricks.
- Databricks foundational/basic certification desired.
- Informatica or AWS Glue certification desired.
- Experience supporting highly scalable, enterprise-level database environments.
Responsibilities
- Design and implement ETL workflows using Informatica and AWS Glue.
- Develop data transformation logic to support schema compliance, data accuracy, and data quality.
- Integrate data from on-premises, cloud, and legacy systems.
- Implement data validation and quality checks.
- Optimize pipeline performance and reliability.
- Maintain data lineage tracking and documentation.
- Serve as the Data Subject Matter Expert, providing technical expertise and guidance to development and technical teams.
- Support database design, data modeling, performance tuning, optimization, implementation, and operational support.
- Support MongoDB, Aurora PostgreSQL, RDS, and relational database environments, including Oracle.
- Support ETL platforms for large-scale databases exceeding 5 TB, ensuring scalability, reliability, and performance.
- Troubleshoot complex database issues and identify opportunities for performance and operational improvements.
- Support Databricks and enterprise-level data solutions.
- Collaborate with developers, architects, and technical teams to develop and maintain scalable, high-performing data integration solutions.
Benefits
- Medical, dental, and vision benefits.
- Life insurance.
- Health savings account.
- Short- and long-term disability.
- Employee assistance program (EAP).
- Parental leave.
- 401(k).
- Paid time off (PTO) for vacation.
- Company-paid holidays.
- Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
