Oracle Database Administrator

The Oracle Database Administrator (DBA) is responsible for the administration, maintenance, security, availability, and performance of Oracle database environments. This role supports development, test, stage and production systems by implementing database best practices, proactively monitoring performance, troubleshooting issues, and ensuring the reliability of mission-critical applications., * Install, configure, upgrade, and maintain Oracle databases across development, test, stage, and production environments.

• Monitor database health, availability, security, storage utilization, and backup/recovery processes.
• Support application deployments and collaborate with developers to ensure efficient database design and operation.
• Implement and maintain backup, recovery, disaster recovery, and high-availability solutions.
• Troubleshoot and resolve database incidents, outages, and data-related issues.
• Develop and maintain SOPs, operational procedures, and technical documentation.
• Participate in change management, system upgrades, and Agile project activities.

Performance Tuning Responsibilities:

• Proactively monitor and analyze database performance to identify bottlenecks and optimization opportunities.
• Perform SQL and PL/SQL tuning using execution plans, AWR, ASH, Statspack, and Oracle performance diagnostic tools.
• Analyze and optimize database queries, indexes, partitions, and schema designs to improve performance.
• Monitor and optimize CPU, memory, I/O, and network utilization.
• Partner with application teams to diagnose and resolve performance issues across the database and application stack.
• Establish performance baselines and implement proactive monitoring and alerting strategies.

• Minimum 3 years of experience as an Oracle Database Administrator.
• Strong experience with Oracle Database administration in enterprise environments.
• Proven experience identifying, analyzing, and resolving database performance issues.
• Experience with Oracle RMAN, Data Pump, and performance monitoring tools.
• Strong knowledge of backup/recovery, security management, and database maintenance.
• Excellent analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications:

• Experience with Oracle RAC, Data Guard, ASM, and high-availability environments.
• Experience supporting large-scale, mission-critical production systems.
• Knowledge of Linux/UNIX administration and shell scripting., Oracle Database Administration, Performance Tuning, SQL Optimization, PL/SQL, Execution Plan Analysis, Oracle RAC, Data Guard, RMAN, Backup & Recovery, Capacity Planning, Database Monitoring, Troubleshooting, Security Management, Disaster Recovery, Documentation, and Agile Collaboration.