Oracle Database Administrator - Support & Implementation (5-10 yrs)

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).