OCC, which stands for Options Clearing Corporation, provides risk management financial services with the goal of bringing greater security to financial markets.
Associate Principal, Database Administration
Location
Texas
Posted
43 days ago
Salary
$112K - $152.5K / year
Seniority
Senior
Job Description
Associate Principal, Database Administration
OCC - Options Clearing Corporation
Title: Associate Principal, Database Administration Location: Dallas United States Job Description: - THIS POSITION IS NOT ELIGIBLE FOR VISA SPONSORSHIP* 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] 1+ year PostgreSQL or enthusiastic to learn 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 vision 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. - 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. OCC is an Equal Opportunity Employer
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator 2
Trilogy InnovationsAt Trilogy Innovations, we believe strong teams build meaningful solutions. We deliver high quality systems and software engineering services across public and private sectors, supporting complex and mission critical environments with integrity, collaboration, and care. Since 2010, our talented team has partnered with organizations such as the FBI, U.S. Air Force, NASA, Department of Education, Department of Energy, DHS, SOCOM, and leading private sector clients. We are known for combining technical excellence with a thoughtful, people first approach. At Trilogy, you will work alongside smart, committed professionals in a supportive, learning oriented environment. We value innovation, accountability, and continuous growth, and we encourage our people to bring both expertise and humanity to the work they do.
Database Administrator 2Secret Level Security Clearance Required About Trilogy Innovations At Trilogy Innovations, we are committed to driving meaningful change for our customers and communities through smart, innovative technology that solves real problems. As a growing systems and software engineering company, we partner across public and private sectors to modernize enterprise systems, strengthen security, and deliver high value solutions. We are scaling with purpose, investing in our people, processes, and platforms as we expand. We work hard, think creatively, and value every perspective as we push boundaries and build systems that matter. Who you areYou are the kind of Database Administrator who enjoys digging into problems and making systems run faster, cleaner, and smarter. You know your way around Oracle and PostgreSQL, and you are just as comfortable in a Linux environment as you are navigating cloud platforms like AWS. You have a solid handle on the fundamentals, backups, performance tuning, and database optimization are not new concepts to you. You have likely written your fair share of SQL and scripts, and you take pride in making things more efficient than you found them. You are naturally curious. When something breaks, you want to understand why, not just fix it and move on. When something works, you look for ways to make it even better. You are proactive, detail-oriented, and not afraid to take ownership. You work well with others, explain technical concepts without making it complicated, and keep a cool head when things get busy. Most importantly, you care about the impact of your work, because behind every database is a mission that depends on it running right. This position will require being on call once every 2 months. What you will do: Database DBA / ETL - Administer, support, configure, upgrade, and maintain Oracle (19c/21c) and PostgreSQL databases across Linux, RHEL, and Windows environments. - Manage database high availability and recovery solutions, including Oracle Data Guard, RMAN, and PostgreSQL backup and recovery methods such as pg_dump, pg_basebackup, and point-in-time recovery (PITR). - Perform database performance tuning and troubleshooting using tools such as AWR, ASH, ADDM, and PostgreSQL explain plans and monitoring utilities. - Execute database patching, upgrades, and maintenance across all COTS database platforms. - Develop and maintain database scripts using PL/SQL and PL/pgSQL, including loops, conditions, and variables. - Design and manage database storage, schemas, user roles, access controls, and security models. - Support database interfaces, integrations with external applications, and cross-system data interactions. - Utilize AWS cloud services, including CloudWatch, CloudTrail, EC2, and RDS (Oracle, PostgreSQL, Aurora). - Perform system-level performance tuning, hardware replacements, firmware upgrades, and patching across operating systems and COTS software. - Develop and maintain shell scripts to automate monitoring, maintenance, and operational tasks. - Apply strong SQL expertise, including query writing, optimization, indexing, and normalization. What you bring - Bachelor's Degree required or related field or equivalent experience - 3+ years' experience in Database Administration - Secret Level Security Clearance - Hands-on experience administering Oracle (19c/21c) and PostgreSQL databases in production environments - Strong understanding of database performance tuning, optimization, and troubleshooting - Experience with backup and recovery strategies, including RMAN and PostgreSQL tools such as pg_dump and PITR - Solid SQL skills, including writing, optimizing, and analyzing complex queries - Experience working across Linux, RHEL, and Windows operating systems - Familiarity with AWS services such as EC2, CloudWatch, CloudTrail, and RDS (Oracle, PostgreSQL, Aurora) - Experience with database patching, upgrades, and overall system maintenance - Scripting experience using shell, PL/SQL, or PL/pgSQL to automate tasks and improve efficiency - Understanding of database security, user roles, access control, and data integrity best practices - Ability to support database integrations and work across multiple systems and applications - Strong problem-solving skills with a proactive, solution-oriented mindset - Clear communication skills and the ability to work effectively with technical and cross-functional teams Work Environment: Remote with limited travel Compensation and Benefits: - Competitive salary based on experience - Performance bonus eligibility - 401k with company match - Medical, dental, and vision coverage - Life and disability insurance - Health Savings Account - Professional development programs - Employee referral bonus program Why Trilogy Innovations At Trilogy Innovations, we believe strong teams build meaningful solutions. We deliver high quality systems and software engineering services across public and private sectors, supporting complex and mission critical environments with integrity, collaboration, and care. Since 2010, our talented team has partnered with organizations such as the FBI, U.S. Air Force, NASA, Department of Education, Department of Energy, DHS, SOCOM, and leading private sector clients. We are known for combining technical excellence with a thoughtful, people first approach. At Trilogy, you will work alongside smart, committed professionals in a supportive, learning oriented environment. We value innovation, accountability, and continuous growth, and we encourage our people to bring both expertise and humanity to the work they do. If you are looking to contribute to impactful work while growing your skills in a collaborative and forward-thinking organization, Trilogy Innovations is a place where you can do just that. Equal Opportunity Employer Trilogy Innovations, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Applicant Privacy Notice Trilogy Innovations, Inc. collects and processes personal information you provide when applying for a position through our careers site, which is powered by JazzHR. This may include your contact details, resume, work history, qualifications, and information obtained through interviews, references, and background checks, where permitted by law. We use this information to evaluate your application, communicate with you, verify your qualifications, and support our recruiting and hiring processes. If you are selected for a role, your information may be used for onboarding and employment purposes. Your information may be shared with authorized Trilogy personnel and trusted service providers, including our applicant tracking system, JazzHR. We may also disclose information where required by law or to protect our business and operations. We retain applicant information for as long as necessary to support recruiting activities and comply with legal requirements, typically up to two years after your application is no longer active. You may have the right to access, correct, or request deletion of your personal information, subject to applicable law. You may also update your information through your candidate profile.
• Design, implement, and maintain high-performance database systems to support large-scale applications. • Optimize database queries, indexing strategies, and partitioning to enhance performance. • Monitor database health, ensuring high availability, scalability, and disaster recovery. • Manage and fine-tune SQL and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB, Redis, DynamoDB). • Implement database security policies, encryption, and access control to protect sensitive data. • Automate database backups, replication, and failover mechanisms. • Work closely with developers to optimize queries, schema design, and data modeling. • Perform capacity planning and monitor database growth trends. • Ensure compliance with data governance, GDPR, and other regulatory requirements. • Stay updated with the latest database technologies, trends, and best practices.
• Design, implement, and maintain high-performance database systems to support large-scale applications. • Optimize database queries, indexing strategies, and partitioning to enhance performance. • Monitor database health, ensuring high availability, scalability, and disaster recovery. • Manage and fine-tune SQL and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB, Redis, DynamoDB). • Implement database security policies, encryption, and access control to protect sensitive data. • Automate database backups, replication, and failover mechanisms. • Work closely with developers to optimize queries, schema design, and data modeling. • Perform capacity planning and monitor database growth trends. • Ensure compliance with data governance, GDPR, and other regulatory requirements. • Stay updated with the latest database technologies, trends, and best practices.
• Design, implement, and maintain high-performance database systems to support large-scale applications. • Optimize database queries, indexing strategies, and partitioning to enhance performance. • Monitor database health, ensuring high availability, scalability, and disaster recovery. • Manage and fine-tune SQL and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB, Redis, DynamoDB). • Implement database security policies, encryption, and access control to protect sensitive data. • Automate database backups, replication, and failover mechanisms. • Work closely with developers to optimize queries, schema design, and data modeling. • Perform capacity planning and monitor database growth trends. • Ensure compliance with data governance, GDPR, and other regulatory requirements. • Stay updated with the latest database technologies, trends, and best practices.
