Oracle DBA - Analyst

Job description

A standard **Oracle Database Administrator (DBA) Analyst** Job Description at **Tata Consultancy Services** revolves around maintaining high database availability, optimizing performance, and complying with strict global SLAs. It typically demands 5 to 9 years of experience managing enterprise-level Oracle environments in 24x7 support models. The roles, responsibilities, and requirements are structured as follows: **Core Responsibilities** - **Database Maintenance:** Install, configure, and upgrade Oracle databases (11g, 12c, 19c). Handle space management, schema creation, and database refreshes. - **Backup & Recovery:** Formulate and execute Disaster Recovery strategies using RMAN (Recovery Manager), export/import, and manage physical/active Data Guard environments. - **Performance Tuning:** Conduct rigorous instance and query tuning. Analyze AWR/ASH reports, trace locking/blocking sessions, and optimize SQL/PL/SQL. - **High Availability & Security:** Implement and manage Oracle RAC (Real Application Clusters), ASM (Automatic Storage Management), and GoldenGate. Ensure database security through user access control, encryption (TDE), and routine PSU/CPU patching. - **Ticket & SLA Management:** Resolve escalated production tickets, conduct technical RCA (Root Cause Analysis), and comply with client-specific SLAs via SDM tools. **Technical Prerequisites** - **Experience Level:** Typically requires a Bachelors degree in IT/Computer Science with 5+ years of hands-on Oracle administration. - **OS & Scripting:** Strong working knowledge of UNIX (AIX/RHEL) and UNIX Shell Scripting. - **Tools:** Proficiency with OEM (Oracle Enterprise Manager) and database assessment platforms. - **Experience- 5-9Years** - **Location-Bangalore**