Database Developer
C. Mack Solutions
full-time
Posted on:
Location Type: Office
Location: Ashburn • Virginia • United States
Visit company websiteExplore more
About the role
- Support a complex program to provide Agile development and operations and maintenance for critical systems on a mission-critical program for the Federal Government.
- Work alongside database developers and administrators to support active application development efforts.
- Create and update database structures, managing data within large and complex environments, and optimizing performance across AWS and on-prem systems.
- Contribute to data pipelines and replication processes while collaborating with program teams to support design and implementation needs.
Requirements
- You must live within the DC, MD, VA area.
- U.S. Citizenship is required.
- Candidate must be able to obtain CBP Public Trust clearance.
- Bachelor's degree plus 3+ years in database development roles
- Experience in data profiling, cleansing, reporting, data staging, ETL jobs, batch jobs, partitioning and replication
- Strong experience troubleshooting, tuning SQL and writing performance queries for AWS hosted and on-prem databases
- Strong experience in developing, tuning, and monitoring data replication jobs – with strong preference to a replication tool (e.i. Qlik Replicate or similar) and manual scripting from various sources (DB2, Postges, Oracle) to various targets (Databricks, DB2, Postgres).
- Strong experience creating complex SQL in complex data environments including entity relationships, data modeling, data normalization/denormalization
- Experience in writing DDL, DML and DCL
- Hands-on experience with PostgreSQL database development – preferable in AWS RDS environment
- Experience script writing (prefer Python)
- AWS experience encompassing large-scale data migration and validation processes, development and maintenance of end-to-end data pipelines, and performance monitoring.
- Proficient in leveraging Kibana and Dynatrace for log analysis, alerting, and system optimization across distributed cloud environments.
- Quickly adapts to new tools and technologies, using them to propose fresh approaches to problem-solving.
- Works closely with program teams and customers to align on design decisions while respecting project parameters.
- Excellent communication skills with both clients and technical staff.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
database developmentdata profilingdata cleansingETLSQL tuningdata replicationDDLDMLdata modelingPython
Soft Skills
communicationproblem-solvingcollaborationadaptabilitycustomer alignment
Certifications
CBP Public Trust clearance