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