SQL Database Developer - CBP public trust or Top Secret required
- Compensation
- Not disclosed
- Location
- USA VA Ashburn
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Software engineering
- Posted
Skills
Must have
- 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 have
- 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
Full description
Type of Requisition:
RegularClearance Level Must Currently Possess:
OtherClearance Level Must Be Able to Obtain:
NonePublic Trust/Other Required:
BI Full 6C (T4)Job Family:
IT Infrastructure and OperationsJob Qualifications:Skills:
Database Development, SQL Database Development, SQL Server Performance TuningCertifications:
NoneExperience:
3 + years of related experienceUS Citizenship Required:
YesJob 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 RegionWHAT 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