SQL Database Developer - CBP public trust preferred

GD Information Technology•Ashburn, VA

16h•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

Responsibilities

Creating new structures
Updating existing structures
Managing data within large, complex databases
Troubleshooting, tuning SQL and writing performance queries
Writing DDL, DML and DCL
Data migration
Data validation
Data pipelines

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
A vision plan
A 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
Variety of paid time off plans, including vacation, sick and personal time, holidays, 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