Database Engineer

Jump Trading Chicago , IL 60602

Posted 6 months ago

Database Engineer

The Database team at Jump Trading is responsible for all aspects of data, including loading, curating, refinement, warehousing, replication, reporting, reconciliation, optimization and backup. The team manages data architecture, database servers, the data warehouse, replication, ETL and reporting tools and is also heavily involved with software development, design and testing.

Customers of the database team include all groups within the firm : clearing, compliance, accounting, trading, core development, reporting teams, QA and management.The team is currently seeking a Database Engineer who has extensive experience with more than one RDBMS platform, knowledge of database design, performance and optimization, data warehousing,experience with application development and automation and an eagerness to dive into new technologies.

What you'll do:

  • Develop data architecture, modeling, and ETL mapping solutions for a warehouse environment with consistency and integrity using data from many disparate sources

  • Automate the capturing of statistical data about large numbers of queries/users/database objects/computing infrastructure. Identify bottlenecks and create solutions for them

  • Develop solutions on a very large scale transaction processing system

  • Research and upgrade our existing databases and build new data warehouses

  • Work alongside both business and technical teams to tackle challenging problems with efficient and creative technical solutions

  • Monitor the databases to ensure optimal availability and performance

  • Weekend and off hours on call schedule

Skills you'll need:

  • 5+ years of database development experience (MySQL / MariaDB / Percona, SAP ASE or MS SQL, SAP IQ)

  • 5+ years of database administration skills on Unix/Linux

  • Proficiency with SQL including stored procedures

  • Experience with data loading, transformation, extraction, profiling, reporting and analytical tools to develop accurate reporting and analysis in order to facilitate data driven decisions for the company.

  • Scripting experience, Python preferred, Shell in a Linux environment and ability to automate recurring tasks

  • Data warehousing experience; Worked with large data sets and handled performance tuning

  • Experience with BI and ETL tools

  • BS/MS in Computer Science or related field

Bonus points:

  • Industry experience in finance/trading

  • Supporting post-trade processing systems

  • Designing large scale BPM/Workflow/eCommerce solutions

  • High Availability, Database Scalability

  • Python, pandas, matplotlib

  • Object oriented language such as Java, Go, C++

  • Open source software and databases

  • Kafka experience

  • MPP Databases (Redshift, Greenplum, ...)

  • Amazon Aurora or Google CloudSQL, Cloud experience

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Engineer

Echo Global Logistics

Posted 2 months ago

VIEW JOBS 7/11/2019 12:00:00 AM 2019-10-09T00:00 Position Purpose The Database Engineer contributes to the design and management of Echo's large scale database systems while supporting the strategic architectural vision of quality, scalability, performance and function. Essential Position Functions Principal Accountability | Technical Planning * Contribute to design and development of extensible/sustainable/quality database solutions based on an understanding of business and customer requirements and needs * Contributes to technical design including high-level conceptual diagrams, updates to data dictionary, creation of standards * Commands a broad awareness of related projects Principal Accountability | Database Engineering * Active member of a data team that solves complex challenges and builds working database solutions * Collaborates with the team to develop database structures that fit into the overall architecture of the systems under development * Exhibits sound, methodical engineering judgment, and effectively manages trade-offs among data volumes, number of users logical and physical distribution, response times, retention rules, security and domain controls * Codes, installs, optimizes, and debugs database queries and stored procedures using appropriate tools or editors * Performs code reviews, providing feedback in a timely manner. * Promotes collective code ownership so that everyone has visibility into the feature codebase * Addresses technical debt * Provides development expertise to team members through education and review * Presents technical ideas and concepts in business -friendly language Principal Accountability | Database Operations * Proactively monitors database trends and acts to improve database systems and processes * Identifies tactical risks and raises/resolves issues effectively * Provides recommendations for and analysis and evaluation of systems improvements, optimization, development and/or maintenance efforts including, but not limited to capacity planning * Develops ad-hoc scripts, including clean-up scripts when needed * Identifies and correct performance bottlenecks related to SQL code. * Contributes to selection and design of tools required for management of the database and transaction processing environments * Supports and is accountable for timely production releases and adherence to release activities * Contributes to development of database maintenance plans and data retention strategy Principal Accountability | Team Member * Open to new ideas and encourages innovative practices amongst peers * Practices positive interactions - leans on encouragement in place of judgment. * Impresses responsibility on others by displaying ownership in tasks. * Acts in the interest of the overall team * Actively works on broadening or adding a skill * Asks for assistance when problems become challenging * Balances best practice decisions with delivering high business value (right vs right now) * Contributes to the success of the team * Able to multi-task in a fast paced, fluid work environment Position Requirements * Master's Degree in Computer Science or equivalent years of experience * 5 to 7 years managing commercial-grade database systems leveraging the following: * Microsoft SQL Server * T-SQL * MS SQL Server Integration Services (SSIS) * adept at creating stored procedures, views, user-defined functions, table functions * T-SQL * 5 to 7 years developing solutions or contributing to development leveraging: * Object-Oriented programming techniques (.Net) * Software Development Lifecycles * Unit Test Techniques * Debugging/Analytical Techniques * Proven track record (3 to 5 years) working in fast-paced, time-sensitive project that requires: * Clear and timely communication of key information deemed critical to project success * Managing design risk * Balancing priorities * Going above and beyond the requirement of the role * Articulating technical information to a non-technical audience * Understanding of Scrum/Agile methodologies is preferred * Leading without authority * All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, status as a qualified individual with a disability, or Vietnam era or other protected veteran. Echo Global Logistics Chicago IL

Database Engineer

Jump Trading