Dev Technology is looking to hire a Database Developer to support an active program of application development, which involves creating new database 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 DB2 or 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 and managing data within large, complex databases
- 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 DB2 or PostgreSQL database development
- Experience writing shell script/Perl script including the command line experience
Other
- Active Public Trust in DHS or a component of DHS
- Bachelor's degree plus 5+ 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
