Jobs
>
Chicago

    Associate Principal, Database Administration - Chicago, United States - The Options Clearing Corporation

    The Options Clearing Corporation
    The Options Clearing Corporation Chicago, United States

    1 week ago

    Default job background
    Description
    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 developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA
    • [Required] Well versed in all phases of Systems Analysis and Design
    • [Required] Experienced in two or more programming languages and two or more scripting languages
    • [Required] Practiced at Entity/Relationship or Object modeling and translation to physical database designs
    • [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
    • [Required] Knowledge of hardware and operating system capabilities within one environment
    • [Required] Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
    • [Required] Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
    • [Required] Speed / Sense of Urgency -Contributes additional effort when necessary to get the job done and to help others meet their objectives
    • [Required] Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
    • [Required] Communicates openly and effectively. Challenges established practices appropriately
    • [Required] Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations
    Technical Skills:
    • [Required] 7+ years' experience with PostgreSQL
    • [Required] 7+ years' experience with DB2 LUW; preferably on Red Hat Linux
    • [Required] Proficient with coding and review of SQL, stored procedures, and triggers
    • [Preferred] 1+ year' Terraform, Ansible, Jenkins & CI/CD skills
    • [Preferred] 1+ years' EDB Postgres & EDB Postgres Distributed experience
    • [Preferred] Basic Java, Perl & Linux Shell script skills
    • [Preferred] 1+ years' experience with SQL Server
    • [Preferred] 1+ years' experience with DB2 in a z/OS environment
    • [Preferred] 1+ years' experience with MySQL/MariaDB
    • [Preferred] Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)
    • [Preferred] Basic JCL & REXX script skills
    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] PostgreSQL Professional Certification
    • [Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows
    Who We Are

    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

    What We Offer

    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

    Competitive health benefits including medical, dental and vision

    Step 1
    When you find a position you're interested in, click the 'Apply' button. Please complete the application and attach your resume.

    Step 2
    You will receive an email notification to confirm that we've received your application.

    Step 3
    If you are called in for an interview, a representative from OCC will contact you to set up a date, time, and location.

    For more information about OCC, please click here.

    OCC is an Equal Opportunity Employer
  • Na Oiwi Kane

    Database Administrator

    2 weeks ago

    Na Oiwi Kane Chicago, United States

    **JOB DESCRIPTION** · **Position Title**:Database Administrator · **Location**:80% Remote, 20% Chicago, IL · **Introduction**: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board ( ...

  • The University of Chicago

    Database Administrator

    3 days ago

    The University of Chicago Chicago, United States

    Department · BSD BIS - Business Intelligence Services · About the Department · About the Department · The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and translational research, education, and patient care come togeth ...

  • Performix

    Database Administrator

    4 days ago

    Performix Chicago, United States

    Job Description: · Database Engineers administer, test, and implement databases, applying knowledge of database management systems. · Database Engineer Responsibilities and Duties: · Assist in design and development of distributed database systems. · Optimize database systems for ...

  • Belvedere Trading

    Junior Database Administrator

    2 weeks ago

    Belvedere Trading Chicago, United States

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...

  • TechCoreGlobal

    SQL Database Administrator

    5 days ago

    TechCoreGlobal Chicago, United States

    **Title: SQL DBA** · **Location: Chicago, IL (Onsite - Open for relocation )** · **Good SQL DBA skills, having some experience of doing TDE data base encryption & automations in the DBA space.** · **Responsibilities**: · - Manage and maintain SQL databases including PostgreSQL, O ...

  • Request Technology, LLC

    Database Administrator

    1 week ago

    Request Technology, LLC Chicago, United States

    NO SPONSORSHIP · Associate Principal, Database Administration - DB2 / LUW · SALARY: $125K - $155K PLUS 15% BONUS · LOCATION: CHICAGO, IL · HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE · Looking for a candidate with 7 years db2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL s ...

  • The University of Chicago

    Database Administrator

    2 weeks ago

    The University of Chicago Chicago, United States

    This job was posted by : For more information, please see: Department · BSD BIS - Business Intelligence Services · About the Department · About the Department · The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and tr ...

  • RIVET OPERATIONS COMPANY LLC

    Database Administrator

    2 weeks ago

    RIVET OPERATIONS COMPANY LLC Chicago, United States

    JOB DESCRIPTION · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) provi ...

  • Rivet Operations Company Llc

    Database Administrator

    1 week ago

    Rivet Operations Company Llc Chicago, United States

    JOB DESCRIPTION · Before applying for this role, please read the following information about this opportunity found below. · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a ...

  • Patterned Learning AI

    Database Administrator

    2 weeks ago

    Patterned Learning AI Chicago, United States

    Job Description · Database Administrator - Remote Job, 1+ Year Experience · Annual Income: $60K - $65K, Onsite · A valid work permit is necessary in the US/Canada · About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It of ...

  • Metropolitan Water Reclamation District of Greater Chicago

    Database Administrator

    2 weeks ago

    Metropolitan Water Reclamation District of Greater Chicago Chicago, United States

    General Statement · Under direction, designs, implements, administers and maintains the District's relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database p ...

  • Belvedere Trading

    Database Administrator

    2 weeks ago

    Belvedere Trading Chicago, United States Full time

    Belvedere is looking for someone passionate about monitoring, maintaining, and providing operational support of our entire database platform. You will improve the performance and efficiency of our data storage and access systems that deliver the high-quality and reliable data tha ...

  • Belvedere Trading

    Database Administrator

    1 week ago

    Belvedere Trading Chicago, United States Full time

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...

  • SDI Presence LLC

    Junior Database Administrator

    5 days ago

    SDI Presence LLC Chicago, United States

    Company · SDI Presence LLC is an IT consultancy and managed services provider (MSP) that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 25-year corporate resume, SDI delivers strategic managed services, IT consulting, and hybrid ...

  • SDI Presence LLC

    Junior Database Administrator

    3 days ago

    SDI Presence LLC Chicago, United States

    Company · SDI Presence LLC is an IT consultancy and managed services provider (MSP) that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 25-year corporate resume, SDI delivers strategic managed services, IT consulting, and hybrid ...

  • The LaSalle Group

    SQL Database Administrator

    3 weeks ago

    The LaSalle Group Chicago, United States

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a SQL Database Administrator their team. · The SQL Database Administrator will be responsible for maintenance and support of the SQL S ...

  • The LaSalle Group

    SQL Database Administrator

    3 weeks ago

    The LaSalle Group Chicago, United States

    We are seeking a skilled SQLDatabase Administrator to join our client's team. As a SQL Database Administrator, you will play a pivotal role in ensuring the smooth operations and optimization of valuable databases. · SQL Database Administrator Responsibilities: · Design, install, ...

  • RIVET OPERATIONS COMPANY LLC

    Cloud Database Administrator

    2 weeks ago

    RIVET OPERATIONS COMPANY LLC Chicago, IL, United States

    JOB DESCRIPTION · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) provi ...

  • Georgia IT Inc

    Senior Database Administrator

    1 week ago

    Georgia IT Inc Chicago, United States

    Position - Senior Database AdministratorLocation - Chicago, ILDuration - 12 MonthsSalary - DOE · US Citizens and those authorized to work in the U.S are encouraged to apply. We are unable to sponsor at this time. · Jo b DescriptionThe SQL Server Database Administrator will prov ...

  • CIBC

    Senior Database Administrator

    6 days ago

    CIBC Chicago, United States

    We're building a · relationship-oriented · bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have ...