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.
Requirements
- Experience in data profiling, cleansing, reporting, data staging, ETL jobs, batch jobs, partitioning and replication
- Strong experience creating complex SQL in complex data environments including entity relationships, data modeling, data normalization/denormalization
- 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 shell script/Perl script including the command line experience
- Experience with Git/version control
Responsibilities
- creating new structures
- updating existing ones
- managing data within large, complex databases
- data profiling, cleansing, reporting, data staging, ETL jobs, batch jobs, partitioning and replication
- creating complex SQL in complex data environments including entity relationships, data modeling, data normalization/denormalization
- troubleshooting, tuning SQL and writing performance queries
- writing DDL, DML and DCL
Other
- Active Public Trust in DHS or a component of DHS
- Bachelor's degree plus 10+ years in database development roles
- 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
