SQL Database Developer - CBP public trust or Top Secret required

General Dynamics Information Technology•Ashburn, VA

3d•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

US Citizenship required
Ability to obtain a CBP public trust
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

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

Responsibilities

Creating new database structures
Updating existing database structures
Managing data within large, complex databases
Troubleshooting and tuning SQL
Writing performance queries
Writing DDL, DML and DCL
Writing Python scripts
Working with Git/version control
Working with AWS services for data migration, validation, and data pipelines
Learning new tools quickly
Working with other program staff and customers to reach design decisions
Communicating with clients and technical staff

Benefits

Full-flex work week
401K with company match
Comprehensive health and wellness packages
Internal mobility team
Professional growth opportunities including paid education and certifications
Paid vacation and holidays
Variety of medical plan options
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 leave
Paid military leave
Paid bereavement leave
Paid jury duty leave
Short-term disability benefits
Long-term disability benefits
Life insurance
Accidental death and dismemberment insurance
Personal accident insurance
Critical illness insurance
Business travel and accident insurance