Sr. Oracle Database Administrator (TEMPORARY UP TO 90 DAYS)

We need to output HTML fragment with sections: About the role? Actually the posting includes "THE OPPORTUNITY" and "How You’ll Make a Difference", "What You’ll Bring". Also there is introductory paragraph about Banc of California and your career. We need to use

for section headings: e.g., About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We should map content accordingly. We must not repeat job title as heading. No Job ID. Remove boilerplate: EEO, accommodation request, etc. Also remove navigation/cookie/legal. Also remove duplicated lines. We need to preserve all substantive information. So we need to include sections that have real content: About the role (maybe the introductory description of the bank and role?), Responsibilities (the "How You’ll Make a Difference" bullet list), Requirements/Qualifications/Skills (the "What You’ll Bring" list). Benefits, Pay, Schedule: not present (except mention of base salary determined etc but no specific numbers). The posting says: "The base salary ultimately offered is determined through a review of education, industry experience, training, knowledge, skills, abilities of the applicant in alignment with market data and other factors." That's not a specific salary or range, it's generic. According to rule: never create Pay/Schedule/Benefits sections unless the posting actually states them. It does state base salary determined etc but not a specific figure. The rule says: never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD") and never create Pay/Schedule/Benefits sections unless the posting actually states them. The phrase "The base salary ultimately offered is determined through a review..." is essentially "commensurate with experience" style. So we should NOT create a Pay section. Benefits: not mentioned. Schedule: not mentioned. So we omit those sections. Thus we will have sections: About the role (maybe combine introductory paragraph about Banc of California and the role?), Responsibilities, Requirements (or Qualifications and Skills). The instruction says use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can choose which to include based on content. We have content for About the role (bank description and role overview). Responsibilities (the "How You’ll Make a Difference" bullet list). Requirements/Qualifications/Skills (the "What You’ll Bring" list). Could split into Requirements (education/experience) and Qualifications (knowledge) and Skills (technical). But we can combine into one section if we want fewer sections. The instruction: "Prefer a few substantive sections over many thin ones." So we could have About the role, Responsibilities, Requirements (which includes qualifications and skills). Or we could have About the role, Responsibilities, Qualifications, Skills. But we need to avoid thin sections. Let's decide: About the role (intro), Responsibilities (duties), Requirements (education/experience + knowledge + skills). That's three sections. We need to use

• for any list of duties/requirements/benefits. So for Responsibilities we need a list. For Requirements we need a list (maybe combine multiple items). Use

  for prose. We must preserve all substantive information; do not invent or summarize away detail. So we need to keep all bullet points from "How You’ll Make a Difference" and all bullet points from "What You’ll Bring". Also keep the introductory paragraphs about Banc of California and the role overview (the "THE OPPORTUNITY" paragraph). Also the first paragraph about Banc of California and your career (the introductory description). Also the sentence about "Performs all duties in accordance with the Company’s policies and procedures, all U.S. state and federal laws and regulations, wherein the Company operates." That's part of responsibilities? It's after THE OPPORTUNITY paragraph. We'll include that as part of responsibilities prose or maybe as a separate bullet? It's a statement; we can include as a

  under Responsibilities. We need to remove boilerplate: EEO statement, accommodation request, etc. Also remove duplicated lines. Ensure we don't include the EEO paragraph at the end. Now craft HTML. Structure:

  About the role

  Banc of California, Inc. (NYSE: BANC) is a bank holding company with over $34 billion in assets and the parent company of Banc of California. Banc of California is one of the nation’s premier relationship-based business banks, providing banking and treasury management services to small, middle market, and venture backed businesses. As the largest independent bank headquartered in California, the bank offers a broad range of loan and deposit products and services through a network of full-service branches and regional offices, as well as through digital and nationwide capabilities. The bank also provides full-service payment processing solutions to its clients and serves the Community Association Management industry nationwide through its technology forward platform, SmartStreet™. Banc of California is committed to supporting its local communities through the Banc of California Charitable Foundation and by partnering with organizations that promote financial literacy, job training, small business support, affordable housing, and more. At Banc of California, our success is powered by our people and a shared commitment to delivering meaningful results. We foster an environment where entrepreneurial thinking is encouraged, and accountability and operational excellence are expected. Our team members are empowered to take ownership, make informed decisions, and make a meaningful impact as the bank continues to grow and evolve. We are dedicated to supporting your growth and wellbeing through comprehensive benefits, robust development opportunities, and inclusive programs that enable you to perform at your best. Together we win!

  Responsible for maintaining, designing, implementing, troubleshooting, administering, and supporting the availability, security, integrity, performance, backup, and recovery of enterprise Oracle relational database environments. The Senior Oracle Database Administrator installs, configures, maintains, patches, monitors, documents, and supports Oracle databases in highly available production and non-production environments, including Oracle 19c; establishes and enforces database standards, procedures, and controls; partners with internal teams, auditors, and external vendors; and provides Tier 2 and Tier 3 support. Performs all duties in accordance with the Company’s policies and procedures, all U.S. state and federal laws and regulations, wherein the Company operates.

  Responsibilities

  • Administer enterprise Oracle database environments.
  • Discuss and suggest database management system improvements, infrastructure platforms, and data-distribution approaches for highly available implementations, including systems operating on a 24-hour basis.
  • Install, configure, upgrade, patch, and maintain Oracle Database software and related infrastructure, including Oracle 19c environments.
  • Assign and control database naming and structural standards, including schemas, tables, indexes, records, database objects, and related conventions.
  • Adhere to and support procedures and safeguards for Oracle database security, privileged access, encryption, auditing, and regulatory compliance.
  • Ensure database integrity and availability through daily monitoring of Oracle backups, archive and redo logs, alert logs, performance statistics, capacity, and scheduled maintenance activities.
  • Design and support highly available Oracle architectures, including controlled replication, disaster recovery, standby database, and clustering technologies as applicable.
  • Translate logical database requirements into secure, supportable designs and apply normalization or denormalization when appropriate.
  • Plan and execute Oracle database performance tests; monitor workload and system statistics; and tune SQL, PL/SQL, memory, storage, and database configuration to meet service-level objectives.
  • Plan and manage tablespaces, datafiles, disk capacity, and space utilization; adjust database objects and storage allocation to optimize performance and resource consumption.
  • Implement, document, test, and maintain Oracle backup, recovery, and disaster recovery procedures using RMAN and related Oracle technologies; coordinate recoveries with other IT teams.
  • Provide production support, troubleshoot database incidents, perform root-cause analysis, and participate in after-hours support and maintenance as required.
  • Maintain current documentation for production, test, development, backup, and disaster recovery database environments, including procedures, configurations, inventories, and recovery runbooks.
  • Work with infrastructure, application, security, audit, and vendor teams to communicate requirements, resolve issues, support audits, and ensure timely delivery of required materials.
  • Evaluate Oracle environments, tools, design aids, and service offerings; interact with vendors and recommend purchases or improvements where appropriate.
  • Perform other duties and projects as assigned.

  Requirements

  • Bachelor’s degree or a minimum of 8 years of equivalent job experience, with six years of experience supporting production database systems, including system analysis and/or programming, and Oracle database administration.
  • In-depth knowledge of Oracle Database 19c administration, architecture, security, performance tuning, backup and recovery, and high-availability technologies.
  • Experience with and competency with Linux/Unix operating systems and enterprise storage-area networks.
  • Demonstrates knowledge of, adherence to, monitoring and responsibility for compliance with state and federal regulations and laws as they pertain to this position, including but not limited to Regulation Z (Truth in Lending Act), Regulation B (Equal Credit Opportunity Act), Fair Housing Act (FHA), Home Mortgage Disclosure Act (HMDA), Real Estate Settlement Procedures Act (RESPA), Fair Credit Reporting Act (FCRA), Bank Secrecy Act (BSA) in conjunction with the USA PATRIOT Act, Anti-Money Laundering (AML) and Customer Information Program (CIP), Right to Financial Privacy Act (RFPA, state and federal), and Community Reinvestment Act (CRA).
  • Advanced knowledge of Oracle database administration and programming techniques, SQL and PL/SQL, schema and object management, patching, upgrades, maintenance, documentation, testing, debugging, performance tuning, capacity management, backup and recovery, and production operations.
  • Ability to suggest new procedures, discuss and implement enhanced Oracle database administration techniques, automate repeatable operational tasks, and improve existing database services while maintaining security, availability, and recoverability.
  • Advanced skills in computer terminal and personal computer operation; Microsoft Office applications including but not limited to Word, Excel, PowerPoint, and Outlook.
  • Intermediate math skills; calculate interest and percentages; balance accounts; add, subtract, multiply, and divide in all units of measure using whole numbers, common fractions, and decimals; locate routine mathematical errors; and compute rate, ratio, and percent, including the drafting and interpretation of bar graphs.
  • Exceptional oral, written, and interpersonal communication skills.
  • Ability to make decisions that have significant impact on the immediate work unit and cross-functional departments.
  • Ability to provide consultation and expert advice to management.
  • Ability to work with little to no supervision while performing duties.
  • Oracle Certified Professional or comparable Oracle technical certification preferred.
  • Experience with ITIL-based service management, project management, and Six Sigma or related quality and process-improvement practices preferred.
  • High school diploma or equivalent required.
  We need to ensure we didn't include any boilerplate like EEO. We removed that. Check for any duplicated lines: The introductory paragraph about Banc of California appears twice? Actually we have the first paragraph (the "Banc of California and your career" section) and then the "THE OPPORTUNITY" paragraph. We included both as prose under About the role. That's fine. Check if any content missing: The sentence "Performs all duties in accordance with the Company’s policies and procedures, all U.S. state and federal laws and regulations, wherein the Company operates." we included as a separate

  after the THE OPPORTUNITY paragraph. Good. Check if any other substantive content: The line "Together we win!" is included in the first paragraph. Now ensure we didn't include any mention of benefits, pay, schedule. We didn't. Now output only