Job Description
Job Description
Location: Washington, DC
Work Arrangement: Onsite
Duration:12-month contract, with possible extension
W-2 or 1099
No C2C, visa transfers, or sponsorship
The DNA Group is seeking a Solutions Architect SQL Developer to join our client’s Medicaid Data Warehouse Team. This senior-level role will provide technical leadership in architecting, developing, and optimizing enterprise database systems that power critical business applications and analytics. The ideal candidate is a data expert with deep experience in SQL development, data modeling, and performance tuning, capable of translating complex business requirements into scalable, reliable, and secure technical solutions. This position requires strong collaboration with cross-functional teams, mentorship of junior developers, and a strategic mindset to drive data architecture for best practices and long-term data initiatives across the organization.
- Database Architecture & Design: Lead the creation of scalable database structures (relational and NoSQL), including schemas, views, and indexes. Define and approve data models, design standards, and development practices.
- Performance Optimization: Optimize SQL queries, stored procedures, and configurations using tools like SQL Server Profiler to eliminate bottlenecks and boost performance.
- ETL & Data Pipelines: Build and maintain efficient ETL/ELT pipelines for data integration, transformation, and migration across multiple systems.
- Technical Leadership & Mentorship: Guide and mentor developers through code reviews and best practices in SQL, data modeling, and database management.
- Collaboration & Strategy: Partner with leadership, analysts, and developers to align data architecture with business goals and influence the tech roadmap.
- Data Governance & Security: Implement and enforce strong data protection, backup, and disaster recovery strategies ensuring compliance (e.g., GDPR, HIPAA).
- Troubleshooting & Problem Solving: Monitor and resolve complex database issues quickly, ensuring stability and minimal downtime.
- Documentation & Standards: Maintain thorough documentation of database designs, processes, and procedures to ensure continuity and scalability.
Minimum qualifications:
- Technology Leadership: Leads the adoption and implementation of advanced technologies or platforms.
- Subject Matter Expertise: Recognized expert in the functionality and usage of specific systems, platforms, or technology products.
- Client Consulting: Provides strategic guidance to clients on the efficient use and integration of IT products or platforms.
- Implementation & Integration: Develops and executes implementation, testing, and integration plans.
- IT Optimization: Applies deep expertise in IT platforms or services to maximize technology investments.
- Education: Bachelor's degree in information technology or related field, or equivalent experience.
- Certification: Training or certification in relevant IT products, platforms, or services (as required).
Required Experience:
• Project leadership: 6 years (Required)
• Full system engineering lifecycle: 6 years (Required)
• Implementation, integration plans: 6 years (Required)
• Hands-on experience IT products/platforms: 6 years (Required)
• Delivery technology solutions gov't organizations: 8 years (Required)
• Development of data analytics platforms and enterprise applications (SQL, SSRS, SSIS, SSAS, Azure Data Factory, Databricks, Python, DAX): 8 years (Required)
• DBMS platforms (Microsoft SQL Server, Oracle, PostgreSQL, MySQL) and advanced T-SQL/PL-SQL programming: 8 years (Required)
• Data modeling (dimensional, star/snowflake schemas), ETL tools (SSIS, Informatica), and cloud-based data platforms (AWS RDS, Azure SQL): 8 years (Required)
• Database architecture, high availability (clustering, replication), and capacity planning: 8 years (Required)
• Certifications (e.g., Microsoft Certified: Azure Database Administrator Associate), Big Data technologies (Spark, Hadoop), and DevOps: (Highly Desired)
This Job Is Ideal for Someone Who Is:
- A strategic thinker with a passion for data architecture, performance, and system scalability.
- Detail-oriented and driven by delivering high-quality, reliable technical solutions.
- A collaborative leader who enjoys mentoring others and guiding cross-functional teams.
- Proactive and analytical, with strong problem-solving skills and the ability to troubleshoot complex data challenges.
- Adaptable and innovative, thriving in dynamic, fast-paced environments that demand continuous learning.
- Motivated by impactful work, building data systems that directly support organizational goals and decision-making.