Title: Sr Technical Lead-Enterprise Apps
Oracle DBA
Oracle DBA Responsibilities:
- Advanced Troubleshooting:
Resolve complex database issues that L1 and L2 support teams cannot.
- Performance Tuning:
Analyze and optimize database performance, including SQL tuning, identifying bottlenecks, and implementing solutions to improve query execution times.
- High Availability and Disaster Recovery:
Design, implement, and manage solutions like Oracle RAC (Real Application Clusters) and Data Guard for ensuring high availability and enabling seamless failover in case of disaster.
- Database Security:
Implement and enforce security policies and procedures to protect sensitive data, including user access control, encryption, and auditing.
- Database Upgrades and Migrations:
Plan and execute database upgrades and migrations to new versions or platforms, ensuring minimal disruption to business operations.
- Capacity Planning:
Monitor database resource utilization and proactively plan for future capacity needs, including storage, CPU, and memory.
- Documentation:
Develop and maintain comprehensive documentation related to database configurations, procedures, and troubleshooting steps.
- Technical Leadership:
Provide guidance and mentorship to L1 and L2 DBAs, sharing knowledge and best practices.
- Collaboration:
Work closely with application development teams, system administrators, and other IT teams to ensure seamless integration and operation of database systems.
Area(s) of responsibility