Job Title: Database Developer/Data Engineer
Team Profile: This position is for a data engineer role in the transactional data team. Among many other databases, our team manages the firm critical Institutional Trade Capture databases and is responsible for the OTC Derivatives Trades Internal Reporting. We are a team of highly technical individuals who manage a large number of databases that include Big Data volumes. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts are globally distributed, making strong communication skills important to the position. The candidate will be expected to work closely with our IT partners in analyzing and delivering on business requirements.
Role Profile: Development will utilize an agile methodology, which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.), and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be able to work well in teams. Work will include designing, enhancing and developing databases across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 2 support. Collaboration with the Firm's engineering teams is expected.
Major Role & Responsibilities:
#Database Infrastructure Engineering for stability, scalability and capacity planning.
#Application DBA functions: plan & execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
#Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization.
#Enforce database security, standards & guidelines.
QUALIFICATIONS
Required Skills:
# 3-5 years of experience of DB2 Linux version 10.5 and above (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc) and Sybase 15.7 and above
# The candidate must have strong scripting knowledge such as: Python or Perl
# The candidate must have strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc.
#The candidate must have knowledge of database modelling tool such as power designer
#Basic knowledge of other databases is a plus.
#The candidate must have strong scripting knowledge such as: Python or Perl.
#The candidate must have strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc.
#Knowledge of Database cloning tools such as Delphix
#Versioning tools such as perforce and git is a plus, but not required.
#Knowledge of financial instruments would be a great benefit
Personal skills:
Integrity & ownership, good team player, ability to work under time and resource dependencies and constraints, ability to find simple and effective solutions, high degree of motivation to expand technical and business knowledge.