Responsibilities:
- Database Management & Operations: Oversee and manage daily operations of Oracle databases, ensuring smooth functioning, high availability, and optimal performance for IT IS (Information Systems) and AMS (Application Management Services) environments.
- Analysis & Development: Conduct detailed analysis for database requirements, participate in database design, and implement solutions within the Oracle Database Administration domain.
This includes schema design, object creation, and data migration. - Implementation & Configuration: Lead the implementation, configuration, and setup of Oracle database instances, including RAC (Real Application Clusters), Data Guard, and other high-availability solutions.
- Performance Tuning & Optimization: Proactively monitor database performance, identify bottlenecks, and perform expert-level tuning (SQL, instance, OS level) to ensure efficient query execution and overall system responsiveness.
- Backup & Recovery: Design, implement, and manage robust backup and recovery strategies for Oracle databases, ensuring data integrity and business continuity.
- Troubleshooting & Issue Resolution: Provide expert troubleshooting and timely resolution of complex database-related issues, including performance problems, connectivity issues, and database corruptions.
- Security & Compliance: Implement and maintain database security best practices, manage user access, and ensure compliance with organizational policies and regulatory requirements.
- Operational Contribution: Actively contribute to the operational efficiency and effectiveness of database systems, including automating routine tasks and improving existing processes.
- Collaboration: Collaborate with application development teams, system administrators, and other stakeholders to ensure seamless integration and support for applications utilizing Oracle databases.
Required Skills:
- Proficiency in Oracle Database Administration.
- Ability to perform analysis, development, implementation, and troubleshooting within the Oracle database domain.
- Strong understanding of database concepts, architecture, and best practices.
- Familiarity with database performance tuning, backup, and recovery strategies.
- Problem-solving skills for complex technical challenges.
- Ability to ensure smooth operations and contribute to business objectives.
Skills Required
Database Management, Oracle Database Administration, data integrity, Stakeholder Management, Database Concepts