Oracle Database Administrator - Support & Implementation

Oracle DB Administrator. Experience : 5-10 Years. Location : Bangalore. Work Mode : Hybrid. Job Description : - Design, develop, implement, and maintain our core Oracle applications. - Ensure DB availability. - Execution of data migration jobs and scripts as required. - Assist the infrastructure team in sizing hardware used for the DB. - Performance testing and evaluation to ensure data security, privacy and integrity. - Identification of bottle necks and deadlock issues. - Ensure SLA's are met. - Experience should include DB design (modelling and normalisation), capacity planning, performance. tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies. - Oracle management tools (Data Guard, RMAN, Data pump), Partitioning. - Hands on experience with capacity requirements into infrastructure deployment technology. - Strong practical experience of ORACLE in a production RAC (ASM)environment (11gR2). - Experience with an organization with a key reliance on 24x7 reliability on its database. Responsibilities : - Database Design & Implementation: Design, develop, implement, and maintain Oracle databases, including data modeling, normalization, schema management, and report generation. Database Availability & Performance : - Ensure high database availability and performance by implementing proactive monitoring, performance tuning, and capacity planning strategies. - Meet defined SLAs for database uptime and performance. Data Migration & Management : - Execute data migration jobs and scripts as required, ensuring data integrity and minimal downtime. Infrastructure Collaboration : - Assist the infrastructure team in sizing hardware used for the database, providing accurate capacity requirements and forecasts. - Security & Integrity: Implement and maintain database security measures to ensure data privacy and integrity, including user access control, auditing, and data encryption. Performance Tuning & Optimization : - Conduct performance testing and evaluation to identify and resolve performance bottlenecks and deadlock issues. - Utilize Oracle performance tuning tools and techniques to optimize database performance. Backup & Recovery : - Implement and manage robust backup and recovery strategies using Oracle RMAN (Recovery Manager) to ensure business continuity in case of data loss or system failure. Storage Management : - Manage database storage, including tablespaces, datafiles, and ASM (Automatic Storage Management), optimizing storage utilization and performance. - Database Clustering & High Availability : Manage and maintain Oracle RAC (Real Application Clusters) environments, ensuring high availability and failover capabilities. Oracle Management Tools : - Utilize Oracle management tools such as Data Guard, RMAN, and Data Pump for database administration, backup/recovery, and data migration tasks. Partitioning : - Implement and manage database partitioning strategies to improve query performance and manage large datasets. Capacity Planning & Forecasting : - Analyze database usage patterns and performance trends to forecast future capacity requirements and provide input to infrastructure planning. 24x7 Support : - Provide 24x7 on-call support for critical database systems, ensuring timely resolution of production issues and minimizing downtime. Experience Should Include : - Database design (modeling and normalization). - Capacity planning and forecasting. - Performance tuning and optimization. - Storage management (including ASM). (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 2/21/2025