Work with a team of database developers and database administrators to support an active program of application development
Create new structures, update existing ones, and manage data within large, complex databases
Perform data profiling, cleansing, reporting, and data staging
Develop and maintain ETL jobs, batch jobs, partitioning and replication processes
Write complex SQL, DDL, DML, DCL and optimize queries for performance
Troubleshoot and tune database performance and validate data migrations
Collaborate with program staff and customers to reach design decisions within constraints
Use Git for version control and work with AWS services (data pipelines, CloudWatch, Kibana, Dynatrace)
Support learning and adoption of new tools and technologies
Requirements
Bachelor's degree plus 5+ years in database development roles
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
AWS experience including data migration, validation, data pipelines, CloudWatch, Kibana and Dynatrace
Ability to learn new tools quickly as needed
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: Degree in Computer Science
Preferred: Experience with Informatica ETL
Preferred: Experience with Oracle
Preferred: Experience working with federal government clients
Preferred: Experience in database administration
Preferred: Experience with Agile methodology and use of Jira for tracking
Preferred: Must be willing to learn DB2 if not already a skill set
Benefits
Generous and flexible time-off policy
Flexible work schedules and telework options, including remote work availability for eligible projects
Career development opportunities including a mentorship program, technical and management training through Dev University, hands-on learning through DevLab, tuition reimbursement, and paid training opportunities
Industry-leading benefits including a choice of two health plans that include dental and vision, flexible spending account, commuter benefits, life insurance, and more
401K matching with a 5% matching contribution
Regular team and company social events including our annual party, happy hours, fitness challenges, and more
A focus on community engagement including company wide support activities, employer match for donations, and time off for volunteer efforts
ATS Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.