Oracle DBA

Interactive Brokers India Pvt. Ltd. - Chicago, IL

Full-time - Mid Level

Chicago, IL

About the position

The Oracle DBA position at Interactive Brokers involves supporting database operations across Production, Development, and QA environments. The role requires hands-on experience with Oracle databases, particularly version 19c or higher, and emphasizes collaboration with various teams to address business challenges effectively. The DBA will be responsible for diagnosing and resolving database performance issues, ensuring high availability, and participating in projects to enhance database operations.

Responsibilities

• Support database operations in Production, Development, and QA environments.
• Diagnose, troubleshoot, and resolve database performance or availability issues.
• Interact with database users to address issues as needed.
• Utilize Oracle query tuning methodologies and provide tuning suggestions.
• Work with Oracle RMAN, Flashback, DataGuard, Oracle RAC, and ASM.
• Handle large databases and datasets effectively.
• Use Oracle Enterprise Manager to identify performance issues.
• Drive assigned projects to completion according to group standards and procedures.
• Document steps taken and methods utilized in projects.
• Maintain availability after hours and occasionally work nights/weekends for database operations and maintenance.

Requirements

• BS in Computer Science, Mathematics, or a related quantitative field.
• 3-5 years of hands-on experience with Oracle, preferably 19c or higher on Redhat Linux.
• Ability to diagnose, troubleshoot, and resolve database performance or availability issues.
• Experience with Oracle query tuning methodologies.
• Experience with Oracle RMAN, Flashback, DataGuard, Oracle RAC, and ASM.
• Exposure to working with large databases and datasets.
• Experience with Oracle Enterprise Manager.

Nice-to-haves

• Working knowledge of Confluence, Jira, and ServiceNow.
• Superb analytical and problem-solving skills.
• Excellent collaboration and communication skills.
• Comfortable in a fast-paced technology environment.

Benefits

• Competitive salary, annual performance-based bonus and stock grant.
• Retirement plan 401(k) with a competitive company match.
• Excellent health and wellness benefits, including medical, dental, and vision benefits.
• Company-paid medical healthcare premium.
• Wellness screenings and assessments, health coaches, and counseling services through an Employee Assistance Program (EAP).
• Paid time off and a generous parental leave policy.
• Daily company lunch allowance and a fully stocked kitchen with healthy options.
• Corporate events, including team outings, dinners, volunteer activities, and company sports teams.
• Education reimbursement and learning opportunities.
• Modern offices with multi-monitor setups.