Role Overview

We are seeking a highly skilled and proactive Senior Database Administrator (DBA) with solid expertise in Oracle databases and AWS cloud platforms. The role involves managing mission

Key Responsibilities

Database Administration & Management
- Install, configure, and maintain Oracle Databases (11g/12c/19c and above)
- Perform database provisioning, schema management, and patch upgrades
- Manage database lifecycle including development, testing, production, and decommissioning
- Handle database cloning, refreshes, and migrations

Performance Tuning & Optimization
- Monitor and optimize database performance using AWR, ASH, ADDM reports
- Analyze slow queries and optimize using indexing, partitioning, and execution plans
- Conduct regular health checks and performance audits
- Implement resource utilization strategies (CPU, memory, I/O)

Cloud Database Management (AWS)
- Manage and support databases on AWS RDS, Aurora, and EC2-hosted Oracle instances
- Configure and monitor CloudWatch alerts and metrics




- Handle database migrations from on-prem to AWS using tools like DMS
- Ensure cost optimization and right-sizing of AWS database resources
- Implement multi-AZ deployments and failover strategies

Backup, Recovery & High Availability
- Implement and manage backup and recovery strategies using RMAN
- Configure Data Guard / Active Data Guard / RAC environments
- Design and test Disaster Recovery (DR) plans
- Perform regular backup validation and restore testing
- Ensure mínimal downtime and data loss (RPO/RTO compliance)

Security & Compliance
- Manage database security including user roles, privileges, encryption
- Implement data masking and auditing policies
- Ensure compliance with industry standards (ISO, SOC2, etc.)
- Monitor unauthorized access and vulnerabilities

Automation & Scripting
- Automate repetitive DBA tasks using Shell scripting / Python
- Develop scripts for monitoring, backups, and health checks
- Work with tools like Ansible, Terrafo

📌 Senior Oracle Database Administrator (Gurugram)
🏢 Procain
📍 Gurugram