Oracle Database Administrator Job in Zl Tech

Oracle Database Administrator

Location: Hyderabad, IN

Employment Type: Full-Time

Role Overview

We are looking for a skilled Oracle Database Administrator (DBA) to join our IT team. The ideal candidate will be responsible for maintaining the performance, integrity, and security of our Oracle databases to ensure continuous availability and reliability. This role involves proactive monitoring, troubleshooting, and collaboration with various teams to support business-critical applications.

Key Responsibilities

Database Management:

• Install, configure, upgrade, and patch Oracle database software and related tools.
• Create and manage database instances, storage, schemas, and database objects.
• Implement and maintain robust backup and recovery strategies using tools like RMAN.

Performance Optimization:

• Monitor and optimize database performance through tuning, indexing, and query optimization.
• Analyze and resolve bottlenecks and performance issues.
• Manage clustering, replication, Data Guard, and load balancing configurations to ensure high availability.

Troubleshooting and Support:

• Provide technical support and timely resolution of database issues.
• Collaborate with developers and IT teams to resolve complex problems affecting database performance or availability.

Security and Compliance:

• Implement database security policies including access controls, encryption, and auditing.
• Ensure compliance with organizational and industry security standards through regular audits and assessments.

Data Integrity and Management:

• Maintain data integrity and consistency through sound database design and maintenance.
• Oversee data archiving, purging, and retention policies to meet business and regulatory needs.
• Support data migration and integration initiatives.

Documentation and Reporting:

• Document database configurations, maintenance procedures, and policies.
• Prepare reports on database performance, capacity, incidents, and trends.

Capacity Planning:

• Monitor and analyze database capacity and utilization to plan for future growth.
• Develop capacity planning strategies and execute upgrades as required.

Automation and Scripting:

• Develop and maintain scripts to automate routine database maintenance, backups, and monitoring tasks.
• Implement automation tools to improve operational efficiency.

Qualifications

Education:

• Bachelor s degree in Computer Science, Information Technology, or related field, or equivalent experience.

Experience:

• Proven experience as an Oracle Database Administrator or similar role.
• Hands-on expertise with Oracle Database, RMAN, ASM, Data Guard, and related technologies.

Skills:

• Strong knowledge of database architecture, normalization, indexing, and transaction management.
• Proficiency in SQL and PL/SQL programming.
• Experience in performance tuning, query optimization, and troubleshooting.
• Familiarity with database security best practices and tools.
• Competent with database monitoring and management tools.
• Excellent problem-solving, analytical, and communication skills.

Certifications:

• Oracle Certified Professional (OCP) or Oracle Certified Expert (OCE) certifications are highly desirable.