American Board of Internal Medicine | Principal Database Developer

The American Board of Internal Medicine (ABIM) is currently seeking a Principal Database Developer to join our Application Development team. In this role, the Principal Database Developer will serve as the technical Subject Matter Expert (SME) and project champion for all database development related to software systems. They will provide strong technical oversight and support for IT database projects and assignments. The Principal Database Developer will ensure the applications align with the organization's technology infrastructure and business strategy.

Reporting to the Manager, Application Development, the Principal Database Developer has the following primary responsibilities :

• Project / Task Management : Work directly with non-technical users to identify and capture business requirements. Collaborate with professional staff to refine specifications for data requests. Provide technical guidance to other departments regarding cross departmental projects or tasks. Effectively communicate status of assigned projects / tasks . Ensure delivered work meets / performs to technical and functional requirements through testing phases.
• ETL Processes : Develop, manage, and optimize ETL workflows using SSIS to support data migration, integration and transformation needs.
• SQL Performance Reviews : Reviewing tools such as DPA (Database Performance Analyzer) and collaborate with various teams to improve query performance, including reducing logical reads and addressing other performance bottlenecks.
• Mentoring : Providing guidance and mentorship to junior developers on adhering to database coding standards, best practices, and efficient query design. Proficient in sharding / partitioning techniques.
• Database Architecture and Development : Design, develop, and maintain robust database systems that align with business goals and objectives. Optimize database performance, scalability and security. Work with software development team(s) in the creation of database schema objects, integrity constraints, triggers, stored procedures and functions.
• Efficient SQL Coding : Following guidelines for writing efficient queries, using indexing strategies, avoiding unnecessary joins, and ensuring queries are optimized for performance. This may include techniques like EXPLAIN PLAN and other third-party tools to analyze query performance, applying necessary optimizations based on the findings.
• Code Reviews : Leading and participating in code reviews to ensure that the database code adheres to established coding standards and that potential issues related to performance, security, and maintainability are identified and addressed early.
• Documentation and DB Test Environment Maintenance : Create and maintain technical documentation. Maintain database testing environment for various development groups.
• Reporting and Analytics : Design and develop dynamic and visually compelling reports and dashboards using SSRS and Power BI. Ensure the accuracy and timeliness of reporting solutions to support business intelligence initiatives.
• Collaboration : Partner with stakeholders, product managers, and development teams to translate business requirements into technical solutions.

The ideal candidate has a minimum of 10 years of experience in database developer using SQL Server. Experience with Continuous Integration, all stages of Software Development Life Cycle (SDLC) is required. Experience with Oracle is preferred. They must have excellent personnel and program management skills, combined with careful attention to detail, schedules and deadlines. A strong background in prioritizing and coordinating complex projects is required.

A demonstrated knowledge of the following software, languages, and tools as listed below are necessary to succeed in this role :

SQL and SQL server tools

SSIS, SSRS

Entity Relationship diagrams (ERD)

ETL tasks and application tuning

Database administration, creation and management of schema objects

At the American Board of Internal Medicine (ABIM), our team of unique and talented professionals, and the inspiring work they do, are essential to meeting the needs and expectations of ABIM’s diverse community of physicians.

ABIM is like no other workplace, and we are proud of it. We are committed to recognizing the importance of our people by investing in their lives through ongoing learning opportunities and exceptional total compensation and benefit offerings.

We look forward to learning more about your interest in joining our team. EOE