Oracle Database 12C Administration - Database Administrator

Job description

This **Oracle Database 12c Administrator** job description summarizes Tata Consultancy Services (TCS) norms. It outlines core responsibilities and technical requirements for managing large enterprise database environments. **Core Responsibilities** - **Installation & Configuration:** Provision, install, upgrade, and patch Oracle 12c instances, including Multi-tenant Container Databases (CDB) and Pluggable Databases (PDB). - **High Availability:** Architect and manage 24/7 database operations utilizing Real Application Clusters (RAC), Active Data Guard, and Automatic Storage Management (ASM). - **Backup & Recovery:** Design and execute reliable backup, restore, and disaster recovery strategies using Oracle Recovery Manager (RMAN). - **Performance Tuning:** Troubleshoot and optimize instances by performing advanced SQL and PL/SQL tuning using AWR, ASH, and Enterprise Manager (OEM). - **Automation:** Implement scripting solutions (Shell, Python, or Ansible) to automate routine provisioning, monitoring, and patch compliance tasks. - **Security & Auditing:** Implement strict security policies, database encryption, role-based access control (RBAC), and compliance audits. **Required Qualifications** - **Experience:** 5 to 9 years of hands-on Oracle Database Administration experience in large-scale enterprise environments. - **Education:** Bachelors degree in Computer Science, Information Technology, or related engineering discipline. - **Technical Proficiencies:** Deep understanding of Oracle versions (11g, 12c, 19c, 21c) and replication technologies like GoldenGate. - **Certifications:** **Oracle Database 12c Administrator Certified Professional** or OCA credentials are highly preferred. - **Experience- 5-9 Years** - **Location-Kolkata**