oracle dba - Nexora business solutions LLC

Role: Sr. Oracle DBA Location: Remote Need 10+ years of experience 1 Database Architecture, Design & Build both Oracle & SQL Server 2 Cloud Platforms (AWS & Azure) Deep knowledge of deploying, managing, and monitoring Oracle databases on AWS and Azure. Configuring and managing AWS RDS, EC2-based Oracle databases, Azure SQL/Oracle on laaS/VMs. Performance assessments and optimization specific to cloud-hosted databases. Integration with AWS CloudWatch and Azure Monitor for proactive alerting and system health. Management of storage (EBS, Azure Disks), NACL, and Security Groups (SGs) across cloud platforms. 3. Backup, Recovery, and High Availability both Oracle & SQL Server 4. Performance Management & Tuning Advanced performance tuning of database systems, deeper skill sets on troubleshooting IO, CPU & any other bottlenecks. Monitoring wait events, AWR/ASH reports, and optimizing resource utilization. Indexing strategies, plan baselines, and tuning of long-running jobs. 5. Troubleshooting & Support Job Description: Advanced troubleshooting for node evictions, cluster interconnect issues, and configuration problems. Handling connectivity and failover issues in multi-node environments. 6. Database Upgrades, Patching & Migrations Planning and executing Oracle version upgrades and quarterly patching (PSU/CPU/RU). Migrating databases across platforms (on-prem to cloud, cloud-to-cloud). Zero/minimal downtime strategies using Data Guard switchover/failover or GoldenGate. 7. Deep Domain Expertise on Shell Scripting 8. Oracle & SQL Server Database Governance, Security & Compliance 9. Stakeholder & Team Management Interacting with application teams to understand business workflows and data requirements Leading client calls and serving as the primary technical contact for DBA-related queries Managing L1, L2 escalations and coordinating resolution efforts. Creating and maintaining knowledge base documentation and SOPs 10. Project & Capacity Management Capacity planning including CPU. memory, storage, and IOP5 forecasting. Tracking, managing, and reporting on database-related project progress