Job Description

Location: Pune, Bangalore & Chennai Notice Period: Immediate to 30 Days Experience: 8+ years Primary Skills: RAC, DataGaurd, Performance Tuning, Backup & Recovery Shift: 24X7 Rotational Shift Max CTC: 13 LPA Job Description: Senior Oracle DBA Description: Install, configure, upgrade, and maintain all client databases which include performance monitoring, troubleshooting and client support.Perform changes within Company regulations and security standards. Assist with testing, implementation, and installation of new/improved systems, as well as product upgrades. Attend meetings and interact regularly with management, team, and clients to continuously improve services. Participate in On-Call rotation schedule. Specific Duties: Responsible for ensuring all database system operational processes are managed according to established service level agreements. Specifically; Administration of database objects such as indexes, tables, views, constraints, stored procedures Archiving, backup / recovery, replication, cloning, import/export and refresh Administration of database users Capacity Management and storage management Design, test, and optimize/tune RDBMS components Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance Review and assess new features or upgrades to existing RDBMS components as well as application database changes For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features. When possible, test new technologies and report results ASM configuration and management with raw devices ADDM and AWR configuration and management RMAN backup and recovery Grid Control configuration and management Real application cluster administration in 19c,18c and 12c Real application cluster installation and upgrade to 19c Dataguard build and management Patch management Disaster Recovery Planning and execution Vulnerability Assessments R&R details are: 1. Monitoring and Health Checks during reported incident and problem - Database Status: Check the status of all databases (up, down, etc.). - Performance Metrics: Monitor key performance indicators (KPIs) such as CPU usage, memory utilization, I/O statistics, and response times. - Alerts and Logs: Review alert logs and system logs for any anomalies or errors. - Database tuning 2. - Backup Verification: Ensure that daily backups are completed successfully and verify backup integrity. Start/stop and relocate backup agents (Avamar/Networker). - Recovery Testing: Regularly test restore procedures to ensure that data can be recovered in case of failure. 3. - Dataguard rebuild and resolve sync issues when DG is out of sync. - Relocate of instance in OnenodeRAC. - Role Assignments: Ensure users have appropriate roles and permissions according to policy and approve request/change from security team. - Oracle wallet creation and certificate maintenance. 4. Capacity Planning - Space Utilization: Monitor tablespace usage and plan for future growth , work with customer and get required additional disks added via change. 5. Patch Management - Updates and Patches: Stay informed about the latest patches and updates from Oracle. Schedule and apply them as needed with approval on schedule from customer (agreed patch level is N-1) - Testing: Ensure that any updates are tested in a non-production environment before applying them to production and prechecks are carried out before actual implementation change. - Standalone and RAC database patching to be implemented while resolving issues reported during change window. - RACK administration to be added in Patch Management. 6.- Vulnerability Assessments : Regularly assess the database for security vulnerabilities using TSSA reports and work with customer for remediation or get exceptions 7.- Communication with Development Teams and customer on database schema changes, new deployments, and performance issues. - Incident Response: Respond to incidents and issues in collaboration with IT operations and support teams and work with incident management team. 8. Disaster Recovery Planning and execution , perform all pre checks and confirm pre DR health checks . - DR Drills: Participate in regular disaster recovery drills to ensure the organization can recover from major incidents.