Senior Developer - SQL Database Engineer

Senior Developer - SQL Database Engineer

Responsibilities

• Design and develop

  high-volume, low-latency applications

  for mission-critical systems, ensuring high-availability and performance.
• Contribute effectively in

  all phases of the development lifecycle

  .
• Write well-designed, testable, and

  efficient code

  .
• Participate in regular

  code reviews

  and lead team

  refactoring efforts

  to improve processes.
• Engage in occasional night and weekend work for high-priority issues, with working hours including at least 8 AM-11 AM ET and every other Thursday, 1-2 hours at 8 PM ET.
• Work with

  stakeholders to gather requirements

  and break down work into manageable tasks.
• Address bugs with QA, design schemas with the engineering team, and respond quickly to business needs within an

  Agile development process

  .

Skills

• Strong SQL expertise

  : ability to write complex queries and a deep understanding of database objects (Tables, views, functions, stored procedures, triggers, etc.).
• Experience in

  data modeling

  and understanding of

  data warehousing architecture

  , including star and snowflake schema design, and data integration of disparate systems.

• SQL Server administration experience

  : familiarity with users, permissions, backups, recovery, and monitoring.

• Database tuning experience

  : ability to run diagnostics, optimize queries, build indexes, and perform performance tuning.
• Experience with

  best practices around database operations

  and troubleshooting potential issues, including testing/tracking bugs at the raw data level.

• ETL experience is a must (SSIS)

  , with an understanding of various raw data sources (flat file, ODBC, XML, JSON) and how to manipulate them.
• Understanding of common data warehouse best practices and

  data cleansing

  techniques.
• Willingness to work in an

  Agile development process

  and familiarity with tools (JIRA/Bamboo/git/etc).
• Experience working in

  production systems

  .
• A strong desire to learn new technologies and a

  growth mentality

  .

• Excellent written and verbal communication skills

  .
• Strong attention to detail and problem-solving skills.
• Ability to manage multiple priorities in a fast-paced, dynamic environment.
• Adaptable and flexible, with a positive attitude and willingness to accept input.

Qualifications

• Relevant experience working as a

  database engineer

  or in a related role.
• Preferred: Degree in

  computer science

  or other technical domain.
• Preferred: Experience with both

  MySQL and Microsoft SQL Server

  .
• Preferred: Experience with

  Python

  .
• Preferred: Experience developing

  data-driven healthcare applications

  , including payer claims/attribution models.
• Preferred:

  Microsoft MCSA or MCSE data certifications

  .
• Ability to work and thrive in a strong team environment.