Senior Oracle DBA

Senior Oracle DBA

Oakland, CA-Hybrid (2-3 times per week)

6 months+.

• Ideally looking for candidates within the bay area; if outside the bay area they must relocate within one month to be onsite in Oakland 2-3 times per week.
• On day 1, it is required to be in the office.
• Past Experience in Utility Preferred and CC&B db hands-on.

• Senior Database Administrator with over 10 years of experience in Oracle, Postgre
  
  SQL, and SQL Server (working knowledge), along with AWS and Azure database environments.
• Proven expertise in database administration and management, including designing and building DBA solutions across Oracle, Postgre
  
  SQL, and SQL Server platforms.
• Skilled in ensuring high availability (RAC), robust security, and optimal database performance.
• Perform installation, configuration, patching, upgrades, and migration of database systems across on-prem and cloud environments.
• Design and implement backup and recovery strategies, leveraging RMAN, pgBackRest, native SQL Server backup tools, and AWS Backup.
• Conduct proactive monitoring, capacity planning, and performance tuning using AWR, OEM,  views, DMVs, and cloud-native monitoring tools.
• Performance Tuning & Optimization.
• Diagnose and resolve complex database performance issues involving SQL tuning, indexing strategies, execution plans, database parameters, and storage optimization.
• Optimize large-scale OLTP and OLAP workloads for reliability and efficiency across multi-database platforms.
• Manage and support AWS RDS (Oracle, Postgre
  
  SQL, SQL Server) instances, including provisioning, scaling, monitoring, and security.
• Deploy and maintain AWS Aurora Postgre
  
  SQL/SQL Server where applicable.
• Implement automation using AWS services such as Cloud Watch, Lambda, Systems Manager, IAM, KMS, and Cloud Formation/Terraform.
• Support cloud migrations including schema conversion, data migration, and cutover planning.
• Implement and enforce database security standards including user management, roles, auditing, encryption, and patching.
• Maintain compliance with corporate and industry standards (e.g., access controls, data retention policies).
• Conduct regular vulnerability assessments and remediation.
• Architect and maintain HA/DR solutions such as Data Guard, Oracle RAC, Always On Availability Groups, Postgre
  
  SQL replication, and AWS multi AZ replication.
• Develop and regularly test DR playbooks and failover procedures.
• Automate repetitive DBA tasks using Python, Shell scripting, Power Shell, or PL/SQL.
• Develop and maintain database maintenance scripts and automated alerts.
• Provide advanced troubleshooting for production incidents with strong root cause analysis.
• Support 24x7 on‑call rotation for critical systems.
• Collaborate with application teams to support database-related development, deployments, and performance improvements.
• Partner with engineering, Dev Ops, and application teams on designing scalable, cloud ready data solutions.
• Lead database modernization initiatives, cloud migrations, and cross-platform upgrades.
• Provide technical guidance and mentorship to junior DBAs and engineers.
• Maintain accurate and up-to-date documentation for database configurations, standards, and operational procedures.
• Advocate for continuous improvement in database architecture, automation, and operational workflows.