Oracle DBA
TheCorporate, Oakland, CA, United States
Senior Database Administrator – Experience & Responsibilities
8+ Years of experience as Senior Database Administrator with expertise in Oracle, PostgreSQL, SQL Server (knowledge), and AWS. Proven skills in database administration, management, and cloud migration.
Responsibilities
Oversee end-to-end 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 on‑prem and cloud environments.
Design and implement backup and recovery strategies using 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.
Diagnose and resolve complex database performance issues involving SQL tuning, indexing, execution plans, and storage optimization.
Optimize large-scale OLTP and OLAP workloads for reliability and efficiency across multi-database platforms.
Manage AWS RDS (Oracle, PostgreSQL, SQL Server) instances: 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, CloudFormation, and Terraform.
Support cloud migrations, including schema conversion, data migration, and cutover planning.
Enforce database security standards: user management, roles, auditing, encryption, and patching.
Maintain compliance with corporate and industry standards (access controls, data retention policies).
Conduct vulnerability assessments and remediation.
Architect HA/DR solutions: Data Guard, Oracle RAC, Always On Availability Groups, PostgreSQL replication, and AWS multi‑AZ replication.
Develop and test DR playbooks and failover procedures.
Automate repetitive DBA tasks using Python, Shell, PowerShell, or PL/SQL.
Maintain database maintenance scripts and automated alerts.
Provide advanced troubleshooting for production incidents with root cause analysis.
Support 24x7 on‑call rotation for critical systems.
Collaborate with application teams on database‑related development, deployments, and performance improvements.
Partner with engineering, DevOps, and application teams on scalable, cloud‑ready data solutions.
Lead database modernization initiatives, cloud migrations, and cross‑platform upgrades.
Mentor junior DBAs and engineers.
Maintain accurate documentation for database configurations, standards, and operational procedures.
Advocate for continuous improvement in database architecture, automation, and operational workflows.
Required Skills AWS, PostgreSQL, SQL, Oracle, database, cloud, SQL Server, tuning.
#J-18808-Ljbffr
Responsibilities
Oversee end-to-end 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 on‑prem and cloud environments.
Design and implement backup and recovery strategies using 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.
Diagnose and resolve complex database performance issues involving SQL tuning, indexing, execution plans, and storage optimization.
Optimize large-scale OLTP and OLAP workloads for reliability and efficiency across multi-database platforms.
Manage AWS RDS (Oracle, PostgreSQL, SQL Server) instances: 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, CloudFormation, and Terraform.
Support cloud migrations, including schema conversion, data migration, and cutover planning.
Enforce database security standards: user management, roles, auditing, encryption, and patching.
Maintain compliance with corporate and industry standards (access controls, data retention policies).
Conduct vulnerability assessments and remediation.
Architect HA/DR solutions: Data Guard, Oracle RAC, Always On Availability Groups, PostgreSQL replication, and AWS multi‑AZ replication.
Develop and test DR playbooks and failover procedures.
Automate repetitive DBA tasks using Python, Shell, PowerShell, or PL/SQL.
Maintain database maintenance scripts and automated alerts.
Provide advanced troubleshooting for production incidents with root cause analysis.
Support 24x7 on‑call rotation for critical systems.
Collaborate with application teams on database‑related development, deployments, and performance improvements.
Partner with engineering, DevOps, and application teams on scalable, cloud‑ready data solutions.
Lead database modernization initiatives, cloud migrations, and cross‑platform upgrades.
Mentor junior DBAs and engineers.
Maintain accurate documentation for database configurations, standards, and operational procedures.
Advocate for continuous improvement in database architecture, automation, and operational workflows.
Required Skills AWS, PostgreSQL, SQL, Oracle, database, cloud, SQL Server, tuning.
#J-18808-Ljbffr