Senior Associate, Database Administration

The Options Clearing Corporation; Chicago (IL); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Hybrid work environment

Tuition Reimbursement

Student Loan Repayment Assistance

Technology Stipend for remote device

Generous PTO and parental leave

401(k) employer match

Competitive health benefits

Job summary

The Options Clearing Corporation (OCC) is seeking an Associate Database Administrator to design and maintain database solutions that operate within prescribed resource limits and meet company standards. You will actively participate in system development projects, monitor and tune database and application performance, and provide on‑call support for production issues.

The role includes designing, implementing, and maintaining databases, monitoring performance, backing up data, and supporting

Qualifications

• 3+ years of experience as an associate DBA.
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies.
• Proficient in all access methods of a DBMS and underlying operating system access methods.
• Bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.

Responsibilities

• Assist with the design, implementation, and maintenance of databases.
• Manage database performance and disk usage.
• Provide support for database access methods.
• Consult on database analysis, modeling, coding, and production problem resolution.
• Develop maintenance, backup, and recovery procedures and documentation.
• Participate in disaster recovery drills.
• Provide primary on‑call support for production problems.
• Understand and support corporate data standards.
• Recommend and assist with new DBMS and operational standards.
• Participate in testing and evaluation of new software and release upgrades.
• Support business studies, proposal teams, and feasibility studies.
• Prepare system documentation.
• Maintain metadata repositories.
• Perform other duties as assigned.

Skills

SQL/DBMS proficiency

Database performance tuning

On-call production support

Education

Bachelor's degree in CS/Engineering/Math/Business

Tools

Terraform

Ansible

Jenkins

CI/CD

PostgreSQL

Microsoft SQL Server

Job description

Job Overview

As an associate Database Administrator at the Options Clearing Corporation (OCC), you will design and maintain database solutions that operate within prescribed resource limits and meet company standards. You will actively participate in system development projects, monitor and tune database and application performance, and provide on‑call support for production issues.

Key Responsibilities

• Assist with the design, implementation, and maintenance of databases.
• Manage database performance and disk usage.
• Provide support for database access methods.
• Consult on database analysis, modeling, coding, and production problem resolution.
• Develop maintenance, backup, and recovery procedures and documentation.
• Participate in disaster recovery drills.
• Provide primary on‑call support for production problems.
• Understand and support corporate data standards.
• Recommend and assist with new DBMS and operational standards.
• Participate in testing and evaluation of new software and release upgrades.
• Support business studies, proposal teams, and feasibility studies.
• Prepare system documentation.
• Maintain metadata repositories.
• Perform other duties as assigned.

Qualifications

Required:

• 3+ years’ experience as an associate DBA.
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies.
• Proficient in all access methods of a DBMS and underlying operating system access methods.
• Bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.

Preferred:

• 3+ years’ experience with Microsoft SQL Server.
• 1+ year of Terraform, Ansible, Jenkins, and CI/CD skills or enthusiastic to learn.
• 3+ years’ experience with PostgreSQL.
• Microsoft Certified: Database Administrator Associate.

Benefits

• Hybrid work environment allowing up to 2 days per week remote.
• Tuition Reimbursement to support continued education.
• Student Loan Repayment Assistance.
• Technology Stipend for remote device use.
• Generous PTO and parental leave.
• 401(k) employer match.
• Competitive health benefits including medical, dental, and vision.

EEO Statement

OCC is an equal opportunity employer that is committed to diversity, equity, and inclusion. OCC provides equal employment opportunities to all employees and applicants for employment without regard to race, color, national origin, citizenship status, sex, sexual orientation, gender identity or expression, disability, age, marital status, religion, veteran status, or any other characteristics protected by applicable federal, state, or local laws.