Oracle Database Administrator

JOB DESCRIPTION -

Role & responsibilities :

• Database Management:
• Install, configure, and upgrade Oracle database software and related products.
• Create and manage database instances, storage structures, and objects.
• Implement and maintain database backup and recovery strategies.
• Performance Optimization:
• Monitor and optimize database performance using tuning tools and techniques.
• Analyze and resolve database performance issues, including query optimization and indexing strategies.
• Implement and manage database clustering, replication, and load balancing.
• Troubleshooting and Support:
• Provide technical support and troubleshooting for database-related issues.
• Resolve database incidents and problems, ensuring minimal downtime.
• Collaborate with application developers and other IT staff to resolve complex issues.
• Security and Compliance:
• Implement and enforce database security measures, including user access controls and encryption.
• Monitor database security and ensure compliance with industry standards and regulations.
• Conduct regular security assessments and audits.
• Data Integrity and Management:
• Ensure data integrity and consistency through proper database design and maintenance.
• Implement and manage data archiving, purging, and retention policies.
• Support data migration and integration projects.
• Documentation and Reporting:
• Create and maintain database documentation, including configurations, procedures, and policies.
• Prepare and maintain reports on database performance, capacity, and incidents.
• Capacity Planning:
• Monitor database capacity and utilization to ensure adequate resources for current and future needs.
• Develop and implement database capacity plans and upgrades.
• Automation and Scripting:
• Develop and maintain scripts for database automation tasks, such as backups, monitoring, and maintenance.
• Implement and manage database automation tools and solutions.

Preferred candidate profile :

Qualifications

• Education:
• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• Experience:
• Proven experience as an Oracle Database Administrator or similar role.
• Hands-on experience with Oracle database software, tools, and technologies (e.g., Oracle DB, RMAN, ASM, Data Guard).
• Skills:
• Strong understanding of database concepts, including normalization, indexing, and transactions.
• Proficiency in SQL and PL/SQL programming.
• Experience with database performance tuning and optimization techniques.
• Knowledge of database security practices and technologies.
• Familiarity with database monitoring and management tools.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.