OCC
We clear and settle trades for the options industry.
Hybrid

Associate Principal, Database Administration

Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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 www.theocc.com.
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

See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

What are OCC Perks + Benefits

OCC Benefits Overview

Educational Assistance and Student Debt Forgiveness, 12-week paid parental leave, BYOD program with technology stipend up to $2,000 every three years, $35 per month pay to offset costs of mobile data plans. Open offices, online health coaching.

Culture
Volunteer in local community
Each year, OCC employees select a locally-based charitable organization for each of our three offices (Chicago, Dallas and Washington, D.C.). We offer multiple opportunities to get involved.
Partners with nonprofits
OCC Partners with local organizations in Dallas, Chicago and DC to raise funds and support their missions. Employees select the charity and are eligible for up to 8 hours of paid time to volunteer.
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Flexible work schedule
OCC provides employees with a flexible work schedule that includes Flexible start and end times.
Remote work program
2 days per week work from home program
Diversity
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Diversity employee resource groups
Health Insurance + Wellness
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
HSA or FSA accounts available for those enrolled in medical plans.
Life insurance
Wellness programs
Includes back-up child or elder care along with other wellness programs.
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
OCC provides employees with a 401(k) matching plan managed by Fidelity. We match 50% of contributions up to 12% of an employee's annual gross pay.
Performance bonus
Charitable contribution matching
Child Care & Parental Leave
Generous parental leave
12-week paid parental leave
Vacation + Time Off
Generous PTO
OCC employees receive between 22 and 32 days per year of paid time off based on years of service.
Paid volunteer time
Sabbatical
Eligible employees get 30 days of paid sabbatical after their first 10 years of working at the company.
Paid holidays
Paid sick days
Office Perks
Commuter benefits
OCC Offers pre-tax commuter benefits for employees in Chicago and Washington, D.C.
Company-sponsored happy hours
Relocation assistance
OCC offers relocation assistance which varies based on the position level and location.
Home-office stipend for remote employees
Professional Development
Job training & conferences
OCC offers employees professional development opportunities including onsite training courses and the ability to attend job related certification courses, conferences and seminars.
Tuition reimbursement
Our tuition reimbursement plan offers an annual max of $10000.
Lunch and learns
OCC hosts leadership lunches on a regular basis so you can learn about your colleagues and their unique backgrounds.
Promote from within
Online course subscriptions available
Customized development tracks
Paid industry certifications
Employees are strongly encouraged to stay current in relevant technologies and supports certification programs.

Additional Perks + Benefits

We were recently recognized as one of LinkedIn's Top Company in Financial Services! Take a look at our blog post here: https://www.theocc.com/newsroom/press-releases/2022/06-23-linkedin-list…

More Jobs at OCC

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about OCCFind similar jobs like this