Database Administrator

Cloudologic; Gurugram District; Hybrid; INR 2,500,000 - 4,200,000; Full time

Job summary

Cloudologic is seeking an experienced Oracle Database Administrator for an on-site role in Gurugram. You will install, configure, and maintain Oracle databases (11g/12c/19c), ensure high availability, monitor health, optimize queries, and manage backups across on-prem and AWS environments.

Collaboration with DevOps, security, and application teams is essential. You will implement DR plans, enforce security controls, and automate repetitive tasks using scripting and automation tools.

Qualifications

• 67 years of hands-on experience in database administration.
• Strong expertise in Oracle Database (11g/12c/19c).
• Hands-on experience with AWS (RDS, Aurora, EC2, DMS).
• Expertise in RMAN backup & recovery.
• Experience with Data Guard / RAC (high availability setups).
• Strong knowledge of SQL & PL/SQL.
• Experience in performance tuning and troubleshooting.
• Good understanding of Linux/Unix systems.
• Experience with monitoring and alerting tools.
• Exposure to DevOps tools (Docker, Kubernetes, CI/CD pipelines).

Responsibilities

• 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.
• 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).
• Manage and support databases on AWS RDS, Aurora, and EC2-hosted Oracle instances.
• Configure and monitor CloudWatch alerts and metrics; handle migrations using DMS.
• Ensure cost optimization and right-sizing of AWS resources; implement multi-AZ deployments.
• Backup and recovery strategies using RMAN; design and test DR plans.
• Manage database security including user roles and encryption.
• Automate DBA tasks with Shell scripting / Python; use Ansible/Terraform for automation.
• Collaborate with DevOps, application, and infrastructure teams; support deployments.
• Provide on-call support for production incidents; maintain documentation.

Skills

Oracle Database

AWS (RDS/Aurora/EC2/DMS)

RMAN backup & recovery

Data Guard / RAC

SQL & PL/SQL

Performance tuning

Linux/Unix

Monitoring & alerting

DevOps tools (Docker)

DevOps tools (Kubernetes)

CI/CD pipelines

Tools

Oracle Enterprise Manager (OEM)

DMS

Job description

Company Description Cloudologic is a prominent cloud consulting and IT services provider specializing in cloud operations, cybersecurity, and managed services. Headquartered in Singapore with strong roots in India, the organization leverages the strengths of both tech-driven regions to deliver innovative solutions. Over the past decade, Cloudologic has built a global client base by consistently providing reliable, high-quality services. The company is recognized as a trusted partner for organizations seeking secure, scalable, and efficient cloud and IT environments. Team members join a collaborative environment focused on technical excellence and continuous improvement.

Role Description This is a full-time, on-site Oracle Database Administrator role based in Gurugram. The Oracle Database Administrator is responsible for installing, configuring, and maintaining Oracle databases, ensuring high availability, performance, and reliability. Daily tasks include monitoring database health, optimizing queries, managing backups and recovery, and implementing replication strategies to support business continuity. The role involves diagnosing and resolving database issues, applying patches and upgrades, and enforcing robust database security controls in alignment with organizational standards. Collaboration with application, infrastructure, and security teams is expected to support deployments, troubleshoot incidents, and improve overall data management practices.

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 minimal 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, Terraform for infrastructure automation Collaboration & Stakeholder Management
• Work closely with DevOps, application, and infrastructure teams
• Support developers with query tuning and database design
• Participate in release management and deployment activities
• Provide on-call support for production issues Monitoring & Reporting
• Use tools like Oracle Enterprise Manager (OEM), AWS CloudWatch
• Generate reports on database performance, uptime, and incidents
• Maintain documentation for configurations, SOPs, and runbooks

Required Skills & Qualifications

• 67 years of hands-on experience in database administration
• Strong expertise in Oracle Database (11g/12c/19c)
• Hands-on experience with AWS (RDS, Aurora, EC2, DMS)
• Expertise in RMAN backup & recovery
• Experience with Data Guard / RAC (high availability setups)
• Strong knowledge of SQL & PL/SQL
• Experience in performance tuning and troubleshooting
• Good understanding of Linux/Unix systems
• Experience with monitoring and alerting tools a Preferred Qualifications
• AWS Certifications (e.g., AWS Certified Solutions Architect / Database Specialty)
• Experience with multi-database environments (MySQL, PostgreSQL)
• Exposure to DevOps tools (Docker, Kubernetes, CI/CD pipelines)
• Knowledge of data warehousing or big data tools is a plus