Oracle DBA L2
Introduction
Monitoring & Health Checks
Database Availability: Monitor the database instances, server availability, and disk space to ensure continuous operation.
Log Files: Regularly check Oracle alert logs, transaction logs, and backup logs for errors or warnings.
Resource Utilization: Track high CPU, memory, or application performance metrics and identify potential issues.
User & Access Management
User Creation/Modification: Handle user creation requests, grant basic data access, and manage user roles.
Request Processing: Respond to user requests, often by passing them to L2 or L3 support for complex resolution.
Your role and responsibilities
Job Description for Oracle DBA L2 :
Responsibilities
Monitoring & Health Checks
Database Availability: Monitor the database instances, server availability, and disk space to ensure continuous operation.
Log Files: Regularly check Oracle alert logs, transaction logs, and backup logs for errors or warnings.
Resource Utilization: Track high CPU, memory, or application performance metrics and identify potential issues.
User & Access Management
User Creation/Modification: Handle user creation requests, grant basic data access, and manage user roles.
Request Processing: Respond to user requests, often by passing them to L2 or L3 support for complex resolution.
Backup & Recovery Support
Backup Monitoring: Oversee scheduled database backups and respond to any errors or failures during the process.
Error Notification: Notify the team about backup failures or recovery errors and process requests for restoration.
Alerts & Escalation
Alert Handling: Acknowledge and investigate alerts, notifying relevant teams for quick resolution.
Escalation: Escalate complex performance problems, storage issues, or critical failures to L2 or L3 DBAs for deeper analysis and action.
Environment Management
Storage Management: Assist with basic tasks like adding datafiles to tablespaces and monitoring storage growth.
Want more jobs like this?
Get jobs in Panvel, India delivered to your inbox every week.
Schema Refresh: Participate in daily schema refreshes to update development and testing environments.
Monitoring & Performance:
Monitor database health and performance using tools like Oracle Enterprise Manager Grid Control.
Analyze and resolve performance issues to ensure optimal system operation.
Monitor OS services for application and database availability.
Maintenance & Operations:
Perform regular backups and restores.
Apply database patches and updates to software and security.
Manage database storage and resolve space-related issues.
Assist with database installations, configurations, and upgrades.
Troubleshooting & Support:
Troubleshoot and resolve technical issues reported by users or detected by monitoring tools.
Provide technical support and assistance to end-users experiencing database problems.
Respond to database security alerts and apply necessary security measures.
Security & User Management:
Assist in implementing and maintaining database security policies and procedures.
Manage user accounts, authorizations, and access rights.
High Availability (HA) & Disaster Recovery (DR):
Implement and manage high-availability and disaster recovery solutions like Data Guard.
Perform failover and switchover procedures.
Collaboration & Documentation:
Collaborate with senior team members and other departments (e.g., application teams) to resolve issues and optimize performance.
Contribute to developing and maintaining documentation for database configurations and procedures.
Advanced Troubleshooting: Resolve issues that L1/L2 teams cannot, including complex ORA-600 errors and database corruption, often requiring deep analysis and root cause investigation.
Performance Tuning: Conduct in-depth performance analysis using tools like AWR and ASH to identify and resolve bottlenecks through SQL tuning, partitioning, and managing execution plans.
High Availability & Disaster Recovery: Design, implement, and maintain solutions such as RAC, ASM, and Data Guard for high availability and disaster recovery, including conducting DR drills.
Upgrades & Migrations: Lead and execute complex database upgrades, patching, and migrations, ensuring all prerequisites, testing, and post-upgrade tasks are completed effectively.
Backup & Recovery: Formulate, implement, and test advanced backup and recovery strategies, utilizing RMAN for reliable data protection.
Security & Compliance: Implement security policies, conduct auditing, and ensure databases comply with enterprise security standards.
Proactive Monitoring & Capacity Planning: Proactively identify potential issues and design strategies for capacity planning, ensuring future storage, memory, and CPU requirements are met.
Mentorship & Documentation: Provide technical guidance and mentorship to junior DBAs, and develop and maintain comprehensive technical documentation, SOPs, and knowledge base articles.
Collaboration: Work closely with development teams, application owners, and system administrators to optimize database usage and resolve issues collaboratively.
Required education
Bachelor's Degree
Preferred education
Bachelor's Degree
Required technical and professional expertise
BE / Btech/BSc IT with 8+ years of Extensive experience
Preferred technical and professional experience
BE / Btech/BSc IT with 8+ years of Extensive experience
.
ABOUT BUSINESS UNIT
IBM Systems helps IT leaders think differently about their infrastructure. IBM servers and storage are no longer inanimate - they can understand, reason, and learn so our clients can innovate while avoiding IT issues. Our systems power the world's most important industries and our clients are the architects of the future. Join us to help build our leading-edge technology portfolio designed for cognitive business and optimized for cloud computing.
YOUR LIFE @ IBM
In a world where technology never stands still, we understand that, dedication to our clients success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better.
Being an IBMer means you'll be able to learn and develop yourself and your career, you'll be encouraged to be courageous and experiment everyday, all whilst having continuous trust and support in an environment where everyone can thrive whatever their personal or professional background.
Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions everyday is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome focused approach within everything that they do.
Are you ready to be an IBMer?
ABOUT IBM
IBM's greatest invention is the IBMer. We believe that through the application of intelligence, reason and science, we can improve business, society and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.
Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we're also one of the biggest technology and consulting employers, with many of the Fortune 500 companies relying on the IBM Cloud to run their business.
At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it's time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.
IBM is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, neurodivergence, age, or other characteristics protected by the applicable law. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
OTHER RELEVANT JOB DETAILS
When applying to jobs of your interest, we recommend that you do so for those that match your experience and expertise. Our recruiters advise that you apply to not more than 3 roles in a year for the best candidate experience. For additional information about location requirements, please discuss with the recruiter following submission of your application.
Perks and Benefits
Health and Wellness
Parental Benefits
Work Flexibility
Office Life and Perks
Vacation and Time Off
Financial and Retirement
Professional Development
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at IBM.