AWR OEM PLSQL Administrator

AWR OEM PLSQL Administrator As a Senior Oracle Database Administrator, you will be responsible for the architecture, administration, optimization, and security of enterprise Oracle database environments across a hybrid landscape including Oracle Cloud Infrastructure (OCI), Oracle workloads hosted in AWS, and traditional on‑premises systems. This role is critical to ensuring high availability, performance, and compliance of shared database platforms supporting mission‑critical applications. You will serve as a strategic partner to application teams, infrastructure, security, and data governance functions, driving modernization, automation, and operational excellence. Key Responsibilities Enterprise Database Administration Manage, monitor, and support Oracle database environments (11g through 23c) across OCI, AWS (EC2/RDS for Oracle), and on‑prem platforms. Administer multi‑tenant architectures (CDB/PDB), RAC, and Data Guard configurations. Ensure database uptime, availability, and performance meet enterprise SLAs. Cloud & Hybrid Architecture Design and manage Oracle deployments in OCI (Autonomous DB, Exadata Cloud Service, DB Systems). Support Oracle databases running in AWS (EC2‑hosted Oracle, RDS Oracle where applicable). Implement hybrid connectivity strategies (VPN, Fast Connect, Direct Connect). Lead cloud migration and modernization initiatives (lift‑and‑shift, re‑platforming). Performance & Capacity Management Proactively monitor performance using AWR, ASH, OEM, and cloud‑native tools. Tune SQL, PL/SQL, and database configurations for optimal performance. Forecast capacity and storage growth across environments. Backup, Recovery & High Availability Implement and manage RMAN backup strategies across hybrid environments. Maintain and test disaster recovery solutions (Data Guard, Active Data Guard). Ensure RPO/RTO targets are met and validated regularly. Security & Compliance Enforce database security standards including encryption (TDE), patching, and access controls. Partner with security and compliance teams to support audits and regulatory requirements. Implement least‑privilege access and database activity monitoring. Automation & DevOps Enablement Develop automation using Shell, Python, Ansible, Terraform, or OCI Resource Manager. Integrate database operations into CI/CD pipelines. Standardize provisioning, patching, and configuration management. AI Tool Integration: Proficiency in managing AI‑powered database features and other LLMs. Data Governance & Quality Enablement Support enterprise data initiatives including data cataloging, lineage, and quality controls. Ensure database environments align with governance standards and metadata management practices. Collaborate with data engineering and analytics teams to optimize data accessibility. Operational Excellence Provide 24/7 support as part of an on‑call rotation. Troubleshoot complex incidents and perform root cause analysis. Maintain documentation, runbooks, and SOPs for database operations. Proven ability to lead projects, work both independently and in a team environment, take ownership of projects from the beginning to the finish line. Able to prioritize tasks and make adjustments as needed. Background Multiple years of hands‑on enterprise Oracle database experience. EOE Protected Veterans/Disability #J-18808-Ljbffr COOLSOFT