28 days old

Senior Database Programmer

BGC Partners
New York, NY 10007
  • Job Code

Job Description: Senior Database Developer

Cantor Fitzgerald's Technology Team is looking for a Senior Database Developer who will design, develop, implement and support the firm's global data warehouse.

Work with SQL and other database access tools and methods to address business or technical requirements
Design, implement and support data movement solutions across multiple platforms and data sources (Database tables/views and external files) using custom code and ETL tools and frameworks
Conduct PL/SQL, shell scripting and advanced SQL developments
Identify opportunities to fine-tune and optimize SQL queries/views and PL/SQL programs
Become proficient in the data model and data structures to be able to efficiently respond to business queries and requests
Provide ongoing maintenance and support of database schemas and views
Conduct root cause analysis and resolve production problems and data issues
Work within the defined software development lifecycle, following rigorous change control policies

Experience Required:

Interact with business stakeholders to provide solutions addressing business data analytic requirements:

  • Demonstrated experience working on the design, implementation, and deployment of large, complex software projects. (5+ Years)

  • High Level of expertise with Oracle 12c, and PL/SQL programming. (5+ Years)

  • Familiarity with Python, Perl or other shell scripting languages. (3+ Years)

  • Advanced proficiency with Oracle SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and Oracle SQL Performance/Tuning

  • Advanced proficiency with PL/SQL Packages/Functions/Procedures programming and debugging, Oracle Collection and Object Types

  • Experience with Oracle Data Pump, SQL*Loader and external tables framework

  • Experience of working with large volumes of data

  • Good understanding of Oracle Database Architecture

  • Solid understanding of relational and dimensional data models

  • Experience with business intelligence reporting tools, data integration tools , and metadata repository processes and tools

  • Full Software Development Lifecycle, including requirements identification, design, and task estimation.

  • Ability to understand sophisticated mathematical and financial concepts

  • Experience working on financial data model and orders/trade Flows

  • Self-starter with proven ability and initiative to learn and research new concepts, ideas, and technologies quickly

  • Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills

  • Ability to take responsibility and work independently in a high-pressure, time critical environment

  • Expertise in full stack J2EE technologies, Servlets, Angular 2.0, Spring 4.0, HTML 5, XML, JSON, JQuery, JDBC, CSS (Bootstrap), JXLS, IText

    To all recruitment agencies - BGC Partners & affiliates do not accept agency resumes. Please do not forward resumes to our job alias, employees or any other company location. BGC Partners & affiliates are not responsible for any fees related to unsolicited resumes. Please contact the Recruitment function for additional details.

  • Posted: 2020-07-13 Expires: 2020-08-11
    Sponsored by:
    ADP Logo
    Sponsored by:
    Bank of America Logo

    Featured Jobs[ View All ]

    Featured Employers

    Before you go...

    Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

    Share this job:

    Senior Database Programmer

    BGC Partners
    New York, NY 10007

    Join us to start saving your Favorite Jobs!

    Sign In Create Account
    Powered ByCareerCast