DBA Analyst

The Oracle Database Administrator will be responsible for providing 24 x 7 production database support, ensuring high availability, security, performance, and reliability of mission-critical database systems. The role involves day-to-day monitoring, new environment setup, database patching, backup & recovery, performance tuning, and compliance with enterprise security standards. 

Key Responsibilities

1. Conduct daily health checks, capacity monitoring, performance diagnostics, and incident resolution.
2. Install, configure, and upgrade Oracle Database software according to system architecture, security standards, and operational guidelines.
3. Execute database patching, PSU/RU upgrades, and implement best-practice change management processes. 
4. Perform database cloning for development, testing, and support environments. 
5. Plan, manage, and validate database backup and recovery using RMAN and enterprise backup tools. 
6. Implement Real Application Cluster (RAC), Oracle Database Vault, Transparent Data Encryption (TDE), and key management integration.
7. Design and implement table partitioning, indexing strategies, and database schema optimizations. 
8. Configure and maintain Unified Auditing to meet compliance and audit requirements. 
9. Perform deep performance tuning of SQL, memory, storage, and system resources. 
10. Participate in disaster recovery planning, Data Guard configuration, testing, and failover procedures. 
11. Collaborate with infrastructure, security, application, and DevOps teams to support system deployment and troubleshooting. 
12. Prepare documentation, operational procedures, and knowledge transfer to internal teams. 

Preferred Experience / Advantage

1. Experience integrating Oracle with HSM (Hardware Security Module) for TDE key storage
2. Experience setting up Splunk, ELK, or other SIEM/SOAR tools for DB log monitoring. · Experience in high-availability architectures (RAC, Data Guard, ASM, Flashback, etc.). 
3. Experience in Oracle Multi-tenant daily operations. 

Required Qualifications & Skills Requirement Description Experience 

1. Minimum 5 years hands-on experience administering Oracle Database environments (11g, 12c, 19c or later). 
2. Education Degree in Computer Science, Information Systems, Engineering, or related discipline. 
3. Technical Skills Strong SQL, RMAN, OEM, Data Guard, performance tuning, database security, backup strategy. 
4. Soft Skills Strong communication, analytical thinking, problem-solving abilities, and collaborative team attitude. 
5. Others Ability to work under pressure, support critical systems, and participate in on-call rotation.