Senior Database Developer

Cantor Fitzgerald Securities New York, United States

Posted 8 hours ago Permanent Competitive

Responsibilities

Responsibilities:

Interact with business stakeholders to provide solutions that address business data analytics requirements
Work with SQL and other database access tools and methods to meet business or technical needs
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/frameworks
Conduct shell scripting and advanced SQL development
Identify opportunities to fine-tune and optimize SQL queries and views
Become proficient in the data model and data structures to efficiently respond to business queries and requests
Provide ongoing maintenance and support for database schemas and views
Conduct root-cause analysis and resolve production problems and data issues
Work within the defined software development lifecycle, following established change-control policies

Qualifications

Demonstrated experience working on the design, implementation, and deployment of large, complex software projects.
High Level of expertise with Oracle Database, PL/SQL programming and ASE Sybase,.
Familiarity with Python, Perl or other shell scripting languages.
Advanced proficiency with SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and SQL Performance/Tuning
Advanced proficiency with Packages/Functions/Procedures programming and debugging.
Financial Industry Experience
Experience of working with large volumes of data
Good understanding of 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.