Walk-in || Tcs hiring Oracle DBA For Chennai

Job description

**Company:** Tata Consultancy Services (TCS) **Role:** Senior Oracle DBA (Infrastructure Platform Specialist) **Experience:** 810 Years **Location:** Sholinganallur, Chennai **Employment Type:** Full-Time Job Summary Tata Consultancy Services (TCS) is seeking an experienced **Senior Oracle DBA (Infrastructure Platform Specialist)** to manage and support mission-critical Oracle database environments. The ideal candidate should possess strong expertise in Oracle database administration, high availability architectures, performance tuning, disaster recovery, automation, and enterprise database infrastructure management. This role involves managing large-scale Oracle environments across on-premises, Exadata, Oracle Database Appliance (ODA), and cloud platforms while ensuring maximum availability, security, and performance. Key Responsibilities Oracle Database Administration - Install, configure, administer, and maintain Oracle databases including: - Oracle 11g - Oracle 12c - Oracle 19c - Oracle 21c - Manage database creation, upgrades, migrations, and platform refresh activities. - Ensure database stability, performance, and availability across enterprise environments. High Availability & Disaster Recovery - Design, implement, and support high-availability solutions using: - Oracle RAC - Oracle Data Guard - Oracle ASM - Oracle GoldenGate - Develop and maintain robust disaster recovery and business continuity strategies. - Perform regular DR testing and failover validation. Performance Tuning & Optimization - Perform advanced SQL and PL/SQL performance tuning. - Analyze and resolve database bottlenecks using: - AWR Reports - ASH Reports - Oracle Enterprise Manager (OEM) - Optimize database workloads, queries, indexes, and resource utilization. Backup, Recovery & Cloning - Implement and manage RMAN backup and recovery solutions. - Perform database cloning, restoration, and recovery operations. - Ensure backup compliance and recovery readiness across all environments. Infrastructure & Platform Management - Architect and support Oracle database platforms across: - On-Premises Infrastructure - Oracle Exadata - Oracle Database Appliance (ODA) - Cloud Platforms - Collaborate with Linux, Storage, Infrastructure, and Network teams to optimize database performance and availability. Database Security & Compliance - Implement and manage: - Database Encryption - Auditing - Access Control Mechanisms - CIS Security Hardening Standards - Ensure compliance with organizational security and regulatory requirements. - Support audit and governance initiatives. Automation & DevOps - Develop automation solutions for: - Database Provisioning - Patching - Monitoring - Compliance Management - Utilize technologies such as: - Shell Scripting - Python - Ansible - Drive operational efficiency through automation and standardization. Monitoring & Incident Management - Perform proactive database monitoring and capacity planning. - Troubleshoot and resolve production-critical incidents. - Participate in on-call support and major incident management activities. - Conduct root cause analysis and implement preventive measures. Documentation & Technical Leadership - Prepare and maintain: - Architecture Documents - SOPs - Runbooks - Deployment Standards - Operational Procedures - Provide L3 support for complex database issues. - Mentor junior DBAs and contribute to solution design reviews and best practices. Required Skills & Experience - 810 years of hands-on Oracle Database Administration experience in enterprise environments. - Strong expertise in: - Oracle RAC - Data Guard - ASM - GoldenGate - Extensive experience with Oracle Database versions: - 11g - 12c - 19c - 21c - Advanced knowledge of: - SQL - PL/SQL - Database Performance Tuning - Query Optimization - Strong experience with: - RMAN Backup & Recovery - Database Cloning - Disaster Recovery Planning - Database Upgrades & Migrations - Knowledge of: - Linux Administration - Storage Technologies - Database Security Best Practices - Experience with automation and scripting tools. Preferred Qualifications - Oracle Certified Professional (OCP) - Oracle Certified Expert (OCE) - Oracle Certified Associate (OCA) - Experience with Oracle Cloud Infrastructure (OCI) - Exposure to DevOps and Infrastructure Automation practices Keywords Oracle DBA, Senior Oracle DBA, Oracle RAC, Data Guard, ASM, GoldenGate, Oracle 19c, Oracle 21c, RMAN, Oracle Exadata, ODA, SQL, PL SQL, Database Administration, Disaster Recovery, Performance Tuning, AWR, ASH, OEM, Oracle Cloud, Infrastructure Specialist, Oracle DBA Jobs **Preferred Candidates:** Immediate Joiners or Candidates with Notice Period up to 30 Days.