oracle dba - Nexora business solutions LLC
Role: Sr. Oracle DBALocation: Remote Need 10+ years of experience 1 Database Architecture, Design & Build both Oracle & SQL Server2 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 Server4. Performance Management & TuningAdvanced 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 & SupportJob 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 & MigrationsPlanning 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 Scripting8. Oracle & SQL Server Database Governance, Security & Compliance9. Stakeholder & Team ManagementInteracting with application teams to understand business workflows and data requirementsLeading client calls and serving as the primary technical contact for DBA-related queriesManaging L1, L2 escalations and coordinating resolution efforts. Creating and maintaining knowledge base documentation and SOPs10. Project & Capacity ManagementCapacity planning including CPU. memory, storage, and IOP5 forecasting. Tracking, managing, and reporting on database-related project progress Apply to this job