Aurora AWS Database-DataWarehouse Developer - job id 32331


Your Way To Work™

Aurora AWS Database-DataWarehouse Developer

Market $$$ - Per Year F/T Employee

NY



How to Apply

logo

Jason Vu


logo

(646) 876-9536


logo

(212) 616-4800 ext-290




A Full-time position at primary business is to manage client and proprietary capital through global macro hedge fund strategies. Assets are managed via a broad mandate to trade in a variety of global markets and instruments..


Pay Options: F/T Employee.

Contact Jason Vu. call (646)876-9536 / (212)616-4800 ext.290 or email jason@sans.com with the Job Code JV32331 or Click the Apply Now button ().

Location: Midtown.

Skills required for the position: ORACLE, MS SQL SERVER, QUERY, WINDOWS, UNIX, DATA WAREHOUSING.


Detailed Info:


The Data, Databases & Reporting team (DDR), a sub team within the Core Development, Reporting & Data

Group is seeking an experienced Database & Data Warehouse Developer to join the firm's Technology department


REQUIREMENTS

Key Responsibilities:


Working with business users and technical managers to develop and refine reporting and analytics requirements

Working with the various groups to identify and resolve data issues through configuration of data cleansing and migration to new systems

Managing the database aspects of the reporting and analytics platforms to ensure that reporting jobs are successfully run and analytics data aligns to timeliness / completeness requirements

Ensure each database and data warehouse is tuned for optimal performance


Design, maintain, enhance ETL process and schedules for all aspects of the firm's positions, trades and pricing information

Design data models and define both logical and physical models

Administer all requirements and design various functional specifications for data

Prepare ad hoc queries reports for both technical and business teams

Design and implement various unit tests on system and prepare test data

Performing different kinds of testing including Functionality, Compatibility, Integration, Regression, Performance, Stress, Error Paths of database services

Working with other teams to deliver and operate large scale, distributed services in the cloud

Mentoring other offshore engineers, defining our technical


Development/Computing Environment:

Experience Required:


Good working knowledge of Aurora AWS, Windows and UNIX

Strong SQL coding and tuning experience

Experience troubleshooting application and system performance and complex, production software issues

Experience executing and interpreting results from database performance benchmarks

Ability to lead projects and drive them to completion

Ability to work in a fast paced and agile development environment

Possess excellent communication skills and experience working with external customers (both technical and non-technical audiences)

Advanced SQL coding, tuning and query optimization

Knowledge of database internals as it relates to query and system performance and tuning

Understanding of overall system architecture, scalability, reliability, and performance in a database environment


Experience designing and leading database performance benchmarks

Hands-on experience in scripting test-automation and execution framework

Hands-on experience in open source databases (MySQL, Postgres)

Hands-on experience in commercial databases (Oracle, MS SQL)

Hands-on experience in Aurora AWS including RDS solutions for Aurora

Hands-on experience with a Reporting solution, preferably Tableau or Power BI

Experience in diagnosing and trouble-shooting complex, production software

Ability to drive tasks to completion and take ownership of projects

Ability to work in a fast paced and agile development environment

Possess excellent communication, sharp analytical ab.

The position offers competitive compensation package.


Job Id: 32331