Contractor Senior Database Developer

Duties & Responsibilities
Responsibilities include but are not limited to:

• 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. Includes consuming and producing data from/to external customers including exchanges, industry regulators and third-party platforms.
• 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.
• Applying strong knowledge of database design, normalization concepts, primary and foreign key constraints.
• 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.
• Using other common SQL Server tools (Profiler, SSIS, SSMS, PerfMon, DMVs).
• 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.

Qualifications:

• Experienced in working with Visual Studio Database Projects and SQL Server Data Tools (SSDT).
• Comfortable working both independently and within small project teams.
• Capable of producing documentation around designs, processes, and procedures.
• Proven abilities to investigate, diagnose and resolve production incidents raised by tier 2 support, often also involving other developers during the process.
• Experience working in financial services or another regulated environment is a plus.
• 5+ years experience in designing, developing, and deploying SSIS packages for complex data integration scenarios within a Microsoft-centric environment, including SQL Server.
• Demonstrated expertise in working in a complex business and technical environment.
• Keen analytic and problem-solving skills.
• Articulate individual who can interact with developers, technologists, and business stakeholders.
• Strong understanding of SSIS architecture, components, and best practices.