Senior Associate, Database Administration

The Options Clearing Corporation; Chicago (IL); On-site; USD 112,000 - 152,500; Full time

Benefits offered by this job

Tuition Reimbursement

Student Loan Repayment Assistance

Technology Stipend

Generous PTO

401k Employer Match

Competitive health benefits

Job summary

The Options Clearing Corporation in Chicago is seeking an Associate Principal for Database Administration. This role requires designing and maintaining databases, along with monitoring performance and providing support for database systems.

Candidates should have over 3 years of experience with DBMS technologies, including proficiency in Microsoft SQL Server and PostgreSQL. The company offers a hybrid work environment, competitive compensation, and benefits.

Qualifications

• 3+ years' experience as an associate DBA.
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies.
• Bachelor's degree (or equivalent) required.

Responsibilities

• Design and maintain databases and solutions that meet company standards.
• Monitor and tune database performance.
• Provide support in database analysis, modeling, and coding.

Skills

DML, DDL, and database utilities

Database management and performance

Microsoft SQL Server

Terraform

Ansible

PostgreSQL

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or Business

Tools

SQL Server

PostgreSQL

Terraform

Ansible

Jenkins

Job description

## Associate Principal, Database AdministrationApplylocations: Chicago - 125 S Franklintime type: Full timeposted on: Posted 2 Days Agojob requisition id: REQ-4614***To be considered for this position, applications and resumes are accepted only through our careers site by directly applying to the posted job. We do not accept unsolicited resumes or sales solicitations from staffing agencies. Any OCC employee wishing to submit a referral must do so through their Workday account. Any resume submitted outside of an active job posting will not be considered for employment.*****What You'll Do:**This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.**Primary Duties and Responsibilities:**To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.* 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**Supervisory Responsibilities:*** None**Qualifications:**The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.* [Required] 3+ years’ experience as an associate DBA* [Required] Proficient in DML, DDL, and database utilities for at least two DBMS technologies* [Required] Proficient in all access methods of a DBMS as well as the underlying operating system access methods**Technical Skills:*** [Preferred] 3+ years’ experience with Microsoft SQL Server* [Preferred] 1+ year Terraform, Ansible, Jenkins & CI/CD skills or enthusiastic to learn* [Preferred] 3+ year PostgreSQL**Education and/or Experience:*** [Required] bachelor s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business* [Preferred] Related financial industry experiences**Certificates or Licenses:*** [Preferred] Microsoft Certified: Database Administrator Associate**About Us**The Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization. Founded in 1973, OCC is dedicated to promoting stability and market integrity by delivering clearing and settlement services for options, futures and securities lending transactions. As a Systemically Important Financial Market Utility (SIFMU), OCC operates under the jurisdiction of the U.S. Securities and Exchange Commission (SEC), the U.S. Commodity Futures Trading Commission (CFTC), and the Board of Governors of the Federal Reserve System. OCC has more than 100 clearing members and provides central counterparty (CCP) clearing and settlement services to 19 exchanges and trading platforms. More information about OCC is available at www.theocc.com.**Benefits**A highly collaborative and supportive environment developed to encourage work-life balance and employee wellness. Some of these components include:* 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 visionVisit https://www.theocc.com/careers/thriving-together for more information.**Compensation*** The salary range listed for any given position is exclusive of fringe benefits and potential bonuses. If hired at OCC, your final base salary compensation will be determined by factors such as skills, experience and/or education.* In addition, we believe in the importance of pay equity and consider internal equity of our current team members as part of any final offer.* We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. We also offer a substantial benefits package as noted on www.theocc.com/careers* All employees may be eligible for a discretionary bonus. Discretionary bonuses are based on various factors, including, but not limited to, company and individual performance and are not guaranteed.**Salary Range**$112,000.00 - $152,500.00**Incentive Range**8% to 15%This position is eligible for an annual discretionary incentive compensation award, for which the target range is listed above (see **Incentive Range**). The amount of such award, if any, will be based on various factors, including without limitation, both individual and company performance.