Senior Database Developer

Raas Infotek - New York, NY

Full-time - Mid Level

New York, NY

Professional, Scientific, and Technical Services

About the position

The Senior Database Developer will play a crucial role in designing, developing, and enhancing backend data integration and movement processes within a financial services firm. This position requires collaboration with peers and business analysts to execute complex data integrations, manage the full lifecycle of SSIS package development, and support ongoing improvements to existing packages. The successful candidate will also work closely with application developers and tier 2 support teams to resolve production issues.

Responsibilities

• Gathering and analyzing data integration requirements from internal business and technical stakeholders.
• Designing, developing, and deploying robust SSIS packages for data extraction, transformation, loading, and synchronization across internal databases.
• Designing, developing, and deploying SSRS-based reports for internal distribution.
• Crafting complex packages, stored procedures, functions, tables, views, triggers, indexes, constraints, etc.
• Implementing error handling, logging, and monitoring as standard features within SSIS packages.
• Conducting performance tuning and query optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Applying knowledge of how indexes are structured, how statistics work and affect query plans, how indexes are stored, how they can be created and managed effectively.
• Processing incoming data in common formats such as JSON and XML.
• Documenting SSIS package designs, data flows, and processes for knowledge transfer and maintenance.
• Providing guidance and support to application developers including promoting database design and implementation best practices.

Requirements

• 5+ years experience in designing, developing, and deploying SSIS packages for complex data integration scenarios within a Microsoft-centric environment, including SQL Server.
• Experienced in working with Visual Studio Database Projects and SQL Server Data Tools (SSDT).
• Demonstrated expertise in working in a complex business and technical environment.
• Strong understanding of SSIS architecture, components, and best practices.
• Proven abilities to investigate, diagnose and resolve production incidents raised by tier 2 support.
• Keen analytic and problem-solving skills.
• Articulate individual who can interact with developers, technologists, and business stakeholders.

Nice-to-haves

• Experience working in financial services or another regulated environment is a plus.