Principal SQL Developer

Macpower Digital Assets Edge Private Limited

Washington, DC

JOB DETAILS
SALARY
$152,000–$163,000 Per Year
SKILLS
Access Control, Amazon Relational Database Service (RDS), Apache Hadoop, Apache Spark, Big Data, Business Solutions, Capacity Management, Cloud Computing, Clustering Software, Code Reviews, Communication Skills, Computer Science, Data Analysis, Data Modeling, Data Quality, Data Recovery, Data Science, Data Warehousing, Database Administration, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), DevOps, Disaster Recovery, Documentation, Enterprise Applications, Government, HIPAA (Health Insurance Portability and Accountability Act), Healthcare Software, High Availability, Identify Issues, Informatica, Information Technology & Information Systems, Information/Data Security (InfoSec), Integration Testing, Leadership, MCDBA - Microsoft Certified Database Administrator, Mentoring, Microsoft Certifications, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, MySQL, Operations Processes, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, PostgreSQL, Product Lifecycle, Public Finance, Public Health, Python Programming/Scripting Language, Regulations, Regulatory Requirements, Replication and Remote Mirroring, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Snowflake Schema, Star Schema, Stored Procedures, System Lifecycle, Systems Engineering, Technical Leadership, Technical/Engineering Design, Test Plan/Schedule
LOCATION
Washington, DC
POSTED
23 days ago
Job Summary:
  • Provide technical leadership to design, develop, optimize, and secure enterprise data platforms supporting analytics and critical business applications for a public sector healthcare finance environment.
  • Translate complex business and regulatory requirements into scalable, reliable, high performance data solutions.
Core responsibilities:
  • Lead end to end data architecture for relational and cloud platforms, including schema design, indexing strategies, and data integrity.
  • Own performance tuning for complex SQL queries, stored procedures, and database configurations in high volume environments.
  • Architect, build, and maintain ETL/ELT pipelines to integrate data from diverse sources into data warehouses and downstream stores.
  • Define and govern data modeling standards, design practices, tools, and development lifecycle processes.
  • Enforce database security, access controls, backup/recovery, and disaster recovery aligned to regulations (e.g., HIPAA, GDPR).
  • Proactively monitor databases, troubleshoot complex issues, and implement permanent fixes to minimize downtime.
  • Produce and maintain comprehensive documentation for architectures, pipelines, standards, and operational procedures.
  • Provide technical leadership, code reviews, and mentoring for SQL developers and data engineers.
  • Partner with senior leadership, application teams, data science, and business stakeholders to align data strategies and roadmaps.
  • Create implementation, testing, and integration plans for new platforms, features, and migrations.
  • Lead adoption of advanced data technologies and platforms to maximize IT investment and value.
Required qualifications:
  • Bachelor's degree in IT, Computer Science, or related field, or equivalent experience.
  • 6+ years leading advanced technology or service projects with full systems engineering lifecycle exposure.
  • 6+ years creating implementation, integration, test plans, and training materials.
  • Deep expertise with major DBMS platforms (SQL Server, Oracle, PostgreSQL, MySQL) and advanced T SQL/PL/SQL.
  • Strong experience delivering analytics platforms and enterprise apps using SQL, SSRS, SSIS, SSAS, Azure Data Factory, Databricks, Python, and DAX.
  • Hands on data modeling (dimensional/star/snowflake), ETL tools (SSIS/Informatica), and cloud data platforms (Azure SQL, AWS RDS).
  • Solid knowledge of database architecture, high availability (clustering/replication), and capacity planning.
  • Senior level understanding of healthcare management systems and experience engaging senior executives.
  • Excellent communication and documentation skills.
Preferred qualifications:
  • Master's degree in CS, IT, data, or related field.
  • Certifications such as Microsoft Certified: Azure Database Administrator Associate.
  • Experience with Big Data technologies (Spark, Hadoop) and DevOps practices.

About the Company

M

Macpower Digital Assets Edge Private Limited