Senior Oracle DBA

Description:
Ideally looking for candidates within the bay area, please be sure to add your candidate's work location at the top of the resume. If the candidate is outside the bay area they must relocate within one month to the bay area to be onsite in Oakland 2-3 times per week. On day 1, it is required to be in the office.

Senior Database Administrator with over 10 years of experience in Oracle, PostgreSQL, 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, PostgreSQL, 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 onprem 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, pg_stat 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, PostgreSQL, SQL Server) instances, including provisioning, scaling, monitoring, and security.
Deploy and maintain AWS Aurora PostgreSQL/SQL Server where applicable.
Implement automation using AWS services such as CloudWatch, Lambda, Systems Manager, IAM, KMS, and CloudFormation/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, PostgreSQL replication, and AWS multiAZ replication.
Develop and regularly test DR playbooks and failover procedures.
Automate repetitive DBA tasks using Python, Shell scripting, PowerShell, 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 databaserelated development, deployments, and performance improvements.
Partner with engineering, DevOps, and application teams on designing scalable, cloudready 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.