Senior Database Engineer - Postgres

DRW; Chicago (IL); On-site; USD 150,000 - 225,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401k matching

Disability insurance

Life insurance

HSA

FSA

Job summary

DRW is a diversified trading firm headquartered in Chicago seeking a Senior Database Engineer focused on PostgreSQL and Oracle. You will own implementation, support, and maintenance of mission-critical database environments, including clustering, backups, and disaster recovery, across multiple environments.

You will collaborate with system engineering and development teams to optimize design, tuning, and performance, ensuring reliability for high-pressure trading operations and evolving business

Qualifications

• 5+ years of production PostgreSQL database engineering experience.
• 5+ years of production Oracle database engineering experience desired.
• Experience with clustering, replication and mirroring a plus.
• Strong knowledge of database performance tuning and configuration tools.
• Proven ability to work in an agile, fast-paced environment, prioritize multiple tasks and projects.

Responsibilities

• Proactively manage and optimize various database platforms and related OS environments.
• Perform database performance and query tuning.
• Implement and maintain production and non-production databases.
• Perform database backups, restores, log shipping, mirroring and replication, etc.
• Collaborate with development teams on database design, implementation and usage optimization.
• Respond to production and business-critical issues and needs.

Skills

PostgreSQL

Oracle

Database performance tuning

Agile/SDLC

Teamwork

Problem solving

Change management

Tools

Clustering

Replication

Mirroring

SAN

Job description

DRW is a diversified trading firm with over 3 decades of experience bringing sophisticated technology and exceptional people together to operate in markets around the world. We value autonomy and the ability to quickly pivot to capture opportunities, so we operate using our own capital and trading at our own risk.

Headquartered in Chicago with offices throughout the U.S., Canada, Europe, and Asia, we trade a variety of asset classes including Fixed Income, ETFs, Equities, FX, Commodities and Energy across all major global markets. We have also leveraged our expertise and technology to expand into three non-traditional strategies: real estate, venture capital and cryptoassets.

We operate with respect, curiosity and open minds. The people who thrive here share our belief that it’s not just what we do that matters–it's how we do it. DRW is a place of high expectations, integrity, innovation and a willingness to challenge consensus.

Senior Database Engineer with focus in PostgreSQL and Oracle who will be responsible for implementation, support and maintenance of mission critical database environments. The administration of these environments includes clustering, storage, securing, monitoring, performance tuning, troubleshooting, and disaster recovery. This person will help manage and support current and future database and storage environments and initiatives, and proactively evaluate physical and logical design and architecture of the systems to keep up with the dynamic and growing business needs of DRW.

Responsibilities:

• Proactively manage and optimize various database platforms and related OS environments
• Perform database performance and query tuning
• Implement and maintain production and non-production databases
• Perform database backups, restores, log shipping, mirroring and replication, etc.
• Work with system engineering team on database server installations, configurations, system performance tuning and capacity planning
• Collaborate with development teams on database design, implementation and usage optimization
• Respond to production and business-critical issues and needs

Position Requirements:

• 5+ years of production PostgreSQL database engineering experience
• 5+ years of production Oracle database engineering experience desired
• Experience with clustering, replication and mirroring a plus
• Strong knowledge of database performance tuning and configuration tools
• Strong technical problem-solving skills essential
• SAN knowledge a plus
• Proven ability to work in an agile, fast-paced environment, prioritize multiple tasks and projects, and efficiently handle pressure and stress
• Must be self-motivated, possess strong initiative, and be willing to take on new challenges
• Must demonstrate strong teamwork and collaboration skills
• Ability to learn new technologies quickly and adapt to different work environments
• Strong understanding of and the proven ability to comply with SDLC, source control and change management protocols
• Excellent verbal and written communication skills

The annual base salary range for this position is $150,000 to $225,000 depending on the candidate’s experience, qualifications, and relevant skill set. The position is also eligible for an annual discretionary bonus. In addition, DRW offers a comprehensive suite of employee benefits including group medical, pharmacy, dental and vision insurance, 401k (with discretionary employer match), short and long-term disability, life and AD&D insurance, health savings accounts, and flexible spending accounts.

For more information about DRW's processing activities and our use of job applicants' data, please view our Privacy Notice at https://drw.com/privacy-notice .

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in DRW ’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval, or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval, or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.