SQL Database Developer - CBP public trust or Top Secret required

General Dynamics Information Technology; Ashburn (VA); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Full-flex work week

401K with company match

Comprehensive health and wellness

Internal mobility team

Professional growth opportunities

Cutting-edge technology

Paid vacation and holidays

Job summary

General Dynamics Information Technology in the National Capital Region seeks a Database Developer to support an active program of application development—creating new structures, updating existing ones and managing data within large, complex databases.

The role requires US citizenship and the ability to obtain a CBP public trust. You will work with PostgreSQL, SQL, ETL, Python scripts and AWS data pipelines in a collaborative team, learning new skills while delivering robust data solutions.

Qualifications

• 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.

Skills

Database development

SQL development

Data profiling

ETL

DDL/DML/DCL

PostgreSQL

Python

Git

AWS data pipelines

Jira

Data migration

Education

Bachelor's degree

Tools

PostgreSQL

Python

Git

AWS

Jira

Job description

HOW A DATABASE DEVELOPER WILL MAKE AN IMPACT

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

WHAT YOU’LL NEED TO SUCCEED:

Required Skills and Experience:

• 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

Preferred Skills and Experience:

• 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

GDIT IS YOUR PLACE:

• Full-flex work week to own your priorities at work and at home
• 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