Banc of California

Database Administrator

• Maintain, design, implement, troubleshoot, administer, and support enterprise Oracle relational database environments
• Install, configure, upgrade, patch, monitor, document, and support Oracle databases, including Oracle 19c, in highly available production and non-production environments
• Establish and enforce database standards, procedures, and controls
• Administer enterprise Oracle database environments and recommend database management, infrastructure platform, and data-distribution improvements
• Manage database naming and structural standards, including schemas, tables, indexes, records, and database objects
• Support database security, privileged access, encryption, auditing, and regulatory compliance
• Monitor backups, archive and redo logs, alert logs, performance statistics, capacity, and scheduled maintenance
• Design and support highly available architectures, replication, disaster recovery, standby databases, and clustering technologies
• Translate logical database requirements into secure, supportable designs and apply normalization or denormalization as appropriate
• Plan and execute performance tests; monitor workloads and tune SQL, PL/SQL, memory, storage, and database configuration
• Manage tablespaces, datafiles, disk capacity, space utilization, database objects, and storage allocation
• Implement, document, test, and maintain backup, recovery, and disaster recovery procedures using RMAN and related Oracle technologies
• Provide production support, troubleshoot incidents, perform root-cause analysis, and participate in after-hours support and maintenance
• Maintain documentation for production, test, development, backup, and disaster recovery database environments
• Collaborate with infrastructure, application, security, audit, and vendor teams to resolve issues, support audits, and deliver required materials
• Evaluate Oracle environments, tools, design aids, and service offerings; interact with vendors and recommend purchases or improvements
• Perform other duties and projects as assigned

Senior Oracle Database Administrator