Database Developer
Cantor Fitzgerald
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Tech stack
Big Data
Computer Programming
Databases
Data Integration
ETL
Data Structures
Data Warehousing
Software Debugging
Perl
Python
Metadata Repositories
Oracle
Performance Tuning
Regular Expressions
Shell Script
Software Engineering
PL-SQL
SQL Databases
Sql Optimization
SAP Sybase ASE
Analytic Functions
Sql Tuning
Job description
- 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
Requirements
- 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.