Apply on Employer Site

The Options Clearing Corporation (OCC) · 4 hours ago

Lead Associate Principal, Database Administration

Chicago, IL

Full-time

Hybrid

Senior Level, Lead/Staff

$132K/yr - $186K/yr

7+ years exp

The Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization, dedicated to promoting stability and market integrity. They are seeking a Lead Associate Principal in Database Administration to design and maintain databases, monitor performance, and support various database functions within the company.

FinanceFinancial ServicesProperty Management

H1B Sponsor Likely

Responsibilities

Assists with the design, implementation, and maintaining databases

Manage database performance and disk usage

Provides support in database access methods

Provides consultation support in database analysis, modeling, coding, and production problem resolution

Develops maintenance, backup and recovery procedures and documentation

Participates in Disaster Recovery drills

Provides Primary On-Call Support for production problems

Understands and supports corporate data standards

Recommends and assists with new DBMS and operational standards

Participates in testing and in evaluations of new software and software release upgrades

Supports business studies, proposal teams and costing/feasibility studies

Prepares system documentation

Maintains metadata repositories

Other duties as assigned

Qualification

PostgreSQLDatabase AdministrationSystems AnalysisTerraformAnsibleJenkinsCI/CDDBMS TechnologiesEntity/Relationship ModelingDMLDDLBackupRecoverySQL ServerMySQL/MariaDBDB2 LUWDB2 in z/OSPostgreSQL CertificationIBM Certified DBA

Required

3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA

Well versed in all phases of Systems Analysis and Design

Experienced in two or more programming languages and two or more scripting languages

Practiced at Entity/Relationship or Object modeling and translation to physical database designs

Proficient in DML, DDL, and database utilities for at least two DBMS technologies

Proficient in all access methods of a DBMS as well as the underlying operating system access methods

Knowledge of hardware and operating system capabilities within one Environment

Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment

Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility

Speed / Sense of Urgency –Contributes additional effort when necessary to get the job done and to help others meet their objectives

Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise

Communicates openly and effectively. Challenges established practices appropriately

Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations

7+ years' experience with PostgreSQL (preferred EnterpriseDB (EDB) version)

3+ year' Terraform, Ansible, Jenkins & CI/CD skills

bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business

Preferred

3+ years' experience with CTE(CipherTrust Transparent Encryption), Barman (EDB Backup and Recovery Manager) and AWS

5+ years' experience with DB2 LUW; preferably on Red Hat Linux

1+ years' experience with SQL Server

1+ years' experience with MySQL/MariaDB

1+ years' experience with DB2 in a z/OS environment

Related financial industry experiences

PostgreSQL Professional Certification

IBM Certified Database Administrator - DB2 for Linux UNIX and Windows

Benefits

A hybrid work environment, up to 2 days per week of remote work

Tuition Reimbursement to support your continued education

Student Loan Repayment Assistance

Technology Stipend allowing you to use the device of your choice to connect to our network while working remotely

Generous PTO and Parental leave

401k Employer Match

Competitive health benefits including medical, dental and vision

Company

The Options Clearing Corporation (OCC)

Glassdoor3.3

The Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization.

Founded in 1973

Chicago, Illinois, USA

1001-5000 employees

https://www.theocc.com/

H1B Sponsorship

The Options Clearing Corporation (OCC) has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (73)

2024 (96)

2023 (72)

2022 (60)

2021 (37)

2020 (56)