This role is for a Senior Developer - SQL Database Engineer to join a software engineering team focused on building high-performing, scalable, and enterprise-grade data-driven applications. The successful candidate will be a key contributor to mission-critical systems, combining strong database expertise with a collaborative and growth-oriented mindset.
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.