SQL Database Developer - CBP public trust or Top Secret required
General Dynamics Information Technology3 months ago
Ashburn, VA, USASenior
Base Salary
$81k - $109k/yr
Responsibilities
- Create new database structures, update existing structures, and manage data in large, complex databases.
- Develop complex SQL and write DDL, DML, and DCL.
- Perform data profiling, cleansing, reporting, staging, and ETL jobs.
- Troubleshoot SQL issues, tune database performance, and write performance queries.
- Develop PostgreSQL databases and Python scripts.
- Support AWS data migration, validation, data pipelines, and related monitoring and observability tools.
- Collaborate with program staff, technical teams, and customers to make design decisions within constraints.
- Learn new tools and DB2 as needed.
Requirements
- Bachelor’s degree plus 5+ years of experience in database development roles.
- Strong experience with complex SQL, SQL troubleshooting, performance tuning, and performance queries.
- Hands-on PostgreSQL database development experience.
- Experience with data profiling, cleansing, reporting, data staging, and ETL jobs.
- Experience writing DDL, DML, and DCL.
- Experience writing Python scripts and using Git/version control.
- AWS experience with data migration, validation, data pipelines, CloudWatch, Kibana, and Dynatrace.
- U.S. citizenship and ability to obtain CBP public trust; existing CBP, ICE, or USCIS public trust or Top Secret clearance may provide reciprocity.
- Experience with federal government clients, Oracle, DB2, SQL Server, MySQL, Teradata, Databricks, PySpark, Liquibase, DMS, database administration, Agile methodology, and Jira is preferred.
- Must be local to the National Capital Region and able to communicate and collaborate effectively with clients and technical staff.
Benefits
- Hybrid work arrangement in Ashburn, Virginia, with a full-flex work week where possible.
- 401(k) with company match.
- Medical, dental, vision, health savings account, and wellness plan options.
- Paid vacation, sick and personal time, holidays, and additional paid leave programs.
- Paid education and certifications, professional growth opportunities, and internal mobility support.
- Disability, life, accidental death and dismemberment, critical illness, and other insurance offerings.
- 40 scheduled hours per week with no travel required.
Tech Stack
Categories
BackendData Engineering
About General Dynamics Information Technology
General Dynamics Information Technology (GDIT) delivers enterprise IT, systems integration, cybersecurity, cloud, and software engineering services to U.S. federal agencies, including defense and intelligence organizations. It provides contract-based professional and managed services ranging from network operations and unified communications to training and simulation. GDIT is a business unit of General Dynamics (NYSE: GD) and is headquartered in Falls Church, Virginia.