Job Description
Oracle DBA - Sr. Oakland, CA Hybrid - 2-3 times per week On day 1, it is required to be in the office. 6 Months Contract - 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. - 8+ Years of experience as Senior Database Administrator (Oracle, PostgreSQL, SQL Server(Knowledge), AWS) Database Administration & Management - Oversee endtoend administration of Oracle, PostgreSQL, and SQL Server database environments, ensuring high availability, security, and optimal 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.