Principal SQL Developer

Macpower Digital Assets Edge LLC
Washington, DC, United States
1 day ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Working hours
Regular working hours

Tech stack

Business Analytics Applications Systems Engineering Backup Devices Big Data Business Software Code Review Databases Data Architecture Data Integrity Extract Transform Load (ETL) Data Systems Data Warehousing
+32 more
Database Security DevOps Disaster Recovery Apache Hadoop Python (Programming Language) PostgreSQL Microsoft SQL Server SQL Azure MySQL Oracle (Applications) Performance Tuning Cloud Services SQL Stored Procedures PL-SQL SQL Databases SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Transact-SQL Enterprise Data Management Freeform SQL Azure Data Factory Sql Server Database Administration System Availability Snowflake Database Optimization Apache Spark Data Strategy Amazon Relational Database Service Information Technology Data Pipelines Databricks

Job description

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

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…