Database Developer

C. Mack Solutions is seeking Database Developers to support a complex program to provide Agile development and operations and maintenance for critical systems on a mission-critical program for the Federal Government.

Requirements

• 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.