SQL Database Developer - CBP public trust preferred
General Dynamics Information Technology•Ashburn, VA
•$81,349 - $109,250•Hybrid
About The Position
The Database Developer will work with a team of database developers and database administrators to support an active program of application development - creating new structures, updating existing ones and managing data within large, complex databases. This is a great opportunity to learn a new domain and a new skillsets in a dynamic environment. Candidate must be a US Citizen and able to obtain a CBP public trust. Candidates that have the following clearances CBP/ICE/USCIS Public Trust, or a Top Secret will gain reciprocity. Candidate must be local to the National Capital Region.
Requirements
- Bachelor's degree plus 5+ years in database development roles
- Experience in data profiling, cleansing, reporting, data staging, ETL jobs
- Strong experience creating complex SQL in complex data environments
- Strong experience troubleshooting, tuning SQL and writing performance queries
- Experience in writing DDL, DML and DCL
- Hands-on experience with PostgreSQL database development
- Experience writing Python scripts
- Experience with Git/version control
- AWS experience including data migration, validation, data pipelines, CloudWatch, Kibana and Dynatrace
- Ability to learn new tools quickly as needed to provide new ideas for solving problems
- Ability and desire to work with other program staff and customers to reach design decisions within given constraints
- Excellent diplomacy and communication skills with both clients and technical staff
- US Citizenship Required
- Able to obtain a CBP public trust
Nice To Haves
- Experience working with federal government clients
- Experience with Oracle/DB2/SQLServer/MySQl/Terradata
- Experience with Databricks, PySpark, Liquibase, DMS
- Experience in database administration
- Experience with Agile methodology and use of Jira for tracking
- Must be willing to learn DB2 if not already a skill set
- CBP/ICE/USCIS Public Trust, or a Top Secret clearance
Responsibilities
- Creating new structures
- Updating existing structures
- Managing data within large, complex databases
- Data profiling
- Cleansing data
- Reporting
- Data staging
- ETL jobs
- Writing DDL, DML and DCL
- PostgreSQL database development
- Writing Python scripts
- AWS experience including data migration, validation, data pipelines, CloudWatch, Kibana and Dynatrace
- Learning new tools quickly as needed to provide new ideas for solving problems
- Working with other program staff and customers to reach design decisions within given constraints
Benefits
- Full-flex work week
- 401K with company match
- Comprehensive health and wellness packages
- Internal mobility team dedicated to helping you own your career
- Professional growth opportunities including paid education and certifications
- Cutting-edge technology you can learn from
- Rest and recharge with paid vacation and holidays
- Variety of medical plan options, some with Health Savings Accounts
- Dental plan options
- Vision plan
- 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
- Paid parental, military, bereavement and jury duty leave
- Short and long-term disability benefits
- Life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
