Senior Database Developer

2 weeks ago

Chicago, United States R.J. O'Brien Full time
Job Title: Senior Database Developer

Business Unit: RJO Technology

Location: Chicago

Reports To: Director, Risk & Portal

Full Time/Part Time: Full Time

Hours: 8:00 a.m. - 5:00 p.m. CST/CDT

Position Summary:

This is a unique opportunity for an experienced SQL Database & SSIS developer to join our team and play an important role in designing, developing, and enhancing our backend data integration and data movement processes in an established financial services firm.

The successful candidate will collaborate with peers and business analysts to understand and execute complex data integrations. They will be responsible for the full lifecycle of SSIS package development, from requirements gathering and design to implementation, testing and deployment. Additionally, this resource will support these capabilities and make ongoing improvements to existing packages to address functional and non-functional requirements.

The successful candidate will collaborate with other developers within the Application Development department and IT teams and interact with business analysts. Additionally, this candidate will work with the firm's tier 2 support teams to diagnose and resolve production issues.

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.


It is the policy of RJO Technology, LLC to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, citizenship, genetic information, or any other characteristic protected by law.

Search Firm Representatives please read carefully:

R.J. O'Brien & Associates, LLC (RJO) is not seeking assistance or accepting unsolicited resumes from search firms for this employment opportunity. All resumes submitted by search firms to any employee at RJO via-email, the Internet or directly to hiring managers at RJO in any form without a valid written search agreement in place for this position will be deemed the sole property of RJO, and no fee will be paid in the event the candidate is hired as a result of the referral or through other means.

  • Senior Database Architect

    1 week ago

    Chicago, Illinois, United States Selby Jennings Full time

    Job Title: Senior Database ArchitectAbout the Role:We are seeking an experienced Senior Database Architect to join our team at Selby Jennings. As a key member of our IT department, you will be responsible for designing and implementing database solutions that meet the evolving needs of our business.Key Responsibilities:- Design and develop high-performance...

  • Senior Database Architect

    1 week ago

    Chicago, Illinois, United States DRW Full time

    Senior Database Engineer RoleAt DRW, we're seeking a highly skilled Senior Database Engineer to join our team. As a key member of our engineering team, you'll be responsible for the implementation, support, and maintenance of our mission-critical database environments. Your expertise in PostgreSQL and Oracle will be essential in ensuring the scalability,...

  • Senior Database Systems Architect

    1 week ago

    Chicago, Illinois, United States Northwestern Memorial Healthcare Full time

    Job SummaryWe are seeking a highly skilled Senior Database Systems Architect to join our team at Northwestern Memorial Healthcare. This is a critical role that requires expertise in designing, implementing, and maintaining high-availability database systems.About the RoleThe Senior Database Systems Architect will be responsible for leading the development of...

  • Database Developer

    2 months ago

    chicago, United States Phillip Capital Inc. Full time

    Phillip Capital Inc. Employment OpportunityJob Title: Database Developer (Hybrid)Location: Chicago, IL Phillip Capital Inc. is seeking a motivated Database Developer to join a growing, agile team of developers to build innovative software solutions for its futures and brokerage businesses. About Phillip Capital Inc. and the Phillip Capital Group Phillip...

  • Database Developer

    2 months ago

    Chicago, United States Phillip Capital Inc. Full time

    Phillip Capital Inc. Employment OpportunityJob Title: Database Developer (Hybrid)Location: Chicago, IL Phillip Capital Inc. is seeking a motivated Database Developer to join a growing, agile team of developers to build innovative software solutions for its futures and brokerage businesses. About Phillip Capital Inc. and the Phillip Capital Group Phillip...

  • Database Developer

    2 months ago

    chicago, United States Phillip Capital Inc. Full time

    Phillip Capital Inc. Employment OpportunityJob Title: Database Developer (Hybrid)Location: Chicago, IL Phillip Capital Inc. is seeking a motivated Database Developer to join a growing, agile team of developers to build innovative software solutions for its futures and brokerage businesses. About Phillip Capital Inc. and the Phillip Capital Group Phillip...

  • Senior Database Administrator

    3 months ago

    Chicago, United States Northwestern Memorial Healthcare Full time

    Job DescriptionThe Senior Database Administrator, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.The Senior Database Administrator is responsible for keeping the...

  • Senior Database Administrator

    2 weeks ago

    Chicago, United States Northwestern Memorial Healthcare Full time

    Company Description At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better healthcare, no matter where you work within the...

  • Senior Database Administrator

    1 week ago

    Chicago, Illinois, United States Northwestern Memorial Healthcare Full time

    Job SummaryThe Senior Database Administrator position at Northwestern Memorial Healthcare is a critical role that requires a high level of technical expertise and strategic thinking. As a member of our Database Team, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure optimal performance and...

  • Database Systems Developer

    1 week ago

    Chicago, Illinois, United States Next Level Business Services, Inc. Full time

    Job Summary: We are seeking a skilled Database Systems Developer to join our team at Next Level Business Services, Inc. As a key member of our IT team, you will be responsible for designing, developing, and maintaining our company's database systems. The ideal candidate will have a strong background in computer programming, database management, and software...

  • Senior Database Systems Specialist

    1 week ago

    Chicago, Illinois, United States Selby Jennings Full time

    Job SummaryWe are seeking an experienced Senior Database Systems Specialist to join our team at Selby Jennings. This is a challenging role that requires expertise in database management and administration, as well as excellent communication and collaboration skills.About the RoleIn this position, you will be responsible for managing and optimizing PostgreSQL...

  • SQL Database Developer

    1 month ago

    chicago, United States Paul Murphy Associates Full time

    Job Title: SQL Server Database DeveloperLocation: Hybrid (3-4 days in office)6-12 Month Contract Job Overview: As a Database Developer, you will design and implement database models and scripts that support commission payout processes. Your expertise in SQL Server and database modeling will be crucial in ensuring accurate and efficient calculations. You will...

  • SQL Database Developer

    1 month ago

    chicago, United States Paul Murphy Associates Full time

    Job Title: SQL Server Database DeveloperLocation: Hybrid (3-4 days in office)6-12 Month Contract Job Overview: As a Database Developer, you will design and implement database models and scripts that support commission payout processes. Your expertise in SQL Server and database modeling will be crucial in ensuring accurate and efficient calculations. You will...

  • SQL Database Developer

    3 months ago

    Chicago, United States Paul Murphy Associates Full time

    Job Title: SQL Server Database DeveloperLocation: Hybrid (3-4 days in office)6-12 Month Contract Job Overview: As a Database Developer, you will design and implement database models and scripts that support commission payout processes. Your expertise in SQL Server and database modeling will be crucial in ensuring accurate and efficient calculations. You will...

  • Senior Database Administrator

    8 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...

  • Database Developer

    1 week ago

    Chicago, United States Diverse Lynx Full time

    Technical Postgres SME who has worked in Database migration from Oracle to PostgreSQL. Should have a thorough understanding of schema and data migration of large database to PostgreSQL2) Very strong expertise in PostgreSQL database3) Very strong expertise and hands-on experience in understanding and rewriting SQL queries, migrating packages, migrating stored...

  • SQL Database Architect

    7 days ago

    Chicago, Illinois, United States Alert IT Solutions Full time

    At Alert IT Solutions, we are seeking a highly skilled SQL Database Architect to join our team. About the RoleThe Senior SQL Report Developer will be responsible for participating in analysis, building, and testing software components for data migration solutions. This includes developing high-quality dataset solutions, researching required data, and...

  • Database Analyst

    8 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Essential Job...

  • Senior Database Administrator

    4 months ago

    Chicago, United States Barrow Wise Consulting, LLC Full time

    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today. Responsibilities:...

  • Senior Power Bi Developer

    4 days ago

    Chicago, United States ZipRecruiter Full time

    Senior Power BI Developer Position Summary We are seeking a skilled Power BI Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions using Microsoft Power BI. You will transform raw data into meaningful insights through interactive dashboards and reports, enabling informed...